Excel Training Slide Deck & Worksheets

This was a 2hr all staff training I conducted on Excel. Each slide is designed to be usable as a one-page reference.

The first half is appropriate for the most basic users (and more advanced users can benefit from refreshers and the shared language). The second half is appropriate for more advanced users (and basic users can benefit from seeing what is possible, if not understanding how to do it).

Please feel free to share these materials with others, and let me know if you have any questions.

Download all Files: Slides & Worksheets (FREE or Donation)

Visualizing and Tracing Formulas

Tracing formulas through the Formula Auditing tools in Excel can be invaluable in navigating complex formulas and diagnosing unexpected results. This guide reviews methods of visualizing and tracing formulas, including Trace Precedents, Trace Dependents, and Evaluate Formula.

Click to download the Tracing Formulas Guide (FREE)
Click to download the Tracing Formulas Guide (Donation)

Tracing Formulas 150 x 150

Multiple Windows & Arranging Views in Excel

Using appropriate “view” tools in Excel can help you better navigate worksheets and files. This guide shows how to freeze rows and columns, split a worksheet into panes that scroll separately, and how to show multiple windows side by side.

Click to download the Arranging Views Guide (FREE)
Click to download the Arranging Views Guide (Donation)

Arranging Views 150 x 150

Data Analysis Toolpak – Statistics in Excel

The Data Analysis Toolpak in Excel provides an interface to the native statistical functions. Using simple graphical dialogs to select and input data, the tools produce reports for common statistical tests.

This guide covers the Descriptive Statistics tool and the Regression tool, as well as an overview of showing a linear regression in a scatterplot.

Click to download the Data Analysis Toolpak Guide (FREE)
Click to download the Data Analysis Toolpak Guide (Donation)

Data Analysis

Data Tables – A Printable Guide to 1 and 2 Variable Data Tables

Data Tables answer the question of “What happens to Y when I change X?”

This printable guide demonstrates both one variable and two variable data tables.

Download the Guide: Data Tables (FREE)
Download the Guide: Data Tables (Donation)

Data Tables