Skip to content
I. Foundations: Laying the groundwork
- 1. Excel Interface Tour:
- Navigating the Ribbon
- Cells
- Rows
- Columns
- 2. Data Entry and Management:
- Inputting
- Editing
- Formatting Data
- 3. Formula Fundamentals:
- SUM
- AVERAGE
- COUNT
- MAX
- MIN
- VLOOKUP
- INDEX MATCH
- XLOOKUP
- IF
- SUMIF
- COUNTIF
- CONCATENATE
- LEFT
- RIGHT
- LEN
- TODAY
- NOW
- DATE
- MONTH
- YEAR
- SUMPRODUCT
- COUNTIFS
II. Building Blocks: Essential Skills for Everyday Use
- 4. Charts and Graphs:
- Visualizing Your Data with Bar
- Pie
- Line
- 5. Formatting for Clarity:
- Conditional Formatting
- Cell Borders, and Shading
- 6. Printing with Precision:
- Setting Margins
- Headers
- Footers
III. Power Tools: Unlocking Advanced Functionality
- 7. PivotTables:
- Summarizing and Analyzing Data Like a Pro
- 8. Macro Magic:
- Automating Repetitive Tasks for Efficiency
- 9. Function Frenzy:
- Exploring Advanced Financial
- Statistical, and Text Functions
IV. Mastering the Data: Refining Your Approach
- 10. Conditional Formatting 2.0:
- Highlighting Trends and Important Data Points
- 11. Data Validation:
- Ensuring Accuracy and Consistency
- 12. Power Query:
- Importing, Cleaning, and Transforming Data with Ease
V. The Big Picture: Putting it All Together
- 13. Power Pivot:
- Creating Data Models and Performing Complex Calculations
- 14. Dashboard Design:
- Communicating Insights Effectively with Interactive Dashboards
- 15. VBA Programming:
- Custom Functions and Automation for Ultimate Control