Advanced Excel

Advanced Excel

17th April 2019
9:30 am

James O Keeffe Institute
Places remaining: 9
Cost: €€100.00 (Plus booking fee)

Terms & Conditions - Click Here

Advanced Excel

Start Date: 17th April

Day of the Week: Wednesday

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.