MS Excel

About Course

The Excel Course is designed to equip learners with essential data management and analysis skills using Microsoft Excel – one of the most powerful tools in the business world. This course covers everything from basic spreadsheet operations to advanced formulas, charts, pivot tables, and data visualization. Whether you’re a student, professional, or entrepreneur, mastering Excel will help you make smarter decisions through data-driven insights. With hands-on projects and real-world examples, you’ll gain the confidence to use Excel efficiently for reporting, budgeting, and analysis.

What will you get in this Course?

Excel Fundamentals:
Learn basic Excel concepts like cells, worksheets, formulas, formatting, and spreadsheet navigation.
Functions & Data Handling:
Work with essential functions, filtering, sorting, data cleaning, and organizing large datasets efficiently.
Charts & Visualization:
Create charts, tables, and visual reports to present data clearly and professionally.
PivotTables & Analysis:
Master PivotTables, PivotCharts, and data analysis tools to make smarter business decisions.
Practical Excel Projects:
Practice with real datasets and hands-on tasks to build strong Excel skills for office and professional use.

Course Curriculum

1 – Excel – Introduction
2 – Excel – Exploring
My First Workbook
3 – Excel – Understanding Ribbon
4 – Excel – Shortcuts
5 – Excel – Help
6 – Excel – Wroking with Template
7 – Excel – Workbook and Worksheet
8 – Excel – Saving and Recovery
9 – Excel – Editing Data
10 – Navigation and Selection
10.1 – Excel – Exercise 1
Sample_Store_Sales

11 – Excel – Formulas and Functions
12 – Excel – Calculations
13 – Excel – Counting Values and Blanks
14 – Excel – Filtering Average
15 – Excel – Working with Min and Max
16 – Excel – Error Handling
17 – Excel – ABsolute and Relative Reference
18 – Excel – AutoSum and AutoFill
19 – Excel – Exercise 2
Absolute vs Relative Referencing
Autosum and Autofill
Calculating with the SUM function
Counting Values with the COUNT function
Error Handling
Finding Averages
Flash Fill
Formulas and Functions Explained
Using MIN and MAX

20 – Excel – FlashFill
21 – Excel – Named Ranges
22 – Excel – Create Named Ranges
23 – Excel – Managing Named Ranges
24 – Excel – Using Named Ranges in Calculation
25 – Excel – Exercise 3
Creating Named Ranges
Using Named Ranges in Calculations
What are Named Ranges

26 – Excel – Number Formatting
27 – Excel – Date and Time Formatting
28 – Excel – Formatting Cells
29 – Excel – Using Format Painter
30 – Excel – Exercise 4
Date and Time Formats
Format Painter
Formatting Cells Rows and Columns
Number Formatting

31 – Excel – Working with Rows and Columns
32 – Excel – Deleting and Clearing Data
33 – Excel – Aligning Text and Numbers
34 – Excel – Applying Themes and Styles
35 – Excel – Exercise 5
Aligning Text and Numbers
Applying Themes and Styles
Clearing Cells
Working with Rows and Columns

36 – Excel – How to Structure Data
37 – Excel – Single Level Sorting
38 – Excel – Multi Level Sorting
39 – Excel – Custom Sorting
40 – Excel – Auto Filtering
41 – Excel – Format as a Table
42 – Excel – Subtotal
43 – Excel – Exercise 6

44 – Excel – Cut and Copy
45 – Excel – Paste Options
46 – Excel – Pasting form the Clipboard
47 – Excel – Linking Worksheets and Workbooks
48 – Excel – 3D Referencing
49 – Excel – Inserting Hyperlinks
50 – Excel – Exercise 7

51 – Excel – VLOOKUP Introduction
52 – Excel – VLOOKUP – Approximate Match
53 – Excel – Error Handling Functions
54 – Excel – Logical Functions IF, AND, OR
55 – Excel – Making Decision with IF
56 – Excel – Text Functions
57 – Excel – Time and Date Functions
58 – Excel – Exercise 8
Creating Subtotals
Custom Sort
Format as a Table
Multi Level Sorting
Single Level Sorting
The Structure of Lists
Using Autofilter

59 – Excel – Chart Types
60 – Excel – Data withChart
61 – Excel – Chart Formatting
62 – Excel – Exercise 9
3D Referencing
Cut and Copy
Hyperlink to Worksheets
Linking to Other Worksheets and Workbooks
Paste Options
Pasting from the Clipboard

63 – Excel – Data Bars
64 – Excel – Highlighting Cell Values
65 – Excel – Color Scales
66 – Excel – Icons Set
67 – Excel – Exercise 10
Cleaning Data with Text Functions
Error Handling Functions
Linking to Other Worksheets and Workbooks 2
Logical Functions
Time and Date Functions
VLOOKUP – Films Master List
VLOOKUP Approx Match

68 – Excel – Inserting Pictures
69 – Excel – Inserting Shapes and Text
70 – Excel – Icons and 3D Models
71 – Excel – Diagrams and SmartArt
72 – Excel – Screenshots
73 – Excel – Comments
74 – Excel – Exercise 11
Formatting Charts
Presenting Data with Charts
Selecting a Chart Type

75 – Excel – Wprkbook Views
76 – Excel – Using Zoom
77 – Excel – Arranging Workbooks
78 – Excel – Freezing Panes
79 – Excel – Exercise 12
Color Scales
Data Bars
Highlight Cell Values
Icon Sets

80 – Excel – Setting Margins and Orientations
81 – Excel – Print Area
82 – Excel – Page Breaks
83 – Excel – Print Titles
84 – Excel – Headers and Footers
85 – Excel – Printing Options
86 – Excel – Exercise 13
Inserting Comments
Inserting Icons and 3D Models
Inserting Pictures
Inserting Screenshots
Inserting Shapes and Text Boxes
Inserting SmartArt

87 – Excel – Protecting Wroksheet and Workbook
88 – Excel – Spell Checking
89 – Excel – Imspecting Workbook
90 – Excel – Saving and Export
91 – Excel – Share Document
92 – Excel – Exercise 14
Freezing Panes
Using Zoom
Workbook Views

AI Tools to Learn

ChatGPT
Gemini
Perplexity

Technical Tools & Software to Learn

Microsoft Excel
Excel Power Query
Excel Power Pivot
Google Sheets
Office 365

Job Scope After Course Completion

Data Entry Operator
MIS Executive
Administrative Assistant
Junior Data Analyst

FAQs

Instructor

<p>With over two decades of expertise in Software, AI, Networking, and Cyber Security, Girish Chaudhary brings deep industry knowledge and practical insights to his teaching. He is currently a <strong>Master Faculty at Red & White</strong>, guiding students towards industry-ready skills.</p>

Girish Chaudhari

With over two decades of expertise in Software, AI, Networking, and Cyber Security, Girish Chaudhary brings deep industry knowledge and practical insights to his teaching. He is currently a Master Faculty at Red & White, guiding students towards industry-ready skills.

📊 Excel Mastery
📈 Data Handling
📝 Smart Reporting
🚀 Office Ready Skills

₹499.00 ~~₹12,000.00~~

Enroll Now Enroll Now

Lectures93
Skill LevelIntermediate
LanguageHindi

₹499.00 ~~₹12,000.00~~

Category Submenu Items

Category Submenu Items

Category Submenu Items

MS Excel

About Course

What will you get in this Course?

Course Curriculum

Introduction, Shortcuts, Data Editing

1 – Excel – Introduction

2 – Excel – Exploring

My First Workbook

3 – Excel – Understanding Ribbon

4 – Excel – Shortcuts

5 – Excel – Help

6 – Excel – Wroking with Template

7 – Excel – Workbook and Worksheet

8 – Excel – Saving and Recovery

9 – Excel – Editing Data

10 – Navigation and Selection

10.1 – Excel – Exercise 1

Sample_Store_Sales

Formuls, Calculations, Filtering

11 – Excel – Formulas and Functions

12 – Excel – Calculations

13 – Excel – Counting Values and Blanks

14 – Excel – Filtering Average

15 – Excel – Working with Min and Max

16 – Excel – Error Handling

17 – Excel – ABsolute and Relative Reference

18 – Excel – AutoSum and AutoFill

19 – Excel – Exercise 2

Absolute vs Relative Referencing

Autosum and Autofill

Calculating with the SUM function

Counting Values with the COUNT function

Error Handling

Finding Averages

Flash Fill

Formulas and Functions Explained

Using MIN and MAX

FlashFill, Managing, Calculation

20 – Excel – FlashFill

21 – Excel – Named Ranges

22 – Excel – Create Named Ranges

23 – Excel – Managing Named Ranges

24 – Excel – Using Named Ranges in Calculation

25 – Excel – Exercise 3

Creating Named Ranges

Using Named Ranges in Calculations

What are Named Ranges

Number Formatting, Time Formatting, Format Painter

26 – Excel – Number Formatting

27 – Excel – Date and Time Formatting

28 – Excel – Formatting Cells

29 – Excel – Using Format Painter

30 – Excel – Exercise 4

Date and Time Formats

Format Painter

Formatting Cells Rows and Columns

Number Formatting

Clearing Data, Aligning Text, Applying Themes

31 – Excel – Working with Rows and Columns

32 – Excel – Deleting and Clearing Data

33 – Excel – Aligning Text and Numbers

34 – Excel – Applying Themes and Styles

35 – Excel – Exercise 5

Aligning Text and Numbers

Applying Themes and Styles

Clearing Cells

Working with Rows and Columns

Structure Data, Custom Sorting, Filtaring

36 – Excel – How to Structure Data

37 – Excel – Single Level Sorting

38 – Excel – Multi Level Sorting

39 – Excel – Custom Sorting

40 – Excel – Auto Filtering

41 – Excel – Format as a Table

42 – Excel – Subtotal

43 – Excel – Exercise 6

Clipboard, Workbooks, Hyperlinks