Excel Advanced - Validate and Summarise

LocationCambridge

Price ex. VAT
215 GBP

Start Date30 April 2019

Course typeStandard

Course codeFROG227

Duration1 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

*
Number of Attendees

*
Salutation:

*
Firstname:

*
Last Name:

*
Email:

* Attendees Names:

Software Version:

* Telephone No:

Company:

How did you here about us:

Voucher Code:

Comments:

FROG would love to keep in touch about future offers and services we think you’ll like to hear about. To confirm you would like to receive this information by email, please tick the box. Don’t forget, you can also change your marketing contact preferences at any time by emailing training@frog.co.uk or by using the unsubscribe links which you’ll find on all our marketing emails. For further information please see our Privacy Policy