Filter by

Close

Topics

Excel (29)

Excel (11)

Sort by: 

Financial analysis

Excel – How to Create Accurate Spreadsheets

£109.00

Excel – How to Create Accurate Spreadsheets

Speakers: Bryan Smith, CPA, CITP, CISA; John Higgins

Webcast: 07 May, 2019 | 5:00 am - 8:00 am UTC

This webcast is designed to teach you the fundamentals of good spreadsheet design that will increase your accuracy and efficiency when creating Excel spreadsheets.

Select a date and time

£109.00 (CIMA members only)

£139.00

VAT calculated on checkout

Data analytics

Microsoft PowerBI – Introduction to data analysis in Excel

£79.00

Microsoft PowerBI – Introduction to data analysis in Excel

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 22 May, 2019 | 5:00 am - 7:00 am 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 Microsoft Excel. You will learn how to use Power BI various techniques to cleanse your data by removing errors, validating and standardizing data.

Select a date and time

£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

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

Speaker: Jeff Lenning, CPA, CITP

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.

There are no upcoming dates for this Webcast

Excel

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

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

Speaker: Jeff Lenning, CPA, CITP

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.

There are no upcoming dates for this Webcast

Excel

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

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

Speaker: Jeff Lenning, CPA, CITP

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

There are no upcoming dates for this Webcast

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

Online Event

Webcast

Excel

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

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

Speaker: Jeff Lenning, CPA, CITP

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.

There are no upcoming dates for this Webcast

Excel

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

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

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

There are no upcoming dates for this Webcast

Excel

Mastering Data Preparation and Analysis in Excel

£79.00

Mastering Data Preparation and Analysis in Excel

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 16 May, 2019 | 12:00 pm - 2:00 pm 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 for Accounting Professionals Session 1: Tables and Named References
LIVE

Online Event

Webcast

Excel

Excel for Accounting Professionals Session 1: Tables and Named References

Excel for Accounting Professionals Session 1: Tables and Named References

Speaker: Jeff Lenning, CPA, CITP

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

There are no upcoming dates for this Webcast

Excel

Excel for Accounting Professionals Session 6: List Comparisons and Indenting

Excel for Accounting Professionals Session 6: List Comparisons and Indenting

Speaker: Jeff Lenning, CPA, CITP

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.

There are no upcoming dates for this Webcast