More fun with Excel

OBJECTIVES: After completing this class, students will be able to

  • Understand absolute versus relative cell referencing
  • Use Cell Styles to format a spreadsheet
  • Use conditional formatting

Challenge yourself:

  • Use templates
  • Use Goal seek
  • Use a nested IF
  • Use a Lookup Table
  • Create a Pivot table
  • Work with multiple sheets
  • Use Page Setup to print headers on multiple pages

 

lmayer@elgin.edu