Course Info

Length: 1 Week

Type: In Classroom

Available Dates

Venue

  • Oct-21-2024

    Barcelona

  • Oct-21-2024

    Dubai

  • Oct-28-2024

    London

  • Nov-04-2024

    Kuala Lumpur

  • Nov-04-2024

    Istanbul

  • Nov-11-2024

    Singapore

  • Nov-11-2024

    Paris

  • Nov-18-2024

    Dubai

  • Nov-18-2024

    Barcelona

  • Nov-25-2024

    London

  • Dec-02-2024

    Istanbul

  • Dec-02-2024

    Kuala Lumpur

  • Dec-09-2024

    Singapore

  • Dec-09-2024

    Paris

  • Dec-16-2024

    Dubai

  • Dec-16-2024

    Barcelona

  • Dec-23-2024

    Istanbul

  • Dec-23-2024

    London

  • Dec-30-2024

    Kuala Lumpur

  • Jan-06-2025

    Barcelona

  • Jan-06-2025

    Dubai

  • Jan-06-2025

    London

  • Jan-13-2025

    Istanbul

  • Jan-13-2025

    Kuala Lumpur

  • Jan-20-2025

    Paris

  • Jan-20-2025

    Singapore

  • Jan-27-2025

    London

  • Feb-03-2025

    Dubai

  • Feb-03-2025

    Barcelona

  • Feb-10-2025

    Istanbul

  • Feb-10-2025

    Kuala Lumpur

  • Feb-17-2025

    Paris

  • Feb-17-2025

    Singapore

  • Feb-24-2025

    London

  • Mar-03-2025

    Barcelona

  • Mar-03-2025

    Dubai

  • Mar-10-2025

    Kuala Lumpur

  • Mar-10-2025

    Istanbul

  • Mar-17-2025

    Paris

  • Mar-17-2025

    Singapore

  • Mar-24-2025

    London

  • Apr-07-2025

    Dubai

  • Apr-07-2025

    Barcelona

  • Apr-14-2025

    Kuala Lumpur

  • Apr-14-2025

    Istanbul

  • Apr-21-2025

    Paris

  • Apr-21-2025

    Singapore

  • Apr-28-2025

    London

  • May-05-2025

    Barcelona

  • May-05-2025

    Dubai

  • May-12-2025

    Istanbul

  • May-12-2025

    Kuala Lumpur

  • May-19-2025

    Paris

  • May-19-2025

    Singapore

  • May-26-2025

    London

  • June-02-2025

    Dubai

  • June-02-2025

    Barcelona

  • June-09-2025

    Kuala Lumpur

  • June-09-2025

    Istanbul

  • June-16-2025

    Paris

  • June-16-2025

    Singapore

  • June-30-2025

    London

  • June-30-2025

    Dubai

  • June-30-2025

    Barcelona

  • July-07-2025

    Barcelona

  • July-07-2025

    Dubai

  • July-14-2025

    Istanbul

  • July-14-2025

    Kuala Lumpur

  • July-21-2025

    Singapore

  • July-21-2025

    Paris

  • July-28-2025

    London

  • Aug-04-2025

    Barcelona

  • Aug-04-2025

    Dubai

  • Aug-11-2025

    Kuala Lumpur

  • Aug-11-2025

    Istanbul

  • Aug-18-2025

    Paris

  • Aug-18-2025

    Singapore

  • Aug-25-2025

    London

  • Sep-01-2025

    Barcelona

  • Sep-01-2025

    Dubai

  • Sep-08-2025

    Kuala Lumpur

  • Sep-08-2025

    Istanbul

  • Sep-15-2025

    Paris

  • Sep-15-2025

    Singapore

  • Sep-29-2025

    Dubai

  • Sep-29-2025

    Barcelona

  • Sep-29-2025

    London

  • Oct-06-2025

    Dubai

  • Oct-06-2025

    Barcelona

  • Oct-13-2025

    Kuala Lumpur

  • Oct-13-2025

    Istanbul

  • Oct-20-2025

    Paris

  • Oct-20-2025

    Singapore

  • Oct-27-2025

    London

  • Nov-03-2025

    Dubai

  • Nov-03-2025

    Barcelona

  • Nov-10-2025

    Istanbul

  • Nov-10-2025

    Kuala Lumpur

  • Nov-17-2025

    Singapore

  • Nov-17-2025

    Paris

  • Nov-24-2025

    London

  • Dec-01-2025

    Dubai

  • Dec-01-2025

    Barcelona

  • Dec-08-2025

    Kuala Lumpur

  • Dec-08-2025

    Istanbul

  • Dec-15-2025

    Singapore

  • Dec-15-2025

    Paris

  • Dec-29-2025

    London

Course Details

Course Outline

5 days course

Creating and modifying workbook templates
 
  • Working with worksheets, cells and cell data
  • Sorting, filtering, and managing worksheets
  • Summarising data using formulas and functions
  • Working with advanced formulas and functions
  • Using validation rules to restrict the data entered in cells
  • Creating named ranges

 

Analysing data and formulas
 
  • Formatting worksheet elements
  • Introduction to arithmetic operators
  • Using relative and absolute cell references
  • Finding data using Vlookup and Hlookup
  • Auditing formulas by identifying precedents and dependants
  • Managing Excel formula error indicator

 

Creating rule-based conditional formats
 
  • Defining data bar, colour scale and icon set conditional format
  • Working with charts
  • Creating bar, column, pie, line and XY charts
  • Creating stock charts
  • Adding trendline to a chart
  • Creating sparkline charts

 

Working with external data
 
  • Importing data from CSV and txt files
  • Using hyperlinks
  • Linking an excel chart to another MS Office programme
  • Working with objects
  • Creating and formatting shapes
  • Managing objects using the Selection pane

 

Introduction to Pivot tables
 
  • Pivoting a pivot table report
  • Managing subtotals and grand totals
  • Setting AutoCorrect and automatic replace options
  • Protecting a workbook
  • Automating workbooks using Macros
  • Recording a macro

Course Video