Areef’s Blog

17.0  03/10/22 Pdf files – Extract, cleanse & append multiple pages with Excel

Excel Office 365 users have been able to connect, extract & manipulate data from Pdf files since at least June  2020 using Excel’s ETL tool – Power Query.  This feature is also in Power BI.   See below the short video I did on how to use it and apply some of the routines to extract and fix a 5-year financial dataset using Excel

16.0  04/09/22 Excel AI data extraction from pictures 

Microsoft released to current channel users of Excel Office 365 a feature to allow you to get data from hardcopy documents or from tables on websites that are not accessible using Excel’s Power Query feature.   Once you take a picture or a softcopy of it to Excel’s clipboard you should be able to retrieve the data using the new AI extraction interface.  Please see the short video I did on it below

15.0  07/08/22 Date restructuring using new formulas

Microsoft released some new formulas earlier this year for Excel Office 365 users which are useful for data restructuring.  If you have a Current Channel version of Excel you should have these formulas already. 

In the 1st  video we look at a new dynamic array formula MS introduced called textsplit, how to nest it with other dynamic array formulas and regular formulas to restructure data.

The 2nd video covers 2 new text formulas – textbefore and textafter.  These can be used to overcome two limitations noted with the textsplit formula. 

See the sample exercise file here.  You can use it to practice the exercises shown in the videos below:

14.0  07/04/22 Updated “Finding Success” Guide

As some of you may know, I am passionate about helping others to find their success.  My personal experience is that if you implement the advice offered in the guide which follows you are guaranteed to find your own success. 

One small request – if you find it beneficial please pay it forward – share it with others who you feel can benefit from it.    

You can download the detailed guide to help you on your journey from here.  I usually run this as a short private session for organisations. 

13.0  08/06/22 “Creating an automated Ageing report”

See the video by clicking below

12.0  02/09/21 “Finding Success” Presentation  Superceeded

Download the full presentation updated with detailed speaker notes from here

11.0  21/08/21 “Business Intelligence: Excel vs Power BI” Presentation

Download the Overview presentation from here

10.0  15/11/20 Outlier Analysis 2.0 – Power BI

See the video by clicking below

9.0  3/11/20 Covid-19 Active cases Pareto Analysis – Power BI

See the video by clicking below

8.0 26/10/20 Outlier Analysis Automation – MS Excel

See the video by clicking below

7.0 4/10/20 Sales Forecast Automation – MS Excel – Click here to view our video from Youtube

6.0 7/8/20 Automating Statutory & Fixed format reports – MS Excel – Click here to download.  See the video by clicking below

5.0 7/7/20     Success Centre Safety & Facility Enhancements – click here

4.0 9/6/20     10 Golden rules for Data Automation – click here


3.0 20/4/20 COVID-19 Power BI model PBIX file- Click here to download.  See the video by clicking below

2.0 20/1/15 Power BI vs Excel Presentation – Click here

1.0 20/1/2 – Fuzzy Look up matching our Power BI video – Click here

Business Guardian article – Thu Feb 21 2019