Excel Training
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..
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..
Leave Work On Time With Microsoft Outlook
This webinar is for individuals working in Outlook 2013, 2016, or 2019. If you want to catapult your career in addition to leaving work on time, sign up for this webinar. You will benefit professionally as you use Microsoft Outlook features to:Finish projects on timeRemember all assignmentsNever miss a deadlineNever miss a meetingYou will be recognized for your individual responsibility and accountability, ..
Linking, Goalseek, Formula Auditing and Named Ranges In Ms 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..
Mastering Chart and Graph Essentials in Excel
Imagine impressing your team, executives and clients with your new skills, presenting data visually in engaging professional charts!Effective charting is a strongly “in-demand” and valuable skill to possess in the government, private and education sectors.Charts (graphs) can present information for decision makers and researchers in appealing presentations, making it easier to interpret data.A visually-orie..
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..
Now that I’ve Got Them, How Do I Keep Them?
Employee Turnover is an expensive problem. Coupled with the difficulty in hiring, turnover is putting additional pressure on existing employees and managers. It limits growth opportunities, causes stress, morale problems, customer dissatisfaction, and brand damage.Compensation challenges, the demand for job flexibility, an unwillingness to “come to work”, cost of living, and other factors are driving the tu..
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..
Pivot Table Essentials for Data Analytics in Excel
PivotTables are considered by many to be the most powerful data analysis feature in Excel, combining the ability to sort, filter, subtotal, calculate and chart data in minutes.A PivotTable displays a summary of a selected data set in a condensed format of rows, columns, data fields and pages. These components can be “pivoted” with your mouse allowing you to expand, isolate, calculate, and group the particul..
Power BI
In today's busy world, we are sometimes overwhelmed with huge amounts of data, sometimes that data can come from more than one table, or even more than 1 data source. Trying to make sense of this data can be an overwhelming task.Microsoft Power BI will allow to use to pull in all of your data , and then create great reports and dashboards from that data. This course will show you how to connect your data fr..