Advanced Excel

Advanced Excel

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

Location:
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 / louise.bourke@irdduhallow.com ***

Bookings no longer allowed on this date.

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