arrow_back
Chapter 1
1.1 Course Content & Coverage
1.2. Compatibility & Setup Information
1.3. Course Resources & Downloads
1.4. Course Expectation
Chapter 2
2.1. About Section
2.2. Print Preparation
2.3. Text to Column
2.4. Data Protection Using Cell Format
2.5. 3D Referencing
2.6. Name Manager in Excel
2.7. Understanding Flash Fill & Hyperlink Function
2.8. Conditional Formatting & Usages
2.9. Remove Duplicate Function
2.10. Data Validation Tools
2.11. Group & Ungroup Function
2.12. Consolidation
2.13. Bonus Video_Conditional Data Validation
Chapter 3
3.1. About the chapter
3.2. Basic IF Sttement
3.3. Nested IF Statement
3.4. Combination of various logical statements
Chapter 4
4.1. About The Chapter
4.2. EDATE & EOMONTH Function
4.3. DATEDIF Function
4.4. CONCATENATE & SUBSTITUTE Function
4.5. Bonus Video-Text to Column
Chapter 5
5.1. About the Chapter
5.2. AVERAGE & ROUND function
5.3. SUMIF function
5.4. SUMIFS function
5.5. COUNTIF & COUNTIFS Function
5.6. SUMPRODUCT function
5.7. SUBTOTAL Function
5.8. Bonus Video_ Reconciliation using SUMIFS
Chapter 6
6.1. About Chapter
6.2. Converting the Range to Table & Vice-Versa
6.3. Visual presentation with table
6.4. Visual presentation with charts
6.5. Sparklines
6.6. People graph & map chart
6.7. Bonus Video_Add data to chart
6.8. Bonus Video_Analysis Tool
Chapter 7
7.1 Bonus Video-Calculation of Salary Sheet Using simple IF & MIN statement
7.2 Congratulations
7.3 Your Next Step
Resources
Chapter 2 Related Workable Files
Chapter 3 Related Workable Files
Chapter 4 Related Workable Files
Chapter 5 Related Workable Files
Chapter 6 Related Workable Files
Chapter 7 Related Workable Files