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.

IT management & assurance

About this topic

These learning resources are designed to help you - whether working in a business or firm - establish and maintain proficiency in the areas of information and data management and analysis; IT risk and assurance services, including service organization controls (SOC) reporting; and information security and privacy, including the growing issue of cybersecurity.

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 1: Tables and Named References

The first webcast in the Excel for Accounting Professionals series covers one of the most significant enhancements rolled out with Excel 2007, Tables.

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 4: Conditional Summing and Lookups

This webcast opens with conditional summing. If you have not explored conditional summing yet, you are in for a surprise. Conditional summing is a game changer and...

Webcast Information systems environment Foundational

Excel for Accounting Professionals Session 6: List Comparisons and Indenting

This webcast opens with how to use Excel's lookup functions to perform list comparisons. And, how to perform multicolumn list comparisons without first combining...

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

Simplifying Security of Online Passwords

This webcast will provide an overview of the top password keeper programs and demonstrate how they are the best way to secure your personal data. You will learn how to...

Webcast Information security & privacy Foundational

Coaching and mentoring

Understand the similarities and differences between coaching and mentoring to improve your skill set and performance.

Webcast Coaching & mentoring Foundational

Leading vs managing (formerly Manager vs. Leader: When to be Which and Why)

Analyzing what leaders do, why they do it and when they do it is vital to understanding how to manage. In this webcast, we will look at how to create a balance between...

Webcast Coaching & mentoring Foundational

Emotional intelligence (formerly Conflict and difficult people)

Learn about emotional intelligence and how it can greatly increase your chances of personal and professional success.

Webcast Communication Foundational