How to edit a formula in Excel
Yes I know you have been using formulas in Excel for decades. But just trust me… there is more. Here are some small but nice things you should know when
Yes I know you have been using formulas in Excel for decades. But just trust me… there is more. Here are some small but nice things you should know when
Data handling in Excel is probably the single most important drain on human effort every day. That is where Power BI comes in. Billions of people who have the false
Calendar view shows only Day, Week, Work Week and Month views. You can only select all appoints within a month. Even in the month view, CTRL A does NOT select
In few minutes you can analyze any public Facebook page data. Here we see how to analyze the likes and comments – instantly. You need Excel 2010 or Excel 2013
In the previous article , we have explored a new kind of mini chart called Sparklines. In this article, we will explore when and where to use Sparklines to quickly identify trends,
The need Visual data analysis usually means charts. There are some limitations of using charts. In some cases, traditional charts don’t work well. Primary and secondary Y axis allows two
Problem One of the participants (Mr. Amjad) in a seminar I conducted asked me this question. The scenario is common enough. But the solution is not even noticed – it
If I have to teach ONE thing to the world, it would be Excel Tables. I recently created this video for a Microsoft Webcast. Excel Tables were introduced in Office
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
