Excel is the Microsoft Office office suite spreadsheet, intended for use on Windows or Mac OS platforms.
Through this software it is possible to analyze, manage and share information. Thus, Excel will allow you to create data tables, integrate calculations in order to perform statistics and then add graphs with ease. In addition, the latest version of this spreadsheet improves collaborative work and offers to save your workbook directly on the Web in order to access it from any computer.
The 5-day « Excel: Initiation + Deepening + VBA » training that we offer takes place as follows:
– Getting started with the software
– Adding content (text, images, tables …)
– Formatting this content
– Integration of formulas
– Generation of graphs and pivot tables
– Automation of tasks thanks to macros in VBA
– Passage of PCIE or TOSA cerfication in order to validate knowledge
6 training to see :
Excel: Initiation
Duration : 2 days
Goals :
- Know how to create a table in Excel
- Be able to configure the printing of your table
Excel : Advanced
Duration : 2 days
Goals :
- Be able to perform calculations and use formulas
- Know how to handle graphs and pivot tables
Excel: VBA macros
Duration : 1 day
Goals :
- Know how to integrate a macro in Excel
- Know the VBA objects linked to Excel
Excel : Initiation + Advanced
Duration : 4 days
Goals :
- Know the main Excel tools
- Be able to perform calculations and use formulas
- Know how to handle graphics and pivot tables
Excel : Advanced+ VBA Macros
Duration : 3 days
Goals :
- Be able to perform calculations and use formulas
- Know how to handle graphs and pivot tables
Excel : Initiation + Advanced + VBA Macros
Duration : 5 days
Goals :
- Know the main Excel tools
- Be able to perform calculations and use formulas
- Know how to handle graphics and pivot tables