Excel for data analysis
11/06/2022
Automate Sum aggregate based on specified condition using Offset function in Excel. In this video, we walk you through how to use Offset function to automate sum aggregate in your Data. For instance, if you are trying to compute sales based ...
04/06/2022
Copy, Paste and Formatting multiple worksheets at the same time. If you watch this video, it is going to save you hours whenever you are facing this kind of problems in your work place. The video will show you how to copy ...
28/05/2022
3 ways to extract text within text. #Powerquery, #Flashfill and #formular in Excel This video explained how to extract text within a text to new column using 3 methods in Excel. Watch the video and see the 3 methods.Endeavor to subscribe to...
24/05/2022
Number Formatting in MySQL - #SQL Many data analysts find it difficult to make their numeric data readable, especially large figure. With this video, you will surely overcome this problem. Th...
16/01/2022
https://youtu.be/OqmEBtOkNIU
In this video, we appraised a project to see if it worthwhile to commit our capital on it or not. We made use of NPV as an investment Appraisal technique.
Watch the video to upgrade both your Excel and Finance skills. Do not forget to subscribe to my YouTube channel, like it and also comments there.
I remain your humble Excel Guru guy, Ibraheem Babatunde, ACA, MNAEE, MIAEE.
Thanks and God bless!
10/01/2022
Loan Amortization Schedule Automation Using Excel Macro. In this video, we will learn how to compute loan amortization schedule and not only this, we will also learn to automate it and similar problems. We made use...
28/11/2021
In this video, we will learn how to build simple Financial modeling and Scenario analysis using Scenario manager add-in function in Excel. We will also learn how to compute Net Present Value of cash flows, forecast Revenues, Sales and Costs, and computation of Company Income Tax to arrive at Profit After Tax. In the Scenario analysis, we make use of Base Case, Best Case and Worst Case scenarios. Finally, we will learn how to detect outliers in our models and also learn how to mask our cells using custom format.
Please, do not forget to subscribe, comments and like this YouTube channel That is only price you can pay for this great knowledge channel.
I remain your humble Excel Guru, Ibraheem Babatunde, ACA, MNAEE, MIAEE.
Simple Financial modeling and Scenario analysis In this video, we will learn how to build simple Financial modeling and Scenario analysis using Scenario manager add-in function in Excel. We will also learn...
30/10/2021
Personal Income Tax Computation (PAYE) This video explained how to compute employees Personal Income Tax (PAYE) in accordance with 2020 Finance ACT of FGN using Excel. It assumes zero knowledge of...
24/10/2021
https://youtu.be/xiutZNEge6U
In this video, you will learn how to sum or aggregate a value based on certain conditions. There are many ways of achieving this, a common way is Sumifs, but this has limitation. It can only handle columns conditions. If we have two or more conditions within a column, Sumifs cannot handle it, except we complement it with another function. As a result, this video provides many solutions to do this, such as SumProduct, Sumifs with Sum and Dsum. Dsum function is very concise and straight forward among them but it is not popular among Microsoft Excel users. The video also talked about data validation and how to remove duplicate from group of data.
Let take our time to watch this wonderful video and improve our skills.
Please, do not forget to subscribe to my YouTube channel.
I remain your humble guy,
Ibraheem Babatunde, BSc (Economics) MSc (Energy Finance), ACA, MNAEE, MIAEE.
Dsum, Sumifs, SumProduct and data validation.. In this video, you will learn how to sum or aggregate a value based on certain conditions. There are many ways of achieving this, a common way is Sumifs, but...
24/09/2021
Transport cost optimization via Excel Solver In this video, you will learn how to incur minimum cost when you are moving your products from many warehouses to different customers based on their number o...
14/09/2021
In this video, you will learn how to combine data from many workbooks in Excel into single excel sheet in a separate workbook using power query.
Excel power query to combine workbooks into single excel sheet In this video, you will learn how to combine many workbooks in Excel or other files into single excel sheet using Excel power query.
24/08/2021
In this video you will learn how to automate pension contributions future value using Excel macro. Apart from this automation, you will learn how to improve your efficiency and productivity at your various places of work. There are some our activities which are routine in nature, skills in this video will prevent you from repeating the same process whenever you need to get done on such activities. You can't afford to miss this video.
If you need the template of this work, subscribe to my YouTube channel, click like button and drop your email.
Cheers!
Ibraheem Babatunde, ACA, MNAEE, MIAEE, MSc (Energy Finance).
Automate pension contributions future value using Excel macro and use macro relative reference. In this video, you will learn how to automate pension contributions future value using Excel inbuilt macro. This knowledge will improve your efficiency and p...