All topics (25)

Mastering Data Preparation and Analysis in Excel

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 13 November, 2019 | 9:00 am - 11: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.

Microsoft PowerBI – Fundamentals of Power Query

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 11 November, 2019 | 3:00 pm - 5:00 pm UTC

This webcast focuses on using Power Query, as well as 'Get' and 'Transform' in Excel 2016, to clean, shape, and transform your messy data while still allowing you the one-click refresh.

Microsoft PowerBI – Fundamentals of the PowerBI Dashboards

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 13 November, 2019 | 3:00 pm - 7:00 pm UTC

This webcast introduces you to Microsoft PowerBI Dashboards and its differences from PowerBI Desktop. You will learn how you can share data from Power Pivot or PowerBI Desktop to PowerBI.com.

Microsoft PowerBI – Fundamentals of the PowerBI Desktop app

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 12 November, 2019 | 3:00 pm - 7:00 pm UTC

This webcast focuses on learning the PowerBI Desktop interface, connecting to data sources and creating visualisations. We tour the PowerBi Desktop interface and create each of the various visualisations.

Microsoft PowerBI – Improve data analysis with DAX Measures

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 17 October, 2019 | 2:00 pm - 4:00 pm UTC

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

Microsoft PowerBI – Power Pivot for advanced data analysis

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 18 October, 2019 | 2:00 pm - 4:00 pm UTC

This webcast focuses on using the Power Pivot features to enhance your data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will use the power of DAX to create meaningful calculations that add new dimensions to your data.

Microsoft PowerBI – Introduction to data analysis in Excel

Speaker: Bryan Smith, CPA, CITP, CISA

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 standardsing data.

Spreadsheet Risk: Can You Eliminate It?

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 08 November, 2019 | 2:00 pm - 4:00 pm UTC

This webcast focuses on ways to control and reduce the risk of spreadsheet errors.

Using Market-Based Data to Provide Valuation Report

Speaker: Brian Pearson

Webcast: 10 December, 2019 | 6:00 pm - 7:30 pm UTC

In this webcast we will be using the MergerShark database, the AICPA’s FVS section member valuation choice for merger, acquisition and valuation related data to demonstrate how to prepare better, more reliable and defendable valuation reports, in less time.

Modernization of the International Tax System to Reflect the Digital Age

Speaker: Edward Karl

Webcast: 19 November, 2019 | 6:00 pm - 7:00 pm UTC

There are unique and complex tax challenges raised by the digital economy. In this webcast we will discuss the tax implications of the digitalization of the economy as well as AICPA’s recommendations.