Microsoft Excel Course
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.
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
