Excel 2010 Tutorial List



Tutorial 1 - Getting Started
Tutorial 1 shows the user interface.

Tutorial 2 - AutoFill
This video tutorial will show how to use the AutoFill. The AutoFill can make complex situations easy and allows the user to complete work fast.

Tutorial 3 - Times Table
The AutoFill makes quick work of making a times table.

Tutorial 4 - Calculations
Simple calculations and the Fibernachi sequence are shown.

Tutorial 5 - Functions
Simple functions are shown. The functions include Sum (AutoSum) Large, Small, ABS, Power, Min, Max, and Average. Also, the AutoFill is used with filling the functions throughout the worksheet

Tutorial 6 - Worksheet Function Example
A worksheet is formatted and filled with sales figures from Q1. Functions are used to find the total, average, median, maximum and minimum figures for the salespeople and each item.

Tutorial 7 - Multiple Worksheets
Tutorial 7 build upon the workbook used within Tutorial 6. Tutorial 7 shows how to make a master worksheet and copy and paste worksheets within a workbook. Once the data is entered, a worksheet is created to calculate the fiscal year totals using the data from the other worksheets.

Tutorial 8 - Absolute Reference $
The AutoFill has problems placing information into rows from data that is in columns (or placing data from columns into rows). Absolute reference will be used to solve this problem.

Tutorial 9 - Absolute Reference Times Table
Similar to tutorial 3, this tutorial shows how to make a times table using absolute reference calculations.

Tutorial 10 - Printing and Print Settings
Most of the Excel print settings are shown within this tutorial.

Tutorial 11 - Save As PDF and Picture Formats
Excel can save to PDFs. This tutorial will show Excel’s built in PDF capabilities and options. BullZip PDF will also be used. BullZip can save as a PDF, PS and Image formats.

Tutorial 12 - Chart Overview
This tutorial shows a quick overview of Excel Charts.

Tutorial 13 - Line Charts
Line charts are demonstrated within this tutorial.