Course Description
This course explains how to use Microsoft Excel for advanced spreadsheets use.
This course is intended for those who are experienced in Excel or have completed the Intermediate level Excel course.
Course Content
- Creating Tables in Excel
- Advanced formulas and functions
- Database Functions
- Text Functions
- Lookup, Index and Match
- Array Formulas
- Advanced List management
- Importing & Exporting Data
- What If Analysis
- Scenarios,
- Data Tables,
- Goal Seek
- Spreadsheet Security
- Working with Macros
- Creating a Macro
- Inserting a Macro
- Assigning a macro to a button
- Forms and Form controls in Excel
Course Duration
One full day 9.30 am – 4.30 pm
Course Fee
Course fee is €195 per person
*Discount for multiple or group bookings
Training Locations
We have training locations in Dublin, Naas, Cork, Limerick, Galway, Sligo & Waterford.
We can also provide onsite training in a group or one to one basis.
Training Dates
For public training dates at our regional training locations see here
Enquiries
If you would like further information please complete our online enquiry form
Please call us on 1800 250350 to chat with one of our staff.
Back to the Main Excel Menu