This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.

Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups

This webcast walks through the limitations, and suggests how to improve the VLOOKUP function. We spend some time trapping errors with the IFERROR function, which was...

Webcast Information systems environment Foundational

Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting

This webcast covers the function that sums better than the SUM function for accounting professionals.

Webcast Information systems environment Foundational

Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization

This webcast covers workbook design principles to help you build reliable recurring-use workbooks, as well as workbook and worksheet organization ideas.

Webcast Information systems environment Foundational

Excel for Accounting Professionals Session 7: Date Driven Workbooks and Concatenation

This webcast covers key date and text functions. It also demonstrates how to greatly improve the utility of the conditional summing function by using comparison...

Webcast Information systems environment Foundational

Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check

This final session in the Excel for Accounting Professionals webcast series offers you the opportunity to apply many of the items covered at the same time. The...

Webcast Information systems environment Foundational

Introduction to Data Analytics and Microsoft PowerBI Tools

Excel is the #1 data analysis tool for accountants, yet most accountants don’t know the basics of Excel data analysis functions and tools. In this webcast, we will...

Webcast Information systems environment Foundational

Microsoft PowerBI - Get Started with the Right Data

This webcast discusses the importance of having data in a data model versus in a spreadsheet. We will introduce some of the basic features of the Microsoft PowerBI...

Webcast Information systems environment Foundational

Microsoft PowerBI - Fundamentals of Power Query

This webcast focuses on using the PowerBI Power Query, as well as Get and Transform in Excel 2016, to clean, shape and transform your messy data while still allowing...

Webcast Information systems environment Foundational

Integrating Audit Data Analytics into the Audit Process

Get introduced to the concept of audit data analytics, a brief overview of what audit data analytics are and how these tools can be integrated into your current audit...

Webcast Data analytics Foundational

MS PowerPoint - Advanced Techniques for Better Presentations

Learn how to leverage the more advanced features of PowerPoint to take your presentations to the next level. You'll create more effective presentations by reviewing a...

Webcast Communication Foundational

KPI Dashboards - The New Financial Reporting Model

Join this webcast to learn more about the growing need for KPI dashboards and how to embrace this model. You will learn the what, why and how of integrating KPI...

Webcast Information systems environment Foundational

Microsoft PowerBI - Improve Data Analysis with DAX Measures

This webcast digs into major PowerBI tools. We will introduce DAX formulas and how they are used to create calculations. You will also learn about Power Pivot as a...

Webcast Information systems environment Foundational