Programs

Latest

Courses

Excel for Beginners

Audience:

Individuals who have little or no Excel experience

Topics:

What is MS Excel

How to use Excel

Basic data entry

Explanation of Home Ribbon

Overview of Excel

Audience:

Individuals who have used excel but want to expand their knowledge

Topics:

Overview of Home, Insert and View tabs

Creating full data sets

Creating a table Inserting basic Chart

Using auto formulas on Home tab

Power of

Excel

Audience:

Individuals who use excel on a regular basis but wants to expand their knowledge

Topics:

Creating Tables and Pivot Tables

Creating Charts and Pivot Charts

Introduction to Power Pivot

Excel Formulas & Functions

Audience:

Individuals requiring knowledge of Excel Functions

Topics:

Methodology of Functions

How to write a function

Deep dive into most used functions

Creating Excel Dashboards

Audience:

Individuals who require the skill of interpreting data for analytical consumption

Topics:

Basics of Dashboard building

How to build a dashboard

How to use slicers to your advantage

Normal vs Pivot Charts in a dashboard

Using Power Pivot to your advantage

CLICK HERE TO START LEARNING NOW