Advanced Excel

Advanced Excel

4th May 2017
9:30 am - 5:30 pm

James O'Keeffe Institute,

Places remaining: 3

There are a limited number of Free places on most courses available for those in receipt of a welfare payment. Eligibility Criteria
Terms & Conditions - Click Here

This course is designed for people who have and excellent knowledge of Excel up to intermediate level. On completion of this advanced course, candidates will have the necessary skills to produce complex documents using all the tools and functions available to them in Excel.

This Course will Cover:
• Data importing into Excel
• Build & Work with Macros
• Creating queries using Filters
• Customising Excel
• Using shared workbooks
• Creating and applying a template
• Using styles and data tables
• Using scenario manager and solver
• File protection
• Using data validation
• Using Sub totals
• Auditing Tools
• If & Formula
• Multiple IF Statements
• H & V Lookups
• Pivot Tables
• Pivot Charts
• Advanced Formatting
• Linking Sheets
• Embedded objects within Excel & Word

Download a Full Course Outline by Clicking Here: Advanced Microsoft Excel


Duration: 1 Day

Time: 9.30am – 5.30pm


*** A Limited Number of Free Places are Available for those in receipt of a Welfare Payment. For further details please contact Louise on 029-60633 / ***

Keep this field blank:

Registration Form

First Name *
Required field
Last Name *
Required field
E-Mail *
Required field
Phone number:*
Required field
Apply for Subsidised Place * (if any spaces remain).
Book a Place on the course
Pay now via paypal
Comments / Special Requirements

*For Social Welfare Recipients. See Eligibility Criteria

Tweet about this on TwitterShare on FacebookShare on Google+Pin on PinterestShare on LinkedInEmail this to someone