| Print |

Excel Advanced - Validate and Summarise

Location Cambridge
Price ex. VAT 215 GBP
Start Date 29 May 2019
Course type Standard
Course code FROG227
Duration 1 Day

Description

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 create and edit Macros to speed up processes.

 

Target Audience

Designed for existing users of Excel who wish to progress their Excel skills and benefit from its powerful data analysis tools.

Prerequisites

It is assumed that the participant will have either attended an Excel Intermediate course or have equivalent knowledge.

Outline

Data Validation

Lists

  • “Cleansing Data”
  • Single & Multi-level sorting
  • Auto Filter & Advanced Filter
  • Tables

Pivot Tables and Pivot Charts

  • Summarising with Pivot Tables
  • Creating Pivot Charts
  • Using the Slicer/Timeline
  • Quick Analysis Tool

Outlining

  • Grouping
  • Subtotals

Importing Data

  • Importing Data from Various Sources
  • Query Databases
  • Get & Transform

Templates

  • Excel Templates
  • Create/Edit a Template
  • Default Templates

Introduction to Macros

  • Recording a macro
  • Personal macro workbook
  • Running and editing a macro
  • Assigning a macro to Objects or Buttons

Using Excel in a Workgroup

  • Comments
  • Sharing Workbooks
  • Tracking Changes
  • Document Inspector
  • Mark as Final

Protecting Cells and Workbooks


Book the course: Excel Advanced - Validate and Summarise

Course Search