Compliance Training Webinars for Regulated Industries

Lookup formulas are far superior to manually searching for specific data elements in a spreadsheet. VLOOKUP, HLOOKUP, INDEX and MATCH are some of the most well-known (and most useful) functions in Excel which are used to to return data from other locations in worksheets. VLOOKUP enables you to quickly and easily look for a value in a column of data and return a value from the same row in a different column. This is invaluable when working with large tabular data. INDEX and MATCH work in a similar way but provide more flexibility. If you handle large amounts of data in Excel, this webinar will help you tremendously.

This 4-hour course is considered intermediate level Excel Training. Learn beyond the basics of Excel.
There are many print options. Print options are found on the Page Layout ribbon. You can set margins, page orientation, and select paper size.

Data is important. Locating specific data is important. Being sure that the correct data is being input is critical. Thanks to Conditional Formatting, you can highlight all information that is important to you (the highest or lowest values, duplicate values, values that are larger or smaller than a certain value). This will provide you with the necessary information to make important business decisions. Conditional formatting is one of the major strengths of Excel!

This training session covers THREE intermediates to advanced features of Excel that provide automation within the application. Explore what are considered the top 10 functions.

Being able to create and edit a macro is one of the must have skills for Excel Power Users. Having this knowledge will save you hours of time by allowing you to automate any Excel-based task or process. If you’ve never created macros or used VBA before, this webinar is for you.

This webinar will discuss the excel What-If Analysis tools within Microsoft Excel’s Data menu. In addition, it will explain Excel Scenario Manager, Data Table features, Excel’s Goal Seek feature, Excel Solver feature, FORECAST and more. Participants can avoid replicating worksheets. The advance functions can also help in comparing different scenario and extrapolate trends based on existing data in your spreadsheets.

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 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 webinar will help you master pivot tables in Excel 2007, 2010, 2013, and 2016. Learn tricks and traps of working with pivot tables to help ensure accuracy of reports and convert obsolete Excel spreadsheet files to modern workbook formats.

Excel has many built-in functions that help you deal with that data. Attend this webinar to learn how to turn the data into meaningful information and then provide the answers that you need for yourself, your boss, your company or your organization. Learn how to use performance reports, scenarios, use of Excel in multi-user environments, relative and absolute formulas and many more.

Extracting data from text files or from database management systems, such as Microsoft Access or Microsoft SQL Server, can be intimidating to Excel users. In this informative session, Excel expert David Ringstrom, CPA, walks you through the process of getting the data you need from databases or from text files into Excel.

This Microsoft Excel training program will explains how several Excel features—Data Validation, Conditional Formatting, and hide and protect features—can be implemented to control users’ actions and protect your worksheets and workbooks from unauthorized changes.

Learn how to create a dynamic budget spreadsheets by using various techniques – streamline & preserve formula , how to create both operating and cash flow budget, how to improve integrity of spreadsheet using VLOOKUP, Excel’s CHOOSE, SUMIF, ROUNDUP and ROUNDDOWN worksheet functions.

If you understand Excel charts and Pivot Tables then you can leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently. This 100-minute webinar takes you from Excel Dashboards to easier and more powerful MS Power BI dashboards. With this training you’ll learn the basics of implementing "do it yourself business intelligence" using Power BI.

This Excel data visualization webinar will teach you how to: create a basic chart and then customize it, combine charts and then automate them, create infographics, and present geographical data visually. Demonstrate scenario on the fly, SUMIFS and COUNTIFS-based tables, Non-native chart types – waffles and maps, conditional formatting

Learn how to manage databases in Excel with this webinar. Learn the tools that will help large amounts of data seem more manageable, and easier to sort through and analyze. Understand what functions work best with large tables, and how you can automate repetitive steps with simple macros. Become a master of working with databases in Excel.

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.

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