Filter by

Close

Topics

Excel (28)

Excel (28)

Sort by: 

Data analytics

Microsoft PowerBI – Introduction to data analysis in Excel

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.

There are no upcoming dates for this Webcast

Disruption

Spreadsheet Risk: Can You Eliminate It?

£79.00

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.

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

Office 365 and Excel for Analysts

Excel

Video

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

Accounting applications

Power BI

£35.00

Power BI

Speakers: Chris Ortega; Rob Collie

Microsoft has quietly been turbocharging Excel by integrating industrial-strength business intelligence and reporting engines into it.

£35.00 (CIMA members only)

£45.00

VAT calculated on checkout

Disruption

Excel – Using PivotTables for Data Analysis

£139.00

Excel – Using PivotTables for Data Analysis

Webcast: 21 October, 2019 | 3:00 pm - 7:00 pm UTC

In this webcast, you will learn how PivotTables are crucially important for analyzing data. We will show you examples of PivotTables to demonstrate that data analysis can be an easy task for any accountant.

£139.00 (CIMA members only)

£179.00

VAT calculated on checkout

Data analytics

When Excel-Based Analytics Detect Fraud

£35.00

When Excel-Based Analytics Detect Fraud

Speaker: Rich Lanza, CPA, CFE, CGMA

Learn to reduce fraud using data analytic surveillance. This audio session focuses on simple techniques to minimize risk in key areas, which can be executed using Excel-based analytics.

£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 Session 2: Working with PivotTables

£79.00

Streamlined Excel Reporting Series Session 2: Working with PivotTables

Speaker: Jeff Lenning, CPA, CITP

This video begins by comparing the formula-based reports to PivotTables. It digs into the details between these two report types so that you are comfortable applying them to specific workbooks.

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout

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

Streamlined Excel Reporting Series Session 4: External Data and Pivot Charts

Excel

Video

Excel

Streamlined Excel Reporting Series Session 4: External Data and Pivot Charts

£79.00

Streamlined Excel Reporting Series Session 4: External Data and Pivot Charts

Speaker: Jeff Lenning, CPA, CITP

This video focuses on external data and digs into the details for retrieving data from other sources. You will learn how to retrieve data from simple text files as well as how to prepare data for use with Excel.

£79.00 (CIMA members only)

£99.00

VAT calculated on checkout