You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
To navigate through the Ribbon, use standard browser navigation keys. To skip between groups, use Ctrl+LEFT or Ctrl+RIGHT. To jump to the first Ribbon tab use Ctrl+[. To jump to the last selected command use Ctrl+]. To activate a command, use Enter.
Site Actions
This page location is:
Home
Tech Tools @ Mason
Excel-Intro
Browse
Tab 1 of 3.
Page
Tab 2 of 3.
Publish
Tab 3 of 3.
Sign In
Tech Tools @ Mason
Excel-Intro
team site for students, parents, and staff
Top Link Bar
Tech Tools @ Mason
Currently selected
PC Maintenance & Security
Digital Citizenship
Digital Citizenship links
Access
Intro
Intermediate
Advanced
Outlook
Office 2010
Sound Recording
Audacity PC
Audacity Mac
What does sound look like?
Video tools
Premier Pro CS4
Windows Movie Maker
Recently Modified
Home
Premier Pro CS4
Movie Maker
Audacity Project
Audacity PC
Quick Launch
Team Discussion
Word
Getting Started
Intro
Intermediate
Advanced
Newsletter Workshop
Mail Merge Workshop
WordTips
PowerPoint
Getting Started
Intro
Intermediate
Advanced
Excel
Intro
Currently selected
Intermediate
Advanced
Charting Workshop
Pivot Tables
Statistical Analysis
All Site Content
Excel 2007 - Intro
A. Basics
Using the new Excel 2007 interface
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
false,false,1