Microsoft Excel - Advanced

Course Overview
The advanced excel course is designed to introduce other features of Excel that will enable users to be more exploitative of Excel's abilities.
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 .
Intake Dates
We run two intakes for this course, commencing in Autumn and Spring.
- October*
- February*
*subject to sufficient numbers.
Course Details
Modules
- Importing Data from External Sources
- Importing Text Files
- Using Microsoft Query
- Querying Data from The Web
- Refreshing Data
- Working with Templates
- Working with Styles
- What-If Analysis
- Goal Seek
- Data Tables
- Scenario Manager
- Solver
- Using Pivot Tables
- Working with Macros
- Running Macros
- Adding Custom Controls
- Security Features
- Protecting Excel Files
- Worksheet Protection
- Working with Digital Signatures
- Checking Spelling
- Using Data Validation
- Using Text to Speech
- Documentation
- Configuring Excel Options
- Customising the Excel Environment
- Working with Workspaces
- Sharing Workbooks
- Sending Workbooks
- Consolidation
Course Contacts
If you have any questions please get in touch with us at [email protected] or 01 415 0429.
Timetables
This course is available as customised training please contact [email protected] for further information about this option.
How to Apply
How to apply
Directly to Griffith College Short Courses Department
Fees
Study mode: Part time
Fee: Available on request
