Section 1: Introduction
Section 2: Getting Started with Excel
Section 3: Entering Data to Excel
-
3.1. Data Entry Editing and AutoFill (4:43)
-
3.2. Flash Fill (1:57)
-
3.3. Dates and Times (5:16)
-
3.4. Undo Redo Save and Save As (4:41)
-
3.5. Rows and Columns Insert Delete Hide and Unhide (7:54)
-
3.6. Moving Copying and Deleting Data (4:12)
-
3.7. Finding and Replacing Data (3:31)
-
Section 3 Practice Files
-
Section 3 Quiz
Section 4: Formatting
Section 5: Formulas and Functions
-
5.1. Introductions to Formulas and Functions (5:45)
-
5.2. Relative Absolute and Mixed References (4:36)
-
5.3. SUM and AVERAGE (2:05)
-
5.4. Statistical Functions MIN MAX (4:00)
-
5.5. IF and Nested IF (4:41)
-
5.6. COUNT COUNTA (4:27)
-
5.7. SUMIF AVERAGEIF (4:41)
-
5.8. ROUND (2:45)
-
5.9. VLOOKUP (6:08)
-
5.10. Problems with VLOOKUP (3:56)
-
5.11. XLOOKUP (3:11)
-
5.12. RAND (3:13)
-
5.13. CONCAT (2:15)
-
5.14. Text Functions 1 (4:47)
-
5.15. Text Functions 2 (4:16)
-
5.16. New Text Functions (2:49)
-
5.17. Date and Time Functions (2:10)
-
5.18. What Next With Formulas (1:20)
-
Section 5 Practice Files
-
Section 5 Quiz
Section 6: Adjusting Worksheet Views and Layout
Section 7: Managing and Analyzing Data
Section 8: Other operations with Worksheets
Section 9: Conclusion
