Whoops! Something went wrong.

Click here to refresh the page

Microsoft Excel 2007 Advanced

Microsoft Excel 2007 Advanced
Microsoft Excel 2007 Advanced
Microsoft Excel 2007 Advanced
Microsoft Excel 2007 Advanced
Microsoft Excel 2007 Advanced
Microsoft Excel 2007 Advanced
Microsoft Excel 2007 Advanced
Microsoft Excel 2007 Advanced
Product Description
The Advanced Guide to Microsoft Excel 2007 demonstrates how to name and manage ranges, copy or move worksheets, link worksheets and consolidate data, work with Scenarios, use Goal Seek, use the Auditing Toolbar to trace errors.

Also: Create a grand total from several spreadsheets, understand Absolute and Relative References, analyze data with a PivotTable, filter the data, create Subtotals, Group and Outline data, and use the Logical, Lookup, Math and Text Functions.

Recommended Microsoft Excel 2007 Sample Files (Not Included)
Microsoft Excel 2007 Beginning Sample Files
Microsoft Excel 2007 Intermediate Sample Files
Microsoft Excel 2007 Advanced Sample Files

If you are interested in Microsoft Office 2007, here are some links you may consider:
Microsoft Word 2007 Beginning
Microsoft Word 2007 Intermediate
Microsoft Word 2007 Advanced

Microsoft Excel 2007 Beginning
Microsoft Excel 2007 Intermediate
Microsoft Excel 2007 Advanced

Microsoft Outlook 2007
Microsoft PowerPoint 2007

Looking for Microsoft Excel 2013?
Microsoft Excel 2013 Beginning
Microsoft Excel 2013 Intermediate
Microsoft Excel 2013 Advanced

Looking for Microsoft Excel 2010?
Microsoft Excel 2010 Beginning
Microsoft Excel 2010 Intermediate
Microsoft Excel 2010 Advanced

Students who wish to prepare for the Microsoft Certification Exam 77-602: Using Microsoft® Office Excel 2007 will find beginning lessons that demonstrate these required MOS topics:

Advanced Microsoft Excel
Cell References
Data Analysis page 2
Filter the Data page 12
Text Formulas page 14
Conditional Formulas page 21
Named Ranges page 30
Convert Text to Columns page 35

Create Filters, Subtotals
Sort & Filter page 57
Create Subtotals page 58
Group and Outline Data page 60
Name a Range page 68
The VLookup Function page 69
The HLookup Function page 75
Logical Function: And page 76
Conditional Logic page 77
IFERROR Function page 78
SmartArt! page 85

Create a PivotTable
Create a PivotTable page 92
PivotTable Fields page 94
Using Row Labels page 96
Count the Values page 97
Pivot the Table! page 100
Refresh the PivotTable page 101
PivotCharts page 102
Change the Chart Type page 105
Workgroup Collaboration page 113
Total Pages
149 pages
Answer Key
Teaching Duration
2 days
Report this Resource
  • Comments & Ratings
  • Product Q & A
Digital Download
Digital Download
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up