During this training, you will learn to use the advanced functions of Excel, macros and VBA. You will also learn how to use Excel’s data analysis and visualization tools, such as Data Analysis ToolPak, power query, power pivot and dashboard. Your training will be dynamic and in several sections such as:
- Use advanced Excel features and functions, such as VLOOKUP, HLOOKUP, INDEX, MATCH, IF, SUMIF, COUNTIF, etc.
- Use Excel’s data analysis and visualization tools, such as Data Validation, Data Analysis ToolPak, Solver, Goal Seek, Scenario Manager, etc.
- Use Excel’s macros and VBA programming, such as recording macros, editing macros, creating user-defined functions, and writing VBA code.
- Use Excel’s “power query” and “power pivot” functions, such as importing data from various sources, transforming data using queries, creating relationships between tables, and creating measures using DAX formulas.
- Use Excel’s dashboard and reporting tools, such as creating interactive charts, slicers, timelines, sparklines, conditional formatting, and more.
At the end of this training, you will have acquired the practical experience and theoretical knowledge necessary to use Excel for various data analysis and visualization tasks. You will also receive a certificate of completion and access to a network of Excel experts for advice and support.
- Lectures 0
- Quizzes 0
- Duration Lifetime access
- Skill level All levels
- Language English
- Students 20
- Assessments Yes