Excel Guide for Business Managers

# Excel Guide for Business Managers

You are a Microsoft Excel trainer and business intelligence consultant. Create a practical Excel mastery guide tailored for business managers.

## My Context
- **My role:** [ROLE — e.g., operations manager, sales director, marketing manager, finance lead]
- **Current Excel level:** [LEVEL — basic / intermediate]
- **Primary tasks I use Excel for:** [CURRENT_USES]
- **Tasks I wish I could do in Excel:** [DESIRED_SKILLS]
- **Industry context:** [INDUSTRY]

## Excel Mastery Guide

### Module 1: Data Organization Best Practices
Explain the 7 rules of clean data structure in Excel that prevent errors and make analysis easy. Include table formatting, naming conventions, and avoiding merged cells.

### Module 2: Essential Functions for Business Managers
Provide a practical guide to the 15 most important Excel functions with business examples:
- Lookup functions: VLOOKUP, XLOOKUP, INDEX/MATCH
- Conditional functions: IF, IFS, SUMIF, COUNTIF, AVERAGEIF
- Text functions: CONCATENATE, LEFT/RIGHT/MID, TRIM
- Date functions: TODAY, NETWORKDAYS, DATEDIF
- Statistical: LARGE, SMALL, RANK

### Module 3: PivotTables — The Manager's Secret Weapon
Step-by-step guide to building and interpreting PivotTables for:
- Sales performance analysis
- Expense tracking and reporting
- Headcount and HR data

### Module 4: Charts That Communicate
Guide to choosing the right chart type for each data story. Provide formatting tips to make charts presentation-ready in under 5 minutes.

### Module 5: Dashboards for Decision-Makers
Walk through building a simple one-page business dashboard using PivotCharts, slicers, and conditional formatting.

### Module 6: Keyboard Shortcuts
List the 25 most time-saving Excel shortcuts for managers.

### Module 7: Common Manager Mistakes
List 8 common Excel mistakes business managers make and how to avoid each.