Module 1 – Overview and Basic Set up
- Introduction – Basic Overview of the Course
- Understand the Basic Layout and Setup of Excel
- Excel Interface
Module 2 – Data Manipulation and Navigation
- Navigation & Anchoring Cells
- Adding/Deleting Rows and Columns
- Hiding/Unhiding Rows and Columns
- Group/Ungroup Rows and Columns
- Merge & Center
- Copying Values, Formats, Comments… (Paste Special)
Module 3 – Formatting
- Basic, Number, Currency, Date and Custom formatting
- Fills, Fonts, Border and Alignment
- Conditional Formatting
Module 4 – Filters and Drop Downs
- Filters and Sorting
- Drop Downs
Module 5 – Basic Charting
- Line Chart, Bar Chart and Combination Chart
- Pie Chart
Module 6 – Basic Excel Functions, Formulas and Lookups
- Autosum Shortcut Key
- AND
- AVERAGE
- AVERAGEIF
- CHOOSE
- CONCATENATE
- COUNT
- COUNTIF
- DATE, EOMONTH, TODAY, YEAR & MONTH
- Vlookup and Hlookup
- IF
- IRR (Internal Rate of Return)
- Index, Match & Index Match
- Max, Min and Median
- NPV (Net Present Value)
- OR
- IF (OR and AND)
- PROPER
- ROUND
- SUM
- SUMIF
- SUMPRODUCT
- TRIM
- PMT
Module 7 – Niche Functions
- Pivot Tables
- Goal Seek
Module 8 – Self Evaluation
- Practice Test 1
- Practice Test 2