On-Demand Webinar
Excel Power Query Data Cleaning Basics
In today’s data-driven landscape, mastering the art of data cleaning and preparation is critical. The "Excel Power Query Data Cleaning Basics" webinar is a pivotal resource for anyone looking to harness Excel's Power Query for advanced data management. This session goes beyond introducing Power Query’s features, aiming to arm participants with practical skills to revolutionize data analysis and enhance thei..
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 tablesWho 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 productiveAdministratorsSalespeople..
Excel – Build Even More Powerful Pivot Tables: DAX Essentials
In today's data-driven world, having a strong command of Excel is essential, and understanding the Data Analysis Expressions (DAX) formula language is the key to unlocking the true potential of Excel's Power Pivot and Data Model features. This session is for intermediate Excel users who are already familiar with Pivot Tables, Power Pivot, and the Data Model but are hungry for more. We will delve deep into D..
Excel – Mastering Logic Functions
Have you ever needed to Automate entering different values into a cell depending on a certain criterion?Count the number of times a word, number or date appears in a range (and keep it current)?Add up a set of numbers that match a criterionReplace the ugly #NA or #DIV/0 with something more aesthetically pleasing?These are just some of the things that you can do using Excel's built-in Logic functions.Areas C..
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..
Exempt or Non-Exempt? Proper Worker Classification Under the New FLSA Overtime Rule
The new rule will become effective on July 1, 2024, so employers need to be prepared for these changes. The new rule makes significant changes in which of your employees will now qualify to be “exempt” and therefore not be entitled to overtime. Employees who were previously classified as exempt will now need to be reclassified to non-exempt employees and will then be entitled to overtime. Employers need to ..
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..
Export Due Diligence: What Every U.S. Exporter Must Know?
Provisions in the Export Administration Regulations (EAR) require that exporters know their exports, destinations, end-users, and end uses. Exporters must submit an individual validated license application if the exporter "knows" that an export that is otherwise exempt from the validated licensing requirements is for end-uses involving nuclear, chemical, and biological weapons or related missile delivery sy..
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..