ICAEW.com works better with JavaScript enabled.

Data analytics courses

Our data analysis and Excel training courses will give you the skills to harness the power of big data, gain predictive and prescriptive analytical skills and transform the way finance adds value to the business. Our courses cover an array of topics in data analytics, including data visualisation, programming languages, and Excel training.

All courses are live virtual classrooms and can be delivered in-house.

Virtual data analytics classrooms

Data visualisation

Gain accessible and comprehensive understanding of the subject of data visualisation: how to effectively communicate data visually.

Data Analytics Certificate

Data Analytics certificate
Enrol now for immersive data analytics e-learning, bespoke to finance professionals and provided by ICAEW in partnership with Kaplan.

Excel modelling - investment appraisal, valuation and business cases

Apply best practice Excel techniques to produce a robust business model for the evaluation of investment opportunities with this Excel training course.

Excel FP&A – system data and automating month-end reporting

An Excel course to help you to apply best practice techniques to extract information from databases and produce monthly management accounts and rolling strategic plans.

Intermediate trend forecasting and analysis

A data analysis training course covering how you can prove a trend exists using statistical analysis and then extrapolate trends to create forecasts.

Introduction to Python

Discover the high-level programming language for general-purpose programming, an introduction to Python.

Introduction to R

This course is intended as an introduction to the R programming language for individuals working in the financial sector.

Introduction to SQL

Understand the basics of SQL and empower yourself to formulate SQL statements and directly query your databases.

PivotTable refresher and Power Pivot

Create more powerful PivotTable reports, summarise multi-dimensional PivotTables and dissect data to produce detailed information for business reporting and forecasting purposes with this data analytics course.

Power Query: Streamline the automation of key business reports

This big data training course will help you to extract, load, customise and transform data automatically, freeing you up to append more time analysing and less time preparing reports.

Additional data analytics courses available for in-house delivery

For more information on how you can run any of the below data analysis training courses for your team or to find out how they can be tailored to your company, please email academy@icaew.com.

Advanced data analytics: distribution, sampling, classification and regression

Advanced analytics can help businesses predict outcomes and answer business questions.

An introduction to statistical data analysis

This one day course introduces delegates to statistics and analyses and takes them through the six key concepts that underlie all statistical thinking and analysis.

Business and analytical problem framing

To maximise the benefits that data and its analysis can offer, the analyst requires an understanding of the data-driven decision-making framework and its basic concepts.

Data preparation and ethics

Explore a range of different data sources and formats as well as the legal and ethical issues related to data-handling.

SQL programming - the next level

Learn to write powerful, customisable SQL queries directly to the database that are lightweight and fast.

Successful data strategies and case applications in business

Get an up-to-date overview of big data and how to apply it to your organisation.