EXCEL

Master data analysis, calculations, and visualization with Microsoft Excel.

What you will learn

1. Workbooks, cell formatting, printing and layout
2. Formulas, relative and absolute references, essential functions (SUM, IF, COUNTIF, SUMIF)
3. Lookup functions to find and match data
4. Text and date functions, cleaning messy data
5. Tables, sorting, filtering and drop-down lists with data validation
6. Conditional formatting to highlight what matters
7. Charts that communicate
8. PivotTables and a simple dashboard
9. Protecting and sharing workbooks
10. Introduction to automation

A monthly sales and stock tracker with a one-page dashboard.

A laptop, recommended so you can follow the course and practice at home (machines are available at the center if you don't have one yet)
An internet connection to practice at home
The software appropriate to the chosen training

Free WiFi coverage throughout the center, for registered students onlyFree
Some software is provided free of charge by the center, depending on the trainingFree
Machines available for your use during training