MS Excel Mastery with AI
2.Formatting
MS Excel Mastery with AI
0%
Completed
MS Excel For Beginners
1.Intro+Interface
Video - 00:14:45 mins
2.Formatting
Video - 00:10:15 mins
3.Data Entry
Video - 00:11:15 mins
4. Basic Analysis
Video - 00:16:15 mins
5. Insert Illustration
Video - 00:06:52 mins
6. Concept Formula
Video - 00:05:51 mins
7. Calculative Function
Video - 00:07:10 mins
8. Text Function
Video - 00:08:47 mins
9. Others function
Video - 00:04:40 mins
10. Data Tools
Video - 00:06:20 mins
11.Data Validation
Video - 00:8:56 mins
Class 01 Resourses File
Reading
Section 02
2.1 Flash Fill-1
Video - 00:08:14 mins
2.2 Len Function
Video - 00:02:24 mins
2.3 Transepose-1
Video - 00:02:55 mins
2.4 Group-1
Video - 00:04:51 mins
2.5 SUBTOTAL-1
Video - 00:09:33 mins
2.2.1 Go to Special
Video - 00:11:24 mins
2.2.2 Paste Special
Video - 00:08:27 mins
2.2.3 Skip Blanks Paste
Video - 00:05:05 mins
2.2.4 Mround
Video - 00:06:45 mins
2.2.5 Iferror
Video - 00:08:58 mins
Class 02 Resourses File
Reading
Section 03
3.1.1-Relative Ref-Absulote
Video - 00:13:17 mins
3.1.2-Mix Cell
Video - 00:11:39 mins
3.1.3 Rank F
Video - 00:05:30 mins
3.2.1 File Protection
Video - 00:04:21 mins
3.2.2 Cell Protection
Video - 00:12:06 mins
3.2.3 Individual Protection
Video - 00:08:15 mins
Class 03 Resourses File
Reading
Section 04
4.1-Shape-Image-Icon
Video - 00:06:27 mins
4.2 Hyperlink
Video - 00:08:51 mins
4.3 Bar chart
Video - 00:12:04 mins
4.4 Line Chart
Video - 00:06:04 mins
4.5 Pie chart
Video - 00:03:05 mins
4.6 Combo Chart
Video - 00:04:49 mins
4.7 Sparkline
Video - 00:02:43 mins
4.8. Print
Video - 00:08:48 mins
4.9 Page Layout
Video - 00:07:00 mins
Class 04 Resourses File
Reading
Section 05
5.1 Conditional Formatting
Video - 00:24:28 mins
5.2 Data Validation
Video - 00:08:12 mins
5.3 Dependent Dropdown
Video - 00:17:25 mins
Class 05 Resourses File
Reading
Section 06
6.1 SumIF-CountIFS
Video - 00:20:00 mins
Class 06 Resourses File
Reading
Section 07
7.1 Logic True-False
Video - 00:04:15 mins
7.2 Logic OR-AND
Video - 00:10:31 mins
7.3. IF Basic
Video - 00:11:30 mins
7.4 Calculation with IF
Video - 00:04:31 mins
7.5 Nested IF
Video - 00:10:05 mins
Class 07 Resourses File
Reading
Section 08
8.1 Basic Lookup
Video - 00:05:27 mins
8.2 Smart Lookup
Video - 00:04:39 mins
8.3 Vlookup
Video - 00:15:03 mins
8.4 Hlookup
Video - 00:03:00 mins
8.5 Xlookup
Video - 00:08:34 mins
Class 08 Resourses File
Reading
Section 09
9.1 Pivot Table Introducing
Video - 00:10:28 mins
9.2 Analysis With Field
Video - 00:08:34 mins
9.3 layout & formatting
Video - 00:09:00 mins
9.4 Field Calulation
Video - 00:13:23 mins
9.5 Slicer
Video - 00:02:58 mins
Sec-9.6 Pivot Charts
Video - 00:04:15 mins
9:7 Dashboard (Interactive).
Video - 00:49:49 mins
Dashboards(Interactive) Practise Work Sheet
Reading
Class 09 Resources File
Reading
Section 10
10.1 VBA & Basic Coding
Video - 00:07:45 mins
10.2 Macro Recording
Video - 00:11:05 mins
10.3 Using Code to in Word
Video - 00:08:48 mins
Class 10 Resources File
Reading
Section 11
11.1 ROI-Proffesional Temp
Video - 00:24:52 mins
11.2 Index-Match with Inventory
Video - 00:29:11 mins
11.3 Gantt Chart
Video - 00:34:18 mins
Class 11 Resources File
Reading
AI Tools IN EXCEL
ChatGPT + Excel Combo Magic
Video - 00:37:58 mins
Practice Resources file (ChatGPT + Excel Combo Magic)
Reading
Word File
Word File
Reading
More
Announcements
Reviews
Course Info
Login
Sign Up
Remember me
Forgot Password?
Sign in
I accept the
Terms of Service and Privacy Policy
Sign Up
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
Email Reset Link
body::-webkit-scrollbar { width: 7px; } body::-webkit-scrollbar-track { border-radius: 10px; background: #f0f0f0; } body::-webkit-scrollbar-thumb { border-radius: 50px; background: #dfdbdb }
