When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Microsoft Excel - The Ultimate Excel Course from ZandaX
FOUR COURSE Training Pack: Learn Excel from Beginners to Professional in Easy Steps, with course workbooks & exercises

This Course Includes
udemy
4.3 (36 reviews )
12h 3m
english
Online - Self Paced
professional certificate
Udemy
About Microsoft Excel - The Ultimate Excel Course from ZandaX
Whether you’re a brand new Excel user who wants to go from the basics to the highest level you can manage, or an existing user who’d like a combined “best practice” refresher, skills enhancer and a reference for the future, this is the choice for you!
With every ZandaX Microsoft course
, you get a workbook and exercises (downloadable from the “General Introduction” module at the start of each course).
These are NOT
"follow along" exercises to use during the course, but new exercises you can use afterwards to practice the skills using different examples. People tell us this is a better way to learn because it provides an opportunity to work with new data. Our
Microsoft instructors are seasoned professionals
- they don't just know the software: they've used it commercially and taught it in a classroom environment for years. You won't be in better hands!
And we don’t waffle!
Do you want to sit through hours of over-explaining before you get the knowledge you need? We doubt it! So we make sure that everything is covered in easy-to-follow video lessons, and we get to the point so you make the best use of your time. The
Introduction
course takes you from the very basics in opening and saving workbooks, using the different tabs, working with data and editing data, formatting sheets, reviewing workbooks and creating charts. The
Intermediate
course starts with file management, encryption and accessibility, before moving on to functions and formulas. It teaches you about using tables, data tools like validation, before moving on to more advanced charts and finishing with SparkLines. The
Advanced
course really does take you to another level. It begins with grouping, outlining and subtotals before showing you how to perform What If Analysis, use PivotTables, perform advanced tasks before teaching you about HLOOKUP and VLOOKUP functions. If that wasn’t enough, it finishes with one of out most popular lectures: an introduction to Macros. Finally, in the
Professional
course you’ll learn about advanced ways of using conditional formatting, LOOKUPs, more functions and PivotTable tools. There’s a lecture on form controls and templates, and the final section introduces you to User Defined Functions (UDFs) using VBA. Each lecture is self-contained, so you don’t need to sit through them all: once you’re at a comfortable level, you’ll be able to use this as your reference library, where you can select what you want to view. We’ll say it again:
don’t forget the course workbooks and exercises
– downloadable with the first “General Introduction” module at the start of each course – which really enhance and deepen your learning. Remember that practice makes perfect! So although this is offered as a single course, it’s genuinely
four courses in one
– there are no shortcuts or reduced features. We don’t think you’ll find better value, so why not stop wondering which course to choose, and enroll with us now!
What You Will Learn?
- FOUR courses - Introduction to Professional - with everything you need to take you from a complete beginner to a professional Excel user .
- Each course has its own workbook with separate practice exercises –download from the “Introduction” module – which you can use to practice what you have learned .
- This great four-course pack covers everything from getting to know the interface, through functions & formulas to LOOKUPs, PivotTables & VBA. Click to see more! .
- The INTRODUCTION course covers: Workbook Basics - the Excel Interface - Editing Tools - Formatting - Printing/Viewing - Working with Charts .
- The INTERMEDIATE course covers: Advanced File Tasks - Functions & Formulas - Tables - Data Tools - More About Charts - Sparklines .
- The ADVANCED course covers: Grouping & Outlining and Subtotals - WhatIf - Pivot Tables - Charting Pivots - LOOKUPs - Introduction to Macros .
- The PROFESSIONAL course: Advanced Conditional Formatting - Form Controls & Templates - Array Formulas - Advanced LOOKUPs & Pivot Tables - User Defined Functions Show moreShow less.