Excel - SUM() No More (Currently Unavailable)

Author: Jeff Lenning

What is your number one most-used function of all time? Is it...the SUM function? Well, it shouldn't be...at least if your goal is building more efficient workbooks. In this session, we'll discuss a function that allows you to SUM no more.

Plus, we'll discuss formatting a cell based on its value, reducing errors with the skinny row technique, highlighting input cells, and when and how to hide worksheets. We also cover a few ideas to keep in mind as you organize worksheets and workbooks. Note: this course is designed for Microsoft Excel for Windows, and selected items may not be available in Excel for Mac.

Publication Date: June 2014

Designed For
Accounting professionals looking to learn more about Microsoft Excel for Windows.

Topics Covered

• Conditional Formatting Basics
• Better Summing
• Skinny Row
• Hide Worksheets
• Highlight Input Cells
• Workbook Organization
• Worksheet Organization

Learning Objectives

• Recall the arguments of the SUBTOTAL function
• Identify the feature that formats a cell based on the value of the cell
• State the cell style that can be used to highlight input cells

Level
Intermediate

Instructional Method
Self-Study

NASBA Field of Study
Computer Software & Applications (2 hours)

Program Prerequisites
be familiar with basic Excel functions including, named references, tables, and data validation.

Advance Preparation
None