|
ctc TrainCanada ~ computer training Toronto, Markham, Mississauaga Cancellation Policy
Description: Students will learn to modify and personalize their Excel environment and create macros. Students will also learn to create and use Excel forms.
| Importing Data |
| Enhancements to Query Tables and Lists |
| Using Microsoft Query |
| Querying Data From The Web |
| Refreshing Data |
| Importing Data From External Sources |
| Importing Text Files |
| |
| Templates And Styles |
| Working With Templates |
| Working With Styles |
| |
| Analyzing Data |
| Goal Seek |
| Data Tables |
| Scenario Manager |
| What-if Analysis |
| Solver |
| Using Pivot Tables |
| |
| Macros And Custom Controls |
| Working With Macros |
| Running Macros |
| Adding Custom Controls |
| Enhancements to the Object Model |
| |
| Security And Proofing |
| Working With Digital Signatures |
| Security Features |
| Protecting Excel Files |
| Worksheet Protection |
| Checking Spelling |
| Using Data Validation |
| Using Text To Speech |
| Documentation |
| Data Links and Macro Security Permissions |
| Migrating to the Security Trust Centre |
| |
| Customizing Excel |
| Configuring Excel 2003 Options |
| Customizing The Excel Environment |
| Working With Workspaces |
| |
| Collaboration and Consolidation |
| Sharing Workbooks |
| Sending Workbooks |
| Consolidation |
| |
Pre-Requisites: The prerequisites for this course are the successful completion of an intermediate course on Excel or several months experience with the software. A good knowledge of the Windows environment is also required.
Certificates offered: Certification of Completion
Duration Details: 1 day
9:00am - 4:00pm
Facility Location: Mississauga Office
201 City Center Drive
Suite 601
Mississauga
Ontario
Canada
L5B 2T4
| 
