£80

Intermediate Microsoft Excel - unharness the power with the number one Busi...

Event Information

Share this event

Date and Time

Location

Location

China Fleet Country Club

Saltash

PL12 6LJ

United Kingdom

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

Course Summary

You 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


Outline

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


Share with friends

Date and Time

Location

China Fleet Country Club

Saltash

PL12 6LJ

United Kingdom

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved