Microsoft Office 2000-2003
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.
Upgrade to Microsoft Office 2007 Training
Microsoft Office 2000-2003 Training
Microsoft Access
Introduction
Microsoft Access
Intermediate
Microsoft Access
Macros
Microsoft Excel
Introduction
Microsoft Excel
Intermediate/Advanced
Microsoft Excel
Formulas
Microsoft Excel
Macros
Microsoft Excel
Microsoft Excel Expert
Microsoft Outlook
Introduction/Intermediate
Microsoft PowerPoint
Introduction
Microsoft PowerPoint
Intermediate/Advanced
Microsoft Project
Introduction
Microsoft Project
Intermediate
Microsoft Publisher
Introduction
Microsoft Visio
Introduction/Intermediate
Microsoft Word
Introduction
Microsoft Word
Intermediate/Advanced
Microsoft Word
Microsoft Word
Expert
Microsoft Excel
Introduction
Course Information
Duration: One-Day Course
Platform: Windows and Macintosh
Fee: $275 CDN (+GST)
This class is limited to eight people.
Course Overview
In this introductory course you will learn how to create a professional looking Microsoft Excel worksheet which includes text, numbers and calculations.
Course Content
- Name the Excel window components: Toolbar, Formula Bar, sheet tabs, cells, rows, and columns
- Explore the new Excel Task Panes
- Display, hide and move Toolbars
- Efficiently move through the worksheet
- Proficiently select cells and ranges
- Create time-saving Excel formulas using addition, subtraction, multiplication and division
- Effectively use the following Excel functions: SUM, AVERAGE, MIN, MAX and COUNT
- Avoid mistakes using the new Error Checking command
- Quickly insert, delete or hide cells, rows, and columns
- Discover many unique techniques to cut, copy and paste in Excel
- Enhance the appearance of your worksheet using the many formatting commands
- Name, move and copy worksheets
- Use the Page setup command to setup and then print your worksheet
(PDF 55 kb)