Microsoft Excel Training
Microsoft Excel Training - Part 2: Turn Your Data into Decisions
COURSE CONTENT
ME-EXL365PT2: MICROSOFT EXCEL 365: PART 2 COURSE CONTENT
Welcome to Part 2 of our Microsoft Excel 365 course. This version of Excel comes loaded with features and connectivity options designed to make collaboration and productivity as smooth as possible.
If you work with numbers – sales, inventory, HR, IT or any department that needs data – you know that getting the right info to the right people at the right time is a serious advantage. Data rules the world and it’s not slowing down.
The challenge? Making sense of it all.
You already know the basics: simple calculations, tidy workbooks, readable sheets. Now it’s time to level up. This course is about turning raw data into actionable intelligence. When questions pop up, you’ll know how to get Excel to give you answers, fast.
Building on Part 1, we dive into advanced workbooks and worksheets that reveal patterns, extract insights and help make data-driven decisions that actually matter. Analyse more, present smarter and give your organisation the edge it deserves.
Data is everywhere. Excel Part 2 helps you tame it.
Module 1: Working with functions
Work with ranges
Use specialized functions
Work with logical functions
Work with date and time functions
Work with text functions
Module 2: Working with lists
Sort data
Filter data
Query data with database functions
Outline and subtotal data
Module 3: Analysing data
Create and modify tables
Apply intermediate conditional formatting
Apply advanced conditional formatting
Module 4: Visualizing data with charts
Create charts
Modify and format charts
Use advanced chart features
Module 5: Using PivotTables and PivotCharts
Create a PivotTable
Analyze PivotTable data
Present data with PivotCharts
Filter data by using timelines and slicers
DURATION
1 DAY
LEVEL
Intermediate
TECHNOLOGY
Office 365
METHOD
Teams – Instrutor-led
CERTIFICATION
Attendance Certificate
Start Growing - Register Here!
Level Up Without Leaving Your Desk
Sharpen your skills with our online business courses.
Master data analysis, visualise charts, conquer pivot tables and become a Microsoft pro – one course at a time.
Collaborating with leading business development course providers, Data4Every1 is your go-to partner for business training.
Upskill and have fun – all from the comfort of your desk.
Services
Enterprise Resource Planning
Development
Infrastructure
Payroll
Connect
South Africa + 27 12 740 7429
Zambia +260 63 002 0137
