Richmond Home

The Robins School of Business Excel Competency Exam Resources

Excel is a fundamental business tool, and business school graduates should maintain at least a working level of competency in its functionality and applications. In addition, many courses within the Robins School of Business expect that students are familiar with and comfortable working with Excel. To assure our students possess at least a basic level of competency in Excel, the Robins School requires that all pre-business students beginning with the Fall 2018 entering class obtain a grade of at least 80 percent on an Excel competency exam prior to declaring an Accounting, Business Administration, or Economics-Business major or a Business minor. Students will have three attempts to obtain this grade.

The Excel Competency Exam tests basic Excel skills along the following topic areas:

  • General Concepts (such as cells, worksheets, formulas, IF statements)
  • Data Sorting and Filtering
  • General Formatting
  • Conditional Formatting
  • Autofill
  • Tables
  • Data Tables
  • Named Ranges
  • Spark Lines
  • Charts
  • Pivot Tables
  • Functions (including V-Lookup, H-Lookup, Statistical Functions)
  • Printing & Page Setups

The Robins School recommends or provides a number of resources to assist students in preparing for the Excel competency exam.

  1. Lynda.com Excel tutorials in Excel 2016 Essential Training. Click the Sign In button and type in your Richmond.edu email address in the Username box to gain access to these tutorials. In preparation for the Excel Competency Exam, students will want to give most attention to Chapters 1-7, 10, and 12-14.
  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.
  3. Student may attend Focus Friday workshops on Excel held on various dates throughout the academic year.
  4. Technology Consultants are available for individual appointment times through the TLC: The Technology Learning Center located in Boatwright Library.  

Pre-Business students will receive instructions via their campus email address on scheduling their testing date during the academic year. Pre-Business students may also register for an upcoming testing date here.