Griffith College Logo

Microsoft Excel - Advanced

Microsoft Excel - Advanced

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 .

Course details
Modules
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

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

CTA1

Ready to take the next step?