Course Overview
Taking this course will help you unlock the power of your organization’s data by using data analysis and visualization tools build into Excel. Interpreting data into meaningful insights is essential skill to contribute to strategic progress of your organization. This course takes a deep dive into the data analytics process: collection, cleaning, analysis, and visualization. You will be able the leverage the techniques learned in this course in the area of planning, forecasting, budgeting, decision making, financial analysis and financial reporting.
Key Learning Outcome
- Learn how to develop elaborative excel based databases: extracting, cleaning, sorting, tables
- Applying advance formulas: VLOOKUP, Conditional Formatting, SUMIF, COUNTIF etc.
- Learn to develop pivot tables and its applications
- Each session includes practical examples that display how to apply the techniques to real-world business problems
Pre-requisite
It is essential to have basic Excel knowledge for the training. The course is designed for audience with variety of professional backgrounds and experience levels — including
- Students
- Analysts
- Accountants
- Finance professional
- Planners
