Microsoft Office Excel 2007 Level 3

Upon Completion, students will: Outline & group data, use Pivot Tables, use scenarios, 'What If' Analysis, use Excel & the Internet, create & share workbooks, use security features, use custom & advanced features of Excel.

Course Outline

Section 1:
In this section you will learn how to:

Change your user name in Excel
Change the default color scheme for Excel
Set up formula options
Change the default font for your workbooks
Change the default file format for your workbooks
Search for Excel documents
Use Office diagnostics
Check for updates
Download Excel viewer
Use the Excel viewer
Start Excel on Windows boot
 
Section 2:
In this section you will learn how to:

Use automatic outlining
Display and collapse levels
Group data manually
Create subtotals
Create a PivotTable
Specify data in a PivotTable
Rearrange PivotTable data
Modify PivotTable calculations
Format a PivotTable
Refresh a PivotTable
Chart a PivotTable
Create a PivotTable based on external data
Create a scenario
Create a scenario summary report
Save multiple scenarios
Use a one and two input data table
Use Goal Seek
Use the solver
 
Section 3:
In this section you will learn how to:

Insert a hyperlink
Modify a hyperlink
Use a hyperlink in Excel
Save a workbook as a Web page
Save a worksheet as a Web page
Save a chart as a Web page
Save a range as a Web page
Create a Web query
Save a Web query
Refresh a Web query
Prepare a workbook for Excel services
Publish to a document server
Save to a document management server
 
Section 4:
In this section you will learn how to:

Create a shared workbook
Open and edit a shared workbook
Track changes in a shared workbook
Resolve conflicts in a shared workbook
Create a custom AutoFiIl list
Use a custom AutoFill list
Modify a custom AutoFill list
Use the VLOOKUP function
Use VLOOKUP for an exact match
Use VLOOKUP for a closest match
Consolidate workbooks
Link workbooks
Combine worksheets

Additional Details

Pre-Requisites

Excel 2007 Level 2

Certificates offered

Includes: Course manual; Certificate of completion; breakfast and lunch (at ItPlanit)

Cancellation Policy

Cancellations less than 2 business weeks before the expected delivery date are eligible for a 50% refund, or a credit voucher will be provided for regularly scheduled courses (choice being that of the registrant). Credit Vouchers are transferable within the same company. Please send your cancellation notice to info@itplanit.com.

Map & Reviews

Itplanit Services Corp.
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

A very interesting course. Claude Gerin, our instructor, was excellent in making this a very interesting and learning experience. THANKS!

Reviewed by Oleg T. 2012