Total:
\$0.00

Subjects
Resource Types
Product Rating
Not yet rated
File Type
PDF (Acrobat) Document File
6.84 MB   |   149 pages

### 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 Excel 2007 Beginning
Microsoft Excel 2007 Intermediate

Microsoft Outlook 2007
Microsoft PowerPoint 2007

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

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

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:

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
Included
Teaching Duration
2 Days

### Average Ratings

N/A
Overall Quality:
N/A
Accuracy:
N/A
Practicality:
N/A
Thoroughness:
N/A
Creativity:
N/A
Clarity:
N/A
Total:
0 ratings
\$5.00
User Rating: 3.9/4.0
(65 Followers)
\$5.00