Other Trainings
Excel - Power Pivot - Take Your Pivot Tables to the Next Level
Power Pivot removes many of the limitations and frustrations that users find with creating Pivot Tables in Excel. For example, using Power Pivot you can.Create Pivot Tables from multiple lists/tables without the need to combine them into a single list first (goodbye LOOKUP and all the issues that it brings)Create Pivot Tables from large datasets without worrying about file size, performance, or needing more..
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 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 – 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..
How to Write Better Emails
Emails are a core business communication tool. The speed and volume of email have dramatically changed the business communication. The not-so-old standards for professional correspondence have changed and will continue to do so. Employees need to know the best strategies to communicate effectively. An effective business email is easily understood, but it is not so easily written.We have all received p..
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..