1. Introduction
2. Top 10 Excel Tips to Save You Time
-
1. Overview of top Excel tips (3:30)
-
2. Add numbers like a pro (8:56)
-
3. Save time by filling cells automatically (4:54)
-
4. Did data enter into one column? Split it (4:52)
-
5. Switch data around by transposing it (5:50)
-
6. Sort and filter for quick results (6:40)
-
7. Create a data table for tasks to make it easy (5:21)
-
8. Make drop-down list (7:32)
-
9. Quick Data Analysis (6:22)
-
10. Great charts for your visualization (4:43)
-
11. Pivot Tables for Data Analytics (6:08)
3. Excel essential functions
-
1. Introduction (1:14)
-
2. Basic formula operations (6:14)
-
3. Mathematical functions level1 (19:54)
-
4. Mathematical functions level2 (12:23)
-
5. Text functions level1 (9:07)
-
6. Text functions level2 (12:56)
-
7. Logical functions (11:03)
-
8. Date time functions (6:21)
-
9. V Lookup formula (12:12)
-
10. HLookup formula (4:07)
-
11. HLookup + Match formula (8:35)
-
12. Match + Index formula (5:22)
4. XLookup only for Excel 2021 and Office 365
5. Get Data and tools
6. Pivot Tables
7. Excel Charts
-
1. Introduction (1:12)
-
2. Excel Charts – Categories (2:31)
-
3. Elements of a chart (4:12)
-
4. Easy way to create charts (1:55)
-
5. Column or Bar charts (4:21)
-
6. Formatting charts (3:37)
-
7. Line charts (2:13)
-
8. Area charts (2:04)
-
9. Pie and Doughnut charts (3:47)
-
10. Format Area Plot or XY chart (7:33)
-
11. Scatter or bubble charts (2:08)
