Target Audience

People wishing a deeper understanding of how to use the advanced features of MS Excel in an office environment.
Programme Standards

- Maximum 8 attendees
- 30 days of one to one support
- Handouts
- Programme director/s with at least a Masters Degree in the subject
- Convenient morning timings or in-house at any time for a minimum of two bookings
- Can be configured to address a number of professions and industry sectors

Price

EUR395 ex VAT per participant.

​Participants have to provide their own laptop or book a laptop at a cost of EUR50 ex VAT.
MS Excel Advanced for Office Masterclass

This is a programme aimed at the aspiring MSExcel advanced user who is a typical in a position to analyse data and create advanced reports, analytical tools and templates.
Topics Covered

Using Tables and Ranges
Learning how to manage, sort and filter data in tables and ranges to facilitate the use of large volumes of data.

Output - Creation of a Stock Monitoring Template

Data Integrity and Validation
Learning how to import/input and validate inputted data to ensure data integrity.

Output - Creation of a Ordering Template with five product options

Logical Functions
Learning how to create logical functions using IF statements in single and multi-IF dimensions.

Output - Create an Artificially Intelligent Quotation System with five Product Options.

Analysis Big Data in Multi Dimensional Forms
Learning how to use Pivot Tables, import large volumes of data and create reports and charts ad hoc

Output - Create a Pivot Table to Analyse Shipping Costs from a large imported data file.