Associated Courses

Course Outline

Duration

1 Day

Price

£150 per person

Pre-Requisites

Delegates should have a good working knowledge of using Excel 365 as can be gained from our Excel 365 Core Skills course.

Course tailoring service

Our tailoring service is a luxury you can afford, allowing you to combine elements of related courses producing a bespoke
solution, designed specifically to fulfil your training needs. Is there any better way to meet all of your training objectives and maximise your training ROI?

Kit supply

Running a course at your facilities might sound like a good idea until you start thinking about the practicalities of equipment usage and the
impact this could have on day to day business, so why not let us bring the necessary
equipment with us?

Excel 365 Intermediate

Learn how to

Colour code data based on its value
Filter and sort data in tables
Create decision-making functions
Make use of date and time functions
Make use of financial functions
Make use of statistical functions
Make use of text based functions
Work with data across multiple workbooks and worksheets
Share workbooks for collaborative working
Import and Export data

Content

Conditional Formatting
Introduction to Conditional Formatting
Highlighting Specific Values
Data Bars
Color Scales
Icon Sets
Fine-Tuning Conditional Formatting
Using Multiple Rules

Organizing Data Using Tables
Create Tables
Modify Tables
Format Tables

Sorting and Filtering
Sorting Data
Mutlilevel Sorting
Filtering a List with Autofilter
Filtering a List with Advanced Filter

Working With Tables
Highlighting Duplicates
Combining Data from Multiple Tables
Auto Outline
Automatic Subtotaling

Advanced Charting
Exploding Slices in a Pie
Grouping Slices in a Pie
Creating Combination Charts

Working with Graphics
Inserting Pictures
Inserting ClipArt
Creating AutoShapes
Formatting Graphic Objects

Advanced Formulas and Functions
Inserting Functions
Formula Building Recommendations
Naming Cells and Ranges
Logical Statements
Conditional Formulas (AND, OR, NOT)
IF Functions
Nested IF Functions
Combining IF with AND, OR, and NOT
IS Functions
Using IS with IF to Change Error Messages

Database Formulas and Functions
The LOOKUP Function
Array Lookup
Vector Lookup
The VLOOKUP Function
The HLOOKUP Function

Detailed Functions
Date and Time Calculations
Text and Data Functions
Mathematical Functions
Statistical functions

Importing and Exporting
Exporting Data From Excel
Importing Data From Other Applications
CSV files