Advanced Microsoft Excel
 |
|
Date: 02-09-2010 Duration: 1 Day Location: Procad, Raheen. Limerick Pls note: Verison 2007 of MS Excel Cost: €100 Members, €130 Non Members To book this Event or make an enquiry click this button. |
 |
Course Overview:
This Microsoft Excel Advanced Training course is a 1 Day Programme designed for candidates who would like to enhance their understanding and knowledge of Excel. It takes participants through the items listed in the course contents to a point where participants can use Microsoft Excel to increase efficiency in their everyday work.
Pre-requirements:
A good knowledge of Excel
Content
- Importing Data from External Sources
- Templates & Styles
- Analysing Data
- Pivot Tables
- Macros and Custom Controls
- Security and Proofing
- Customising Excel
- Collboration and Consolidation
Course Outline:
Importing Data From External Sources
- Importing Files
- Using the Text Wizard
- Using the Microsoft Query
- Web Queries
Templates & Styles
- Creating & Applying Templates
- Creating, Applying, Editing & Deleting Styles
Analysing Data
- What-If Analysis
- Goal Seek
- Data Tables
- Scenario Manager
- Solver
Pivot Tables
- Understanding Pivot Tables
- Creating Pivot Tables
- Modifying & Refeshing Pivot Tables
- Grouping Data within Pivot Tables
Macros and Custom Control
- Using Macros
- Recording a Macro
- Assigning a Macro to a shortcut key
- Running Macros
- Working with Buttons
- Creating a New Button
- Renaming & Formatting a Button
- Assigning a Macro to a Button
Security and Proofing
- Working with Security Features
- Protecting Excel Files
- Worksheet Protection
- Protecting Cells
- Digital Signatures
- Data Validation
- Using Text to Speech
- Working with Comments
Customising Excel
- View Options
- Calculation Options
- Edit Options
- General Options
- Custom Lists
- Save Options
- Workspaces
Collaboration and Consolidation
- Sharing Workbooks
- Comparing and Merging Workbooks
- Sending Workbooks
- Consolidation
