Making you awesome in Excel, Power BI, data analytics & charting. One tweet at a time. Also, love mangoes, lego, cycling and coffee...
Sep 23, 2022 ⢠8 tweets ⢠3 min read
Power BI is a highly sought after skill for data folks. It makes the process of data analysis simple and easy. If you ever wanted to learn what all the fuss is about, this tweetorial is for you. š§µ 1) What is it? Power BI is a data analysis & visualization software. We can use it to load up and clean any data, analyze it, visualize it and share the outcomes with others easily.
Sep 13, 2022 ⢠8 tweets ⢠2 min read
I made 10,000+ charts ššš in my life. Here are 6 simple rules that help me create amazing charts consistently.š§µ
#1 - Write punchy, clear titles
Sep 5, 2022 ⢠12 tweets ⢠2 min read
Excel has 100s of functions. Most them are not useful in day to day business setting. Here are the 10 most useful functions based on my 15 years of regular usage.
š§µ
1) SUMIFS
Use it to add up values that meet one or more conditions.
=SUMIFS(A1:A100, B1:B100, "NZ", C1:C100, ">20") adds up all values in A1:A100 where column B is NZ and column C is more than 20.