Microsoft Excel 365 Level 3

MSE365L3

Overview

About the course

Use Formula Auditing tools to find and fix errors
Use Analysis tools

  • Advanced Filter
  • Subtotal
  • Goal Seek
  • Data Tables
  • Scenario Manager
  • Analyze Data

Create macros
Create permanent connections to external sources
Protect your data with Data Integrity tools
Use Linked Data Types
Create a dashboard using PivotTables, slicers and timelines

Audience Profile

Delegates who use Excel as a powerful analysis tool to regularly analyse complex data sets.

Course Details

  • Course Ref: MSE365L3
  • Course Duration: 1 day
  • Course Location: Sunderland
  • Course Dates: 22 October 2024
  • Course Price: £195+VAT

Prerequisites

Delegates who are very familiar with Microsoft Excel and can use intermediate functions.

Modules

Formula Auditing

What is it?
Trace Precedents
Trace Dependents
Show Formulas
Error Checking
Evaluate Formula
Watch Window

Analysis Tools

Advanced Filter
Subtotal
What – If Analysis: Goal Seek
What – If Analysis: Data Tables
What – If Analysis: Scenario Manager
Analyze Data

Macros

Overview
VBA macros

Get Data

Overview
From Microsoft Access Database
From Web

Data Integrity

Data Validation
Password Protection

Data Types

Linked Data Types

Dashboard

PivotTables
PivotCharts
Slicers & Timelines