Filter by

Close

Topics

Financial analysis (10)

Excel (19)

Sort by: 

Excel

Advanced Excel: Practical Applications for Accounting Professionals

£109.00

Advanced Excel: Practical Applications for Accounting Professionals

Instructor: Jeff Lenning, CPA, CITP

This online course will make you excel in Excel. It’s designed for accountants, by an accountant, so you’ll learn how to unlock all the magic in your spreadsheets.

£109.00 (CIMA members only)

£139.00

VAT calculated on checkout

Excel

Excel for Accounting Professionals Series

£479.00

Excel for Accounting Professionals Series

Speaker: Jeff Lenning, CPA, CITP

Become an Excel black belt in eight easy steps. This isn’t a generic Excel training course – it was designed for professionals like you. So if you don’t know your error trapping from your concatenation, this video series is a must.

£479.00 (CIMA members only)

£599.00

VAT calculated on checkout

Power BI

Accounting applications

Video

Accounting applications

Power BI

£35.00

Power BI

Speakers: Chris Ortega; Rob Collie

Microsoft has quietly been turbocharging Excel by integrating industrial-strength business intelligence and reporting engines into it.

£35.00 (CIMA members only)

£45.00

VAT calculated on checkout

Data analytics

When Excel-Based Analytics Detect Fraud

£35.00

When Excel-Based Analytics Detect Fraud

Speaker: Rich Lanza, CPA, CFE, CGMA

Learn to reduce fraud using data analytic surveillance. This audio session focuses on simple techniques to minimize risk in key areas, which can be executed using Excel-based analytics.

£35.00 (CIMA members only)

£45.00

VAT calculated on checkout

Excel

PowerPivot: Excel’s Hidden Feature Will Change Your Life and Career

£35.00

PowerPivot: Excel’s Hidden Feature Will Change Your Life and Career

Speaker: Rob Collie

There are some incredible business intelligence and reporting features tucked away inside the latest Excel. You should be using them right now – this video course shows you how.

£35.00 (CIMA members only)

£45.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

Streamlined Excel Reporting Series Session 4: External Data and Pivot Charts

£79.00

Streamlined Excel Reporting Series Session 4: External Data and Pivot Charts

Speaker: Jeff Lenning, CPA, CITP

This video focuses on external data and digs into the details for retrieving data from other sources. You will learn how to retrieve data from simple text files as well as how to prepare data for use with Excel.

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

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 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 for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check

Excel

Video

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