Excel Essentials

Use this workbook with all the lectures in chapter 2.  it will contain the same workbook we use in the lectures so that you can follow along and practice to learn the concepts

Enhancing reports with Conditional Formatting (creating thematic maps)

Use this workbook to work along with the all of the lectures in the Introduction to Formulas Chapter.

Utilizing absolute and relative references and partial absolute references

Understanding named ranges and creating them to make spreadsheets more efficient

Exploring more advanced functions and having criteria applied to sum, count and average functions

Use this exercise workbook to follow along with the lessons in chapter 4, Intermediate functions

Using the IF function to add logic to formulas and to nest functions

Using many of Excel's text based functions

Creating a unique list of items from a column or table with many duplicates

Utilizing one of Excel’s most valuable (and used) functions for looking up data

Exercise file for Validation, Find and Replace, Working with Tables, and Goal Seek.

Have you ever wanted to make a drop down list with pre defined choices?  Data validation is the tool in Excel that will let you do that.  This lesson will teach you all about data validation.

Review the Find and Replace functionality of Excel.  Also see how you can use find to search for colors and formats.

Learn all about Excel's table features.  See how they can add great formatting and efficiency to your data.

This incredible tool is one of the hidden gems of Excel.  It allows you work formulas and functions backwards to solve for component values.

This workbook is used with all of the lectures in the Pivot Table Introduction Chapter

What is a PivotTable? Sample PivotTables…

Useful ways for sorting and filtering in PivotTables

Use this workbook for the lectures in the Intermediate Pivot Tables Chapter

Creating new metrics in your pivot table based on a calculation

Keeping PivotTables up to date with new data, or data from a different source

One of Excel’s coolest new features! Check it out…

Use this workbook with every lecture in the Viewing and Printing Chapter.

Utilizing Excels different viewing elements including turning on and off gridlines and column headings

Preparing a document to print by setting print area, adjusting page layouts, inserting page breaks and print titles, addressing scaling and sizing issues

Use custom views to set up and save print and screen view settings

Adding headers and footers to print important information on each printed page of your workbook

Download this file to follow along and practice the charting videos.

This lesson introduces you to Excel charting.  Showing you some of the options to enhance your data with graphics that deliver a strong message.

This lesson will teach you the basics of how to build a simple chart.

In this lesson, we'll see how to configure the Y axis.  We'll see how to orient the values, scale the units (hundreds, thousands, etc), and even set a logrithmic scale.