Excel is a very popular program and has many features. Here are tutorials for everyone from the beginner to the advanced user. These tutorials are for both Windows and Mac versions. (I’m rebuilding this page so please come back as I’m adding all the links back in and updating the tutorials).
Getting Started
- What does Excel do?
- Creating a new workbook – you need one of these to get started
- Opening an existing workbook
- Saving your work
- Entering data
- AutoFill to Copy Data, Values, Formulas and Functions. Also Create Series Easily
- Formatting – choosing fonts and changing the style of the text
- Creating a formula – this is where you get to do some simple calculations, like adding up
- Using Autosum to Total Up a Column or Row of Figures
- Using the $ Sign in a Function or Formula to do Absolute or Mixed Referencing
- Using a Percentage in a Formula
- Naming Cells and Ranges
- Excel 2010 an Overview
Formatting
- Conditional Formatting
Printing
Functions
- Introduction to Functions (Windows)
- Introduction to Functions (Mac)
- SumIF and SUMIFs
- CountIF and CountIFs
- IF Function
- VLOOKUP Function
- PMT Function
- Date Functions
- Using the Today function to calculate someone’s age
- Calculating the number of days between dates
- Using text functions to split first and last name in a cell into two separate cells
Data
- Sorting
- Filtering
- Subtotals
- Using Data Validation to Create a Drop Down List
- PivotTables
- Importing Data
- Exporting Data
Charts/Graphs
- Creating a Pie Chart (Excel 2003)
- Getting Started with Charts in Excel 2010
- Formatting a Data Series on a Chart
Advanced Features
- Goal Seek
- Scenario Manager
- Data Tables
Macros and VBA (Visual Basic for Applications)