Excel Part 2 - Excel Intermediate

Overview

About this course

Build on the basics in Excel. You will use functions, work with lists, analyse and visualise data with charts and create PivotTables and PivotCharts.

Curriculum

Curriculum

6 modules

Work with Ranges
Use logical, date/time, and text functions
Apply specialized formulas

Sort and filter data

Create and manage Excel tables
Apply intermediate and advanced conditional formatting

Build and modify charts for clarity
Apply formatting and advanced chart features

Create and analyze PivotTables
Build dynamic PivotCharts
Use slicers and timelines for filtering

What Is Microsoft Copilot Chat?
The Magic Prompt Formula
Work Smarter with AI

Who it's for

Who it's for

Excel users who know the basics.

Before you start

Participants should have completed Excel - Part 1 or have equivalent experience using Excel formulas, formatting, and workbook navigation.

Diplomas

Part of these Alalamia diplomas

Alalamia Diploma in Business Analytics and Data Visualisation (Excel and Power BI)