Excel Training
Time Series Analysis with Python in Excel
Time series analysis is crucial for forecasting trends and making data-driven decisions. While Excel is widely used for this, its limitations in handling advanced analytics and visualizations can hold you back. Python’s powerful libraries like Pandas, Matplotlib, and Seaborn provide the tools to elevate your analyses, offering more flexibility and deeper insights.This webinar will show you how to integrate ..
Excel ChatGPT MasterClass 4 – Gain the Competitive Advantage
A customised practical Excel WorkSheet example is provided in sequence for each question posed to ChatGPT for demonstration and “hands-on” practice by attendees. Explore the power of the fully paid version of ChatGPT, uploading a file for analysis, and posing an extended number of questions. Pose questions verbally and hear responses verbally.Understand the dynamic nature of ChatGPT and how it continually “..
Mastering the Fill Handle and Flash Fill in Excel
Microsoft Excel’s Fill Handle and Flash Fill are powerful tools that simplify data entry and manipulation, making them essential for anyone working with spreadsheets. These features are designed to save time, improve accuracy, and streamline workflows, particularly when dealing with large datasets or repetitive tasks. While they serve similar purposes of automating data entry, they work in different ways an..
SharePoint Basics: Getting Started with Libraries, Lists, and Sites
SharePoint is one of the most powerful tools in the Microsoft 365 ecosystem, designed to help businesses store, organize, and collaborate on documents seamlessly. However, many professionals find it overwhelming, struggling with confusing site structures, lost files, and unclear permissions.Without a proper understanding of SharePoint’s core features, teams often face:Disorganized file storage makes it hard..
Unlocking the Power of Data
Business decisions are easier to make when we are equipped with the relevant industry data. This webinar addresses the collection and usage of data for sales professionals, especially in the real estate industry.Areas CoveredTypes of data - Numerical vs character - Client data, product data, personal and company performance data, - Contextual data: for example, monthly ne..
Creating Measures and KPIs in Power Pivot
This webinar, "Creating Measures and KPIs in Power Pivot," is designed for professionals involved in data analytics, business intelligence, or financial reporting who use Excel’s Power Pivot. This session will provide in-depth knowledge on how to leverage Power Pivot’s full capabilities through the creation of DAX measures and Key Performance Indicators (KPIs), tools essential for sophisticated data manipul..
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 - Build Advanced Pivot Table Solutions Using the Data Model And PowerPivot
Whilst Pivot Tables offer valuable data summarization features, they also have several limitations. They struggle with handling large datasets, they lack the ability to combine data from multiple datasets, and the built-in calculation functionality is very simplistic.This training focuses on the Data Model and Power Pivot, two of Excel's hidden gems that help to overcome the built-in limitations. For exampl..
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 and is vital in a wide range of professions and fields, including public service, banking, accounting, financial analysis, and business administration.Pose questio..
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..
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..
Bringing your PowerPoint Presentation to Life
Even in today's online world, live, face-to-face presentations are still so crucial. That includes presentations of all types: training, sales, staff meetings, stock holder summaries, new company policies, church or organization meetings, fundraisers, etc. Microsoft PowerPoint is still the gold-standard of presentation tools. Because it comes with Microsoft Office and Office 365, most computers have access ..
Excel: Tools of The Trade
This webinar will raise your level of Excel competence and knowledge. In the 20+ years of training students in Excel classes, Andy has always included this set of skills to all levels of Excel users. It doesn’t matter how long you’ve been using Excel, you will probably learn something new, or at least get an idea of a new process by attending this webinar.You will learn how to skip through the spreadsheet t..