MS Excel-Intermediate
18
Duration
Estimated Amount of Funding
€5760
About the training
Learn advanced data analysis, pivot tables, and more.
Maximum Number of participants
16
Certificate Availability
Yes
Training Content
The MS Excel - Intermediate training programme builds on basic skills to explore more advanced features. Participants will learn to perform complex data analysis, use advanced formulas, and create dynamic reports.
Training Objectives and Content:
Advanced Formulas and Functions:
Learn: How to use intermediate functions and formulas for complex calculations.
Content: Using VLOOKUP, HLOOKUP, IF statements, and nested functions.
Data Analysis Tools:
Learn: How to apply tools like PivotTables, PivotCharts, and conditional formatting.
Content: Creating and analyzing PivotTables, using PivotCharts, and applying conditional formatting to highlight data trends.
Advanced Charting:
Learn: How to create and customize complex charts and graphs.
Content: Advanced chart types (combination charts, scatter plots), customizing chart elements, and using sparklines.
Data Validation and Protection:
Learn: How to implement data validation rules and protect worksheets.
Content: Setting up data validation rules, protecting cells and worksheets, and managing workbook protection.