Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0

This is a 1 day instructor led course explaining the Level 2 features and tools of Microsoft Excel.

Course Outline
This is a 1 day instructor led course explaining the Level 2 features and tools of Microsoft Excel.
Course Objectives
Upon successful completion of this program students will be able to successfully work within the Level 2 objectives of Microsoft Excel.
€¢ Define valid sets of Organize data into levels
€¢ Look up information in a Worksheet
€¢ VLookup and HLookup
€¢ Use Workbooks as Templates
€¢ Sort Data
€¢ Filter Links to Data
€¢ Consolidate multiple sets of Data
€¢ Group multiple sets of Data
€¢ Define multiple alternative Data Sets
€¢ Goal Seek
€¢ Find optimal solutions by using Solver
€¢ PivotTables
€¢ Create and Modify Charts
€¢ Pivot Charts
€¢ Create and Modify Spark Lines
€¢ Create Diagrams by using SmartArt
€¢ Add Headers and Footers to printed pages
€¢ Prepare Worksheets for printing
€¢ Print Worksheets
€¢ Create and modify Macros
€¢ Share Workbooks
€¢ Manage Comments
€¢ Track and Manage colleagues' changes
€¢ Protect Workbooks
€¢ Protect Worksheets
€¢ Authenticate Workbook Content

Prerequisites & Certificates

• Those students who have successfully completed the objectives in the Level 1 program. • Those candidates who use Microsoft Excel daily to complete general spreadsheet tasks who are looking to advance their existing skill set. • Knowledge of the Excel interface and spreadsheet creation.

Certificates offered

Certificate of completion

Cancellation Policy
Maximum I.T. reserves the right to cancel and/or change a class date. Students will be notified within 10 business days in this event.

All reasonable attempts will be made to set another class date and time. A refund will be issued if the class is not re-scheduled.

Any student enrolled in a technical program who cancels their registration is responsible for both their exam voucher and course materials.

Map & Reviews
Maximum I.T.
[ View Provider's Profile ]


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.


This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 706 times.