Excel BI – Pivot tables
1 day of training – 6 hours

• Create a pivot table
  – Conditions to meet
  – Creating the pivot table from a source
• Creating the pivot table from several sources
• Add/delete/move fields
• Edit the calculation used and format it
• Add/Hide subtotals, totals
• Update source in crosstab
• Group dates by months, quarters or years
• Change the PivotTable layout
• Formatting the pivot table
• Filter, sort and update data
• Add segments and timelines ( friendly filters )
• Add more specific calculated fields
• Add various % calculations already configured
• Present the results in a report
• The readgiveestabcrossdynamic() function to extract the results from your crosstab
• Create a pivot chart
• Filter a PivotChart
• Create a first dashboard based on your pivot tables and charts

1 day of training – 6 hours

levels : Basic knowledge of IT tools .

The essentials

• Create tables
• Select, insert, delete rows, columns, cells
• Perform simple calculations (addition, subtraction, multiplication, division, percentage calculation)
• Correct a calculation
• Use basic Excel formulas (sum, average, number of values, etc.)
• Move, copy formulas, data
• Formatting the table
• Discovering Table mode
• Print the table
• Sort data

Excel – the intermediate course

1 day of training – 6 hours

• Find/replace data
• Use data table mode and the subtotal() function
• Manage printing large spreadsheets
• Working with headers and footers
• Insert a logo
• Working with graphics
• Use conditional formatting
• Report in one cell the result appearing in another
• Add a comment to a cell
• Work on multiple spreadsheets simultaneously
• Create a spreadsheet template to generate blank documents based on that template
• Create a macro and assign it to a button

Excel – Advanced functions

1 day of training – 6 hours

Prerequisites: know (generally) the basics of Excel.

• Discover more text functions
• Discover more date functions
• Working with hours
• Logical functions: if( ), and(), or( ), sum.if ( ), number .if( ), sum.if.ens( ), average.if.ens ( ), iferror( ), if. conditions ( )
• The search function: searchx ( )
• Nest one function inside another
• Add a drop-down list in cells to limit encoding errors
• Working with range names (to identify a selection of cells)

On request

1 day of training – 6 hours

Excel – Graphs
Prerequisite: know (generally) Excel for Dummies*

1 day of training – 6 hours

• Create, change, resize, move and delete a chart
• Add, remove elements such as legend, axis titles, numbers on the graph, etc.
• Customize the chart formatting and save it as a template for future charts
• Add a trendline
• Create combo charts

Did you know that self-employed people, businesses such as the voluntary sector (non-profit sector), can benefit from bonuses from the Brussels-Capital region to follow our training courses. Click here to find out everything about training bonuses

Lessons are available in private lessons and group lessons. The training sessions are available in person at 156, Boulevard Auguste Reyers in 1030 Brussels and are also accessible by videoconference via the Zoom platform .

	Price Company, association, institution Amount excluding VAT	Actiris price (Not accessible with TIC checks)	Prices Independent and freelance Amount excluding VAT
Excel for Dummies 1 day-6h	250 €	–	250 €
Intermediate course 1 day-6h	250 €	–	250 €
Advanced techniques 1 day-6h	250 €	–	250 €
Pivot tables 1 day-6h	250 €	–	250 €
PowerPivot and PowerQuery databases 1 day-6h	250 €	–	250 €
The graphics 1 day-6h	250 €	–	250 €