Table of Contents

1. Why Excel 365?
2. Why the Spreadsheet Was Invented
3. What Does Excel Do?
4. Key Concepts Used to Create Excel Solutions
5. The Structure of Excel Files and Worksheets
6. Keyboard Keys and Shortcuts
7. Worksheet Efficiency Tricks
8. Worksheet Formulas, Formatting, and Setup to Solve Problems
9. A Golden Rule for Building Excel Models
10. Knowing When to Use the ROUND Function
11. Date and Time Number Formatting and Formulas
12. Worksheet Formula Types and Formula Elements
13. Logical Tests and Related Functions (AND, ISNUMBER, IF, IFS, FILTER, SUMIFS, and More)
14. Worksheet Lookup Functions and Formulas
15. Worksheet Array Formulas: Just Enter!
16. The LET and LAMBDA Functions
17. Data Analysis Basics: Standard Pivot Tables, Sorting, Filtering, Visualizations, and More
18. Advanced Data Analysis with Power Query, Power Pivot, Power BI, M Code, and DAX
19. Data Analysis Examples: Big Data and Complex Data Analysis
20. The Macro Recorder and the VBA Editor
21. Financial Worksheet Functions
22. Simple Linear Regression Worksheet Functions