Discover our Excel trainings below
Have a look at our trainings and discover the one that fits your needs!
Basics – Fundamental skills – 6 hours
The Excel warm-up!
Learn the necessary foundations of this program.
Click here to see its content below
In this class you’ll learn:
– Basic spreadsheet navigation: understanding cells, rows,
columns and sheets
– Data entry techniques: typing values into cells.
– Understanding absolute and relative cell references.
– Formatting cells: changing fonts, colors, alignment and borders.
– Introduction to charts: creating basic charts like bar graphs and pie charts.
– Printing spreadsheets optimally.
Basics – Core skills – 6 hours
After the warm-up!
A further look at the numbers.
Click here to see its content below
In this class you’ll learn:
– Short recap of the fundamentals.
– The first formulas for numbers (SUM, MAX, MIN, …)
– The first formulas for text
– The IF-formula in Excel
– Sorting and filtering data
– Use of tables
– Some handy shortcuts
Intermediate – Essential skills – 6 hours
Using the data!
A handy class for the first formulas.
Click here to see its content below
– Short recap of the Core skills.
– More intense use of tables.
– Searching formulas (VLOOKUP, XLOOKUP, INDEX/MATCH).
– Functions (SUMIFS, COUNTIFS, AVERAGEIFS)
– Data validation: how to make a drop-down list
Intermediate – Core skills – 6 hours
Introduction in Pivot Tables.
cH
Click here to see its content below
– Short recap of the Essentials.
– Useful text formulas, such as CONCAT, TRIM, UPPER/LOWER/PROPER, TEXTBEFORE, TEXTAFTER, …
– Introduction to Pivot Tables with extensive exercises
– Pivot Charts (charts based on Pivot Tables)
– Slicers & Timelines
– Review, protecting/validating with passwords
Advanced – Power Query – 6 hours
Retrieve and automate the data!
cH
Click here to see its content below
Retrieve data with queries from other files and software.
– Import data as a table, pivot, chart, or connection.
– Use the Power Query Editor. Adjust retrieved data step by step so that it appears optimally in your Excel.
– Merge & Append Queries. Combine multiple tables into one comprehensive overview.
– Define parameters, pivot data, add calculated columns, …
– Combine data from different files/software/tables into one large analysis in Excel.
– Automate your steps. Stop repeating the same tasks every week.
Save a lot of time!
Advanced – Power Pivot – 6 hours
Advanced exercises and applications with Pivot Tables
Click here to see its content below
Advanced exercises with Pivot Tables:
– PowerPivot – how do you combine multiple tables or lists into one PivotTable?
– Data import, Data Modeling, …
– Slicers, Timelines, Group
– Charts with PowerPivot, Measures and KPIs, Conditional Formatting, …
– Create a fantastic dashboard and analyze with PowerPivot.
Highly recommended – Pivot Tables
Introduction and detailed workings of pivot tables.
After this training, pivot tables will hold no secrets for you!
Click here to see its content below
– Build your first dashboards based on pivot tables and pivot charts.
– Easily filter your dashboard with slicers and timelines.
– Create ideal pivot charts
– The hidden treasures of pivot tables.
– Provide the ideal layout and conditional formatting in your pivot tables.
Power BI
This class is not yet available
Click here to see its content below
We don’t teach this class a the moment