Course Content
Table of Contents
0/33
1 Understand MS Excel Interface
2 Understand MS Excel Interface_2
3 MS Excel Home Tab
4 Logical Formulas in MS Excel
5 Math and Stat Functions in MS Excel
6 Math and Stat Functions Practice 1
7 Math and Stat Functions Practice 2
8 Text Formula in Excel Part 1
9 Text Formula in Excel Part 2
10 Text Formula in Excel Part 3 (Text Join)
11 Text Formula in Excel Part 4 (Replace)
12 Text Formula in Excel Part 5 (Substitute)
13 Text Formula in Excel Part 6 (Text to Columns)
14 Text Formula in Excel Part 7 (Trim)
15 Text Formula in Excel Part 8 (Retrieved first_name and last_name)
16 Pivot Table in Excel – Part 1
17 Pivot Table in Excel Part 2 (Modify the Pivot Table)
18 Pivot Table in Excel- Part 3 (Pivot Chart)
19 Pivot Table in Excel Part 4 (Filtering in Pivot Table)
20 Pivot Table in Excel Part 5 (Get Pivot Data)
21 VLookup in Excel
22 HLookup in Excel
23 Dynamic Dashboard Using MS Excel
24 What if Analysis [Goal Seek]
25 What if Analysis [Secnario Manager]
26 What if Analysis [Data Table]
27 Sparklines
28 Sort, Filter, Validation, Slicer
29 Descriptive Statistics in Excel
30 Correlation Test in Excle
31 Regression Analysis in Excel
32 t-Test & F-Test in Excel
33 ANOVA Test
Microsoft Excel: Basic to Advanced
    About Lesson

    Previous
    Next