Contact
Demo
Contact
Demo
Cross-cutting

Excel from Scratch

Digital Skills 30 hours

Introduction

Microsoft Excel is the tool office automation most widely used by private individuals and, above all, by businesses to manage data, analyse it and produce attractive charts.

For a business to run smoothly, it is important that it keeps its records up to date. In other words, the accounting, invoices, timetables, payslips, arrivals and departures… everything must be under control, which is why we use tools such as Excel to make this task easier. In this training course on Excel from scratch You will acquire the knowledge you need to carry out the tasks effectively.

Objectives

  • To know the Microsoft Excel interface and which tabs the various features are located under.

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

  • Create different types of charts professionals based on a range of data.

  • Finding out about the main ones formulas which 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.

  • Getting to know the tool Solver to solve certain problems.

Table of Contents

TEACHING UNIT 1. FIRST STEPS IN EXCEL

  1. Interface elements
  2. Data entry and editing
  3. Formatting
  4. Working with multiple sheets
  5. Creating graphics
  6. Customisation
  7. Aid: an important resource

LEARNING UNIT 2. LEARN HOW TO EDIT DATA

  1. Data types
  2. Data entry
  3. Cell references
  4. Introduction

TEACHING UNIT 3. ORGANISING INFORMATION USING TABLES

  1. Initial data
  2. Tally up and summarise
  3. Filtering and grouping data
  4. Pivot tables
  5. Data tables

TEACHING UNIT 4. EXTRACTING USEFUL DATA USING EXCEL

  1. Configuring analysis tools
  2. Tables with variables
  3. Functions for making forecasts
  4. Scenario simulation
  5. Pursuit of objectives
  6. The Solver tool
  7. Other data analysis tools

More related courses

Cross-cutting
Cross-cutting 2 hours

Office 365 – OneDrive for Business

View course →

Your questions answered

Why choose Educa.Pro?

Educa.Pro enables organisations to centralise training management, personalise learning and gain clear insights into the impact of training programmes. Thanks to its AI-powered technology, organisations can optimise their learning strategies, enhance talent development and make data-driven decisions.

Can the courses be taken at your own pace?

Yes. Most of the courses on Educa.Pro are self-paced and on-demand, allowing users to progress at their own pace without missing out on progress tracking or assessments, which makes it easier to fit them around work or study commitments.

What levels of security and compliance does the platform offer?

Educa.Pro complies with security standards designed to protect user and organisational data. Furthermore, it supports the traceability of certifications, digital signatures and the management of assessments, thereby ensuring regulatory and legal compliance in both educational and corporate environments.

What support and guidance does Educa.Pro offer?

The Educa.Pro team offers comprehensive support throughout implementation, roll-out and adoption, ensuring that organisations get the most out of the platform and achieve measurable results from day one.

Scroll to Top