SKU: N/A Category:

Microsoft Excel Course Part 2

Welcome to Part 2 of our Microsoft Excel 365 courseware – Where we show you how to make sense of your data, spot patterns, build dashboards and get answers fast!

Perfect for corporate Excel training, group workshops, or anyone ready to level up their Excel skills with our range of Microsoft Excel Training.

ZK2,233.00 Excl. VAT

Product Details

Welcome to the second part of our Microsoft Excel course. This version of Excel comes loaded with features and connectivity options designed to make collaboration and productivity as smooth as possible. Whether you crunch numbers for sales, inventory, HR, IT, or any other department, getting the right information to the right people at the right time can give your team a serious edge.

The world runs on data and it’s not slowing down. The challenge? Making sense of it all.

You already know the basics: simple calculations, tidy workbooks, and readable worksheets. Now it’s time to level up. This course shows you how to turn raw data into actionable insights, so when questions pop up, Microsoft Excel gives you the answers, fast.

Building on Microsoft Excel for Office 365™ (Desktop or Online): Part 1, we dive into advanced workbooks and worksheets that reveal patterns, extract insights, and help you make data-driven decisions that actually matter. You’ll learn how to analyse large datasets, create dashboards, and present data clearly, giving your organisation the tools to compete at a high level.

Perfect for corporate Excel training, group Excel workshops or professional Excel courses – this course will equip you to harness Excel for business, optimise workflows and deliver real organisational value.

Discover more

Download Outline ➤ ME-EXL365Pt2 – Microsoft Excel 365 Part 2

Watch an informative video ➤  Excel for the web: The evolution of a modern web app

Associated Certification & Exam

On successful completion of this outlook training course, participants will receive an attendance certificate from Training4Every1 powered by Eduqe.

 


COURSE CONTENT

Microsoft Excel Course Module One

Working with Functions
  • Work with ranges
  • Use specialised functions
  • Work with logical functions
  • Work with date & time functions
  • Work with text functions

Microsoft Excel Course Module Two

Working with Lists
  • Sort data
  • Filter data
  • Query data with database functions
  • Outline & subtotal data

Microsoft Excel Course Module Three

Analysing Data
  • Create & modify tables
  • Apply intermediate conditional formatting
  • Apply advanced conditional formatting

Microsoft Excel Course Module Four

Visualising Data with Charts
  • Create charts
  • Modify & format charts
  • Use advanced chart features

Microsoft Excel Course Module Five

Using PivotTables and PivotCharts
  • Create a PivotTable
  • Analyse PivotTable data
  • Present data with PivotCharts
  • Filter data using timelines and slicers

 


Disclaimer

Training4Every1 Course details and content may change without notice to stay aligned with current software updates and best practices.

By booking this training, you agree to our Training Terms and Conditions.

Click here to view Training T & C’s.

Got questions or feeling a bit lost in Excel, Word or Teams?

Don’t worry – we’ve got you! Reach out and we’ll help you find the perfect Microsoft training for you and your team.

Follow us and stay up to date with the latest training journeys, business solutions and powerful automation tools.

Microsoft Outlook Training    Microsoft Outlook Training

Data4Every1