Excel (23)

Data Analytics Modeling Certificate

This is an interactive learning program that includes bonus hands-on learning labs that will expose you to the tools needed to implement an analytics practice in a practical way and that will equip you to deploy those tools as needed within your organization. You will practice using various technologies for preparing, analyzing, and managing data sets in the real world.

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.

Microsoft PowerBI – Introduction to data analysis in Excel

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 04 January, 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 Excel. You will learn how to use various techniques to cleanse your data by removing errors, validating and standardizing data.

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.

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.

Streamlined Excel Reporting Series Session 1: PivotTable Fundamentals

Speaker: Jeff Lenning, CPA, CITP

This video introduces the PivotTable feature and covers the basics

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.

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.

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.

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.