課程資料
課程簡介
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
課程章節
- 32 個章節
- 192 堂課
- 第 1 章 How this MS Excel course will help us to become an Expert in MS EXCEL?
- 第 2 章 How to open excel sheet?
- 第 3 章 HOME Tab Group - Functionality of each and every field comes under HOME Tab
- 第 4 章 INSERT Tab -Insert PIVOT table
- 第 5 章 INSERT Tab - Pivot Table Options & Settings
- 第 6 章 INSERT Tab - Show value as in PIVOT TABLE
- 第 7 章 INSERT Tab - Calculated as, Filter & filter report pages, Slicer & Timeline
- 第 8 章 Insert tab - Insert PICTURE, SHAPES, ICON 3D Models, SmartArt and Screen shots
- 第 9 章 INSERT Tab - PIVOT CHART
- 第 10 章 INSERT Tab - Insert Sparklines & Filters
- 第 11 章 INSERT Tab - Insert Hyperlink in MS Excel
- 第 12 章 Insert comments, Insert Texts & Insert Symbols
- 第 13 章 Insert Texts
- 第 14 章 Draw in MS Excel
- 第 15 章 Page Layout set up in MS Excel
- 第 16 章 Scale to Fit (Width, Height & Scale)
- 第 17 章 All Formulas in MS Excel
- 第 18 章 DATA Tab - Get & Transform Data, Queries & Connections, Sort & Filters
- 第 19 章 Sort & Filter
- 第 20 章 Data Tools in MS Excel
- 第 21 章 Consolidate the data in MS Excel
- 第 22 章 DATA Tab - Data Model
- 第 23 章 What-If Analysis (Scenario Manager, Goal Seek & Data Table)
- 第 24 章 Review TAB in MS Excel
- 第 25 章 VIEW tab in MS Excel (All controls with real-time example)
- 第 26 章 How to RECORD MACRO in MS Excel?
- 第 27 章 50 Shortcuts in MS Excel
- 第 28 章 Become an EXPERT in MS Excel DATA ENTRY.
- 第 29 章 VLOOKUP - Very Basic level to Advanced level
- 第 30 章 HLOOKUP - Very Basic level to Advanced level
- 第 31 章 XLOOKUP - Basic example on XLookup
- 第 32 章 AI Chat GPT for Excel in Details
課程內容
- 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
此課程所涵蓋的技能
評價
-
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.