Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Language
English
Taught by
Manoj Kumar
Rating
Course Overview
Be an Expert in MS Excel with CHAT GPT - 2025
Welcome to most updated MS Excel learning sessions. Which includes all controls along with real-time scenarios. Discussed all formulas along with examples.
This training sessions covers below the details -
Fundamentals on MS Excel
Field by Field discussion on all control which we have under TABS
Clipboard, Font management, Alignment, Number setup,
Conditional formatting
Format as table
Cell style
Insert, delete & format the cell, rows & columns
SUM, Fill, clear the data in MS Excel
Add in and how to convert excel to PDF
Pivot Tables
Advanced Pivot Tables
Recommended PIVOT tables & tables
How to insert PICTURES, SHAPES, ICON & 3D MODELS
How to insert MAP in excel
Text Function
Sparklines
How to add hyperlinks in MS Excel
Filter the data
Advanced filter
Timeline
Insert comments, delete comments & Edit comments
Insert notes, delete notes & Edit notes
Text functionalities
How to insert symbols
Drawing tools
Ink to Shape
Ink to Math
Ink replay
Theme effects
Page setup for printout
How to increase height, weight & scale setup
Sheet option
Text alignment
Arrangement in MS Excel
Formulas
How to transform the data in MS Excel from text/CSV. INTERNET, XML, JSON & PDF
Proofing
Check accessibility
How to translate the data in different languages
Insert comments, display comments
Insert notes, display notes
How to protect the excel sheet with password
Hide link
Sheet view
How to break up the preview
Page layout setting for printout
Customer view for printout
How to hide & display gridlines, formula bar & Headings
ZOOM
How to freeze panes
How to switch the windows
MACRO recording
Use relative reference
Data entry from basic to advance level
VLOOKUP
HLOOKUP
XLOOKUP
CHAT GPT
Dashboard
Course Content
- 32 section(s)
- 192 lecture(s)
- Section 1 How this MS Excel course will help us to become an Expert in MS EXCEL?
- Section 2 How to open excel sheet?
- Section 3 HOME Tab Group - Functionality of each and every field comes under HOME Tab
- Section 4 INSERT Tab -Insert PIVOT table
- Section 5 INSERT Tab - Pivot Table Options & Settings
- Section 6 INSERT Tab - Show value as in PIVOT TABLE
- Section 7 INSERT Tab - Calculated as, Filter & filter report pages, Slicer & Timeline
- Section 8 Insert tab - Insert PICTURE, SHAPES, ICON 3D Models, SmartArt and Screen shots
- Section 9 INSERT Tab - PIVOT CHART
- Section 10 INSERT Tab - Insert Sparklines & Filters
- Section 11 INSERT Tab - Insert Hyperlink in MS Excel
- Section 12 Insert comments, Insert Texts & Insert Symbols
- Section 13 Insert Texts
- Section 14 Draw in MS Excel
- Section 15 Page Layout set up in MS Excel
- Section 16 Scale to Fit (Width, Height & Scale)
- Section 17 All Formulas in MS Excel
- Section 18 DATA Tab - Get & Transform Data, Queries & Connections, Sort & Filters
- Section 19 Sort & Filter
- Section 20 Data Tools in MS Excel
- Section 21 Consolidate the data in MS Excel
- Section 22 DATA Tab - Data Model
- Section 23 What-If Analysis (Scenario Manager, Goal Seek & Data Table)
- Section 24 Review TAB in MS Excel
- Section 25 VIEW tab in MS Excel (All controls with real-time example)
- Section 26 How to RECORD MACRO in MS Excel?
- Section 27 50 Shortcuts in MS Excel
- Section 28 Become an EXPERT in MS Excel DATA ENTRY.
- Section 29 VLOOKUP - Very Basic level to Advanced level
- Section 30 HLOOKUP - Very Basic level to Advanced level
- Section 31 XLOOKUP - Basic example on XLookup
- Section 32 AI Chat GPT for Excel in Details
What You’ll Learn
- Master in Microsoft excel spreadsheets works, We can do data entry in smart way, We must be expert on Microsoft Excel formula, Data analysis, Charts and graphs on Microsoft Excel, Sorting data, Find and replace, VLOOK UP, HLOOKUP, XLOOKUP, Microsoft Excel shortcuts and best practices to increase the productivity, Conditional formatting on data entry, DATA ENTRY, CHAT GPT
Skills covered in this course
Reviews
-
DDatta Dhakne
Deep Understood, Very Nice, Excellent.
-
DDipshikha Sharma
Superb. Nice explanation.
-
NNaresh Saha
Best trainer for MS Excel which I found on Udemy. Just awesome.
-
BBhawna Sharma
Best course for beginner to advance level. Each and every session explained in detail with appropriate example. I will recommend this course.
