Search Trainings
Implementing Advanced Pivot Table Techniques
In this presentation, Excel expert David Ringstrom, CPA, digs deeper into pivot tables to show you step-by-step how to manipulate your pivot table data faster and more efficiently. You’ll learn how to Extract data from Microsoft Access databases and other ...
- Basic & Intermediate
- 90 Mins
- David H. Ringst
- Jan 27, 2020
Excel: Building a Reporting Tool with Pivot Tables
Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) armoury. 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 yo ...
- Basic & Intermediate
- 60 Mins
- Mike Thomas
- Jan 29, 2020
Data Integrity and Privacy: Compliance with 21 CFR Part 11, SaaS/Cloud, EU GDPR
Details the requirements for Part 11 and Annex 11: SOPs, software product features, infrastructure qualification, and validation This highly interactive training uses life examples and explores proven techniques for reducing costs, usually by two-thirds, as ...
- Basic & Intermediate
- 90 Mins
- David Nettleton
- Jan 29, 2020
How ISO/IEC 27001 Can Help Achieve CCPA Compliance
Organizations had until 1 January 2019 to comply with the CCPA. Although there is no confirmed direct relationship between the CCPA requirements and information security, the tasks, activities, processes and system changes needed for CCPA compliance may affect ...
- Basic & Intermediate
- 60 Mins
- Robert E. Davis
- Feb 04, 2020
Take a Deep Dive into Little Known Microsoft Outlook Features with HUGE Productivity Benefits
Microsoft Outlook is a most powerful, comprehensive software tool because it combines email, a calendar and tasks. The goal is to make your professional life more productive and fulfilling as you gain the ability to get more done in less time. You will conquer ...
- Basic & Intermediate
- 60 Mins
- Karla Brandau
- Feb 18, 2020
Mastering Excel: Rising Above the Venerable VLOOKUP Function
Excel expert David Ringstrom, CPA, shares helpful tweaks you can use with the venerable VLOOKUP function. In this invaluable presentation, he explains alternatives to VLOOKUP, including the INDEX and MATCH, SUMIF, SUMIFS, SUMPRODUCT, IFNA, and OFFSET functions ...
- Basic & Intermediate
- 90 Mins
- David H. Ringst
- Feb 25, 2020
Excel Spreadsheets; Ensuring Data Integrity and 21 CFR Part 11 Compliance
This interactive webinar explains how to configure and validate a GxP compliant spreadsheet applications to avoid FDA 483s. Follow the step-by-step instructions as we configure Excel for audit trails, security features, and data entry verification. Understand ...
- Basic & Intermediate
- 75 Mins
- David Nettleton
- Feb 25, 2020
Excel: Data Visualization - Charting 101
"Every Picture Tells a Story" is a popular saying which is true not only in everyday life but in Excel too. Behind your set of numerical data is a story waiting to be told. The telling of this story needs to be to-the-point, easy to understand and engaging. D ...
- Basic & Intermediate
- 60 Mins
- Mike Thomas
- Feb 26, 2020
EPA Tier II Reporting - HRCI & SHRM Accredited
This training program will enumerate the requirements of the Emergency Planning and Community Right-to-Know Act (EPCRA) as it applies to your organization. It will also help attendees understand the threshold trigger for reporting a hazardous chemical on the T ...
- Intermediate
- 60 Mins
- Joe Keenan
- Feb 26, 2020
Excel: Power Pivot - Taking Pivot Tables to the Next Level
Power Pivot, a free addin for Excel, written by Microsoft, puts the "power" into Pivot Tables (hence the name!). Power Pivot removes many of limitations and frustrations that many users find with Pivot Tables. For example, using Power Pivot you can… Create ...
- Basic & Intermediate
- 60 Mins
- Mike Thomas
- Mar 04, 2020