Course Content
Chapter 01 – Microsoft Excel Basic Knowledge
0/6
1- Microsoft Excel Introduction
10:56
2 – How to Work in Excel And Use Basic Formulas
11:10
3- Use Clipboard Like Pro Full Explain
11:57
4 – Organize Row Column And Worksheet
08:47
5 – Data Entry Like Pro
05:45
6 – Create Your Own Custom List
06:31
Chapter 02 – Password Protection & Backup
0/2
07 – How Make Password your Excel File
05:55
08 – How To Create a Backup Excel File
06:01
Chapter 03 – Basic Formula & Data Entry
0/3
09 – How to Use Sum Formula
06:14
10 – How to Use Skip Blanks
03:24
11 – Subtract, Multiple, Divide And Percentage
07:57
Chapter 04 – Excel Home Tab Tutorial
0/9
12 – Use of Number Format in Excel
11:14
13 – Use Conditional Formatting
13:37
14 – How to Sort & Filter Data
08:37
15 – Using Find and Replace and Using GoTo
07:20
16 – How to Use Status Bar
07:27
17 – Freeze Panes Option
04:42
18 – Split Window
04:41
19 – Fill Option
10:51
20 – Flesh Fill
08:10
Chapter 05 – Excel INSERT Tab Tutorial
0/11
21 – Pivot Table
11:40
22 – All Table Option
11:23
23 – Pictures Option
11:36
24 – Use Shape
12:23
25 – Use 3D Modal
06:04
26 – Smart Art
08:28
27 – Advanced Charts & Graph
06:29
28 – People Graph
03:18
29 – Create Hyperlinks
07:45
30 – Header and Footer
07:30
31 – Write, Insert, or Change an Equation
04:27
Chapter 06 – Excel Draw Tab Tutorial
0/1
32 – Using the Draw Tab
03:45
Chapter 07 – Excel Page Layout Tab Tutorial
0/3
33 – How to Use Themes
04:45
34 – Complete Page Setup
15:03
35 – Scale to Fit Setup
04:45
Chapter 08 – Excel Advanced Formulas Part 1
0/16
36 – IF Formula
05:20
37 – IF Formula With Multiple Conditions
06:37
38 – Change Case and Round Figure Formula
05:07
39 – VLOOKUP Formula
06:49
40 – VLOOKUP Formula Examples
16:30
41- HLOOKUP Formula
42 – And Formula
04:12
43 – Convert Number into Word Formula
04:37
44 – Use Macros with Example
04:37
45 – Subtotal Formula
05:15
46 – Link Data in Excel Spreadsheets Formula
04:37
47 – Data Consolidate Formula
02:39
48 – Calculate Age With Date, Date If Formula
05:39
49 – E-Date and Eo-Month Formula
03:39
50 – Calculating Percent Formula
03:13
51 – Superscript and Subscript Formula
02:08
Chapter 09 – Excel Advanced Formulas Part 2
0/11
52 – Group Ungroup Subtotal Formula
03:49
53 – Goal Seek Formula
02:38
54 – PMT Formula
03:03
55 – Goal With PMT Formula
01:24
56 – Concat Formula
06:24
57 – INDIRECT Formula
03:26
58 – Match Formula
04:34
59 – Count, Counta, Countblank Formula
02:38
60 – EXACT Formula
02:42
61 – Sumif Formula
03:08
62 – Sumifs Formula
07:25
Chapter 10 – Excel Advanced Formulas Part 3
0/10
63 – Round, RoundUp, RoundDown, MRound Formula
06:59
64 – Array Formula
05:28
65 – LEFT, RIGHT, MID, LEN & FIND Formula
06:10
66 – Split Name Using LEFT, RIGHT, MID, LEN Formula
04:06
67 – Mod Formula
04:03
68 – Quotient Formula
03:14
69 – Replace Formula
03:43
70 – SUBSTITUTE Formula
04:45
71- Excel Formula Error Types
06:32
72 – SUMPRODUCT Formula
04:38
Chapter 11 – Excel Advanced Formulas Part 4
0/9
73 – Text Formula
03:29
74 – Double VLOOKUP Formula
05:50
75 – Simple Interest Formula
02:47
76 – Compound Interest Formula
05:17
77 – Ceiling And Floor Formula
03:53
78 – Index Formula
02:13
79 – INDEX + MATCH Formula
04:00
80 – Forecast Formula
03:26
81 – Value Formula
03:59
Chapter 12 – Practical
0/9
82 – Most Important Keyboard Shortcut
10:42
83 – Employees Payroll and Salary Slip
13:00
84 – Daily Stock Register
08:39
85 – Dynamic Unit Converter
06:00
86 – Dynamic Dropdown List
08:52
87 – School Marksheet With Grade
07:39
88 – Make Checklist & To Do List
05:11
89 – Make Attendance Sheet
07:19
90 – Student Database With Mail Merge
32:56
On Demand Videos
0/1
1 – Count ifs Formula
Trial Paper and Final Exam for Certificate
0/2
Trial Paper
00:00
Final Exam
20:00
MS Excel Advanced Course
About Lesson

Previous
Next
0% Complete