MS Excel 2016 Level 3: Data Analysis

Course information sheet

Fees: Standard £ 150 Conc £No conc. Full £150

Day Time Weeks Centre Start End Code Enroll
Wednesday 09:30 - 17:00 1 MAC 29/04/2020 29/04/2020 TD3060

What will the course cover?

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

Who is the course for?

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

What skills, knowledge or experience do I need to start this course?

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.

What should I be able to do by the end of the 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

How is the course organised?

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.

What extra study or practice is expected outside of the class?


How will my progress be assessed?

Continuous assessment by the tutor and a certificate of attendance.

What can I expect to go on to after this course?

MS Excel 2016 Pivot Table Workshop MS Excel 2016 Level 4 - Automatic Data Analysis

Are there any other costs and what do I need to bring?

Paper and pen to take notes.

What support is available?

If you need support please speak to your tutor