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 / [email protected] ***

Bookings no longer allowed on this date.