Intermediate Microsoft Excel (Online)

Who is this qualification for?

Feel like your journey of discovery about Microsoft Excel has only just begun? Well, this course could be just right for you!  Designed to help you advance your skills, you'll have the opportunity to expand your knowledge and explore some of Excel's more useful features. It aims to give you further essential knowledge, skills and expertise to build practical, functional spreadsheets that aid your productivity both in the workplace and at home.  Let me help improve your Microsoft Excel capabilities and continue on your quest to be even more productive and proficient!

How long is this course?

This course is delivered over 7 weeks with each session lasting 2 hours.

How is the course delivered?

The course will be delivered on Microsoft Teams.  

What time will the course take place?

Between 10 am and 12 pm 

Which days will the sessions take place, and what will be covered?

• 22/01/2025 - Sesison 1 - Cell addressing essentials - absolute and relative; Calculating Percentages in Excel; Mathematical functions - COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS.
• 29/01/2025 - Session 2 - Introduction to Conditional Formatting; Working with Pre-set Conditional Formatting Options; Adding Data bars, colour Scales and Icons to spreadsheets; Creating your own Conditional Formatting rules
• 12/02/2025 - Session 3 - Introduction to Data Validation; Setting up rules, information messages and warnings; Combining Data Validation and Conditional Formatting
• 19/02/2025 -  Session 4 - If Statements - IF, AND, OR and IFS; Lookup Statements - VLOOKUP, XLOOKUP, INDEX and MATCH
• 26/02/2025 - Session 5 - Introduction to Pivot Tables; Preparing data for a Pivot Table; Creating and working with Pivot Tables
• 12/03/2025 - Session 6 - Adding Pivot Charts to Pivot Tables; Excel Tables in more detail; Creating a simple Data Dashboard with current skills
• 19/03/2025 - Session 7 - Data cleansing tools and functions; Summary activity to bring together all learning

How much will this course cost?

Price upon application, but for some delegates this course will be completely free of charge. Enquire today to check your eligibility! 

Use the reserve button today to register your interest in this course! It's completely free and there is no obligation to enrol on this course.