Compliance Training Webinars for Regulated Industries

Whilst Pivot Tables offer valuable data summarization features, they also have several limitations. They struggle with handling large datasets, they lack the ability to combine data from multiple datasets and the built-in calculation functionality is very simplistic.

Learning how to create Pivot Tables is one of the must have skills for anyone who needs to use Excel to quickly build reports and summaries. This webinar will provide you with a solid foundation that you can use to build your own Pivot tables and reports.

In this training attendees will learn how Power Pivot provides business Intelligence functionality and reporting within the familiar environment of Excel with practical examples. This webinar will discuss best practices for importing data into Excel from external sources, creating relationships in Power Pivot, Power Query data sources, and more.

This webinar will update your Excel skills by teaching you how to create impressive Dashboards even if you don’t have artistic talent. At the conclusion of this webinar you'll be able to create amazing, interactive Excel dashboards that update at the click of a button and leave a lasting 'wow' impression.

This Excel webinar gets you started with VBA. It's aimed at advanced users of Excel, with little or no programming experience, who wish to take their level of automation knowledge beyond the macro recorder.

This Excel training program will guide users in employing Pivot Table filters to analyze data, designing a Pivot Chart from a Pivot Table, developing Slicers for User Interactive Filters, and more. It will also take attendees through the first steps in dashboard design using Pivot Tables.

Pivot Tables are one of the most powerful tools in Excel’s arsenal of data analytics. With just a few clicks, and no complicated formulas or macros, you can quickly and easily build incredibly informative reports, charts and dashboards. In this webinar, you’ll learn Pivot Table techniques that will instantly filter, summarize and analyze huge amounts of raw data. You will learn to use advanced Pivot Table techniques to rapidly produce critical information that will highlight the algorithms and trends buried in reams of data.

HR professionals frequently supervise, manage and/or analyze and report many types of HR data. This overflow of personnel data ranges from employee timesheets to payroll records to the department, divisional and company-wide employee information including hiring date, salary, position, employee class, department, division, employee evaluation ratings, and much more. This 90-minutes of concise, focused Excel training designed specifically for HR professionals can simplify these tasks for you.

This webinar training pays for itself in terms of your firm's potential savings and detection of fraud. The training is designed to both prevent and detect fraud. We first teach you how to establish an administrative environment where fraud is less likely to occur. We’ll then examine Excel tools that are used by CPAs and Internal Auditors to detect fraud.

This webinar will be an informative session for all financial and non-financial professionals to understand the financial statements like balance sheet, income statement, cash flow and more. Participants will learn how to analyze and interpret these statements to assess the profitability, liquidity, efficiency and leverage of their company.

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 Microsoft Excel training will help attendees to understand how to build a dynamic Cash Flow forecasting model in Excel. Also attendees will learn how to design and construct the classic cash flow template and implementation of Excel spinners for dynamic display and calculation of changing assumptions.

As a basic-level user of Microsoft Office, you'd love to reduce the number of "hair-tearing-out" moments. You'd love to be able to do things faster so you can go home on time. You'd love to be seen as an “Office Hero” in your organization. As an added bonus, because Microsoft Office is so widely used across the globe, having good-to-excellent skills means you'll be more marketable in today’s highly competitive job market!

This training session focuses on the email aspect of Outlook. In this session you'll learn how, used in the right way, Outlook can save you time, help you to gain more control over your mailbox, improve your response time and allow you to keep up with the never-ending stream of critical actions and due dates.

Do you import data into Excel from other sources (such as CSV files, text files, web pages, databases or SharePoint)? Does the data that you import need to be "cleaned" before it can be used? (cleaning refers to things like removing duplicate rows, removing blank rows, removing unnecessary columns, converting case, changing date formats and more).

Do you spend more time than necessary performing data cleaning tasks?