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..
Linking, Goalseek, Formula Auditing and Named Ranges in Excel
Understanding of Named Ranges, Goalseek, Linking and Formula Auditing provides a huge advantage in progressing to higher levels of mastering Excel.Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel at introductory to intermediate level.To work efficiently with formulas and functions you must start with clear understanding, good habits, and application..
Outlook - Master Your Mailbox - Inbox Hero Inbox Zero
For most business users (and many home users too), Microsoft Outlook has become the standard application for managing emails, calendar appointments and to-dos. With an abundance of features and versions for desktop and mobile, there’s really no excuse not to be organized. Or so the theory goes. With the average office worker receiving over 100 emails per day, the reality for most people is email overload, m..
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 tablesCourse Level- Beginner/ IntermediateWho 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..
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..
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 ..
Intermediate Functions, Lookups and Linking in Excel
To work efficiently with formulas and functions you must start with 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 beyond introductory level.This course effectively demonstrates and teaches examples of formulas and specific functions, providing the perspective you ne..
Mastering Excel Fundamentals Through to Intermediate Level
Microsoft Excel is the market leader in data tables, spreadsheets, calculations and charts through to powerful data management, Pivot Tables, professional graphs and automation of repetitive tasks.Confident skills in this most popular and powerful application are essential in banking, finance, business, government and education sectors.Gain a solid foundation to efficiently build your knowledge to work smar..
Excel - Automate Repetitive Tasks with Macros
A macro allows you to automate Excel, allowing you to spend more time on other things. So if you find yourself repeatedly performing the same actions or tasks in your spreadsheets, if you have a time-consuming Excel-based process that you want to automate, then it’s time to learn how to create macros.There are two ways to create a macro in Excel - the Macro Recorder and the Macro Editor and this session cov..
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..
Dynamic Array Functions
Microsoft recently came up with a slew of new functions, called dynamic arrays, in which one formula can generate values into several cells. This webinar explores these powerful functions as well as even more recent functions, like VSTACK, LET, CHOOSECOLS and many moreAreas Covered Dynamic Array formulas - RANDARRAY - SORT - SEQUENCE - FILTER - UNIQUE - SORTBYSpill Ranges#-nota..
Modern Excel Analyst - Learn What’s Possible When You Bring Microsoft Excel and Power BI Together
Our advanced training workshop on Excel and Power BI integration can help you streamline your finance processes and improve business efficiencies.This one-day hands-on workshop will show you how to use Power Query and Power Pivot in Excel to transform your existing manual reporting into actionable insights. You’ll learn how to create reusable and seamless solutions that can save you time and effort in the l..
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 - 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 - 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..