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
Pre-Requisites

• 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 ]

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.

need-to-train-a-group-banner

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 714 times.