Level 2 Award: Business Data Essentials

Eligibility Requirements:

• 19+
• Living within a Tees Valley Postcode (AM Training team can make relevant checks)
• Not currently an apprentice or on another funded training programme
• Have lived in the UK 3 years

Overview:

This Level 2 Award enhances your data analysis and presentation skills, equipping you with the knowledge to analyse data and present using Microsoft Excel and Microsoft Powerpoint. We cover the key features of each piece of software, including automated functions, graphs and charts and show you how to create effective presentations for business communication.

Why take this course?

Data analysis and communication are core business skills that are essential to many roles. Sharpening data analysis and presentation skills helps you to become more productive and effective in your role and help position you as an asset to the business.

This course can benefit those working with data in their current role or those working towards a position that deals with sorting and analysing data. It is also a helpful training course for employers looking to upskill teams.

What are the contents of this course?

Topics include:

• Unit 1: Spreadsheet Skills – Develop an understanding of the key features and uses of spreadsheets. Learn how to edit and format data, use automated formulae and transform data into charts and graphs. In addition, you will develop an understanding of spreadsheet usability.
• Unit 2: Presentation Skills – Learn how to create presentations for different audiences & purposes. Understand the use of multimedia and tables and charts in presentations. Understand how and when to use layouts, templates and design themes. Develop an understanding of accessibility, copyright and other legal or ethical considerations in presentation design.

Covering:
Basic Principles of Excel
Introduction to Formulas including SUM, MAX, MIN, Absolute Cell Referencing, and conditional Formatting
Formatting ranges of cells (range vs table)
Pivot tables and pivot charts
IF Statement as well as AND/OR Functions
Vlookup and Xlookup
Presenting data in PowerPoint