Excel 2007 Tutorials

 

Microsoft Excel 2007 is the accepted application for data processing at Lewis University.

If you have additional questions, comments, or concerns, please feel free to contact Melissa Eichelberger at eichelme@lewisu.edu or at (815) 836-5583 (office).

MAIN MENU


Download the Excel 2007 Quick Reference Guide
 

Getting Started
  Office Button
  Ribbons
  Quick Access Toolbar
  Using Spellcheck
   

Calculations
  Creating Formulas
  Using Functions
  Reference Types and Linking Worksheets
   

Charts
  Creating and Modifying a Chart
  Chart Tools
   

Customized Excel

  Customizing the Excel Environment
  Customize Layout using Freeze Panes
  Customize Layout using Split and Hide Features
   

Formatting Cells
  Adding Borders and Fill Colors
  Splitting Text Columns
  Font - Format, Alignment, Dialog Box
  Height, Width, Hide/Unhide, Merge Cells
 

Evaluate the tutorials
 
 

 

Graphics
  Pictures and Clipart
  SmartArt
   

Manipulating Data
  Autofill
  Cut, Copy Paste Features
  Entering Data
  Sorting Data
  Filtering Data
   

Modifying a Worksheet
  Using Find and Replace
  Formatting Worksheet Tab
  Inserting and Deleting Cells
  Inserting and Deleting Worksheets
   

Page Properties and Printing
  Setting Page Breaks and Print Ranges
  Setting Margins and Page Orientation
  Adding Header/Footer
  Printing Titles
   

Working with a Workbook
  Creating, Opening and Saving a Worksheet