Microsoft Excel 2003
Workshop Information


Format used for handouts is Microsoft Word.

To save the files, right click on the link, choose "Save Target As..."

 
Excel 2003 Basics I: Navigating and Formatting
2.0 hours
This workshop assumes no prior experience with Excel. Topics include an introduction to Excel; entering and editing data in cells; cut, copy and paste; formatting fonts, alignments, borders and shading. Lots of shortcuts!
 
     Workshop Handout
17 pages
     Instructor Notes
7 pages
 
Excel 2003 Basics II: Math and Functions
2.0 hours
This workshop assumes minimal experience with Excel, Basics I recommended. Topics include working with series; number formatting; working with formulas; using basic functions; using absolute and relative references; and naming cells and cell ranges.
 
     Workshop Handout
11 pages
     Instructor Notes
10 pages
 
Excel 2003: Printing and Setup
1.0 hour
This workshop assumes some experience with Excel, Basics I recommended. Topics include print preview; printing selections; print areas; page orientation; scaling; margins; centering; headers; footers; printing titles; gridlines; column headings; page break preview; and page breaks.
 
     Workshop Handout
14 pages
     Instructor Notes
4 pages
          Workshop File
 
Excel 2003: Linking Worksheets
1.0 hour
This workshop assumes some experience with simple math within Excel, Basics II recommended. Topics include inserting, deleting and renaming worksheets; linking worksheets; editing and printing multiple worksheets and linking workbooks.
 
          Workshop Handout
10 pages
          Instructor Notes
2 pages
 
Excel 2003: Charts and Graphs
2.0 hours
This workshop assumes prior experience with Excel, Basics I recommended. Topics include data groupings; creating and modifying charts; chart types; source data; chart options; chart locations; formatting; adding trend lines and error bars.
 
     Workshop Handout
14 pages
          Workshop File
 
Excel 2003: Sorting and Filters
1.5 hours
This workshop assumes some experience with Excel, Basics I recommended. Topics include single and multilevel sorting; data groupings; subtotals; applying and customizing data filters; and copying and totaling filtered data.
 
     Workshop Handout
8 pages
          Workshop handouts/Excel/files
 
 
Excel 2003: Pivot Tables
1.5 hours
This workshop assumes some experience with Excel, Basics II recommended. Topics include data groupings, pivot tables, pivot charts, formatting pivot tables, adding and removing data, multiple data forms, and sorting in pivot tables.
 
     Workshop Handout
13 pages
          Workshop handouts/Excel/files
 
 
OTHER STUFF...
How do I create and work with Macros?
4 pages
How can I install the Statistical Analysis Tools to use Regression Analysis?
4 pages
Excel Text Functions (Upper, Right...)
5 pages
Excel Logic Functions (Conditional, If, SumIf...)
4 pages
Excel Other Math Functions (Complex)
11 pages
 

Primary Navigation

  • Home
  • Schedule
  • Email Lists
  • Handouts
  • List All Workshops
  • UF Training Resources
  • Reserve Training Room
  • Directions
  • Contact Us