Excel Training
DeepSeek for Excel Essentials Made Easy
Mastering AI is now a fundamental and highly marketable skill set in Excel. It is vital in a wide range of professions and fields, including public service, banking, accounting, financial analysis, and business administration.Seize this crucial opportunity to advance ahead of your peers and competition significantly.Replicating the in-person classroom experience using a step-by-step guide, student files, an..
Excel - CUBE Functions - Where the Data Model Meets the Spreadsheet
Unlock the full potential of your data with the power of CUBE functions in Excel! This training session is designed to help you master one of Excel’s most advanced tools for integrating and analyzing data from the data model. From creating dynamic reports to accessing specific datasets with precision, CUBE functions enable deeper insights and greater flexibility in your reporting. Whether you're an Excel po..
DeepSeek for Excel Intermediate Masterclass 3 - Work Smarter and Faster
NOTE: A customized practical Excel example is provided with slides in sequence for each question posed to DeepSeek for demonstration and “hands-on” practice by attendees.Mastering DeepSeek is a fundamental and highly marketable skill set in Excel. It is vital in a wide range of professions and fields, including public service, banking, accounting, financial analysis, and business administration.Pose questio..
Visualizing Data with Python in Excel
Effective data visualization is crucial for making informed decisions. While Excel remains a cornerstone for data analysis, its native charting tools are limited when it comes to creating advanced and customized visualizations. If you’ve ever found yourself frustrated by Excel’s inability to handle complex plots or intricate chart designs, you’re not alone. But what if you could bring the power of Python’s ..
Excel Formatting Mastery: Transform Your Data for Maximum Impact
This webinar covers a comprehensive range of tools and techniques designed to enhance the appearance and functionality of your spreadsheets. It begins with the basics, such as applying fonts, colors, and borders to cells, ensuring that participants understand how to make their data visually appealing and easy to interpret. The session delves into alignment options, such as wrapping text, merging cells, and ..
Excel Mastery: Data Storytelling Without the Jargon
Excel Mastery for Non-Analysts" is a highly practical, interactive session crafted specifically for professionals who use Excel regularly but don't consider themselves "data people."In this session, we break down the intimidating world of data visualisation and dashboard creation into approachable steps that anyone can follow. The focus isn't on memorising formulas or becoming a spreadsheet wizard. It's abo..
Excel - Power Query – The Smart Way to Handle Data Cleaning and Transforming
Turn bad data into great data in minutes! Do you spend more time than is necessary importing and updating data from external sources such as databases, CSV files, and web pages?Does the phrase "it's taking too long" describe how you feel about the time it takes to get your data into the right format for your reports?Do you regularly perform repetitive, time-consuming "data cleaning and transforming" tasks s..
DeepSeek for Excel Intermediate Masterclass 4 - Gain the Competitive Advantage
NOTE: A customized practical Excel example is provided with slides in sequence for each question posed to DeepSeek for demonstration and “hands-on” practice by attendees.Mastering DeepSeek is a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including public service, banking, accounting, financial analysis, and business administration.Pose question..
Excel Essentials: Pivot Tables in One Hour: Quickly Summarize and Analyze your Data
This webinar is an in-depth session aimed at equipping participants with the skills to transform raw data into meaningful insights using one of Excel’s most powerful features. The session begins with an introduction to PivotTables, explaining their purpose and the types of problems they solve. Participants learn how to create a basic Pivot Table by selecting a dataset and choosing the fields to include. The..
Beyond the Basics: Do it right: Indexes, Tables of Figures, and Citations in MS Word
"Beyond the Basics: Mastering Indexes, Tables of Figures, and Citations in MS Word" is a practical training session aimed at professionals and academics who work with long documents and want to streamline their workflow.You’ll be introduced to under-used but powerful features in Word that allow for automated referencing and navigation. Rather than building everything manually, you’ll discover how to harness..
Word Smarts: Hidden Features That Will Save You Hours
This session is a fast-paced, practical look at Microsoft Word’s most underutilised time-saving features. You’ll learn to stop wrestling with Word and start using it as the productivity tool it was meant to be.We’ll explore smart navigation, reusable content tools, formatting consistency, and ways to lock down sections of your document, perfect for when multiple people need access. This is a “greatest hits”..
Beyond Bar Charts: Advanced Excel Charting Techniques for Business Insights
"Beyond Bar Charts" is a hands-on training session that takes your Excel charting skills from functional to fantastic. It’s not about knowing every menu option—it’s about using the right chart at the right time to deliver insights that matter.Participants will learn how to create combination charts (e.g., budget vs actual with bar and line), use dual axes without confusion, apply custom data labels, and int..
How to Create Clear, Impactful Visuals in Excel
This practical, interactive session teaches participants how to create high-impact visuals in Excel that do more than just look good—they communicate meaning.We’ll explore how to combine column and line charts, apply variance markers, and incorporate icons like traffic lights for visual alerts. You’ll also learn to use SmartArt and dynamic labels that adapt as your data changes. These techniques help your r..
Data to Dashboard: Smarter Charts, Smarter Decisions
"Data to Dashboard: Smarter Charts, Smarter Decisions" is a practical session focused on modernising how professionals use Excel to communicate insights.Rather than relying on complex tools or plugins, this webinar keeps it simple and accessible, teaching you how to create dashboards using tools already built into Excel. You’ll learn to use Sparklines for in-cell trends, icon sets to highlight highs and low..
Icon Sets, Conditional Formatting, and Next-Level Visual Tricks in Excel
This hands-on webinar dives into the practical use of Excel’s visual enhancement tools. You’ll learn how to combine icon sets, conditional formatting, and smart design to create visually rich reports that support fast, confident decisions.We'll explore how to embed alert-based visuals directly into tables and charts, making reports more interactive and engaging. You'll learn to use icons to signal performan..