Skip to content Skip to navigation Skip to login

Tutorial Playlist

Excel 2007 - Intro Training

A. Basics

	Using the new Excel 2007 interface	Playing...
	Using and minimizing the ribbon
	Using the Quick Access toolbar
	Customizing the Quick Access toolbar
	Understanding a worksheet and entering information into a cell
	Changing the default worksheets and cell movement
	Using a template
	Using save and save as
	Using compatibility mode
	Opening Excel 2007 files in earlier versions of Excel
	Moving with the keyboard pt. 1
	Moving with the keyboard pt. 2
	Using keytips
	Creating a PDF

B. Working with Cells

	Using AutoComplete
	Editing a cell
	Using spell check
	Selecting cell ranges pt. 1
	Selecting cell ranges pt. 2
	Entering values in a cell range
	Using AutoFill
	Using cut, copy and paste
	Using Paste options
	Using the paste list and paste special
	Using the clipboard
	Using drag and drop editing
	Using undo and redo
	Using the Clear command

C. Formulas and Functions

	Using autocalculate
	Using auto sum
	Creating formulas
	Using functions and the function wizard pt. 1
	Using functions and the function wizard pt. 2
	Editing formulas
	Checking formulas for errors
	Using relative cell referencing
	Understanding absolute cell references
	Creating an absolute cell reference

D. Formatting Cells

	Formatting numbers using the ribbon
	Formatting text using the ribbon
	Using the Alignment and Indentation commands
	Rotating information in a cell
	Wrapping text in a cell
	Using the Merge and Center command
	Using the Borders command
	Drawing cell borders
	Formatting information using the format cells dialog box
	Using the Format Painter command

E. Working with Columns and Rows

	Selecting columns and rows pt. 1
	Selecting columns and rows pt. 2
	Changing column width
	Changing row height
	Hiding and unhiding columns and rows
	Inserting columns
	Inserting rows
	Deleting columns and rows
	Inserting and deleting cells

F. Styles, Themes, and Tables

	Using cell styles
	Creating a custom cell style by example
	Creating a custom cell style
	Deleting a custom cell style
	Modifying a custom cell style
	Merging custom cell styles
	Using themes
	Customizing themes
	Formatting as a table pt. 1
	Formatting as a table pt. 2
	Creating a custom table style pt.1
	Creating a custom table style pt. 2
	Deleting a custom table style

G. Workbook Views and Page Setup

	Using Normal view
	Using Page Layout view
	Using Page Break preview
	Using the Page Layout command tab
	Changing the margins
	Changing the page orientation and paper size
	Setting manual page breaks
	Setting print titles
	Creating headers and footers
	Using the Page Setup dialog box

H. Printing

	Using print preview
	Printing
	Printing selected ranges
	Setting, adding to, and removing print areas pt. 1
	Setting, adding to, and removing print areas pt. 2

I. Help

Using Help

lock

Close [X]

No Prev: at first movie

Next

Tutorial Playlist

View a tutorial about using the movie playlist

View a tutorial about sharing a movie

This tutorial © Copyright 2012 Atomic Learning, Inc. All rights reserved.

©2012 Atomic Learning, Inc. All rights reserved.