Excel 2007/2010/2013/2016 Advanced - Validate & Summaries

Short course

In Cambridge

Save 4%
£ 205 + VAT

Description

  • Type

    Short course

  • Level

    Advanced

  • Location

    Cambridge

  • Duration

    1 Day

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 Summarise, Filter, Sort, Import, and Export data at different levels. You will also have gained an understanding of how to create and edit Macros and be able to create a simple Macro. Suitable for: Designed for existing users of Excel who wish to progress their Excel skills and benefit from it's powerful data analysis tools.

Facilities

Location

Start date

Cambridge (Cambridgeshire )
See map
4 Station Court, Great Shelford, CB225 NE

Start date

On request

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Manipulating data
  • Summarise Filter Sort Import and Export data
  • Excel
  • MS Excel
  • Exel 2007
  • Excel 2010
  • Excel 2013
  • Excel 2016
  • Microsoft Excel
  • Accounts

Teachers and trainers (1)

TBA TBA

TBA TBA

Trainer

Course programme

Excel Advanced Validate, summarise, analyse and manipulate your data with Excel

Lists

Single & Multi-level sorting

Auto Filter & advanced filter

Get external data

Extract data

Query databases

Data Validation

Pivot Tables and PivotCharts

Summarising With Pivot Tables

Using the Slicer

Subtotals

Grouping & Outlining

Importing and Exporting Data

Querying

Query databases

Extracting data

Templates

Apply/create/edit templates

Introduction to Macros

Recording a macro

Personal macro workbook

Running and editing a macro

Step through a macro

Assigning a macro to the Quick Access Toolbar

Using Workgroup Functions

Comments

Sharing lists

Tracking changes

Resolving conflicts

History of changes

Merging changes

Document Inspector

Mark as Final

Protecting Cells and Workbooks

Additional information

FROG have been providing excellent training for 30 years

Excel 2007/2010/2013/2016 Advanced - Validate & Summaries

£ 205 + VAT