Microsoft Excel 2007
Workshop Information


Format used for handouts is Microsoft Word.

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

 
Excel 2007 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
22 pages
     Instructor Notes
7 pages
 
Excel 2007 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
13 pages
     Instructor Notes
10 pages
 
Excel 2007: 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
16 pages
     Instructor Notes
5 pages
          Workshop File
 
Excel 2007: 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
11 pages
          Instructor Notes
3 pages
 
Excel 2007: 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
15 pages
     Instructor Notes
3 pages
          Workshop File
 
Excel 2007: 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
10 pages
          Workshop Files
 
 
Excel 2007: 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
14 pages
          Workshop Files
 
 
Excel 2007: Lookups
1.5 hours
Topics include creating a validation rule to make a drop-down list; how to use the VLOOKUP function; creating IF functions to hide errors; and how to use them together to autofill a form. Experience with building equations in Excel required.
 
     Workshop Handout
14 pages
          Workshop Files
 
 
 
OTHER STUFF...
Excel Text Functions (Upper, Right...)
5 pages
Excel Logic Functions (Conditional, If, SumIf...)
4 pages
Excel Other Math Functions (Complex)
11 pages
MS Excel 2007 Online Documentation and Lessons
     - Requires GatorLink Username & Password
     

Primary Navigation

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