Filter by

Close

Topics

MBAexpress (22)

Excel (10)

Sort by: 

Financial analysis

Excel – How to Create Accurate Spreadsheets

Excel – How to Create Accurate Spreadsheets

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

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

There are no upcoming dates for this Webcast

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: 13 February, 2019 | 9:00 am - 11: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 7: Date Driven Workbooks and Concatenation

£79.00

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

Speaker: Jeff Lenning, CPA, CITP

Webcast: 21 March, 2019 | 8:00 am - 10:00 am UTC

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.

Select a date and time

£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

Webcast: 19 March, 2019 | 8:00 am - 10:00 am UTC

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

Select a date and time

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Excel

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

£79.00

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

Speaker: Jeff Lenning, CPA, CITP

Webcast: 14 March, 2019 | 8:00 am - 10:00 am UTC

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.

Select a date and time

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Excel

Mastering Data Preparation and Analysis in Excel

£79.00

Mastering Data Preparation and Analysis in Excel

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 04 February, 2019 | 5:00 am - 7:00 am 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

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

£79.00

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

Webcast: 13 March, 2019 | 8:00 am - 10:00 am UTC

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

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

12 March, 2019

12:00 am - 10:00 am UTC

Webcast
12:00 am - 10:00 am UTC

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

Webcast: 12 March, 2019 | 12:00 am - 10:00 am UTC

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

Select a date and time

£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

Webcast: 20 March, 2019 | 8:00 am - 10:00 am UTC

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.

Select a date and time

£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

Webcast: 15 March, 2019 | 8:00 am - 10:00 am UTC

This session opens with conditional summing, a game-changer that will absolutely improve efficiency in your reporting workbooks

Select a date and time

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout