Filter by

Close

Topics

Performance management (29)

Excel (29)

Sort by: 

Excel

Streamlined Excel Reporting Series Session 2: Working with PivotTables

£79.00

Streamlined Excel Reporting Series Session 2: Working with PivotTables

Speaker: Jeff Lenning, CPA, CITP

This video begins by comparing the formula-based reports to PivotTables. It digs into the details between these two report types so that you are comfortable applying them to specific workbooks.

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Excel

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

£79.00

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

Speaker: Jeff Lenning, CPA, CITP

Webcast: 21 March, 2019 | 8:00 am - 10:00 am UTC

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.

Select a date and time

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

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

Online Event

19 March, 2019

8:00 am - 10:00 am UTC

Webcast
8:00 am - 10:00 am UTC

Excel

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

£79.00

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

Speaker: Jeff Lenning, CPA, CITP

Webcast: 19 March, 2019 | 8:00 am - 10:00 am UTC

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

Select a date and time

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Excel

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

£79.00

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

Speaker: Jeff Lenning, CPA, CITP

Webcast: 14 March, 2019 | 8:00 am - 10:00 am UTC

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.

Select a date and time

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Excel

Mastering Data Preparation and Analysis in Excel

£79.00

Mastering Data Preparation and Analysis in Excel

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 04 February, 2019 | 5:00 am - 7:00 am 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

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

£79.00

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

Webcast: 13 March, 2019 | 8:00 am - 10:00 am UTC

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

Select a date and time

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Excel

Excel for Accounting Professionals Session 1: Tables and Named References

£79.00

Excel for Accounting Professionals Session 1: Tables and Named References

Speaker: Jeff Lenning, CPA, CITP

Webcast: 12 March, 2019 | 12:00 am - 10:00 am UTC

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

Select a date and time

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Excel for Accounting Professionals Session 6: List Comparisons and Indenting
LIVE

Online Event

20 March, 2019

8:00 am - 10:00 am UTC

Webcast
8:00 am - 10:00 am UTC

Excel

Excel for Accounting Professionals Session 6: List Comparisons and Indenting

£79.00

Excel for Accounting Professionals Session 6: List Comparisons and Indenting

Speaker: Jeff Lenning, CPA, CITP

Webcast: 20 March, 2019 | 8:00 am - 10:00 am UTC

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.

Select a date and time

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Excel

Excel for Accounting Professionals Session 4: Conditional Summing and Lookups

£79.00

Excel for Accounting Professionals Session 4: Conditional Summing and Lookups

Speaker: Jeff Lenning, CPA, CITP

Webcast: 15 March, 2019 | 8:00 am - 10:00 am UTC

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

Select a date and time

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout