Contact
Request a demo

Excel from Scratch

Cross-cutting
Digital Skills

Digital Skills

Duration

30h

PRESENTATION

Microsoft Excel is the tool office automation most commonly used by individuals and, above all, by businesses to manage data, analyze it, and create attractive charts.

For a company to operate properly, it is important that it keep its data up to date. In other words, the accounting, invoices, schedules, payroll, and employee check-ins and check-outs… everything must be under control, which is why we use tools like Excel to make this task easier. In this training course on Excel from scratch You will acquire the knowledge necessary to perform your tasks effectively.

Objectives

  • Learn about the Microsoft Excel interface and which tabs contain their various features.

  • Knowing how to handle data, format it, and work across different sheets.

  • Create different types of graphs professionals based on a set of data.

  • Learn about the main ones formulas that are used to edit data and reference cells.

  • Create and Manage data tables using filters, groups data and formulas.

  • Use different types of tables, functions and tools for creating data analysis deeper.

  • Get to Know the Tool Solver to solve certain problems.

Syllabus

LEARNING UNIT 1. FIRST STEPS IN EXCEL

  1. Interface Elements
  2. Data Entry and Editing
  3. Formatting
  4. Working with Multiple Sheets
  5. Creating Charts
  6. Customization
  7. Aid: An Important Resource

LEARNING UNIT 2. LEARN HOW TO EDIT DATA

  1. Data Types
  2. Data Entry
  3. Cell references
  4. Presentation

LEARNING UNIT 3. ORGANIZING INFORMATION USING TABLES

  1. Initial Data
  2. Tally and summarize
  3. Filter and group the data
  4. Pivot Tables
  5. Data Tables

LEARNING UNIT 4. EXTRACTING RELEVANT DATA USING EXCEL

  1. Configuring Analysis Tools
  2. Tables with Variables
  3. Functions for Making Forecasts
  4. Scenario Simulation
  5. Pursuit of Goals
  6. The Solver Tool
  7. Other data analysis tools
Request for Information

Related MOOCs

Course

Workplace Risk Prevention, Ergonomics, and Mental Health

The Course on Workplace Risk Prevention, Ergonomics, and Mental Health addresses the growing need to ensure environments...
Read more
Course

Digital Disconnection and Legal Compliance in the Workplace

In the age of remote work, hyperconnectivity has put companies under the scrutiny of the Labor Inspectorate....
Read more
Course

The Right to Digital Disconnection, Health, and Work Ethics

In a world of global digitization, hyperconnectivity has gone from being an advantage to becoming a challenge...
Read more

Are the Educa PHAROS courses eligible for credit?

Many courses can be credited toward the master's programs at Structuralia.
Specialized Courses Catalog

Facts about our area

+ 1.483

Hours

+88.999

Minutes

264

Courses

Educa PHAROS is a next-generation training model that places a company’s human capital at the forefront. Through a platform that adapts to each company’s corporate identity and offers a total of more than 900 courses, it provides tailored training for each organization. The unlimited flat-rate plan provides each company with the number of courses that best suits its needs, as well as the ability to determine which employees will have access.
Scroll to Top