£84

Microsoft Excel for Intermediates

Event Information

Share this event

Date and Time

Location

Location

Hotel du Vin Exeter

Magdalen Street

Exeter

EX2 4HY

United Kingdom

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

This Half Day session in Microsoft Excel will equip you with the knowledge and skills to use the programme to it’s full advantage. You’ll learn how touse advanced formulas and work with Excel’s tools for analysing data in spreadsheets; things like sorting, filtering, conditional formatting and auditing. You will also organise table data and present data as charts. You will discover how Excel spreadsheets are constructed and be given a clear path on how to create your own templates.

This course is aimed at end users who have taken our Introduction to Excel course or have the following pre-requisites:

Pre-requisites;

  • Create basic spreadsheets
  • Select and edit data
  • Perform basic formatting
  • Open, close and save files
  • Create basic formulas - AutoSum
  • Use Insert Function to create built-in functions
  • Work with absolute references
  • Use the AutoFill feature

Delegates will learn how to;

  • Working with an Excel List
  • Work with Excel tables
  • Organise worksheet data so that data can be sorted and filtered
  • Create and modify Charts
  • Apply Conditional Formatting
  • Analyse data with Recommended Pivot Tables

Module 1: Working with an Excel List

  • Understanding Excel List Structure
  • Sorting a List Using Single Level Sort
  • Sorting a List Using Multi Level Sorts
  • Using Custom Sorts in an Excel List
  • Filter an Excel List Using the AutoFilter
  • Creating Subtotals in a List
  • Format a List as a Table
  • Using Conditional Formatting to Find Duplicates
  • Removing Duplicates

Module 2: Auditing a Workbook

  • Finding Cells
  • Finding and Resolving Errors
  • Evaluating a Formula

Module 3: Mastering Excel Tables

  • Introducing Excel Tables
  • Using Advanced Table Tools

Module 4: Organising Worksheet Data

  • Apply Basic Sorting to a Data Range
  • Advanced Sorting
  • Summarise Data with Subtotals

Module 5: Charts

  • Understanding Charts
  • Create a Chart
  • Modify and Format a Chart
  • Analyse Data Using Sparklines

Module 6: Working with Hyperlinks and Comments

  • Create a Hyperlink
  • Adding Comments

Module 7: Apply Conditional Formatting

  • Conditional Formatting
  • Customising Conditional Formatting
  • Sorting and Filtering by Colour

Module 8: An Introduction to Pivot Tables

  • Understanding Pivot Tables
  • Analyse Data with Recommended Pivot Tables

We're lookng forward to seeing you on the Course.

If you have any questions, you can call the Momentum South West Team on 01803 266600 or email Enquiries@momentumsouthwest.co.uk

Share with friends

Date and Time

Location

Hotel du Vin Exeter

Magdalen Street

Exeter

EX2 4HY

United Kingdom

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved