Compliance Training Webinars for Regulated Industries

Do you import data into Excel from other sources (such as CSV files, text files, web pages, databases or SharePoint)? Does the data that you import need to be "cleaned" before it can be used? (cleaning refers to things like removing duplicate rows, removing blank rows, removing unnecessary columns, converting case, changing date formats and more).

Do you spend more time than necessary performing data cleaning tasks?

This easy-to-follow webinar training will illustrate the use of Pivot Tables, Pivot Charts and Pivot Table Slicers to analyze sales data by state, sales person and sales location. Pivot Tables are very versatile and allow the Excel professional to rapidly change rows, columns, and more to slice and dice raw data for detailed analysis and presentation. These same Pivot Table tools can be used for accounts receivable, inventories, personnel and much more.

In this webinar, you'll learn not only how to turn raw data into meaningful information but also how to present that data in a visually attractive way. This training will provide you with a solid foundation that you can use to build your own business reports.

This Microsoft excel training program will help attendees to understand the financial modeling concepts to model their capital expenditure projects and the methods for CAPEX analyses. Attendees will learn how to prepare and present outstanding, professional-level CAPEX models using special Excel tools.

This Microsoft Excel training will help attendees to understand the business valuation techniques, rate and value relationships, Capital Asset Pricing Model (CAPM), Valuation Modeling, CAPM templates and excel tools for rapid business valuations. It will also cover Weighted After-Tax Cost of Capital (WACC), Weighted Average After-Tax Cost of Capital (WACC), Growth Rate and Discounted Cash Flow (DCF).

In this session, participants will learn how to visually represent your data using both traditional charts (bar charts, line charts etc.) as well as how to do the same using some of Excel's non-charting tools.

In this webinar, attendees will learn how to create a stunning, interactive professional-looking dashboard using Excel. This training will provide you with a solid foundation that you can use to build your own dashboards and reports.

This training program will help attendees to understand the financial modeling concepts to construct powerful & effective templates and Excel's linear regression analysis to model your firm's sales forecast, identifying key revenue and cost drivers and charting techniques for report forecasting results to top management.

The hallmark of an interactive, data-driven dashboard is the ability to see and understand data at the speed of thought. This training webinar will deliver the skills needed to design well-planned Excel dashboards that present answers to questions in real-time, render visually striking displays, turn insight into action, help accomplish your firm’s objectives and improve your Excel skills. Attendees will be able to define key performance indicators and build a dashboard in Excel to monitor them.

This webinar will discuss the excel What-If Analysis tools within Microsoft Excel’s Data menu. In addition, it will explain Excel Scenario Manager, Data Table features, Excel’s Goal Seek feature, Excel Solver feature, FORECAST and more. Participants can avoid replicating worksheets. The advance functions can also help in comparing different scenario and extrapolate trends based on existing data in your spreadsheets.

This Excel dashboards training session will help discover how to quickly assimilate large amounts of data using charts and summary tables. They will also learn a variety of ways to present information in dashboard form.

This Microsoft Excel training program will explain why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP. It will compare the MIN, SMALL, MAX, and LARGE functions. The program will also define uses of the OFFSET worksheet function and detail how to apply the SUMIF function and the SUMIFS function.

This webinar will help you master pivot tables in Excel 2007, 2010, 2013, and 2016. Learn tricks and traps of working with pivot tables to help ensure accuracy of reports and convert obsolete Excel spreadsheet files to modern workbook formats.

Excel has many built-in functions that help you deal with that data. Attend this webinar to learn how to turn the data into meaningful information and then provide the answers that you need for yourself, your boss, your company or your organization. Learn how to use performance reports, scenarios, use of Excel in multi-user environments, relative and absolute formulas and many more.

Extracting data from text files or from database management systems, such as Microsoft Access or Microsoft SQL Server, can be intimidating to Excel users. In this informative session, Excel expert David Ringstrom, CPA, walks you through the process of getting the data you need from databases or from text files into Excel.

This Microsoft Excel training program will explains how several Excel features—Data Validation, Conditional Formatting, and hide and protect features—can be implemented to control users’ actions and protect your worksheets and workbooks from unauthorized changes.

Learn how to create a dynamic budget spreadsheets by using various techniques – streamline & preserve formula , how to create both operating and cash flow budget, how to improve integrity of spreadsheet using VLOOKUP, Excel’s CHOOSE, SUMIF, ROUNDUP and ROUNDDOWN worksheet functions.

If you understand Excel charts and Pivot Tables then you can leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently. This 100-minute webinar takes you from Excel Dashboards to easier and more powerful MS Power BI dashboards. With this training you’ll learn the basics of implementing "do it yourself business intelligence" using Power BI.

This Excel data visualization webinar will teach you how to: create a basic chart and then customize it, combine charts and then automate them, create infographics, and present geographical data visually. Demonstrate scenario on the fly, SUMIFS and COUNTIFS-based tables, Non-native chart types – waffles and maps, conditional formatting