Switch Function in PowerBI and MS Excel
Do you ever get frustrated when you have to nest multiple conditions using the IF function in Excel? If YES, you are not alone on the table. Let me introduce…
I’ve Created a Chatbot, a Buy and Sell Signal, and the most comprehensive Nigerian stocks + bonds analysis Tools. Enjoy!
If you have Telegram, then you should try out the chatbot I created for the Nigerian stocks and macro-economic data: t.me/NigeriaMarketDataBot You can ask it for the stock price of any…
How To Thoroughly Compare Two Different Files or Different Versions of Same File In Microsoft Excel
Ever suspected someone has changed your file or report in Excel or edited places you didn't want them touching? Or it is that you have two different files that should…
How To Set Conditional Formatting To Highlight An Entire Record Row Based On Value In One Field
Let's say you have started a side business. You sell about 21 different products. You've hired a trusted hand to manage the business but he is not Excel savvy. So…