Basic MS Excel

Module 1 – Overview and Basic Set up

1. Introduction – Basic Overview of the Course
2. Understand the Basic Layout and Setup of Excel
3. Excel Interface

Module 2 – Data Manipulation and Navigation

1. Navigation & Anchoring Cells
2. Adding/Deleting Rows and Columns
3. Hiding/Unhiding Rows and Columns
4. Group/Ungroup Rows and Columns
5. Merge & Center
6. Copying Values, Formats, Comments… (Paste Special)

Module 3 – Formatting

1. Basic, Number, Currency, Date and Custom formatting
2. Fills, Fonts, Border and Alignment
3. Conditional Formatting

Module 4 – Filters and Drop Downs

1. Filters and Sorting
2. Drop Downs

Module 5 – Basic Charting

1. Line Chart, Bar Chart and Combination Chart
2. Pie Chart

Module 6 – Basic Excel Functions, Formulas and Lookups

1. Autosum Shortcut Key
2. AND
3. AVERAGE
4. AVERAGEIF
5. CHOOSE
6. CONCATENATE
7. COUNT
8. COUNTIF
9. DATE, EOMONTH, TODAY, YEAR & MONTH
10. Vlookup and Hlookup
11. IF
12. IRR (Internal Rate of Return)
13. Index, Match & Index Match
14. Max, Min and Median
15. NPV (Net Present Value)
16. OR
17. IF (OR and AND)
18. PROPER
19. ROUND
20. SUM
21. SUMIF
22. SUMPRODUCT
23. TRIM
24. PMT

Module 7 – Niche Functions

1. Pivot Tables
2. Goal Seek

Module 8 – Self Evaluation

1. Practice Test 1
2. Practice Test 2