https://www.facebook.com/106981074828054/

Excel guru

Home
Nigeria
Lagos
Excel guru

Excel for data analysis

11/06/2022

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

https://youtu.be/9XoKzo7J48k

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

https://youtu.be/b-tFuuczpXM

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

https://youtu.be/v1cY-4rjAEo

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!

https://youtu.be/6mubQPgTOw4

10/01/2022

https://youtu.be/SVGLFbKRySQ

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.

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

https://youtu.be/3cQWq5ACk-A

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.

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

https://youtu.be/7L5BunjqM-E

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.

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).

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...

Address

Lagos

Website

facebook.com

Alerts

Be the first to know and let us send you an email when Excel guru posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The School

Send a message to Excel guru:

Want your school to be the top-listed School/college in Lagos?