resources on the web

AccountingC  P  EStudentCollegiateEmploymentExcel TipsCertificationsContact

Excel Tips
& Tricks

 

Download individually (Microsoft 2007 versions)
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