Focus: This course is great for those who have some familiarity with Microsoft Excel or have taken our Microsoft Excel Basics class and would like to expand into Excel Intermediate skills with more robust functions and data manipulation techniques.
Objective: By the end of this session, you will be able to:
- Extract data from databases using functions such as VLOOKUP
- Organize and analyze raw data with Pivot Tables.
- Use IF statement formulas as an advanced technique for data analysis.
- Create dynamic report with Excel formulas
The skills learned in this course are what many employers expect.
Pre-requisites: Windows PC, Microsoft Excel application (free), an email account and internet access.
Applicable Roles: Metrics analyst, Business Analyst, Financial Analyst etc