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.

Technical

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.

Streamlined Excel Reporting Series Session 2: Working with PivotTables

This session begins by comparing the formula-based reports we built at the end of the EAP series to PivotTables.

Webcast Information systems environment Foundational

Streamlined Excel Reporting Series Session 1: PivotTable Fundamentals

The first session of the series introduces the PivotTable feature and covers the basics.

Webcast Information systems environment Foundational

Streamlined Excel Reporting Series Session 3: PivotTable Wrap-Up and Web Data

In this session we finish our PivotTable discussion by examining various ways to present report values, discussing the subtly of properly sorting a recurring-use...

Webcast Information systems environment Foundational

Streamlined Excel Reporting Series Session 4: External Data and PivotCharts

This session continues the discussion about external data and digs into the details for retrieving data from other sources.

Webcast Information systems environment Foundational

Time to Get Serious About Information Security

This webcast will provide a clear and concise explanation of both the threats to your information security and the steps your organization should take to protect...

Webcast Information security & privacy Foundational

AICPA Construction & Real Estate Conference

Attend the Construction & Real Estate Conference on Dec 6 - 7, 2018 in Las Vegas, NV. Find breakthrough content for both the construction and real estate industries as...

Conference – Live,   Conference – Virtual FASB financial accounting & reporting Intermediate

Cybersecurity Fundamentals for Finance and Accounting Professionals Certificate - Webcast

This 3-part webcast introduces key terms related to cybersecurity, the impact of digital transformation on business and how it relates to cybersecurity, and major...

Webcast Risk identification & assessment Foundational

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