Microsoft Office 2007/2010
Application Overview:
Microsoft Excel
Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, calculate data, create rich data visualization and professional-looking charts. You can compile your company’s data into a Microsoft Office Excel workbook that can contain many worksheets.
Microsoft Excel can be used to manage numbers and calculations. You can create formulas in Excel that
automatically update when you change your data.
Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create and edit spreedsheets that can be searched, sorted, analysed, reported, updated and shared with other users.
Microsoft Office 2007-2010 Training Courses
Microsoft Access 07/10
Introduction
Microsoft Access 07/10
Intermediate
Microsoft Access 07/10
Macros
Microsoft Access VBA
Introduction
Microsoft Excel 07/10
Introduction
Microsoft Excel 07/10
Intermediate/Advanced
Microsoft Excel 07/10
Formulas and Functions
Microsoft Excel 07/10
Macros
Microsoft Excel 2007
Upgrade
Microsoft Excel 2010
Upgrade
Microsoft Office 2010
Upgrade
Microsoft OneNote 07/10
Introduction 
Microsoft Outlook 2007
Introduction/Intermediate
Microsoft Outlook 2010
Introduction/Intermediate
Microsoft PowerPoint 07/10
Introduction
Microsoft PowerPoint 2007
Intermediate/Advanced
Microsoft PowerPoint 2010
Intermediate/Advanced
Microsoft PowerPoint 2007
Upgrade
Microsoft PowerPoint 2010
Upgrade
Microsoft Project 2007
Introduction
Microsoft Project 2007
Intermediate
Microsoft Project 2010
Introduction
Microsoft Project 2010
Intermediate
Microsoft Publisher 2007
Introduction
Microsoft SharePoint 2007
Introduction
Microsoft SharePoint 2010
Introduction
Microsoft SharePoint 2010
Upgrade
Microsoft Visio 2007
Introduction
Microsoft Visio 2010
Introduction
Microsoft Word 07/10
Introduction
Microsoft Word 07/10
Intermediate/Advanced
Microsoft Word 07/10
Styles and Forms
Microsoft Word 2007
Upgrade
Microsoft Word 2010
Upgrade
Microsoft Excel 2007/2010
Introduction
Course Information
Duration: One-Day Course
Platform: Windows and Macintosh
Fee: $275 CDN (+HST)
This class is limited to eight people.
Course Overview
In this course you will learn the fundamentals of working with spreadsheets. You will learn how to produce a professional looking worksheet by entering numbers and creating timesaving Excel formulas and use the predefined Excel functions. You will also learn how to quickly and easily change the layout of your worksheet and enhance the appearance of your worksheet using the format commands. You will also learn how to work with multiple sheets within a file and how to setup and print your worksheet.
Course Content
Create and Edit a Worksheet
- Creating and Editing a Worksheet
- Get acquainted with the Ribbon and Quick Access Toolbar in Office 2007 and 2010.
- Get acquainted with the new Backstage View in Office 2010.
- Explore the Excel workspace.
- Efficiently move through the worksheet.
- Proficiently select cells and ranges.
Creating Formulas and Functions
- Produce a professional looking worksheet by entering numbers and creating time-saving Excel formulas.
- Effectively use the following Excel functions: SUM, AVERAGE, MIN, MAX and COUNT.
Managing a Worksheet
- Quickly insert, delete or hide cells, rows, and columns.
- Discover many unique Excel techniques to cut, copy and paste.
Formatting a Worksheet
- Enhance the appearance of your worksheet using the many formatting commands.
Managing your Workbook
- Name, group, move, copy and colour your worksheet tabs.
Printing a Worksheet
- Setup and print your worksheet.
(PDF 55 kb)