Excel University: Core Excel Skills 2

Overview

Excel University Volume 2 builds upon the foundation set in Volume 1, and explores ways to automate recurring-use reports. We refer to workbooks that update their report values automatically when new data is inserted into the workbook as "hands-free" reports. Volume 2 demonstrates how to set up a workbook for hands-free reporting. The features, functions, and techniques presented in this course are sure to shave valuable time off of your reporting tasks.

Prerequisites

None

Objectives

In this course, you will learn to:

• Identify which Excel function can be used to perform a multicolumn list comparison 
• Recognize which Excel function can return the last day of the month 
• Recall at least three keyboard shortcuts and the arguments of at least three functions
  

 

Highlights