Whoops! Something went wrong.

Click here to refresh the page

Microsoft Excel 2007 Intermediate

Microsoft Excel 2007 Intermediate
Microsoft Excel 2007 Intermediate
Microsoft Excel 2007 Intermediate
Microsoft Excel 2007 Intermediate
Microsoft Excel 2007 Intermediate
Microsoft Excel 2007 Intermediate
Microsoft Excel 2007 Intermediate
Microsoft Excel 2007 Intermediate
Grade Levels
Product Rating
File Type

PDF (Acrobat) Document File

Be sure that you have an application to open this file type before downloading and/or purchasing.

5 MB|115 pages
Share
Product Description
The Intermediate Guide to Microsoft Excel 2007 teaches: Use advanced text alignment, Use Mail Merge: Create main document, Create data source, Sort records to be merged, Merge the document and data.

Also: Use Conditional Formatting, Merge and Center Cells, Create form controls, Rename a worksheet, Copy or Move worksheets, Link worksheets and consolidate data.

Use Relative References, Absolute References, Work with Scenarios, Use Goal Seek, Use the Auditing Toolbar to trace errors. Calculate Revenue; create a grand total from several spreadsheets, Understand Absolute and Relative References.


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:

Intermediate Microsoft Excel
Tables and Print Options
Single and multilevel sorts page 16
Create a Table page 18
Use the Header Row page 20
Convert a Table to Text page 23
Quick Style Formats page 25
Add a Total Row page 27
Print Preview page 30
Page Break Preview page 32
Set Print Area page 33
Print to Fit page 34

Create a Time Sheet
Calculate the Total page 40
Create a Reference List page 46
Make a Drop-Down List page 49
Use Conditional Formatting page 51
Data Integrity and Validation page 59
Find Special Cells page 72
Compatibility Checker page 73

Relative and Absolute Cell References
Use Relative References page 92
Troubleshoot the equation page 95
Use Absolute References page 96
Use the Auditing Toolbar page 97
What If Scenarios page 99
Use Goal Seek page 102
Total Pages
115 pages
Answer Key
Included
Teaching Duration
2 days
Report this Resource
Loading...
$5.00
Digital Download
More products from Computer Mamas
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
$5.00
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