Compliance Training Webinars for Regulated Industries

This colorful presentation illustrates the best way to display data with Excel charts. We start with the basics: how to select the right data, use the special chart toolbar and the six charts that work best for 95% of your data. We then examine how to use the Chart Toolbar and the chart editing tools to create and edit beautiful, professional-level charts. You’ll learn how to format and fine-tune your charts for incredibly effective data presentation.

This training program will help attendees apply a variety of Excel’s built-in analysis tools for solving calculation needs. It will discuss new features of Excel’s redesigned charts and illustrate when to use which type of chart. It will also detail Lookup formulas and the details that are used within, along with database methods for Lookup results.

For many people the holy grail of organization is a world where email overload doesn't exist and where all those sticky notes and paper notepads are magically replaced by a digital paperless system. Using OneNote, a free application that you will find in the Microsoft Office suite, this dream can become a reality.

This training program will take attendees closer to creating presentations in an engaging format, employing the significant features of MS Word, MS Excel, and MS PowerPoint. From learning Word’s capabilities of integrating Excel data to using Word for automatic PowerPoint speaker notes, this webinar will cover a broad range of functionalities that will make integrating reports and presentations from all three MS Office suite applications that much simpler.

This webinar will teach attendees best practices for managing list and tabular based data in terms of sorting (into different orders), applying and saving filters (that let you display only certain items) and summarizing with Pivot Tables.

This webinar training will help you master and implement Microsoft Word key features. The instructor will share important shortcuts, tips and tricks and discuss the critical tools like formatting, tabs and tables, troubleshooting, navigation, automation, and more.

This training program will update and educate attendees on new features in Word and how to integrate them into daily work. It will also discuss setup, navigation, selection and formatting shortcuts along with applying the Automation of Covers, Table of Contents, using Headers and Footers, Bookmarks, Cross-References, and more.

This Excel macros training program will help attendees apply your extended knowledge of Excel macros. It will define how to create loops within your spreadsheets and help recall when to use the SELECT CASE function versus IF statements. Attendees will also understand how to use Breakpoints to simplify debugging errors in the programming code.

This training program will aid those who use Excel at a basic level and help them learn to create formulas and use some of its built-in functions effectively. The training will be delivered using Excel 2016 for Windows however much of the functionality is also available to users of earlier versions of Excel on both Windows and Mac.

This Microsoft Excel training program will explore how to create a UserForm in Excel. It will help attendees identify how to create macro buttons that enable you to display UserForms on demand. The webinar will also define the benefits of using Visual Basic for Applications (VBA) macros and illustrate how to apply the Tag property within UserForm controls.

This Excel training program will elucidate Excel functions that allow you to quickly create accounting reports. Attendees will learn how to create dynamic reports for any month of the year on one worksheet. They will also receive helpful handouts to help execute their learning.

One of the great features of Microsoft Office is the ability to move data among the applications, such as inserting Excel data into a report created in Word, or building an Excel table within Word with full Excel functionality. This webinar training will increase your efficiency with MS Office software by combining features from Excel, Word, and Access and setting out their reporting capabilities.

This training program in the Microsoft Excel series will define how to adjust Excel’s macro security settings. Attendees will learn how to apply an enhanced understanding of Visual Basic for Applications (VBA) macros and also learn identify how to enhance the code you’ve created with the Macro Record feature. The program will discuss Excel’s Goal Seek feature, which is useful in simplifying what-if analyses and illustrate how to eliminate unwanted text using the Text to Columns feature.

In this Excel training program, attendees will learn six worksheet functions available to sum data in Excel. They will discover the pros, cons, limitations, and uses of Excel’s worksheet summing functions and learn how to create more flexible formulas using the INDIRECT and OFFSET functions.

This session can improve your use of Microsoft Word, increasing understanding, and discovery of the many automated features that reside within Word. Take your work with Word to a higher level, save time and create professional-looking documents.

From calculating DSO and DSI and planning for seasonal adjustments to using Excel date arithmetic to schedule payables, receivables and cash flow, this training program will assist attendees in effectively constructing the monthly cash flow forecast using Excel.

In this training program, participants will learn how to build a macro from scratch. Several macros will be demonstrated in both Word and Excel to generate ideas of how participants can start using their new automation techniques.

Understand the important basics that are often overlooked with PowerPoint. Learn design components, effective use of layouts, masters, and backgrounds and learn to enhance your presentation with graphics, charts and SmartArt.

More than any other Microsoft Office program, it is difficult at best to take a self-taught approach with MS Project. Inaccuracies in data are easy to create and difficult to see. This webinar training offers a quick review of the details to keep your information accurate and your Project on target.

This training program will help attendees recall how to avoid complex IF statements and apply the COUNTIF function to determine the number of times an item appears on a list. It will also demonstrate several key Excel features such as applying the IFNA function in Excel 2013 and later; applying alternatives to the IF function, such as IFS, CHOOSE, VLOOKUP, and others; the ISNA function vs. the IFERROR function, and much more.