An introduction to Power BI
Join this live workshop to hear from Simon Jeffery, Head of Insights + Modelling at Theta Global Advisors LLP. Simon, a business analytics and modelling expert, will present an Introduction to Microsoft’s data visualisation tool, Power BI.
There are no upcoming dates for this Event
Microsoft has quietly been turbocharging Excel by integrating industrial-strength business intelligence and reporting engines into it.
£45.00
VAT calculated on checkout
Learn to quickly and easily perform accounting and finance tasks in Excel.
£139.00
VAT calculated on checkout
There are some incredible business intelligence and reporting features tucked away inside the latest Excel. You should be using them right now – this video course shows you how.
£45.00
VAT calculated on checkout
Become an Excel black belt in eight easy steps. This isn’t a generic Excel training course – it was designed for professionals like you. So if you don’t know your error trapping from your concatenation, this video series is a must.
£599.00
VAT calculated on checkout
This video covers the function that sums better than the SUM function for accounting professionals. Also, it reviews the data validation and conditional formatting features and a technique to address a major pitfall of Excel.
£99.00
VAT calculated on checkout
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.
£99.00
VAT calculated on checkout
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.
£99.00
VAT calculated on checkout
As popular as the VLOOKUP function is, it has limitations. This video walks through the limitations, suggests how to improve the VLOOKUP function, and discusses how to move beyond VLOOKUP altogether.
£99.00
VAT calculated on checkout
Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check
£79.00This video discusses dynamic headers and their use in automating reporting workbooks. It reviews how to transpose the orientation of the conditional summing function to produce horizontal or crosstab reports.
£99.00
VAT calculated on checkout