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)
  • 3 D References
  • Financial Portfolio
  • Custom formatting dates
  • Linking external data in other reports
  • Filters with Macros
  • Duplicates
  • Concatenating
  • Pivot Tables
  • Conditional Formatting
 Topics - Part 2:
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