Course objectives:

- Be able to understand how Excel supports business-management and data-analysis work
- Master the automation of calculations using Excel formulas and functions
- Master data charts

 
Skills to be acquired:

- Know how to implement formulas
- Know how to illustrate series of figures
- Know how to use Excel’s main functions (conditions, searching a table, conditional sums…)
- Understand the data-chart concept
- Know how to build a pivot table
- Know how to use macros

Summary:

Students deepen their computing knowledge, primarily of Excel. They learn to master the program’s advanced functions for automating calculations. They become familiar with data charts and pivot tables.