Filter by

Close

Topics

Financial accounting & reporting (53)

Excel (29)

Sort by: 

Excel

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

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

Speaker: Jeff Lenning, CPA, CITP

The Excel for Accounting Professionals webcast series concludes by applying many of the items covered at the same time. We start by discussing dynamic headers and how important they are when automating reporting workbooks.

There are no upcoming dates for this Webcast

Excel

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

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

Speaker: Jeff Lenning, CPA, CITP

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 operators.

There are no upcoming dates for this Webcast

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

Online Event

Webcast

Excel

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

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

Speaker: Jeff Lenning, CPA, CITP

This session walks through the limitations and suggests how to improve the VLOOKUP function

There are no upcoming dates for this Webcast

Excel

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

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

Speaker: Jeff Lenning, CPA, CITP

Are you familiar with the five workbook design principles that help us build reliable recurring-use workbooks? This session covers them, as well as workbook and worksheet organisation ideas.

There are no upcoming dates for this Webcast

Excel

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

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

Learn about the function that sums better than the SUM function for accounting professionals.

There are no upcoming dates for this Webcast

Excel

Mastering Data Preparation and Analysis in Excel

£79.00

Mastering Data Preparation and Analysis in Excel

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 16 May, 2019 | 12:00 pm - 2:00 pm UTC

This webcast is a must for any accounting or finance professional. Excel is almost as important as your technical training – so why aren’t you using it to save time or analyse data properly? This might be the best two hours of learning in your career so far.

Select a date and time

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Excel for Accounting Professionals Session 1: Tables and Named References
LIVE

Online Event

Webcast

Excel

Excel for Accounting Professionals Session 1: Tables and Named References

Excel for Accounting Professionals Session 1: Tables and Named References

Speaker: Jeff Lenning, CPA, CITP

The session covers tables and named references. In addition, the five most important shortcuts are explored so that you can improve your personal productivity.

There are no upcoming dates for this Webcast

Excel

Excel for Accounting Professionals Session 6: List Comparisons and Indenting

Excel for Accounting Professionals Session 6: List Comparisons and Indenting

Speaker: Jeff Lenning, CPA, CITP

This webcast covers how to perform multicolumn list comparisons without first combining several columns into a single lookup column. We discuss how a minor detail, like indenting, can produce major efficiency gains.

There are no upcoming dates for this Webcast

Excel

Excel for Accounting Professionals Session 4: Conditional Summing and Lookups

Excel for Accounting Professionals Session 4: Conditional Summing and Lookups

Speaker: Jeff Lenning, CPA, CITP

This session opens with conditional summing, a game-changer that will absolutely improve efficiency in your reporting workbooks

There are no upcoming dates for this Webcast