Curriculum

 

​

Getting Started:

• Excel Overview

• Excel Ribbon/Menu Commands

• Basic Data Manipulations

• Managing Workbooks & Worksheets

• Formatting Basics

• Excel Hierarchy

​

Functions:

• Logical Functions

• Arithmetic Functions

• Date Functions

• Aggregations

• Strings

​

Complex Formulas & Functions:

• Lookup Formulas

• Vlookup

• Hookup

• Nested Vlookup

​

Advanced referencing functions:

• Index

• Match

• Offset & etc

​

What-if Analysis:

• Goal-Seek command

• Using Data Tables

• Scenarios

• Merge scenarios from another worksheet

​

Chart & Layouts:

• Creating Charts using the chart wizard

• Useful Graphs & Charts

• One Axis Graphs

• Two-Axis Graphs & etc

• Gantt Charts

​

Pivot Tables:

• Steps to create Pivot Table

• Arranging fields (Methodology –How & Why)

• Formatting Pivot Table

• Introducing Slicing Tool

• Managing & Formatting Slices

​

Sparklines:

• Creating a Sparkline

• Design a Sparkline

• Comparing Sparklines

​

Excel Tools (In-Built):

• Data Filters & Usage

• Data Sorting

• Pivot Tables (Creating, Updating & Modifying)

• Advanced Formatting

​

Macros:

• Recording, Executing & Saving a Macro

• Editing & Debugging a Macro

• Error Handling

​

Career guidance:

• Discussion on practical business scenarios

• Interview question bank with answers

• Resume modelling

​

​