learnit.stfrancis.edu  
A Learning Resource for the University of St. Francis Community

Learnit Home

Word

Powerpoint

Access

Microsoft Excel 2010

Download the Excel 2010 Quick Reference Guide

Getting Started
    Length
min:sec
The File Menu print video 2:16
  The Ribbon (Formerly the Toolbars) print  
  Quick Access Toolbar print  
Customizing the Excel Environment
  Setting Excel 2010 Options print video 1:51
Working With a Workbook
  Creating, Saving and Opening a Workbook print video 3:30
Manipulating Data
  Entering and Selecting Data print video 1:28
  Copy, Cut and Paste / Undo and Redo print video 2:08
  Auto Fill print video 2:02
Modifying a Worksheet
  Insert and Delete Cells, Rows, Columns print video 2:04
  Find and Replace / Go To Command print video 1:52
  Spell Check print    
  Format Worksheet Tabs / Reposition Worksheets print video 1:44
  Insert, Delete, Copy and Paste Worksheets print video 1:41
Performing Calculations
  Excel Formulas print video 4:20
  Functions print    
  Relative and Absolute References / Linking Worksheets print video 3:52
Formatting a Worksheet
  Convert Text to Columns print video 1:29
  Modify Fonts / Format Cells / Align Cell Contents print video 3:23
  Add Borders and Colors to Cells print video 2:24
  Change Width, Heighth / Hide and Unhide / Merge Cells print video 3:40
Sort and Filter
  Basic and Custom Sorts print video 2:24
  Filter print video 2:04
Charts
  Create and Modify a Chart print video 3:08
  Chart Tools print video

3:06

  Copy a Chart to Word print video 2:07
Graphics
  Adding and Editing Pictures and Clip Art print video 2:29
  Adding Shapes and SmartArt print video

2:45

Page Properties and Printing
   
  Print Titles print video 2:42
  Header and Footer print    
  Page Margins and Page Orientation print    
  Page Breaks and Print Range print    
Customizing the Layout
   
  Split / Hide and Unhide Worksheets print video 2:46
  Freeze and Unfreeze Rows and Columns print    

Center for Instructional Delivery • University of St. Francis • Joliet, IL 60435 • [815] 740-5080 • cid@stfrancis.edu
Learnit logo