|
|
|
Microsoft Excel 2007 Training Course (Prices exclude VAT)
|
|
|
[to previous page]
[other products in "MS Office 2007 Courses"]
|
|
|
| Product: |
Microsoft Excel 2007 Training Course
|
|
|
| Description: |
The Microsoft Certified Application Specialist Certification, (MCAS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2007. Our Excel 2007 course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software. When you pass the Excel 2007 Exam 77-602, you achieve Microsoft Certified Application Specialist (MCAS) status in Excel 2007.
As a Microsoft Certified Partner, our course follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed. Learning segments:
New Features
Starting in Excel
Basic Navigation
Working with Data
Formulas and Functions
Formatting Data
Working with Worksheets
Printing
Level Summary
Use AutoSum and AutoFill
Use the Vlookup Function
Use Themes, Styles and Formats
Use Table Styles
Insert Cells, Rows and Columns
Cut, Copy and Paste Cells
Manage Worksheets
Adjust Page Layout
Templates
Sorting and Filtering
Navigating in Excel
Working with Comments
Using Name Box
Controlling and Validating Data Entry
Controlling What You See
Using Drawing Tools
Charting
Level Summary
Create a Hyperlink
Use AutoFilter
Sort Data in a Range or Table
Use the Subtotal Command
Use Advanced Filter
Create a Custom List
Use the Name Box and Go To
Add, Edit, and Delete Comments
Advanced Data Tools
Advanced Formula and Function Tools
Protecting and Reviewing Your Work
Merging and Consolidating
Working with External Data
Macros
XML
Trusting and Privacy in 2007
Excel Options
Level Summary
Use Scenarios
Audit a Formula
Use a PivotTable Report
Consolidate Data
Track and Review Changes
Use Goal Seek
Validate Data
Use Conditional Formatting
Exam 77-602 - Excel 2007 Course Summary
|
