Excel Modelling

• Basic understanding of Excel

Audience

• Data Analysts

Microsoft Excel is a spreadsheet software program by Microsoft that provides tools for data visualization and analysis. The Excel modelling process is where quantitative predictions are made based on a series of underlying assumptions.

This instructor-led, live training (online or onsite) is aimed at data analysts or anyone who wishes to learn how to use Excel for creating data models for data analysis.

By the end of this training, participants will be able to:

• Learn to analyze and solve any business problems using structured problem-solving tools.
• Navigate Excel tools with ease.
• Set up, format, and present data effectively.
• Understand the logical structure and apply correct functions to Excel models.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction to Solving Problems in Excel

Excel Basics

Collecting, Formatting, and Parsing Data

Using Formulas and Functions

Understanding the Spreadsheet Structure

Understanding the Logical Model Flow

Creating a Logical Model Flow

Using Charts, Pivot Tables, and Reporting

Checking, Testing, and Validating

Modeling Scenario and Sensitivity Analysis

Data Visualization and Presentation

Summary and Next Steps