Microsoft Excel 365 Level 3

Microsoft Excel 365 Level 3

Overview

Use Formula Auditing tools to find and fix errors
Use Analysis tools
o Advanced Filter
o Subtotal
o Goal Seek
o Data Tables
o Scenario Manager
o 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

Duration

1 Day

Target Audience

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

Prerequisites

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

Topics

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

 

 

Course Details

Course Ref:

MSE365L3

Course Duration:

1 day

Course Location:

Sunderland

Course Dates:

Please call for dates...

Course Price (Excl VAT):

Please call for prices...


Course Downloads

Send course details to a colleague

Telephone

   To book or for further information, please telephone 0191 515 3355 or e-mail us at sales@mtc-training.co.uk