Graduate School of Business
MBA/MACC

Dynamic Excel Tips & Tricks
By Leslie Miller, MCE
  Size Format

Versions

 Right Click
to Download
Download individually:
GU Presentation 97-03 (BIG FILE) 1.9 MB PDF  97-03v
Concatenate 97-03 44 Kb DOC  97-03v
GU Presentation PPS - Slide Show (BIG FILE) 13.2 MB PPS  97-03v
GU MASTER Sample Data 97-03 927 Kb XLS  97-03v
Student - Raw Data 97-03 79 Kb XLS  97-03v
Additional Files:
GU Presentation Handouts 9703 090608 541 Kb PDF  97-03v
Short Cut Keystrokes 173 Kb XLS  97-03v
 
Session I Topics:
  • Welcome
  • Slideshow Presentation
  • Basics
  • Macros (Autofit and Gridlines)
  • 3 D References
  • Raw Data
  • One on One
 Session II To Do List:
  • Finish up on 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

THANK YOU!

Contact information:
Leslie Miller, MCE
Lecturer, School of Business Administration
Gonzaga University
502 E Boone Ave, AD Box 9
Spokane, WA 99258

Office: 213 Jepson
Phone: 509.313.3422
Fax: 509.313.5811
millerle@jepson.gonzaga.edu
Excel 97-03 How to Create a Macro
Screen Shots (xls file download)

Other Screen Shots

Excel 07 - Data Solver: Data, Analysis

Excel 97-03 - Data Solver: Tools, Solver

Get External Data