On-Demand Webinar
Essential Management Skills - What You Need To Get The Important Work Done
New supervisors will be ready to hit the ground running with the skills learned in this Webinar. Be ready to take on any challenge, be your best and put what you’ve learned into practice immediately.You will learn the skills you need to plan, prioritize and execute effectively each and every day. Putting into practice both the “hard stuff” and “soft stuff” will help you meet new challenges with increased co..
Essentials for Documenting Investigations: HR and Management’s Responsibility to Minimize Liability
As the saying goes - If it isn’t documented, it didn’t happen! Documentation is essential for many legal issues, disputes, audits, meetings, and decision making, to name a few. Perhaps nowhere is it more critical than when documenting your investigation. Your documentation memoralizes the entire investigation, it minimizes confusion, corroborates stories and evidence, demonstrates patterns of behavior and s..
Establishing a Robust Supplier Management Program
Regulatory expectations are clear about manufactures responsibility regarding supplier quality oversight. All regulatory agencies agree that pharmaceutical and medical device manufactures are responsible for ensuring their suppliers adhere to quality standards, maintain compliance to regulatory requirements and consistently meet established expectations. Therefore, it is essential pharmaceutical and medical..
Evaluating, Underwriting, and Lending to Construction Contractors
Volatility of construction risk in economic cyclesSupply chain risk for contractorsPayment process for contractors and subcontractorsContractor status report and key elements in contractor accounting and financial statementsProgress billings, retention, and collateral valueRole of sureties in providing bonds to contractors—lien prioritiesEvaluating contractor downside cash flow, collateral , and guarantors ..
Everyone Communicate but Few Connect – Discover Your Disconnect
We all communicate every day, but are we really “connecting” with those we work and live with? Connecting can make or break relationships. When we relate well to others, even those that are different than we are, it increases our influence with them.Talent and experience are not enough. The ability to communicate effectively is key to any accomplishment, whether in the workplace or at home. It does not come..
Everything About the W-4 Form You Need to Know
On May 31, 2019, the IRS released a draft of the 2020 W-4 form for the payroll and tax community to review. This webinar will prepare the payroll professional to understand the changes to the Form W-4 for 2020 and to review the recently released final of the 2020 W-4 Form. Before changes, the Form W-4 was a critical form that all companies have to obtain from employees and has had special processing require..
Excel - 10 Key Worksheet Functions to Skyrocket Your Productivity
An often-asked question by Excel users is "Which Excel worksheet functions are truly essential?" In a world of over 500 built-in Excel functions, the key is to identify the ones that truly impact your productivity and success while discarding the rest. Let's sift through the clutter, leaving behind the rarely-used and highly specialized functions, to uncover a select set of Excel tools that are universally ..
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..
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 - 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 - Power Pivot – Pivot Tables For 21st Century Data Analysis
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..