Advanced Excel

Advanced Excel

17th April 2018
9:30 am - 5:30 pm

Location:
James O'Keeffe Institute, Newmarket, Co. Cork

Places remaining: 8
Cost: €€100.00 (Plus booking fee)

Terms & Conditions - Click Here

Start Date: 17th April
Day of the Week: Wed
Time: 9:30am -5.30pm
Duration: 1 Day
Venue: IRD Duhallow, James O’Keeffe Institute, Newmarket
Tuition Fee: €100
Accreditation: Certificate of Attendance.

 

Course Description:
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

Bookings no longer allowed on this date.