Other Trainings
Excel ChatGPT PivotTables Advanced Data Management Functions and Much More
Harness the awesome power of AI to take Excel to a new level and boost your efficiency working smarter and faster.Mastering AI is now 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.Understanding the correct setup, options, question formats, capabilitie..
Excel Formulas and Functions
More and more, your company is asking you to do some things with Excel spreadsheets that may leave you challenged or even overwhelmed.Maybe someone else worked on a spreadsheet, and then they moved on, and now you are in charge of that spreadsheet.That is called inheriting a spreadsheet. That is what it is actually called. But inheriting a spreadsheet is not as fun as inheriting a million dollars.Maybe ther..
Excel Power Query Data Cleaning Basics
In today’s data-driven landscape, mastering the art of data cleaning and preparation is critical. The "Excel Power Query Data Cleaning Basics" webinar is a pivotal resource for anyone looking to harness Excel's Power Query for advanced data management. This session goes beyond introducing Power Query’s features, aiming to arm participants with practical skills to revolutionize data analysis and enhance thei..
Excel Shortcuts
This course will show you many ways to be more efficient in Microsoft Excel.Areas CoveredKeyboard ShortcutsFormatted TablesCreate a quick data Entry formVlookupSort / FilterSubtotalsIntro to Pivot tablesWho Should Attend Business owners CEO’s / CFO’s / CTO’sManagers of all levelsAnybody who uses Excel on a regular basis, and want to be more efficient and productiveAdministratorsSalespeople..
Excel – Build Even More Powerful Pivot Tables: DAX Essentials
In today's data-driven world, having a strong command of Excel is essential, and understanding the Data Analysis Expressions (DAX) formula language is the key to unlocking the true potential of Excel's Power Pivot and Data Model features. This session is for intermediate Excel users who are already familiar with Pivot Tables, Power Pivot, and the Data Model but are hungry for more. We will delve deep into D..
Excel – Mastering Logic Functions
Have you ever needed to Automate entering different values into a cell depending on a certain criterion?Count the number of times a word, number or date appears in a range (and keep it current)?Add up a set of numbers that match a criterionReplace the ugly #NA or #DIV/0 with something more aesthetically pleasing?These are just some of the things that you can do using Excel's built-in Logic functions.Areas C..
Excel – Quick Tips to Help You be More Productive
Few people learn or use Excel for fun. In fact, many people see it as a necessary evil. So if you have to use it, why not learn to use it faster and more effectively? How often have you found yourself in Excel thinking, “There must be a better and faster way to do this?”In this session, you’ll learn a handful of powerful productivity-boosting tips and secrets that will speed up your work in Excel, save you ..
Excel: Data Visualization Crash Course
How data is presented can affect decision-making, and “Yes” it is your responsibility to present data in the best manner possible. Q: Are you serious about your data… or are you decorating? A: Find out in this webinar. This course will introduce the theory of looking at data with a new eye and mindset. It challenges the old-fashioned styles and rules. Data presentation will no longer look drab or regular, b..
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..
Excel: Useful Formulas
Excel Formulas and Functions are different from each other in one way: by who designs them. Formulas are created by you, the end-user, whereas Functions are pre-designed by Microsoft Excel programmers. This class is designed to remove the mystery from the language, or syntax, of the formula process. You will view multiple functions and their 2 separate help boxes. You will also see how to reverse-engineer e..
Five Steps to Becoming Comfortable in Emotionally Charged Moments
This webinar delves into how and why the brain and central nervous system respond in emotionally charged moments. According to the CDC, 85% of your thought and behavior patterns were in place by the time you were seven years old. Think about that for a moment. This webinar is intended to build understanding of the natural reactions and responses that are driven by the oldest part of your brain. As you learn..
Formulas Automatic Calculation and Key Functions in Excel
To work efficiently with formulas and functions, you must start with a clear understanding, good habits, and application of correct structure and syntax.Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel at introductory level.This course effectively demonstrates and teaches examples of formulas and specific functions, providing the perspective you nee..
I Didn’t Know Excel Could Do That!
This Webinar describes, Keyboard Shortcuts: Learn and use keyboard shortcuts to perform common tasks quickly. For example, Ctrl+C for copy, Ctrl+V for paste, Ctrl+Z for undo, etc.Flash Fill: This feature helps you automatically fill values in a column based on patterns you establish. It's great for cleaning and formatting data quickly.AutoSum: Use the AutoSum function (Alt + =) to quickly sum a range o..
Intelligent Strategies to Use AI in Writing: How to Make the Most of AI-writing Tools While Safeguarding Authenticity
AI-writing tools, such as Bard and ChatGPT have gained terrain at speed, and many professionals from communicators to trainers to entrepreneurs are using them to share their thoughts in writing easier and faster than ever before. However, they are also confronted with fears of mistakes, as these tools don’t have checked sources and can’t think critically. Another worry is losing their unique and authentic t..
Intermediate Functions, Lookups and Linking In Ms Excel
To work efficiently with formulas and functions you must start with clear understanding, good habits, and application of correct structure and syntax.This webinar effectively demonstrates and teaches examples of formulas and specific functions, providing the perspective you need to understand the depth and scope of these Excel features. Gaining this knowledge is a fundamental and highly marketable skill set..