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
Updated on 08 November, 2015

About Griffith College Dublin

Griffith Halls of Residence is purpose-built student accommodation located on the grounds of Griffith College Dublin.

About Griffith Halls of Residence

Griffith Halls of Residence is purpose-built student accommodation located on the grounds of Griffith College Dublin. Just 15 minutes' walk from Dublin city centre, Griffith Halls of Residence boasts an enviable central location that makes us ideal not just for Griffith students, but also students attending any of Dublin's universities or other third level institutions.

A message from the President of Griffith College.

I am delighted to welcome you to the Griffith College website.  Founded in 1974, Griffith College is Ireland’s largest independent college with 7,000 students from Ireland and across the world and their mission is to be a core of the community and a highly reputed center of education.  

At Griffith College their purpose is to set students on a course of change in their lives, leading them towards achieving their optimum potential.  Education should lead to a deep understanding of the subjects being studied as well as excellent exam results; the courses in Griffith College are taught with this in mind.  The College delivers internationally recognized undergraduate and postgraduate degree courses in a vibrant setting. Their record of prize winning students across a wide range of disciplines is testament to the dedication and professionalism of their lecturing and administrative teams.  I would encourage you to explore their website to discover the wide choice of opportunities they have to offer.

See all Griffith College Dublin courses
Are you from Griffith College Dublin ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

Is this the right course for you?

Didn't find what you were looking for ?

or