Excel Training: Skills for Better Workbook Design

Microsoft Excel is considered one of the most useful tools in the workplace. However, if Excel is used incorrectly, it can seriously drag down productivity. This course guides you through shortcuts and functions to enable you design better workbooks. You’ll learn:

Better Summing

What function do you use the most? Is it the SUM function? It probably shouldn’t be. This online Excel class explores better summing. The Excel lesson examines a summing function that is preferred to the SUM function.

Skinny Row

The skinny row technique helps improve the reliability and efficiency of recurring-use workbooks. It helps avoid the errors that can sometimes result from inserting new rows of data between the last data row and the formula row.

Hide Worksheets

This online Excel class demonstrates how to hide worksheets in order to prevent users from viewing extraneous information.

Highlight Input Cells

Highlighting input cells improves efficiency and reduces errors. This online Excel class reviews highlighting input cells and the advantages of using cell styles rather than manual cell formatting.

Workbook Organization

Did you know that the way we organize our workbooks can impact our efficiency? This online Excel course discusses key ideas to consider when building and organizing Excel workbooks.

Worksheet Organization

Organizing worksheets is a skill needed to maximize efficiency, especially in recurring-use workbooks. This online Excel class walks through many worksheet organization ideas and concepts.

Nested Functions

Nested functions are an absolutely fundamental and critical skill in Excel, and they enable us to write comprehensive and beautiful formulas. This online Excel course walks through the basic idea of nested functions.

Selection Groups

This online Excel class discusses the performance boost that can be achieved when you group select items first, and then perform a command one time to all items in the group.

Workbook Design Principles

This online Excel class reviews 5 critical workbook design principles. This lesson covers the concepts to keep in mind as you build workbooks in order to maximize efficiency in recurring-use workbooks.