Excel Training
Excel - A Beginner’s Guide to Formulas
Think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula. In addition to building formulas, the session will introduce you to Functions which are built-in formulas that have been programmed to perform a specific calculation. They can often be used to shorten and simplify what would otherwise be a long-winded manually-entered formula.Are you n..
Lookup Functions, Formula Tracing and Named Ranges In Excel
When it comes to dynamically looking up and retrieving information from small or huge tables of data, Lookup functions can elevate you to a new world of accuracy, productivity and time savings in Excel.To work efficiently with lookup functions you must start with clear understanding, good habits, and application of correct structure and syntax.Gaining this knowledge is a fundamental and highly marketable sk..
Excel - Lists and Tables - A Beginner’s Guide to Managing List-Based Data
Often perceived as a mere number-crunching tool, Excel's true prowess lies in its capacity to organize and manage list-based data efficiently, and this training session is designed to unveil Excel's full potential beyond arithmetic computations. Whether you're dealing with employee rosters, inventories, course catalogues, or any other list-based information, Excel offers an impressive suite of features that..
Predictive Analytics with Python in Excel
The topic of predictive analytics in Python within Excel represents a significant step forward for professionals seeking to enhance their data analysis capabilities. Excel has long been a staple in data analysis due to its accessibility and versatility. However, as data becomes more complex and the need for deeper insights increases, Excel’s built-in tools can fall short when it comes to handling advanced s..
Mastering Lookup Functions Error Suppression And Xlookup In Excel
VLOOKUP, HLOOKUP, and XLOOKUP are some of the most well-known (and most useful) formulas in Excel. Used properly, they will help you to improve the accuracy and integrity of your Excel workbooks save time, work smarter, and boost your efficiency and productivity.Learning ObjectivesTo gain a practical “hands-on” understanding of key Lookup functions in MS Excel.Areas CoveredVlookup - Range Lookup Table with ..
Excel - Beyond the Bar Chart - Data Visualization and Data Story Telling Techniques
Revolutionize the way you communicate data with this cutting-edge training on Excel visual storytelling. Discover the power of visual data representation to transform complex numerical information into compelling, insightful visual narratives.The era of simple bar and pie charts has moved on. Today's data-driven environment demands more dynamic visualizations and infographics. Our session will guide you thr..
Lookup Functions, Formula Tracing and Named Ranges in Excel
When it comes to dynamically looking up and retrieving information from small or huge tables of data Lookup functions can elevate you to a new world of accuracy, productivity and time savings in Excel.To work efficiently with lookup functions, you must start with a clear understanding, good habits, and application of correct structure and syntax.This course effectively teaches lookup techniques and demonstr..
Excel Pivot Tables
In today’s world, there are tons of data to manage. Data is coming from many different sources. It is very important to be able to process that data quickly and then summarize it into meaningful information. Many companies have reduced their IT staff, so more and more, it is up to each person to deal with all of this data. This webinar will show you how to take large amounts of data from many sources and pr..
Excel: Unleash the Power of Smart Formulas
A Webinar session on Excel's powerful formulas provides a structured and interactive learning experience designed to enhance participants' efficiency and confidence in working with data. The session begins with a brief introduction, where the instructor outlines the objectives, emphasizing the importance of mastering formulas for automating tasks, analyzing data, and solving real-world problems. The first p..
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 using 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 manipulat..
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..
Excel Meets AI - How Microsoft Copilot Can Save You Time
This training is designed to revolutionize the way you work with Excel. Copilot is an AI-powered tool that enhances your Excel experience by automating complex tasks, providing intelligent suggestions, and improving overall efficiency. Whether you’re dealing with large datasets, creating intricate formulas, or simply trying to streamline your daily workflow, Copilot is here to help. This training will not o..
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 ..