|
|
MICROSOFT EXCEL
MS EXCEL is a course that presents skills training and assessment for
some of the skill sets that form the Microsoft Office Excel Expert.
This course provides competency in customizing the Excel interface,
using templates, using custom chart types, using workbook collaboration
features, using workbook integration and XML features,
creating and editing macros, controlling macro assignments and functionality,
and troubleshooting macros.
Guided, step-by-step labs provide opportunities to practice new skills.
You can challenge yourself and review your skills after each lesson in
the Lesson Summary and Lesson Review sections. Additional skill reinforcement
is provided in Activities, Optional Labs, Lesson Quizzes and a Course Assessment.
|
NEXT COURSE START DATES
| START DATE | END DATE | DURATION | DAY | TIMING | CAMPUS | REGISTER |
| June 10, 2013 | July 10, 2013 | 5 weeks | M W F | 6:00pm - 9:00pm | Malton-Mississauga* | Register |
| June 22, 2013 | August 24, 2013 | 10 weeks | Sa | 2:00pm - 6:00pm | Brampton | Register |
| August 11, 2013 | October 27, 2013 | 12 weeks | Su | 2:00pm - 6:00pm | Malton-Mississauga | Register |
| August 21, 2013 | October 02, 2013 | 6 weeks | W Th | 6:00pm - 9:00pm | Brampton | Register |
Pre-Requisites: COMPUTER FUNDAMENTALS
Course overview
Module I
- Introduction to Excel
- Creating Workbooks
- Modifying Worksheets
- Formatting Worksheets
- Printing Worksheets
- Working with Formulas
- Working with Basic Functions
- Enhancing Worksheets
- Using Templates, Styles, Worksheet Backgrounds
and AutoFormats
- Finding and Replacing Data
|
|
Module II
- Working with Multiple Worksheets
- Adjusting the Screen Display
- Working with Advanced Functions
- Using Advanced Print Options
- Filtering Data and Using Comments
- Working with Names
- Working with Charts
- Protecting Data
- Using Basic Integration and Web Features
|
|
Module III
- Working with Databases
- Sorting Database Data
- Using Database Functions
- Using Advanced Filters and
- Automatic Subtotals
- Creating PivotTables and
- Pivot Charts
- Formatting and Adjusting
- PivotTable
- Auditing Worksheets and
- Performing What-If Analyses
- Working with Scenarios
|
|
Module IV
- Customizing the Excel Interface
- Using Templates and Custom
- Chart Types
- Using Collaboration Features
- Using Advanced Integration and
- XML Features
- Creating Macros
- Editing Macros
- Controlling Macro Assignments and Functionality
|
|
|
|