About this topic
Based on the CGMA Competency Framework, these resources allow you to focus on technical, business, people and leadership skills. All areas are underpinned by the need for ethics, integrity and professionalism. Log in and start learning today.
Assess your skills
Take a self-assessment to evaluate your skills and find related learning activities.
Get started928 Results
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
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
Excel for Accounting Professionals Webcast Series
The Excel for Accounting Professionals webcast series is designed to walk through the Excel features, functions and techniques that will save you time.
Webcast Information systems environment Foundational
Adobe Acrobat - Securing Your PDF Files
This webcast teaches you what you need to know about using Adobe's document security controls. Using these controls will help you stay in compliance with the...
Webcast Information security & privacy Foundational
Annual Update for Accountants and Auditors
This webcast will help you identify and apply pronouncements, exposure drafts and other guidance recently issued in the accounting, auditing, preparation, compilation...
Webcast FASB financial accounting & reporting Foundational
Microsoft PowerBI - Power Pivot for Advanced Data Analysis
This webcast focuses on using the Power Pivot features to enhance your data analysis. You will also learn how to use a date or calendar table to perform date analysis.
Webcast Management reporting Foundational
Explore Topics
© 2018 Association of International Certified Professional Accountants. All rights reserved.