Let us say I want to create sample data for my analytics class for a customer. I dont have access to the actual customer data. But I want the data to look familiar to the participants. I want to use the names of their products in sample data containing 1000 rows. I could use Randbetween() with Vlookup but that gives me almost equal distribution for all products. I want to make the data look realistic. I want to use the market share values of their products to generate the sample data. Here is how you do it. 3.5 minute video.
Because of these two villains, millions of people waste their life struggling in Excel. Read on to find out how to handle them and eliminate them from your life.
Select data and choose Insert – Tables or Press CTRL T. Agreed. But there is more to it. Read on to find out the nuances…
This is a series about Excel Tables. I have covered this topic in the past but now we need more details. So let us start at the beginning. What are Excel Tables and why do we need them…
Share data from Head Office to field staff or vice versa. All using the powerful List feature of SharePoint. Zero Programming. Anyone can do it in minutes. Try it and apply it to your needs.
These videos were created in 2013. Therefore the logos and screenshots depict older versions of products. However the concepts – which are more important – are still valid.
Here is a quick overview of how we can analyze data more effectively using new Excel tools. You can also refer to the collection of 51 articles about data analytics for a more detailed coverage. Data Analytics: Knowledge Pack.
|This is a very common and dangerous inaccuracy.
Big operational risk!
Check all your dates imports after reading this article.
Estimated reading time 15 min
Older version of Excel could display only 52 colors. New version (2007 onwards) can display 16 million colors. Yes, that sounds like an overkill, but Excel uses this extra capability in a brilliant way. It provides us with a very easy and useful method of using color to understand information more easily. Read on to find out how…