Excel Training
Excel – Reporting Simplified – Learn Pivot Tables from Scratch
Unlock the power of Excel's data analysis and Business Intelligence (BI) toolkit with Pivot Tables. Whether you're aiming to construct dynamic dashboards, conduct in-depth data analysis, or simply streamline data summaries for personal or business purposes, Pivot Tables are your key to success.In just a few clicks, without the need for complex formulas, you can effortlessly generate insightful reports, dyna..
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..
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..
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 ..
Comprehensive Review Excel Charts
The first part will familiarize you with most of the Excel charts’ gallery. The idea is to understand where, when, and how to use these Excel charts. The second part is to understand Chart Terminology, Elements, and Styles – how to use them and modify the charts with them. At this point, you will be comfortable creating and manipulating any of the Excel charts.The next part enables you to take any “predicta..
Crazy Chaos In Your Inbox? Calm The Chaos Today!
Studies show most people spend about 50% of their work time writing and answering emails, substantiating the fact that email is an indispensable part of the workday. Processing email can be tedious, boring, and often mind-numbing yet writing and responding to emails with speed and acumen is pivotal to your success.In this day we spend together, you will learn how to:Survive the email avalanche that dumps in..
Excel - Automate Repetitive Tasks with Macros
Imagine the thrill of automating those repetitive Excel tasks that have been draining your productivity. Picture the convenience of effortlessly streamlining complex processes, leaving you with more time to focus on what truly matters. Now, consider the positive impact you can have on your team and clients by offering streamlined, error-free solutions.Excel macros are powerful tools that can transform your ..
Excel - Automation Beyond the Macro Recorder - VBA 101
VBA is Microsoft’s programming and automation language that is built into all the MS Office applications. Although Excel’s Macro Recorder allows you to automate a task by recording a series of keystrokes and mouse clicks, that’s where its functionality and power ends. To be able to do anything more, you need to harness the power of VBA.VBA is a fully-featured programming language that includes functionality..
Excel - Creating an Interactive Dashboard
No matter what business you are in, a dashboard is a critical tool in your communication armoury and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, Excel is commonly used due to its power, it’s flexibility and the fact that most people have it installed on their computer. This training focuses on what you need to know to crea..
Excel - Effective Data Visualization Without Charts
Data visualization is the representation of numerical data in a visual format so that your audience can quickly and easily understand it and gain insight from it. Until a few years ago it was enough to take a set of numbers and create a bar chart or pie chart. Although in the right situation these traditional charts are still appropriate, things have moved on and we're constantly hearing words like data vis..