Master MS Excel: Beginner to Advanced with AI Techniques

Name: Master MS Excel: Beginner to Advanced with AI Techniques
Rating: 4.6 (308 reviews)

Learn Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2013, 2016,2019,2021 and 365. with AI Techniques

Created byChandan Kumar

Last updated 9/2026

Hindi

What you'll learn

Master Microsoft Excel from Beginner to Advanced
Learn the most common Excel functions used in the Office
Learn Quick Access Toolbar, File Menu, Home Insert Page Layout Formulas Data Review View Tab
Maintain large sets of Excel data in a list or table
Create Dynamic MIS Reports by mastering one of the most popular tools, PivotTables & Pivot Charts
Learn the most useful tool like Flash Fill, Slicers
Learn the 160+ Excel Keyboard Shortcuts to Become Excel Super Star
Learn the 100+ Excel Magical Tips & Tricks to make easier your Office Work
Learn How to Maintain Attendance Register, Multiple Stock or Inventory
Learn How to make GST Invoice in Excel & How to Maintain Overtime Wages or Salary
Learn the Most Useful Formulas for automate your work in excel
Learn popular formulas Vlookup, Hlookup, Index, Match, If, Sumif, Countif, Averageifs

Course content

5 sections • 128 lectures • 26h 21m total length

Introduction1:13

Starting Excel & Understanding the Interface15:53
Excel Data Preparation7:54
Font Group: Text Formatting Tools in Excel5:52
Clipboard Group: Copy, Cut, Paste & Format Painter10:25
Alignment Group: Cell Alignment and Formatting Tools10:54
Insert Delete Rows Columns Cells - Autofit & Adjust Size7:50
Number Formatting + Download Excel eBook13:18
Sum Function in Excel9:52
Subtraction Formula in Excel9:06
Multiplication Formula in Excel4:16
Division Formula in Excel2:40
Percentage Calculation in Excel4:30
Find and Replace Function in Excel6:46
Conditional Formatting in Excel6:31
Find and Remove Duplicates2:47
File Menu – New, Open, Save, Save AS, Print, Share, Export etc.21:17
Format as Table & Cell Style14:35
Format Command32:53
Auto Sum, Fill & Clear Commands35:19
Illustrations – Pictures, Online Pictures, Shapes, SmartArt, ScreenShot11:47
Working with Charts9:50
Insert Hyperlink, Text Box, Header & Footer, WordArt, Equation, Symbol19:19
Print Large Data & Page Setup for Printing45:56
Create Professional Dummy Data in Just 10 Seconds for Excel Practice7:54
Split Single Column of Text into Multiple Columns3:41
Goal Seek | 3 Examples | Powerful Excel Tool10:37
Group Ungroup Subtotal Function6:38
Comments5:47
View Tab13:01
Start New Line in Same Cell2:23
Absolute Reference12:11
Save 1000s Excel Charts as image within 1 second2:09
Filter Secret Tips and Tricks10:01
Data Entry Work in excel6:16
Write Long or Big Number in Excel5:36
Macro in Excel10:00
Remove Extra Space from Excel Sheet4:32
Link Excel Data with MS Word2:21
Index Formula8:25
Match Formula5:35
Count, Counta, CountBlank Formula5:47
Vlookup Formula29:09
SUMIF and SUMIFS Formula11:18
IF Formula9:27
Hlookup Formula5:47
Rand & RandBetween Formula4:21
Create Normal and 3D Check Box5:56
Split Data from One Column to Multiple Column3:55

Pivot Table & Pivot Chart20:09
25+ Pivot Table Tips and Tricks for Smart Work43:45
18 Excel Problem Solved with Flash Fill Function15:07
Create Barcode & QR Code in Excel11:56
Refresh Pivot Table Automatic & Manual (4 Method)6:32
Create Pivot Table from Multiple Excel Sheets8:32
Split Data from Master Sheet to Multiple Sheets23:42
Slicer in Excel9:16
Maintain Multiple Stock / Inventory in Excel46:37
How to Maintain Cash Book or Petty Cash in Excel11:16
Convert Scan PDF into MS Excel5:43
Convert All Excel Sheets into Separate PDF Files2:20
Convert All Excel Sheets into Separate Excel Files3:13
Prepare Attendance Register15:44
Maintain Multiple Stock / Inventory in Excel Using Pivot Table11:34
Make Search Box6:55
Google Translate formula5:15
3 Best Method to Transpose Excel Data6:06
5 Way to Remove Duplicates Data19:05
4 Way to Add Zero Before any Number7:00
Automatic Update Drop Down List18:51
Best Method to Calculate Running Total6:15
Create Notification or Reminder for Due Dates11:34
Make Fully Automatic GST Invoice57:35
Save Each Invoice in PDF format automatically10:48
Unstack Excel Data from One Column to Multiple Column5:57
Convert any Image or Printout to Excel6:01
Mail Merge with Decimal Problem Solution13:45
Recover Unsaved Excel file - Excel Function8:35
Stop Duplicate Entries14:12
Hide Formula6:31
Convert any Text to lower Proper UPPER case in same cell6:21
Highlight a Particular Word or Number5:09
Serial No. and formula Problem in Data Filtering9:26
Create Data Entry form9:07
Highlight Active Cell Row and Column4:03
Unlock Password Protected Sheet without knowing Password5:44
Maintain Overtime & Overtime Wages22:09
3 Formula to Calculate Rank9:02
Double Vlookup Formula11:32
Hlookup Formula12:03
Fuzzy lookup8:32
Picture Lookup9:46
Subtotal Powerful formula13:56
Value Formula8:21
Index + Match Formula15:03
Quotient and Mod Formula6:22
Add Search Box in Slicer Function9:25
Compare Two List with Match Formula6:08
Convert Formula – Easy way to convert units8:55
Forecast Formula5:27
Average Vs Averageif Formula6:32
Countif Formula4:19
Concatenate Formula and & symbol an alternative of Concatenate7:38
Average, Averageif and Averageifs Formula12:06
Insert Right Tick and Cross Tick9:52
Combine Multiple Columns Data into One & Find Unique Records2:39
Combine All Excel Sheets Data into one Sheet Using VStack Formula3:15

10 New & Fresh Excel Tips11:43
Top 10 Excel Tips and Tricks21:33
12 Excel Magical Tips & Tricks15:06
Top 5 Excel Tips and Tricks9:27
4 Excel Magical Tips and Tricks8:28
Top 6 Excel Tips and Tricks14:31
Top 7 Excel Tips and Tricks14:17
30 Most Useful Excel Shortcuts49:04
2 Excel Magical Tips2:14
Excel Ctrl A to Ctrl Z Shortcut Keys21:09
Excel Sheets Tips and Tricks13:59
160+ MS Excel Keyboard Shortcuts2:01:59
7 way to Jump on any Excel Sheet2:16
5 Excel Tips11:31
Copy Formula without changing cell reference4:23

Requirements

Microsoft Excel 2007, 2010, 2013, 2016, 2019 or Excel 365 (anyone) installed on your computer
No prior Microsoft Excel Knowledge needed

Description

Microsoft Excel all in One Package In HINDI Language with AI Techniques

If you want to learn MS Excel from Zero Level to Advanced Level, then this course will make you Hero in excel.

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor I will use my 8+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

Creating effective spreadsheets
Managing large sets of data
Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, HLOOKUP, INDEX, MATCH, SLICER, PIVOT TABLS, FLASH FILL, IF, AVERAGE, COUNTA, SUMIF, SUBTOTAL, VALUE, and many more...)
Create Dynamic MIS report with Excel PivotTables
Learn how to work with charts in excel
Powerful Keyboard Shortcuts to make your excel superstar
100+ Excel Magical Tips and Tricks to make your office work easier
All Useful Excel basic and Advanced formulas
29+ Hours Course Duration to make you Expert in Excel

So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newb to Excel Guru!

Who this course is for:

Who wants to become master in Microsoft Excel and prepare for any office task

Master MS Excel: Beginner to Advanced with AI Techniques

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Microsoft Excel for Beginners48 lectures • 8hr 22min

AI for Excel Work Automation6 lectures • 1hr 23min

Advanced Excel58 lectures • 11hr 13min

Advanced Excel - Tips & Tricks with Keyboard Shortcuts15 lectures • 5hr 22min

Requirements

Description

Who this course is for: