Making The Most of Your Data

Overview

The brand-new Making The Most of Your Data masterclass is designed to introduce learners to using a range of tools in Microsoft Excel in order to make the most of their data sets. Learners will gain invaluable knowledge on how to display data effectively, protect its integrity and validate, link and sort and filter data. 

Course Overview

This 3 to 4-hour masterclass will cover:

Pivot Tables

• Creating and Using a Pivot Table
• Filtering and Sorting Data within a Pivot Table
• Manually and Automatically Grouping Data in a Pivot Table and Renaming Groups

Charts

• Creating a Combined Line and Column Chart
• Adding a Secondary Axis to a Chart
• Changing the Chart Type for a Particular Data Series
• Adding and Removing a Data Series to a Chart
• Moving and Formatting Chart Data Labels Modifying Chart Axis Scales
• Inserting Images into Chart Bars and Columns

Linking & Embedding

• Linking Data and cells within a worksheet and workbook

Sorting and Filtering Data

• Sorting Data by Multiple Columns at the Same Time
• Applying a Pre-Installed Custom Sort
• Creating a Customized List and Performing a Custom Sort
• Using AutoFilter to Perform Multiple Queries

Validating

• Data Validation - Whole Number, Decimal Number, List and Date

Macros

• Creation and Deletion of Macros

Passwords & Security Issues

• Adding and Removing 'Open' Password Protection to a Workbook
• Adding and Removing 'Modify' Password Protection to a Workbook
• Password Protecting Cells and Worksheets

Course Aims

Skills and knowledge gained:

All learners will be able to confidently manipulate their data to easily understand tables and visuals. Learners will also be able to link, embed and sort, validate and protect their data using advanced Excel tools and techniques.

Benefits

The learner will leave the session with:

• An increased understanding of data
• Better efficiencies, profit and competitiveness 
• The ability to predict and analyse markets
• Improved transferable and employable data skills

Award

On completion of this masterclass, learners will receive a Certificate of Attendance.

Funding

The Stoke-on-Trent Higher Skills Accelerator is fully funded by the UK Shared Prosperity Fund in partnership with Stoke-on-Trent Council and offered free of charge to each participating organisation.