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-Intermediate
Browse
Tab 1 of 3.
Page
Tab 2 of 3.
Publish
Tab 3 of 3.
Sign In
Tech Tools @ Mason
Excel-Intermediate
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
Intermediate
Currently selected
Advanced
Charting Workshop
Pivot Tables
Statistical Analysis
All Site Content
Excel 2007 - Intermediate
A. Working with Worksheets
Activating and moving between worksheets
Selecting multiple worksheets
Adding a worksheet to a workbook
Deleting a worksheet from a workbook
Changing the name of a worksheet
Changing the sheet tab color
Rearranging the worksheets pt. 1
Rearranging the worksheets pt. 2
Hiding and unhiding worksheets
B. Controlling the Worksheet View
Zooming in and out of a worksheet
Viewing a worksheet in multiple windows
Viewing workbooks side by side
Splitting the worksheet window
Freezing and unfreezing panes
Monitoring cells with the Watch window
Viewing using full screen
Creating custom views
C. Using Names to Work with Ranges
Creating range names
Moving to a named range
Using range names in formulas
Managing named ranges pt. 1
Managing named ranges pt. 2
Creating a 3-D range name
D. Understanding Cell Comments
Adding a comment to a cell
Reading comments
Showing and hiding comments
Editing comments
Formatting comments
Changing a comment shape
Printing comments
Deleting a comment
E. Working with Charts
Creating a chart
Changing the chart layout
Changing the data orientation in a chart
Changing the chart type
Understanding chart types pt. 1
Understanding chart types pt. 2
Creating an embedded chart or a chart sheet
Moving and resizing an embedded chart
Adding a chart title
Adding axis titles
Changing the location of the chart legend
Adding data labels
Adding a data table to a chart
Changing the chart axis
Changing the gridlines
Formatting chart elements
Moving, resizing, and deleting chart elements
Deleting a chart
Printing a chart
F. Working with Graphics
Inserting a shape
Inserting a picture
Inserting clip art
Inserting a SmartArt graphic
Inserting a text box
Inserting WordArt
Selecting objects
Resizing a graphic object
Reshaping a graphic object
Rotating a graphic object
Moving a graphic object
Aligning graphic objects
Copying a graphic object
Deleting a graphic object
Grouping graphic objects
Stacking graphic objects
Formatting the fill of a graphic object
Formatting the outline of a graphic object
G. Conditional Formatting
Understanding conditional formatting
Applying highlight cells rules pt. 1
Applying highlight cells rules pt. 2
Applying data bars
Applying color scales
Applying icon sets
Creating a Conditional Formatting Rule
Managing Conditional Formatting Rules
Clearing Conditional Formatting Rules
H. Functions
Using COUNT functions
Using the IF function
Using the VLOOKUP function
Using the HLOOKUP function
Using Concatenate pt. 1
Using Concatenate pt. 2
Using Text to Columns
false,false,1
