| Microsoft Excel 2007 | ||
| Level: Advanced | ||
| Duration - 1 Day | ||
|
This course is designed to familiarise the Student with the more advanced techniques of the package. Delegates should have completed an Excel Introductory course prior to attending. Themes• Using a predefined Theme• Creating a Theme Styles• Creating a Style• Changing Default Styles • Merging Styles from Other Workbooks • Applying Styles Templates• Creating a Template• Storing Templates • Using Templates • Editing Existing & Default Templates • Inserting Sheet Templates Startup Folders• Using the XLSTART Folder• Using Alternative Startup Folders File Linking• Creating linking Formula• Opening & Updating Linked Worksheets • Editing a Link • Editing Arrays made with Paste Link • Opening Target and Source Workbooks Data Consolidation• Data Consolidation by Position• Consolidation by Category • Creating Links and Consolidation Sharing Workbooks• Setting up Shared Workbooks• Tracking changes • Merging Workbooks Outlining• Creating an Outline• Working in Outline • Removing an Outline The View Manager• Creating a View• Displaying a View • Deleing a View Report Manager• Creating a report• Printing a report • Editing a report |
Embedding Objects in a Worksheet• Inserting a Microsoft Word Document in a Worksheet• Embedding Other Objects • Linking Excel With Other Applications Goal Seek
• Adding a Scenario |
|
