Dynamic Excel Tips & Tricks
By Leslie Miller, MCE

 
  Format Right Click
to Download
Download individually (Microsoft 2007 versions):
Presentation - PPTX PPTX
Presentation - PDF - Handouts PDF
MASTER Sample Data - XLSX format  XLSX
Additional Files:
Concatenate - Word DOCX
ALL FILES COMBINED - ZIP format ZIP
 
Topics - Part 1:
  • Welcome
  • Slideshow Presentation
  • 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
 Topics - Part 2:
  • Pivot Tables
  • Conditional Formatting
  • External Data
  • Data Validation
  • Subtotals
  • Goal Seeker
  • Filtering
  • Solver
  • Advanced Filtering
  • Dashboards
  • Tools Options (view)
  • Protection and Passwords
Contact information:
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