We offer training on both Windows and Mac computers locally around Cambridge but also any location in the UK and abroad if required:

  • Microsoft Office: Word, Excel, Outlook, PowerPoint, OneDrive, Visio, Teams
  • Microsoft Project
  • Microsoft SharePoint
  • Adobe Creative Suite: Photoshop, InDesign, Illustrator, Acrobat
  • Power BI
  • And many others…just call us on 01223 841848 or email us

Excel Advanced - Validate and Summarise

Location Great Shelford, Cambridge
Price ex. VAT £225.00
Start Date 30 June 2020
Course type Standard
Course code FROG227
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 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 Recording 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

 

Course Search

Contact Us
Contact Us