Microsoft Excel - Advanced

Course details

If you have attended or understand the concepts covered at the Introductory and Intermediate levels, this course would be your next step. Its main focus is to introduce users to more specialist areas of Excel 's functionality and enable participants obtain an in-depth understanding of the more complex components that make up Microsoft Excel .

Importing Data

• Importing Data from External Sources
• Importing Text Files
• Using Microsoft Query
• Querying Data from The Web
• Refreshing Data

Templates and Styles

• Working with Templates
• Working with Styles

Analysing Data

• What-If Analysis
• Goal Seek
• Data Tables
• Scenario Manager
• Solver
• Using Pivot Tables

Macros and Custom Controls

• Working with Macros
• Running Macros
• Adding Custom Controls

Security and Proofing

• Security Features
• Protecting Excel Files
• Worksheet Protection
• Working with Digital Signatures
• Checking Spelling
• Using Data Validation
• Using Text to Speech
• Documentation

Customising Excel

• Configuring Excel Options
• Customising the Excel Environment
• Working with Workspaces

Collaboration and Consolidation

• Sharing Workbooks
• Sending Workbooks
• Consolidation