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.

Objectives

• 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

Prerequisites

None