Excel Training
Excel - Power Query for the Everyday Excel User
This is a follow-on session to "Excel - Power Query for the Everyday Excel User - Part 1" and covers the key advanced features of Excel’s Query Editor, designed to help you transform imported data quickly and without having to learn to code. The focus of this training is on how to create additional columns without complex formulas and how to combine, merge and unpivot unusable data to make it report-ready.A..
Email and Calendar Essentials with Power-User Skills in Outlook
This course effectively demonstrates and teaches the key elements of Outlook from introductory to beyond the basics, including power-user techniques, shortcuts, tips and tricks. Microsoft Outlook is the powerhouse in managing email, appointments, tasks and contacts. It aims to provide the knowledge you need to understand and use the outstanding capabilities of this powerful application. The expert tuition a..
Excel: Useful Formulas
Excel Formulas and Functions are different from each other in 1way: 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 exis..
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..
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..
Excel: Power Query Crash Course
Power Query is a somewhat new feature, it first made its entrance in Excel 2010, and now is a standard part of Excel 2016 and 2019.Power Query is a tool designed for Excel to handle repetitious steps specifically tied to data prep. We all know the drudgery of removing columns, shifting rows, correcting data formats, all before we can actually do the work with the data!The old alternative was to use macros f..
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..
Understanding the Math of HR, So You Can Show How HR Impacts the Bottom-Line and Get a Raise!
Don has presented on HR-related topics to more than 6,000 CEOs. They tell him nobody has ever explained the math of HR to them the way he does. He’s also coached HR executives for many years. Strategic HR executives know their math, use it to make sound decisions and show the value they add. He will share with you a method you can use to educate your executive and management teams on the value of great HR.T..
Mastering Data and Information Management Essentials
Learn the powerful fundamentals of managing data and efficient techniques to transform data into valuable information for business decision making.Skills to effectively manage, present and communicate data are now vital in the competitive financial and business analysis fields and offer vast opportunities to expand accounting client services and career paths.Microsoft Excel offers powerful ‘market-leading’ ..
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..
Mastering Excel Fundamentals Through to Intermediate Level
You can use Excel for basic tables, spreadsheets, calculations and charts through to powerful data management, PivotTables, professional graphs and automation of repetitive tasks. Confident skills in this most popular and powerful Microsoft application are becoming an essential requirement in banking, finance, business, government and education sectors. Gain a solid foundation to efficiently build your know..
Excel - Creating an Interactive Dashboard
No matter what business you are in, a dashboard is a critical tool in your communication armory 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, its flexibility, and the fact that most people have it installed on their computers. This training focuses on what you need to know to..
Power BI - Create Compelling Interactive Reports
Power BI is an application from Microsoft that turns your raw data (loaded in from a variety of sources) into stunning interactive visual reports, providing you with real-time insights into your data and enabling you to make better business decisions.Gone are the days of submitting a request to the IT Department and waiting for them to produce a less than perfect report. With Power BI you can create those r..
Linking Techniques in Depth in Excel
Linking between spreadsheets, workbooks and applications offers huge efficiencies, but needs clear understand to work accurately and avoid risks that linking can pose.Understand and apply the power of linking techniques within Excel and other key MS Office applications to boost productivity and efficiency for you and your organization. Object Linking and Embedding (OLE) makes content that is created in one ..
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, ..