Excel is an incredibly powerful tool, essential for a wide range of business and personal tasks. However, its many features can be overwhelming, especially for beginners. To help you determine which level of Excel course is right for you, we’ve detailed the content of our Beginner, Intermediate, and Advanced courses. This guide will help you choose the course that best fits your current skill level and learning goals.
Beginner Excel Course
The Beginner Excel course is perfect for those who are new to Excel or have only a basic understanding of the software. This course starts with the fundamentals, including an introduction to the anatomy of a spreadsheet. You’ll learn how to navigate and customise the Quick Access Toolbar, use essential keyboard shortcuts, and find commands and help options. The course also covers basic data entry techniques like Flash Fill and creating custom lists.
As you progress, you’ll delve into formatting and aligning numbers and cells, including applying number formats, using the Format Painter, and managing worksheet themes. The course also introduces you to basic formulas and functions, such as SUM, COUNT, and AVERAGE, and teaches the difference between absolute and relative referencing. You’ll get hands-on experience with named ranges, Excel tables, and sorting and filtering lists. By the end of the course, you’ll have a solid foundation in Excel, including basic chart creation, conditional formatting, and inserting pictures and annotations. You’ll also learn how to prepare your spreadsheets for printing and protect your workbooks, ensuring your data is well-presented and secure.
Intermediate Excel Course
If you’re comfortable with the basics of Excel and want to enhance your skills further, the Intermediate Excel course is ideal. This course focuses on improving spreadsheet design and introducing more complex functions and tools. You’ll start by learning how to improve readability with cell styles and control data input using data validation. The course covers logical functions like IF, AND, OR, and nested IF statements, helping you make better decisions with your data. You’ll also explore error handling and using logical functions with conditional formatting.
Advanced lookup formulas, including VLOOKUP, HLOOKUP, INDEX, and MATCH, are thoroughly covered. You’ll learn how to handle duplicates, use statistical functions, and apply custom formatting. The course also includes detailed lessons on date and time functions, text manipulation, and importing and cleaning data with Power Query. You’ll gain proficiency in creating and managing PivotTables and Pivot Charts, adding interactivity with slicers, and performing formula auditing. Additionally, the course introduces what-if analysis tools, including Goal Seek and Scenario Manager, allowing you to perform complex data analysis and forecasting.
Advanced Excel Course
For those who are already proficient in Excel and want to master its advanced features, the Advanced Excel course is the way to go. This course dives into dynamic arrays, teaching you how to use functions like UNIQUE, SORT, SEQUENCE, and FILTER to manipulate large datasets efficiently. You’ll learn advanced lookup and reference functions, including complex criteria lookups and using OFFSET and INDIRECT functions.
Creating custom functions with LET and LAMBDA functions is covered, allowing you to streamline repetitive tasks and calculations. The course offers extensive training on Power Query, enabling you to import, transform, and load data seamlessly. You’ll also learn advanced PivotTable and Pivot Chart techniques, including creating calculated fields and items, using GETPIVOTDATA, and adding dynamic elements to your charts.
Moreover, the course covers new dynamic array formulas, form controls, and checkboxes, enhancing your ability to create interactive spreadsheets. You’ll get hands-on experience with macros and VBA, from recording and running macros to writing and debugging VBA code. Lastly, the course introduces AI tools like Microsoft Copilot, showing you how to leverage AI for generating datasets, formulas, and even VBA code, taking your Excel skills to the next level.
Choosing the right Excel course depends on your current knowledge and what you aim to achieve. Whether you're a beginner looking to understand the basics, an intermediate user wanting to enhance your skills, or an advanced user seeking to master Excel's most powerful features, there’s a course tailored for you. Enrol today to unlock the full potential of Excel and boost your productivity and data management capabilities.
Inhouse Tailored Training for Your Team
We provide training programs that are developed by industry, for industry. Our range of programs can be delivered in a way that suits the needs of your business to offer your employees learning that is accessible and flexible.
We add value to your business by providing specialised, flexible and scalable training that meets your training needs. As your workforce grows and evolves, our globally certified and industry-validated learning solutions can assess, train and qualify your employees. For more information on how we can help please visit the in-house training page.
Membership, Stay Connected. Stay Relevant.
Completing a program is a point-in-time exercise that delivers huge value, but there is a next step to maintaining the currency of your skills in the ever-evolving professional world.
Membership is the next step.
A unique platform, membership is designed to ensure that you are in tune and up-to-date with the latest tools, trends and developments. Being a member provides just-in-time training and continuous professional development, and an exclusive and evolving content library informed by subject matter experts and industry leaders.
