Filter by

Close

Topics

Macroeconomic analysis (7)

Excel (21)

Sort by: 

Data analytics

Microsoft PowerBI – Introduction to data analysis in Excel

£79.00

Microsoft PowerBI – Introduction to data analysis in Excel

Speaker: Bryan Smith

Webcast: 24 October, 2018 | 12:00 pm - 2:00 pm UTC

This webcast introduces you to the relevant Excel data analysis tools and focuses on what you can do with your data once it is in Excel. You will learn how to use various techniques to cleanse your data by removing errors, validating and standardizing data.

Select a date and time

  • + 2 more

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Advanced Excel: Practical Applications for Accounting Professionals

Excel

Course

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

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

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

Excel

Streamlined Excel Reporting Series

£239.00

Streamlined Excel Reporting Series

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

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

Spreadsheet Risk – Can You Eliminate It?

£79.00

Spreadsheet Risk – Can You Eliminate It?

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

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

Excel

Video

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

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

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