On-Demand Webinar
Evaluating Your Board
The membership, structures, and functions of most boards of directors come about by happenstance and continue through inertia. Members are named through ownership, networking, and personal or family connections. Board operations likewise are structured to meet basic legal requirements, but too often ignore structural, support and meeting practices that could nurture the most value from membership. Only with..
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 - 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 - Mastering Lookup Functions
"How do I look up a value in list ONE and pick up a related value from list TWO""How do I avoid my lookup formula displaying an ugly error when it can't find a match?""I've heard of VLOOKUP but what's HLOOKUP and what’s XLOOKUP?"These are just a few of the questions I get asked on a regular basis. You can get the answers to these questions (and more) by attending this training session dedicated to mastering..
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 Charts
Excel charts are visual representations of data created within Microsoft Excel. They allow users to present data in a graphical format, making it easier to analyze and interpret trends, patterns, and relationships. Excel offers a variety of chart types that can be customized to suit different data visualization needs. Some common types of Excel charts include: Column Chart, Bar Chart, Line Chart, Pie Chart,..
Excel ChatGPT Data Management Charting Protection and Formulas
Gain easy-to-understand and practical “hands-on” knowledge of ChatGPT and Artificial Intelligence (AI) with a focus on significantly enhancing capabilities in Microsoft Excel.Harness the awesome power of AI to take Excel to a new level and boost your efficiency, working smarter and faster.Mastering AI is now a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions a..
Excel ChatGPT PivotTables Advanced Data Management Functions and Much More
Harness the awesome power of AI to take Excel to a new level and boost your efficiency working smarter and faster.Mastering AI is now a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including public service, banking, accounting, financial analysis, and business administration.Understanding the correct setup, options, question formats, capabilitie..
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..