Excel guru

https://youtu.be/QJmfz0kQ8Ic

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

https://youtu.be/b-tFuuczpXM

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

https://youtu.be/SVGLFbKRySQ

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

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

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

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