Excel 365 Intermediate Training Course

Excel 365 Intermediate

Course Overview

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will:

Work with functions.
Work with lists.
Analyze data.
Visualize data with charts.
Use PivotTables and PivotCharts.

Duration: 1 day course

Course Content

Working with Functions

Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date and Time Functions
Work with Text Functions

Working with Lists
Sort Data
Filter Data
Query Data with Database Functions
Outline and Subtotal Data

Analyzing Data
Create and Modify Tables
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting

Visualizing Data with Charts
Create Charts
Modify and Format Charts
Use Advanced Chart Features

Using PivotTables and PivotCharts
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers

Email us about this courses

Telephone on 01952 938014