Home > Microsoft Office Training:
Microsoft Excel Training - Intermediate/Advanced
Microsoft Office 2000-2003
Application Overview:
Microsoft Excel
Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, and calculate data. You can use advanced features to manage, track, and chart critical business data to create rich data visualization, PivotTable views, and professional-looking charts. You can compile your company’s data into Microsoft Office Excel by retyping or by copying and pasting. But importing is most effective when you're working with large amounts of data that would be time-consuming to enter manually or too large to copy and paste. In addition, if you import your data, Excel can automatically update your reports and summaries whenever the original source database is updated. Your data is always current.
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 Excel
Intermediate/Advanced
Course Information
Duration: Two-Day Course
Platform: Windows and Macintosh
Fee: $545 CDN (+GST)
This class is limited to eight people.
Course Overview
Increase your competence with Excel by discovering the more advanced features of the program. You will see a demonstration of the feature and will be given hands-on exercises to reinforce your learning.
Course Content
- Add, delete and move buttons on an existing toolbar or create a custom toolbar
- Name a single cell or a range of cells to easily select that area or to make formulas easier to create and read
- Apply conditional formatting to highlight formula results
- Insert cell comments to effectively annotate a worksheet with information
- Use the IF function to create a formula for decision making and calculation
- Use the SUMIF function to sum a range only if it meets a certain criteria
- Use the COUNTIF function to count the number of cells within a range that meet your criteria
- Create and use an Excel database using the Form command
- Use the Sort command to rearrange the information of a list
- Use the AutoFilter and Advanced Filter to extract information from a listUse the Subtotal command to produce automatic subtotals and grand totals
- Manage a large worksheet using the Auto Outline command
- Link worksheets and workbooks cells
- Track and highlight changes made in a worksheet
- Protect cells containing formulas with the Protection command
- Avoid entering incorrect or inconsistent data by using the Data Validation feature
- Graphically display relationships between the cells in your worksheet by using the Formula Auditing Toolbar buttons
- Learn to nest or combine a number of operations in one cell
- Locate a value within a table by using the VLOOKUP function
- Reduce time and effort by creating and using a simple macro
- Apply repetitive formatting by creating styles
- Establish a consistent look by creating a template of a frequently used worksheet
- Share Excel data with other Office applications
- Present data more effectively by creating charts
- Get an introduction to pivot tables which will help you summarize, organize, analyze and compare large amounts of data
Calendar Dates:
Jul 2/3, 2008
Jul 16/17, 2008
Jul 28/29, 2008
Aug 5/6, 2008
Aug 13/14, 2008
Aug 21/22, 2008
Aug 25/26, 2008
Aug 27/28, 2008
Sep 8/9, 2008
Sep 24/25, 2008
Oct 14/15, 2008
Oc 29/30, 2008
Nov 5/6, 2008
Nov 11/12, 2008
Nov 24/25, 2008
Dec 2/3, 2008
Dec 8/9, 2008
Download PDF of Course Outline
If you have Adobe Reader installed you can view it now:
Related Training
DPA Certificate Programs
Our certification programs give you the opportunity to build your proficiency in electronic imaging, page layout, Internet, and office productivity while saving you a considerable amount.
more >>
(PDF 55 kb)