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-Advanced
Browse
Tab 1 of 3.
Page
Tab 2 of 3.
Publish
Tab 3 of 3.
Sign In
Tech Tools @ Mason
Excel-Advanced
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
Advanced
Currently selected
Charting Workshop
Pivot Tables
Statistical Analysis
All Site Content
Excel 2007 - Advanced
A. Templates
Viewing templates
Creating a workbook from a template
Creating custom templates
Modifying a template file
Deleting a template
B. Working with Dates and Times
Entering dates into a cell
Formatting date entries
Displaying the current date
Generating a series of dates
Using date related functions pt. 1
Using date related functions pt. 2
Entering times into a cell
Formatting time entries
Displaying the current time
C. Custom Number Formats
Formatting numbers automatically
Understanding Custom Number formatting
Creating a Custom Number format
Creating custom date and time formats
Hiding the contents of a cell using a Custom Format
Deleting a Custom Format
D. Advanced Charting
Selecting elements in a chart
Formatting chart elements
Modifying the chart area
Modifying the plot area
Adding text to a chart
Modifying the legend
Creating a chart template
Modifying the Value axis
Modifying the Category axis
Deleting a data series from a chart
Adding a data series to a chart
Adding a trend line to a chart
Creating a Combination chart
Creating Picture charts
E. Data Validation
Specifying Data Validation criteria
Creating Data Validation Rule messages
Identifying invalid data within a Data Validation range
Creating a Data Validation drop down list
Finding cells that contain Data Validation rules
Clearing existing Data Validation rules
F. Sorting and Filtering
Sorting data in a worksheet
Sorting by multiple columns or criteria
Filtering data in a worksheet using AutoFilter
Clearing a filter in a worksheet
Creating and/or statements using AutoFilter
Creating a Criteria range
Defining criteria using the Criteria range
Creating And/Or statements using the Criteria range
G. Outlines
Creating an outline automatically
Creating a Manual outline
Displaying levels in an outline
Hiding the outline symbols
Clearing an outline
Adding subtotals to a worksheet pt. 1
Adding subtotals to a worksheet pt. 2
H. Linking and Consolidating Worksheets
Creating a link formula within the same workbook
Creating a link formula to another workbook
Consolidating worksheets using formulas pt. 1
Consolidating worksheets using formulas pt. 2
Consolidating worksheets using formulas pt. 3
Using the Consolidate command pt. 1
Using the Consolidate command pt. 2
Opening a workbook with External Reference formulas
Breaking links to External References
I. What-if Analysis
Creating scenarios pt. 1
Creating scenarios pt. 2
Displaying scenarios
Modifying scenarios
Generating a Scenario report
Deleting a scenario
Using Goal Seek
J. Workbook Protection
Protecting a worksheet
Unprotecting a worksheet
Using a password to protect a worksheet
Protecting a workbook pt. 1
Protecting a workbook pt. 2
Unprotecting a workbook
K. Auditing and Error Checking
Displaying formulas
Identifying precedent cells
Identifying dependent cells
Checking for errors
Evaluating a formula
L. Macros
Recording a macro
Running a macro
Editing a macro
M. Sharing Data with Word
Copying and pasting static information
Copying and pasting as a link
Importing a text file into Excel
false,false,1
