FinanceBeginner

MS Excel for Beginners: Formulas, Pivot Tables & Dashboards

Name: MS Excel for Beginners: Formulas, Pivot Tables & Dashboards
Price: 499 INR
Availability: InStock

Master Microsoft Excel from absolute zero to professional-level data analysis and dashboard creation. Learn formulas, functions, lookups, data cleaning, Pivot Tables, charts, interactive dashboards, shortcuts, and real-world spreadsheet workflows through hands-on practice.

10h

What You'll Learn

Master Microsoft Excel from the basics and confidently manage, format, and organise spreadsheet data.

Create powerful formulas and functions using cell references, logical functions, text, date, conditional, and lookup functions.

Clean, structure, and analyse real-world business data using Excel Tables, sorting, filtering, and Data Validation.

Build Pivot Tables, charts, and interactive reports to turn large datasets into useful business insights.

Design professional Excel dashboards with KPIs, Slicers, charts, and dynamic reporting techniques.

About this course

MS Excel for Beginners: Formulas, Pivot Tables & Dashboards is a self-paced beginner-level finance online course on GreyAcademy, taught by Saurav Singh. It has 10 modules and 22 chapters, and it takes about 10 hours to complete. Enrol once and learn at your own pace. You get a completion certificate when you finish all the lessons.

Topics covered: What Excel Is, Getting Data In, Rows, Columns, Cells, Formatting, Your First Formula, Cell References, Logical Functions, Counting and Adding with Conditions, Text and Dates, The VLOOKUP Family, INDEX MATCH, Sort, Filter, Clean and more.

Not sure where to start? Compare this with other online courses or follow a career roadmap.

Course Content

Module 1

Meeting Excel for the First Time

2 chapters

What Excel IsFree Preview

→

Your Instructor

Student Reviews

Enter your review…

Students Also Bought

Finance

NISM Series-I: Currency Derivatives — Complete Exam Preparation

Saurav Singh

₹499

Finance

NISM Securities Markets Foundation: Crack the Exam & Master Indian Stock Market

Saurav Singh

₹499

NISM VIII Equity Derivatives: Master Futures & Options for Indian Markets – online course

Finance

This Course Includes

Lifetime access

Mobile & desktop access

Certificate of completion

Price Breakdown

Course Fee:₹423

Platform Fee (18%):₹76

Total:₹499

All prices include a 18% platform fee

Getting Data InFree Preview

Module 2

Making a Sheet Correct and Readable

2 chapters

Module 3

Formula Foundations

2 chapters

Your First FormulaLocked

→

Cell ReferencesLocked

→

Module 4

Everyday Functions

3 chapters

Logical FunctionsLocked

→

Counting and Adding with ConditionsLocked

→

Text and DatesLocked

→

Module 5

Lookup: Joining Data Together

2 chapters

The VLOOKUP FamilyLocked

→

INDEX MATCHLocked

→

Module 6

Taking Control of Data

2 chapters

Sort, Filter, CleanLocked

→

StructureLocked

→

Module 7

Pivot Tables

3 chapters

Your First PivotLocked

→

Controlling the PivotLocked

→

Going FurtherLocked

→

Module 8

Charts

2 chapters

Building a ChartLocked

→

Advanced VisualsLocked

→

Module 9

Dashboards

2 chapters

Planning a DashboardLocked

→

Building the DashboardLocked

→

Module 10

Speed and Good Habits

2 chapters

Working FastLocked

→

Professional HabitsLocked

→

Saurav Singh

Trading expert with 15+ years of experience. Built 19 companies and invested in 78 startups.

sauravsingh@cre8r.in

MS Excel for Beginners: Formulas, Pivot Tables & Dashboards

What You'll Learn

About this course

Course Content

Meeting Excel for the First Time

Your Instructor

Student Reviews

Students Also Bought

NISM Series-I: Currency Derivatives — Complete Exam Preparation

NISM Securities Markets Foundation: Crack the Exam & Master Indian Stock Market

This Course Includes

Price Breakdown

Making a Sheet Correct and Readable

Formula Foundations

Everyday Functions

Lookup: Joining Data Together

Taking Control of Data

Pivot Tables

Charts

Dashboards

Speed and Good Habits

Saurav Singh

NISM VIII Equity Derivatives: Master Futures & Options for Indian Markets

Securities Markets Foundation — From Zero to Smart Investor (Indian Edition)