Filter by

Close

Topics

Strategy (26)

Excel (28)

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

Office 365 and Excel for Analysts

£35.00

Office 365 and Excel for Analysts

Instructor: Joseph McDaid, CA

In this session, attendees will learn about some new and existing analytics features provided by Microsoft Excel.

£35.00 (CIMA members only)

£45.00

VAT calculated on checkout

Excel

Streamlined Excel Reporting Series Session 1: PivotTable Fundamentals

£79.00

Streamlined Excel Reporting Series Session 1: PivotTable Fundamentals

Instructor: Jeff Lenning, CPA, CITP

This video introduces the PivotTable feature and covers the basics

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Streamlined Excel Reporting Series

Excel

Excel

Streamlined Excel Reporting Series

£239.00

Streamlined Excel Reporting Series

Instructor: Jeff Lenning, CPA, CITP

Take your reporting skills to the next level. These four 2-hour videos with interactive exercises will show you how.

£239.00 (CIMA members only)

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

Instructor: 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 3: Workbook Design Principles and Organization

£79.00

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

Instructor: 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

Spreadsheet Risk – Can You Eliminate It?

£79.00

Spreadsheet Risk – Can You Eliminate It?

Instructor: Bryan Smith

This video focuses on ways to control and reduce the risk of spreadsheet errors. Learn about specific procedures that every organisation should implement when creating spreadsheets.

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Excel

Streamlined Excel Reporting Series Session 3: PivotTable Wrap-Up and Web Data

£79.00

Streamlined Excel Reporting Series Session 3: PivotTable Wrap-Up and Web Data

Instructor: Jeff Lenning, CPA, CITP

This video finishes the PivotTable discussion by examining various ways to present report values, discussing the subtly of properly sorting a recurring-use PivotTable, and covering numerous filtering options, including slicers.

£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

Instructor: 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 Series

£479.00

Excel for Accounting Professionals Series

Instructor: 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

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

Excel

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

Instructor: 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

Data analytics

When Excel-Based Analytics Detect Fraud

£35.00

When Excel-Based Analytics Detect Fraud

Instructor: 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

Instructor: 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 6: List Comparisons and Indenting

£79.00

Excel for Accounting Professionals Session 6: List Comparisons and Indenting

Instructor: 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 8: Dynamic Headers, Mapping Tables and Error Check

£79.00

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

Instructor: 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

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

Instructor: 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

Instructor: 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

Instructor: 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 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

Webcast: 26 July 2018 | 6:00 pm - 8:00 pm UTC

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.

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout