Webinars
Refine Search
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..
Excel - Pivot Tables - The Key To Modern Data Analysis and Reporting
Whether you need to build an Excel-based dashboard, perform some serious data analysis, or simply summarize data for a personal project, Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) toolkit.With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build the reports, dashboards and charts that help you to summarize..
Excel - Power Pivot - Take Your Pivot Tables to the Next Level
Power Pivot removes many of the limitations and frustrations that users find with creating Pivot Tables in Excel. For example, using Power Pivot you can.Create Pivot Tables from multiple lists/tables without the need to combine them into a single list first (goodbye LOOKUP and all the issues that it brings)Create Pivot Tables from large datasets without worrying about file size, performance, or needing more..
Excel Formulas and Functions
More and more, your company is asking you to do some things with Excel spreadsheets that may leave you challenged or even overwhelmed.Maybe someone else worked on a spreadsheet, and then they moved on, and now you are in charge of that spreadsheet.That is called inheriting a spreadsheet. That is what it is actually called. But inheriting a spreadsheet is not as fun as inheriting a million dollars.Maybe ther..
Excel Shortcuts
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 – Quick Tips to Help You be More Productive
Few people learn or use Excel for fun. In fact, many people see it as a necessary evil. So if you have to use it, why not learn to use it faster and more effectively? How often have you found yourself in Excel thinking, “There must be a better and faster way to do this?”In this session, you’ll learn a handful of powerful productivity-boosting tips and secrets that will speed up your work in Excel, save you ..
Excel-10 Must-Know Functions to Boost Your Productivity
Microsoft Excel contains almost 500 built-in worksheet functions. Strip away the ones nobody uses. Discount the ones that have a specialized use-case and you’re left with a small set of functions that all Excel users should know, regardless of their job function, industry or business sector. This webinar covers ten of Excel’s most popular productivity-boosting functions.Areas coveredIF: Automate data entry,..
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..
Expat And Inpat Payroll Processing
Details of payroll tax policies for international assignments from understanding details of tax equalization and tax protection to understanding how to calculate hypothetical tax. Review of accounting concepts and best practices. Will also have a review of international visas and the payroll requirements over each Visa.Areas Covered Concepts on how to handle tax for international assignme..
Fail Forward
Life is a series of actions, in some we succeed and in some we fail. There is no guarantee of the result in any of the actions that we take. We act today in hope that its result will give us a better future. But sometimes, that is not the case. It doesn't mean that we stop aspiring for a better future! Failure was not our destination and we should never allow it to become one.We were all born as very resour..
Fair Hearings from A Hearing Officer’s Perspective
It sometimes becomes necessary for the medical staff to recommend to the governing board that the medical privileges of a practitioner either be removed or denied. Before such an adverse action is taken, it is very important that the practitioner is afforded due process. That requires planning. It is extremely important to set the stage properly. This session will provide the perspec..
Fair Lending Compliance - An Overview of and What It Means for Your Financial Institution
Failing to follow the fair lending compliance regulations can result in civil money penalties, restrictions on branching and significant reputational damage for an institution. During this webinar, we will go through each of the regulations that fall under Fair Lending and take look at the latest developments in regulatory compliance.Areas Covered Overview of Fair LendingIllegal Discrimina..