Building Computer Skills to Enable Success
Building Computer Skills to Enable Success
Microsoft Excel Data Analysis
What Your Team Will Learn
Ready for your team to unleash the true analytical power of Excel? Welcome to our “Microsoft Excel Data Analysis” course, where we’ll transform your staff from formula users into data analytics specialists! Get ready for your group to master Excel’s most powerful analytical tools and turn complex data challenges into actionable insights.
In this power-packed day of learning, we’ll take your team from competent Excel users to confident data analysis experts. This course is ideal for staff who are already comfortable with Excel but ready to dive into advanced analysis techniques and powerful automation tools.
Your group will learn to harness features like Goal Seek, Scenario Manager, and advanced array formulas to model and analyse data like never before. By the end of the day, they’ll be confidently building dynamic range names, creating sophisticated validation rules, and using powerful What-If analysis tools to explore multiple business scenarios. Plus, your staff will master advanced functions that automatically handle errors and exceptions, ensuring their analyses are both robust and professional!
What You'll Get With This Course
Live Instructor-Led Training
Highly experienced and approachable trainers
Comprehensive Materials
eCertificate of Completion
Proudly recognise your achievement
Lifetime Support
Expert help, always within reach
Skill Level: Advanced
Duration: 1 Day
Time: 9:00am – 4:00pm
CPD Hours: 6hrs
Microsoft Excel Data Analysis Course Content
Working with Range Names
- Naming Ranges
- Navigating with Range Names
- Using Range Names in Formulas
- Modifying Range Names
Preparing your Data
- Working with Raw Data
- Converting Lists to Tables
Working with Arrays
- Creating Arrays
- Modifying Arrays
- Trend Functions
- Other Array Functions
Using SumIF and CountIF
- Setting up SumIF Functions
- Creating CountIF Functions
What If Analysis
- Goal Seek
- Data Tables
- Scenario Manager
- Solver
Using IFError
- Uses for the IFError Function
- Applying the IFError Function
Validating Data
- About Data Validation
- Setting up Validation Rules
- Input Messages
- Error Alerts
*Our outlines are a guide to the content covered in a typical class.
We may change the course topics to meet the objectives of a particular class.
Want to run this course for your staff?
Standard course ready to go — customisation available if your team needs it.
Our Clients
FAQ's
We know team training comes with a lot of questions, who, what, how many, when, where, and sometimes even why. To save you a few clicks (and a few minutes), we’ve pulled together the most common ones we get from other HR managers, L&D teams, and people just like you.
Where can this Microsoft Excel Data Analysis training be delivered?
We can deliver this training in whichever way suits your organisation best. If you prefer a traditional classroom style, we’ll come to your workplace and run the session face to face. If your team is spread out, we can deliver it online with live facilitation, ensuring everyone can participate no matter their location. A hybrid approach is also available, with some staff in the room and others logging in virtually. The flexibility means we can make learning accessible without disrupting your normal operations.
How many staff can attend a Microsoft Excel Data Analysis training session?
Data analysis is best learned in smaller to medium-sized groups, so that participants can ask questions and receive individual guidance. We’ll recommend an ideal group size depending on your needs, but we can adjust to accommodate your team. The focus is on making sure everyone has time to practise and build confidence in applying the tools.
Can we schedule the Microsoft Excel Data Analysis training at a time that suits us?
Yes, scheduling is completely flexible. We can deliver a full day to cover analysis tools in depth or break it into shorter sessions spread across several days to reduce disruption. Our aim is to make sure training fits around your work priorities while still giving participants time to absorb and practise what they learn.
What will my team be able to do after the Microsoft Excel Data Analysis course?
By the end of this course, participants will know how to prepare, organise, and analyse data using Excel’s built-in tools. They’ll be able to work confidently with features such as range names, advanced functions including SumIF and CountIF, and Data Validation. They’ll also learn how to use analysis tools like Goal Seek and the Scenario Manager to present their findings effectively. This combination of skills helps them turn raw data into insights that can support better decision-making in your business.
Do participants need any prior knowledge of Microsoft Excel Data Analysis?
Yes. Learners should already be confident with intermediate-level Excel skills, such as basic formulas, functions, and formatting. This foundation ensures they can follow along comfortably as we introduce more advanced analysis features. If your team is completely new to Excel, we recommend starting with the Introduction or Intermediate courses first.
Can the Microsoft Excel Data Analysis training content be customised to our needs?
Definitely. If your organisation regularly works with specific data sets, we can build examples and exercises around them. This makes the training directly relevant and ensures staff see how the tools apply to their day-to-day tasks. Customisation helps learners immediately transfer their new skills into workplace practice.
Will staff receive a certificate of completion?
Yes, all attendees will receive a certificate of completion. This is a formal record of their new skills, which can be kept in HR files or shared on LinkedIn. It’s a clear way to recognise their professional growth and highlight your organisation’s investment in staff development.
Do you provide support after the Microsoft Excel Data Analysis training?
Yes, lifetime support is included. If participants face challenges weeks or even months later, they can email us for help with specific analysis tasks. This ongoing support ensures that your team continues to benefit from the training long after the session ends.
Get your team members to try our short, anonymous Microsoft Excel Data Analysis skills test.
You’ll discover your true proficiency level in minutes, no registration required
Prior Knowledge
This focused course is designed for users who have a good working knowledge of Microsoft Excel. You should be comfortable with creating worksheets and using basic formulas. This course is ideal for those who work with data and want to learn effective techniques for analysing, summarising, and presenting data insights.
Required Software
You will need Microsoft Excel installed on your computer to participate in this course. This can be through a Microsoft 365 subscription or a perpetual license version.
Course Materials
All exercise files needed for the course will be provided. In some cases, you may receive them by email prior to the training so you can download them in advance. Otherwise, everything will be supplied during the session, and no preparation is required.
Note About Different Versions
While this course uses the latest version of Microsoft Excel, the Data Analysis skills learned are transferable to recent versions. However, for the best learning experience and access to all features covered in the course, we recommend using the latest version of Microsoft Excel.
Brendon Farrell
Co-Founder / Facilitator
From my early days wrestling with DOS commands to navigating today’s cloud-based world, I’ve dedicated my career to demystifying technology for others.
As a certified Microsoft and eLearning specialist, there’s nothing I enjoy more than seeing that spark of understanding when a student masters a new skill.
Outside of the training room, my passions run deep, whether I’m spending quality time with my wife and son, sharing my four decade love of lacrosse with junior players as their coach, or cycling around Melbourne’s on either my road bike or mountain bike.
Mark Finney
Co-Founder / Facilitator
With a coffee in hand and a passion for problem solving in my heart, I’ve made it my mission to turn tech frustrations into success stories. Through years of hands-on experience, I understand the challenges learners face.
Being both a co-founder and trainer at Keystroke Learning lets me combine my love for teaching with creating innovative learning solutions that actually work in the real world.
When I step away from the keyboard, find me strumming my favorite tunes on guitar, relaxing with my wife watching movies on the couch, or tending to my garden.