Filter by

Close

Topics

Excel (28)

Excel (28)

Sort by: 

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

This video covers one of the most significant enhancements rolled out with Excel 2007, the table feature. It also covers named references and the five most important shortcuts so that you can improve your personal productivity.

£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

Speaker: Jeff Lenning, CPA, CITP

This video covers the function that sums better than the SUM function for accounting professionals. Also, it reviews the data validation and conditional formatting features and a technique to address a major pitfall of Excel.

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

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

Excel

Video

Excel

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

£79.00

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

Speaker: Jeff Lenning, CPA, CITP

This video covers the five workbook design principles that help you build reliable recurring-use workbooks, as well as workbook and worksheet organisation ideas.

£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

This video opens with conditional summing, which will absolutely improve efficiency in your reporting workbooks. It also explores lookup basics and why lookups are preferable to direct cell references and the details of VLOOKUP.

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

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

As popular as the VLOOKUP function is, it has limitations. This video walks through the limitations, suggests how to improve the VLOOKUP function, and discusses how to move beyond VLOOKUP altogether.

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

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

This video explains how to use Excel's lookup functions to perform list comparisons, and how to perform multicolumn list comparisons without first combining several columns into a single lookup column.

£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

This video covers key date and text functions. It also demonstrates how to greatly improve the utility of the conditional summing function by using comparison operators.

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Excel

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

£79.00

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

Speaker: Jeff Lenning, CPA, CITP

This video discusses dynamic headers and their use in automating reporting workbooks. It reviews how to transpose the orientation of the conditional summing function to produce horizontal or crosstab reports.

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout