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