Tentatively over 2 months

Module 1: Let’s Start with some basics - Working with Basic excel functions

1. Working with the SUM() Function
   
2. Working with the MIN() and MAX() Functions
3. Working with the AVERAGE() Function
4. Working with the COUNT() Function
5. Adjacent Cells Error in Excel Calculations
6. Using the AutoSum Command
7. Excel AutoSum Shortcut Key
8. Using the AutoFill Command to Copy Formulas
9. How Subtotals function can save you time
10. Absolute vs Relative cell Referencing

Module 2: Data Cleanup with Excel

Sub-Module 1: Formatting Data into Excel Workbook

1. Working with Font Formatting Commands
2. Changing the Background Color of a Cell
3. Adding Borders to Cells
4. Formatting Data as Currency Values
   

Sub-​Module 2: Working with large sets

1. Formatting Percentages
2. Using Excel's Format Painter
3. Creating Styles to Format Data
4. Merging and Centering Cells
5. Using Conditional Formatting

Module 3: Advance Formulas for quick and dynamic analysis

1. ​Formula #1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions
2. Formula #2 - IF (Nested Functions) Because Data Analysis is Often Not Simple
3. Formula #3 - IFERROR for Credible Reports
4. Formula #4 - VLOOKUP For Dynamic Lookups
5. Formula #5 - INDEX & MATCH for Flexible Lookups

Module 4: Some more Advanced Formulas to master

1. Formula #6 - AVERAGEIFS
2. Formula #7 - Excel's Top Date Functions
3. Formula #8 - OFFSET for Dynamic Calculations
4. Formula #9 - FREQUENCY, SMALL & LARGE to Organize and Rank
5. Formula #10 - SUMPRODUCT For the experts

Module 5: Continuation of Advance Formula Marathon with Case Study

1. ​YTD Calculations - SUM, SUMPRODUCT & OFFSET
2. 3 Ways to Lookup within Boundaries - SUMIFS, SUMPRODUCT & INDEX
3. Sum Alternate Columns based on Selection - SUMIFS & INDEX
4. Sum Alternate Columns – SUMPRODUCT

Module 6: Learn to Excel some cool Data Validation rules and text

Sub-Module 1: Excel Data Validation

1. Creating an Excel Data Validation List
2. Excel Decimal Data Validation
3. Adding a Custom Excel Data Validation Error
4. Dynamic Formulas by Using Excel Data Validation Technique

Sub-Module 2: Types of error in Excel and ways to resolve them

Module 7: Excel Text Function - Working with Text function

1. Introduction
2. Capitalization with UPPER LOWER PROPER & TRIM
3. Combining Text with CONCATENATE (&)
4. Extracting Strings with LEFT MID RIGHT & LEN
5. Converting Text to Values with TEXT & VALUE
6. Searching Text String with SEARCH & FIND
7. Categorizing Data with IF(ISNUMBER(SEARCH))
8. Combining RIGHT, LEN and SEARCH
9. Replacing Text with SUBSTITUTE

Module 8: Bonus Lecture on Formula based Formatting

1. Introduction
2. Creating Editing & Managing Formula-Based Rules
3. Highlighting Rows Using the MOD Function
4. Formatting Based on the Value of Another Cell
5. Formatting Cells Using Stats Functions
6. Formatting Cells Using Text Functions & Logical Operators.