Premium
Chapter 1: Getting Started with Excel 3
1/15/2025
Navigating the Excel Interface 3
1/15/2025
Entering and Editing Data 7
1/15/2025
Chapter 2: Essential Formulas 12
1/15/2025
Basic Arithmetic Functions (SUM, AVERAGE, MIN, MAX) 12
1/15/2025
Conditional Functions (IF, AND, OR) 17
1/15/2025
Chapter 3: Intermediate Formulas 22
1/15/2025
Financial Functions (PV, FV, PMT) 22
1/15/2025
Date and Time Functions (NOW, DATE, TIME) 27
1/15/2025
Chapter 4: Advanced Formulas 31
1/15/2025
Array Functions (SUMPRODUCT, MAXIFS, MINIFS) 31
1/15/2025
Pivot Tables and Charts 35
1/15/2025
Chapter 5: Functions for Data Manipulation 39
1/15/2025
Text Functions (CONCATENATE, LEFT, RIGHT, MID) 39
1/15/2025
Logical Functions (NOT, TRUE, FALSE) 43
1/15/2025
Chapter 6: Functions for Statistical Analysis 48
1/15/2025
Correlation and Regression (CORREL, SLOPE, INTERCEPT) 48
1/15/2025
Hypothesis Testing (T.TEST, ANOVA) 52
1/15/2025
Chapter 7: Functions for Financial Analysis 56
1/15/2025
Investment Functions (IRR, NPV, XIRR) 56
1/15/2025
Loan Functions (PMT, FVSCHEDULE, PPPMT) 60
1/15/2025
Chapter 8: Functions for Date and Time Management 66
1/15/2025
Date Math Functions (DATEADD, DATEDIF) 66
1/15/2025
Time Conversion Functions (TIMEVALUE, TIME, HOUR) 69
1/15/2025
Chapter 9: Conditional Formatting 74
1/15/2025
Conditional Formatting Basics 74
1/15/2025
Data Bars, Color Scales, and Icon Sets 78
1/15/2025
Chapter 10: Advanced Formatting 83
1/15/2025
Custom Number Formats 83
1/15/2025
Conditional Formatting Rules 86
1/15/2025
Chapter 11: Tips and Tricks 91
1/15/2025
Keyboard Shortcuts 91
1/15/2025
Error Handling 95
1/15/2025
Chapter 12: Troubleshooting and Problem-Solving 99
1/15/2025
Common Excel Errors 99
1/15/2025
Troubleshooting Tips 103
1/15/2025