Introduction to Data Analysis for Finance
Data is the new oil as the world biggest firms are all creating value through data. In this short video, we introduced the concept of data to finance professional with a practical case study using Excel.
Excel: How to Split Data in One Column to Multiple Columns
In some cases, the files we download from other applications does not come in a format that will enable us to analyse and present reports in Excel. For instance, if you copy information from a text file into excel all the data may appear in one column as shown below. In this above situation, we […]
Notes – ACCA Africa Members Convention – Evolution
With over 800 delegates from 38 countries, the ACCA Africa Members Convention may be the biggest gathering of accountants in the continent. Kigali Convention Centre in Rwanda was the host of the 2019 convention between 09th to 11th December 2019. The convention was jam-packed with multiple plenaries and breakout sessions relating to the evaluation of […]
XLOOKUP Replaces VLOOKUP in Excel 2019
It is often common that users refer to different tables or sources during entry in Excel. For instance, Product Sales report would refer to the product price list using unique product code. This referencing ensures fast data entry and minimize error. If you are a novice user, you probably know VLOOKUP as use Excel function […]
