Objectives
The aim of this course is to assist users who need to become proficient in manipulating data within Excel. By the end of the course you will be able to Clean and Summarise, Filter, Sort, Import, Share and Protect data. You will also have gained an understanding of how to record and edit simple Macros to speed up processes.
Data Validation & Protecting Cells
Lists
- “Cleansing Data” with formulas, Remove Duplicates, Text to Columns
- Filter & Advanced Filter
- Tables & Slicers
Outlining
- Grouping
- Subtotals
Pivot Tables and Pivot Charts
- Summarising with Pivot Tables
- Creating Pivot Charts
- Using the Slicer/Timeline
- Quick Analysis Tool
Importing Data
- Importing Data from Various Sources
- Get & Transform
Templates
- Create/Edit a Template
Introduction to Recording Macros
- Recording a macro
- Running and editing a macro
- Assigning a macro to Objects or Buttons