Make the switch to Excel 2010
Training Are you switching to Excel 2010 from a previous version? This course is for you.
Getting started with Excel 2010
Article If you know Excel 2007, used an earlier version of Excel, or have never used Excel before, explore these resources to begin learning how to use the latest...
Get to know Excel 2010: Create your first spreadsheet
Training New to Excel? Learn how to create a spreadsheet, do basic math, create and format column titles, freeze the top row, and set some printing options.
Office 2010 Security: Protecting your files
Training In Microsoft Office 2010, when files open, Message Bars can alert you to useful information and potential problems with your files. Security Message Bars...
Get to know Excel 2010: Create formulas
Training Learn to use formulas to do math, update formula results automatically, and use predefined formulas (functions) to calculate things like monthly payments.
Download Office 2010 training
Article Get free, downloadable versions of many Office 2010 training courses. They’re in PowerPoint 2010 format, so you can customize them for group training or...
VLOOKUP: What it is, and when to use it
Training You may have heard of the VLOOKUP function, and you may have heard reasons why you should use it. But what does it do, exactly? In this training course...
Understand data at a glance with conditional formatting
Training Have you heard about conditional formatting? Get hands-on practice using conditional formatting to make data stand out.
Sparklines: Use tiny charts to show data trends
Training Overview As you look at rows and rows of data, sometimes it’s hard to immediately make sense of it. Add tiny charts called sparklines next to data to...
Use Excel tables to manage information
Training Learn how to use Excel tables to sort and filter data, get special table formatting, and see table formulas auto fill.
The IF function: what it is, and how to use it
Training Overview The IF function checks to see if a condition you specify is true, or false. If true, one thing happens; if false, something else happens. For...
How to create a basic chart in Excel 2010
Training Learn how to create a chart and how to make changes to a chart after you create it.
Save time by creating and running macros in Excel 2010
Training Overview Do you find yourself doing the same actions over and over again in your spreadsheets? Did you know you can create macros so that Excel can do...
Figure out dates by using formulas in Excel 2010
Training Figure out dates by using formulas in Excel 2010 Overview Use formulas to figure out dates such as how many workdays until vacation, or calculate the...
Plan payments and savings in Excel 2010
Training Learn how to use financial functions in Excel formulas to figure out payments and savings
Excel 2010 keyboard shortcuts I: CTRL key shortcuts
Training Learn Excel 2010 keyboard shortcuts. Learn CTRL key shortcuts that let you do everything from selecting and editing cells, to inserting cells, rows, and columns.
Excel 2010 keyboard shortcuts II: ALT key shortcuts
Training Learn how to use ALT key shortcuts that let you access almost any command in Excel 2010. These keyboard shortcuts are also called access keys, and they...
