Compliance Training Webinars for Regulated Industries

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 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.

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.

This training program will explore several new functionalities within the MS Office suite. For example, did you know Word 2013 can open PDF files directly? Charting has been revamped throughout the Office products, especially in Excel. This Excel webinar will serve as a quick start to learn the new features.

This excel work book webinar will showcase how to link excel to word documents, databases, web pages, how to fix broken links, improve integrity of workbooks. Learning how to break links to other workbooks and data sources. Handouts and sample workbook with steps.

Learn the ins and outs of the Outlook environment, and learn to enhance time management with email. This webinar will focus on the updated and time saving features of MS Outlook. It will teach attendees to explore convenient features hidden within the application.

This MS Excel training program will offer attendees insight into Excel’s printing and page layout nuances. While demonstrating several key features, it will also detail how the Custom Views feature can streamline repetitive print actions and how to restore the classic Print Preview screen from Excel 2007 and earlier.

Microsoft Excel has powerful tools that can be used to quickly tame large sets of data. This training session will help attendees discover techniques that can simplify and format data according to your audience.

This training program will detail applying new charting capabilities in Excel 2013 and later, define how to save time by copying chart formatting between charts, and list ways to simplify chart-related tasks. It will also enumerate how to enliven Excel charts with clip art.

This webinar covers the underlying principles of visual design, practical goals that emerge from design theory, and useful techniques to achieve those objectives. Participants will learn a systematic process designed to improve the appeal of presentations.

The training will help you to create high-profile, articulate, and memorable slide presentations that will enable your audience to make informed decisions with confidence.

This first training program in the Microsoft Excel webinar series will discuss the automation possibilities that Excel macros offer and the nuances of Excel’s Personal Macro Workbook. It will also define how to use Excel’s Macro Recorder, and offer a quick guide on how to create a keyboard shortcut on the Quick Access Toolbar and on applying Relative References when recording macros.

This training program will detail applying new charting capabilities in Excel 2013 and later, define how to save time by copying chart formatting between charts, and list ways to simplify chart-related tasks. It will also enumerate how to enliven Excel charts with clip art.