Advanced Excel

Advanced Excel

6th November 2019
9:30 am

Location:
IRD Duhallow, James O'Keeffe Institute, Co. Cork
Co. Cork
Places remaining: 12
Cost: €€100.00 (Plus booking fee)

Terms & Conditions - Click Here

Course Name: Advanced Excel

Start Date: Wednesday 6th November

Time: 09:30am – 5.30pm

Duration: 1 Day

Venue: James O’Keeffe Institute, Newmarket, Co. Cork

Tuition Fee: €100

Accreditation: Cert 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

Keep this field blank:

Registration Form


Required field

Required field

Required field

Required field