1.1 Course Overview

1.2 Excel Overview

2.1 Data Entry  

2.2 Basic Formatting  

2.3 Inserting Formulas  

2.4 Go to Special  

2.5 Data Extraction  

2.6 Data Validation  

Ex. 2 Exercise S.2  

3.1 Protection  

3.2 Excel Visualization  

3.3 Paste Special  

3.4 Excel Shortcuts  

3.5 Hyperlinks  

Ex. 3 Exercise S.3  

4.1 Basic Formulas (Parts I & II)  

4.2 Cells Reference  

4.3 Range Names  

4.4 What-If Analysis  

4.5 Formula Tools & Tips (Parts I & II)  

Ex. 4 Exercise S.4  

5.1 Logical Functions (Parts I & II)  

5.2 Math Functions (Parts I & II)  

5.3 Statistical Functions (Parts I & II)  

5.4 Reference Functions (Parts I & II)  

5.5 Lookup Functions (Parts I & II)  

5.6 Date & Time Functions (Parts I & II)  

5.7 Financial Functions (Parts I, II & III)  

Ex. 5 Exercise S.5  

6.1 Data Sorting (Parts I & II)  

6.2 Data Filtering  

6.3 Data Cleaning  

6.4 Find & Replace  

6.5 Excel Tables  

Ex. 6 Exercise S.6  

7.1 Charts – Introduction  

7.2 Variance & Combo Charts  

7.3 Charts – Special Features  

Ex. 7 Exercise S.7  

8.1 Pivot Table – Introduction  

8.2 Pivot Table – Management  

8.3 Pivot Table – Important Tools  

Ex. 8 Exercise S.8  

9.1 Advanced Formatting  

9.2 Conditional Formatting  

9.3 Printing Techniques  

Ex. 9 Exercise S.9  

10.1 Case Resolution – Part I  

10.2 Case Resolution – Part II  

10.3 Case Resolution – Part III