-
Presentation
- PPTX format
-
Handouts
- PDF format- Handouts
-
MASTER Sample Data - XLSX format
-
Concatenate
- Word DOCX format
-
ALL
FILES COMBINED - ZIP format
Topics
- Basics
- Macros (Autofit and Gridlines)
- Raw Data
- 3 D References
- Financial Portfolio
- Custom formatting dates
- Linking external data in other reports
- Filters with Macros
- Duplicates
- Concatenating
- Pivot Tables
- Conditional Formatting
- External Data
- Data Validation
- Subtotals
- Goal Seeker
- Filtering
- Solver
- Advanced Filtering
- Dashboards
- Tools Options (view)
- Protection and Passwords
Contact information:
Leslie Miller, MCEd
Phone: 509.939.7641
Excel v07 How to Create a Macro:
Screen Shots (xls file download)
Other Screen Shots
Excel 07 - Data Solver: Data,
Analysis
Excel 2007 - Data Solver:
Tools, Solver
Get External Data
