Microsoft Excel 365 Intermediate

Who should attend

This course is ideal for professionals who use Excel regularly and want to enhance their skills. It’s perfect for business analysts, accountants, data managers, and administrative staff looking to improve efficiency in reporting and data management. Anyone with basic Excel knowledge who wants to master advanced formulas, PivotTables, charts, and collaboration tools will benefit. If you’re looking to work smarter with data, this course will help you boost productivity.

Learning Outcomes

Having completed the training the attendees will be able to: Use Advanced Formulas & Functions – Apply logical, lookup, and text functions for efficient data processing. Manage & Analyze Data – Organize, filter, and sort large datasets effectively. Create & Customize Charts – Visualize data with dynamic charts and graphs. Work with PivotTables & PivotCharts – Summarize and analyze complex data sets. Apply Conditional Formatting – Highlight key data trends and patterns. Use Data Validation Techniques – Control data entry and maintain accuracy. Enhance Efficiency with Named Ranges – Simplify formulas and navigation. Automate Tasks with Excel Features – Utilize Flash Fill and Quick Analysis tools. Collaborate in Excel 365 – Share, comment, and work on spreadsheets with others. Improve Productivity with Shortcuts & Tips – Speed up workflow with essential Excel tricks.

Some key features in Excel

Flash fill, Quick Analysis and Tell me About

Working With Charts

Creating charts
Selecting charts from the Add-ins Store
Identifying and using the correct chart for your data
Creating Sparklines
Insert 3D map

Working with Functions and Formulas

Using Functions in Excel: IF Statements, VLookup and XLookup, CountIf, SumIf Working with Names and Ranges Using names to simplify formulas

Some key functions in Excel

Ifs, Switch, TextJoin, ConCat

Advanced Formatting

AutoFormat (Table Format)
Visualising Data using Conditional Formatting
Data Validation
Using Multiple Worksheets & Workbooks

Pivot Tables

Introduction to Pivot Tables
Manipulating data in the Pivot Table
Creating Pivot Charts
Using Slicers

Get and Transform Data

Introduction to Power Query