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.
TOPICS
- Spreadsheet Modeling
- Advance Excel formulas
- Formulating pivot tables
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
Duration: 3 hours
Participants
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
Planers
Course Features
- Lectures 0
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 87
- Assessments Yes
