David Ringstrom speaker of compliance global

25
Friday
August, 2017

Speaker: David Ringstrom
Duration: 90 Minutes
Product ID: 700509

Register

Automating Excel: Introduction to Dashboards

In this enlightening webinar, Excel expert David H. Ringstrom, CPA, introduces you to Microsoft Excel worksheet dashboards. 

David typically teaches from Excel 2016, but he points out any differences in earlier versions of Excel. He’s also happy to demonstrate techniques in a specific version of Excel spreadsheet upon request. David’s detailed handouts serve as reference tools you can fall back on after participating in one of his webinars. He also provides an Excel dynamic dashboard workbook that includes a majority of the examples he uses during this webinar.

read more
David Ringstrom speaker of compliance global

29
Wednesday
March, 2017

Speaker: David Ringstrom
Duration: 90 Minutes
Product ID: 700694

Purchase

Building Error-Proof Excel Spreadsheets

If you want to learn how to improve the integrity of your Excel spreadsheets and discover techniques for auditing the spreadsheets created by others, you won’t want to miss this advanced Excel training presented by Excel expert David Ringstrom, CPA.

He thoroughly explains the uses of several Excel features, including the Hide and Protect feature, the Conditional Formatting feature, the Table feature, the Data Validation feature, and the Custom Views feature.

In addition, David compares the IFNA, IFERROR, and ISERROR functions and shares a simple design technique that will improve the integrity of Excel’s SUM function.

David will demonstrate techniques from Excel 2016, but his detailed handouts identify differences in Excel 2007, 2010, 2013, and 2016 when needed.

read more
David Ringstrom speaker of compliance global

28
Tuesday
February, 2017

Speaker: David Ringstrom
Duration: 90 Minutes
Product ID: 700666

Purchase

Get a Handle on Duplicates in Your Excel Data

Excel expert David H. Ringstrom, CPA, shows you how to identify and manage duplicate data within your spreadsheets in this live Microsoft Excel training. He covers a variety of topics, including identifying duplicate data visually by way of the Conditional Formatting feature, using a pivot table to determine how many duplicates are in a list, and applying worksheet functions like SUMIF or COUNTIF to sum or count instances of duplicates.

In addition, David explains how to use the MATCH worksheet function to help you identify discrepancies in two different lists, how VLOOKUP will stop searching for duplicates after an initial match in found within a list, and how to use Excel’s Data Validation feature to create a rule that ensures users can’t enter the same data more than once in a given area of a spreadsheet.

read more
David Ringstrom speaker of compliance global

30
Wednesday
March, 2016

Speaker: David Ringstrom
Duration: 90 Minutes
Product ID: 700303

Purchase

Leveraging Linked Workbooks in Excel

Many Excel users have a love-hate relationship with workbook links. For the uninitiated, workbook links allow you to connect one Microsoft Excel training spreadsheet to other spreadsheets, MS Word training online documents, databases, and even web pages. 

In this webinar, Excel expert David Ringstrom, CPA discusses the pros and cons of workbook links, and walks you through the nuances of creating workbook links. David will also show how to dramatically improve the integrity of linked workbooks by using Microsoft Query instead of traditional cell-based links. 

David will primarily give 2010 Excel training, but will discuss Excel 2013 new features when applicable, as well as differences in Excel 2007. Discussion of Excel 2003 will be limited to questions from the audience. David's fast-paced teaching style covers a lot of ground, so even long-time Excel users are certain to learn something new.

read more
David Ringstrom speaker of compliance global

25
Tuesday
August, 2015

Speaker: David Ringstrom
Duration: 90 Minutes
Product ID: 700167

Purchase

Encapsulate Excel Data with Pivot Tables

In this webinar Excel expert David Ringstrom, CPA helps you master one of the most overlooked, yet easiest to use features in Excel—creating Pivot Tables. The webinar leads off with techniques for quickly transforming raw data into pivot table-ready formats. The webinar then moves into creating pivot tables, expanding and collapsing data, and issues that can affect pivot table integrity.

For the uninitiated, pivot tables are a means of creating reports in Excel by simply dragging and dropping with your mouse. Work that could take hours to do by manually isolating unique items and writing summary formulas can be accomplished in seconds. Not only do pivot tables enable you to easily summarize large sets of data, you can easily drill back down into the details with a simple double-click. You’ll also be able to quickly expand and collapse reports so that you can always work with as much or as little detail as you need.

David will teach from primarily from Excel 2010, but will demonstrate new features in Excel 2013 when warranted, as well as disclose any differences in Excel 2007. Coverage of Excel 2003 will be limited to questions raised by the audience. As a special feature of this webinar, David will provide four different handouts so that you can see exactly how pivot tables work in your version of Excel. The handouts will be specific to:

• Excel 2013
• Excel 2010
• Excel 2007
• Excel 2003

David's webinars are fast-paced, and even experienced Excel users are certain to learn several new tips and tricks. David welcomes your questions and is happy to answer Excel questions unrelated to the webinar during the question and answer session.

read more
David Ringstrom speaker of compliance global

30
Thursday
July, 2015

Speaker: David Ringstrom
Duration: 90 Minutes
Product ID: 700160

Purchase

Enforcing Internal Control within Excel Spreadsheets

Excel expert David Ringstrom, CPA often likens Excel spreadsheets to the old West, where anything goes. Users are generally free to enter anything they like in any worksheet cell, often at the expense of data integrity. In this webinar David will show you how to use features and techniques in Excel to future-proof spreadsheets and ensure that users work within the required constraints. These techniques minimize spreadsheet maintenance, improve the user’s experience, and bolster spreadsheet integrity.

David will teach from primarily from Excel 2010, but will demonstrate new features in Excel 2013 when warranted, as well as disclose any differences in Excel 2007. Coverage of Excel 2003 will be limited to questions raised by the audience.

David's webinars are fast-paced, and even experienced. Excel users are certain to learn several new tips and tricks. David welcomes your questions and is happy to answer Excel questions unrelated to the webinar during the question and answer session.

read more
Moving from an Operational Manager to a Strategic Leader

Speaker: Chris DeVany

Time: 01:00 PM EDT | 10:00 AM PDT
Location: New York

Logistics Channel Incoterms Standards

Speaker: Dr. Rossano V. Gerald

Time: 01:00 PM EDT | 10:00 AM PDT
Location: New York

Looking to host a webinar at your organization?

Contact us for Customized solutions
+1.516.900.5506

michael@complianceglobal.us

Learn More

TESTIMONIALS