Richmond Home

Excel Preparation Resources

The Robins School provides a number of resources to assist students in preparing for the Excel Competency Exam.

Instructional Resources

  1. Visit Lynda.com to watch Excel tutorials in Excel 2019 Essential Training, and use its practice examples. Click the Sign In button and type in your Richmond.edu email address in the Username box to gain access to these tutorials. 
  2. BUAD 203: Software Tools (.5 unit elective) is available to register in class during fall and spring semesters as well as online during May term.

Campus Resources

  1. You can view our Excel Competency Workshop here:

 

2. Technology Consultants are available for individual appointment times through the TLC: The Technology Learning Center located in Boatwright Library.  

3. Excel Workshop Series:

  • Excel Workshop I | March 27, 2020 | 3 - 6 p.m. | RSB Classroom 113
    • Introduction to EXCEL
    • General formatting
    • AutoFill
    • Order of operations
    • Basic formulas and functions
    • Absolute vs. relative reference
  • Excel Workshop II | April 3, 2020 | 3 - 6 p.m. | RSB Classroom 114
    • Named ranges
    • Conditional formatting
    • More EXCEL functions including VLOOKUP
    • Print setup including Headers and Footers
  • Excel Workshop III | April 10, 2020 | 3 - 6 p.m. | RSB Classroom 114
    • Charts
    • Sparklines
    • Sorting and filtering data
    • Tables including PivotTables
    • Structured references