Microsoft Excel - Advanced

Microsoft Short Courses
Type
Professional / Short Course
Duration
1 Day (9.30am - 5.00pm)
Validated by
Griffith College
Mode
Part-Time
Campus
Dublin
NFQ Level
N/A
Apply Now Contact Us

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

Ready to take the next step?