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 1 hour

Masterclass – How to design a data governance model for your organisation?

View course →
Cross-cutting
Cross-cutting 10 mins

Integration between Excel and PowerPoint: Dynamic Charts in Presentations

View course →
Cross-cutting
Cross-cutting 30 hours

Skills for Digital Transformation

View course →
Scroll to Top