Advanced Excel

Advanced Excel

13th November 2018
9:30 am - 5:30 pm

Location:
James O Keeffe Institute
Newmarket
Places remaining: 7
Cost: €€100.00 (Plus booking fee)

Terms & Conditions - Click Here

Advanced Excel

Start Date: 13th November

Day of the Week: Tuesday

Time: 9.30am – 5.30pm

Time: 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.