Compliance Training Webinars for Regulated Industries

This webinar will discuss and explain in detail the excel advance formulae. The instructor will define how to use the Evaluate Formula feature, apply hide and protect features to preserve key formulae and recall how to find and select all formulae within a worksheet. Participants will learn the F9 keys, IFERROR, N functions and more.

The purpose of this webinar is to give users at any level in Word, tools to help automate their work. Participants will learn to build and apply Quick Parts for automatic signatures and other text blocks; create merge documents for automatically entering information from Excel fields and other fields. Bookmarks, cross-references and reference fields will also be demonstrated.

This Excel training program will help participants identify formula errors such as #VALUE!, #REF!, #N/A. Participants will also learn to apply Excel’s Filter feature to quickly scan a column for # sign errors and understand when to use ISERROR or ISNA instead of the IFERROR function. The program will also help recall how to bring Excel’s green error-checking prompts under control.

In this training program, participants will learn the best ways to create PivotTables and Pivot Charts by comparing two or more fields in a variety of layout styles, performing ad-hoc grouping of information, creating a Pivot Chart that is in sync with a PivotTable, and more.

This training program will help attendees identify the differences in Excel 2016 from previous versions. Attendees will also learn which worksheet functions are available in Excel 2016 but not in other earlier versions of Excel. Understand the nuance involved between the 32-bit and 64-bit versions of Excel.

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 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 training program will present in-depth coverage of specific formulas and functions, as well as provide attendees with the perspective they need to understand the scope and depth of these critical Excel features. All examples will be presented within the context of Excel worksheets.