Other Trainings
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..
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..
Excel Lookup Essentials Setup Data Cleanse And Formula Auditing
In this “easy-learn” webinar, Ray Evans clearly demonstrates the essentials of VLOOKUP and HLOOKUP setup, structure, and options, and how this knowledge can significantly save time, preserve accuracy, highlight errors, and boost productivity.Lookup functions can match, retrieve, and merge data between tables with exact and range matches using absolutes and named ranges.VLOOKUP is an Excel function that look..
Power BI - Data Cleaning and Transformation - From Raw and Poor to Report-Ready Overview
It's a known fact that raw data loaded into Power BI is hardly ever "report-ready" and requires "cleaning" to make it useable.Unnecessary rows and columns need to be removed, data that isn't required needs to be filtered out, dates are never in the correct format and often aren't even dates, columns require splitting or merging, and "weird" characters must be removed. These are just a few examples of what i..
Intro to ChatGPT for Excel Users
Artificial intelligence (AI) is transforming the way we approach data management and analysis, and this transformation is now reaching Excel, a tool used by millions of professionals worldwide. With the rise of AI-powered tools like OpenAI's ChatGPT, Excel users can now automate repetitive tasks, solve complex problems, and unlock new efficiencies in their workflows. This webinar is designed to introduce yo..
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..
DeepSeek for PowerPoint Essentials Made Easy
NOTE: A customized practical PowerPoint 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 PowerPoint and is vital in a wide range of professions and fields including public service, banking, accounting, financial analysis, and business administration.Pos..
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..
Take a Deep Dive into Little Known Microsoft Outlook Features with HUGE Productivity Benefits
Microsoft Outlook is a powerful, comprehensive software tool because it combines email, a calendar, and tasks. The goal is to make your professional life more productive and fulfilling as you gain the ability to get more done in less time. You will conquer your task list in record time as you learn advanced Outlook techniques and how to: Use the features in the expanded ribbon in these Outlook folders: Mail..
Managing Team Workflow with Microsoft Outlook
No doubt you and your team are proficient at using Microsoft Outlook for email and meetings, but did you know you and your team are leaving about 85% of the power of Microsoft Outlook unused. Outlook is a powerful program that can simulate a programming language if you know how to use it. This webinar helps individuals customize Outlook for their personality and their job. It helps you manage those who repo..
Excel Lookups XLookup Linking Named Ranges and Error Suppression
Going “beyond the basics” Ray Evans clearly demonstrates, features and functionality that enhance the power and flexibility of lookup functions at intermediate level.In this “easy-learn” webinar expand your understanding of lookup functionalities and options further enhancing your productivity and data presentation.Lookup functions can match, retrieve and merge data between tables with exact and range match..
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..
AI to improve MS Excel
Data Entry and Cleaning: AI can automate the process of entering data into Excel, reducing manual effort and the risk of errors. It also assists in cleaning data by identifying and correcting inconsistencies, duplicates, or missing values. Complex Calculations: AI can handle complex calculations and data manipulations that would be time-consuming and prone to error if done manually.Pattern Recognition: AI e..
Are You Kidding Me?: Communication Tricks for Sticky Situations
This webinar is for you if you ever find yourself in a difficult emotional situation where a cool head is necessary.This session will include a discussion of how the brain and central nervous system react in difficult situations to help participants understand the natural responses driven by these parts of the body. As you learn some of the very basic information built into your human DNA, you will begin ta..