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 […]
The Impact of IFRS 16 on Financial Statements
IFRS 16 is effective for annual reporting periods beginning on or after 1 January 2019, with earlier application permitted (as long as IFRS 15 is also applied). What is IFRS 16 The objective of IFRS 16 is to faithfully represent lease-based transactions and support users assessment of cash flows arising from leases. The standard requires […]
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 […]
