Maximum I.T.

remote support  cart  facebook  twitter  YouTube  Phone

Training

Home Training Application Programs Microsoft Excel Course

Fri,15Dec2017

Microsoft Excel Course

Excel

Microsoft Excel for Windows operating systems, breaks down the barriers of traditional spreadsheets, making it easier than ever to analyze, report, and share your data. Whether you're an expert or a novice, Microsoft Excel provides answers you can count on. The world's most comprehensive spreadsheet program is also the most intuitive. Microsoft Excel breaks down the barriers between you and your spreadsheet. It's more discoverable and more usable, making it easier to turn your numbers into answers.

requestinfo

 

Level 1 Overview

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

Next Course Dates

Dates are available upon request.

Call 905-637-2220

Target Audience

• Basic computer knowledge, such as keyboard and mouse skills.
• Basic file-management skills.
• The student should know how to navigate to folders and files on a computer.

Course Objectives

Upon successful completion of this program students will be able to successfully work within the Level 1 objectives of Microsoft Excel.

• Customize the Ribbon
• Customize the Quick Access Toolbar
• Change the Default Program Options
• Create Workbooks
• Modify Workbooks
• Modify Worksheets
• Enter Data
• Revise Data
• Move data within a Workbook
• Define Excel Tables.
• Name Groups of Data
• Create Formulas to calculate Values
• Summarize data that meets Specific Conditions
• Find errors in Calculations
• Correct errors in Calculations
• Format Cells
• Define Styles
• Apply Workbook Themes
• Add Excel Table
• Add Images to Worksheets
• Manipulate Worksheet Data

Level 2 Overview

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

Next Course Dates

Dates are available upon request.

Call 905-637-2220

Target Audience

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

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

 

Max News

Your mail*
Your name*


Address

Maximum I.T.

4125 North Service Road - Suite 200
Burlington, ON
L7L 6A3
map

About Us

logo 02

Maximum I.T. provides quality, timely, cost effective IT service and training support within the Halton Region (Hamilton, Burlington, Oakville, Stoney Creek) Mississauga and the GTA. We provide service and support for the following products: Microsoft Windows Server (2000, 2003, 2008), Microsoft Exchange (2003, 2007, 2010), Windows XP, Windows 7, Linux, Cisco devices, Mac OSX, Quick Books, Microsoft CRM and Virtualization software. We specialize in computer repair, network management, data recovery and printer service. Our Microsoft Office training products include Word, Excel, Outlook, PowerPoint, Access, Visio, Project. Our technical IT certification training programs include Microsoft (MCSE, MCTS, MCITP),
CompTIA (A+, Network+, Security+), Linux LPI and Unix solutions.


Copyright © 2011 Maximum I.T.. All Rights Reserved.