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
EUR495 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. |