Fees: Standard £ 150 Conc £No conc. Full £150
|Wednesday||09:30 - 17:00||1||MAC||29/04/2020||29/04/2020||TD3060|
This advanced Excel course offers a focused approach that looks at manipulating and analysing data and goes into detail on how to normalise data and analyse it with Pivot Tables
This course is aimed at experienced Excel users who need to perform more complex functions, lists analysis, use what-if tools and for those who would like to start recording macros
You must have sound Excel skills and understand key concepts of spread sheets or you have attended our MS Excel 2016 Level 2 - Practical Business Use course.
After the Course you will be able to: - Use Lookup functions - Create Pivot Tables - Use Pivot tables to analyse data - Data Cleansing - Protect data in worksheets and workbooks - Record basic Macros
This is a 1 day course and the tutor will go through the features of Excel on screen. You will be given time to practice using the application through set exercises.
Continuous assessment by the tutor and a certificate of attendance.
MS Excel 2016 Pivot Table Workshop MS Excel 2016 Level 4 - Automatic Data Analysis
Paper and pen to take notes.
If you need support please speak to your tutor