Home > Microsoft Office Training:
Microsoft Excel Training Toronto - Formulas
Microsoft Office 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. If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.
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
Formulas
Course Information
Duration: Two-Day Course
Platform: Windows and Macintosh
Fee: $595 CDN (+GST)
This class is limited to eight people.
Course Overview
This course focuses on Excel formulas, range names and proper spreadsheet design.
You’ll also learn some useful keyboard shortcuts and some “hidden” tricks.
Course Content
- The Excel Object model explained
- Different ways of entering Excel
formulas: typing versus pointing
- Formula limits
- Formula Operators
- Operator precedence
- Cell and range references
- Absolute and relative references
- A1 versus R1C1
- Linking formulas
- Converting formulas to values
- Hiding formulas
- Formula errors explained
- Range names
- Name scope, i.e. workbook versus worksheet scope
- Defining and creating range names
- Managing names
- Naming entire rows and columns
- Multisheet names
- Listing names
- Names in formulas
- Referencing a single cell in a multicell named range
- Naming constants
- Potential problems with names
- Worksheet functions
- Function argument types
- Function categories
- Text functions
- Dates and Times in formulas
- Formatting dates and times
- Problems with dates
- Generating a date series
- Counting and summing functions
- Lookup Functions
- Match and Index functions with lookups
- The Subtotal Function
- Database functions, i.e. DSum,
- Average, etc.
- Advanced data filter
- Data tables – one way and two way
- Arrays
- Array formulas
- Array constants
- Editing array formulas
- Pivot tables
- Data validation
- Create custom functions using VBA
Calendar Dates:
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)