Data Analysis in Excel

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