AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Excel data analysis add in quick stats3/14/2024 ![]() When you have a bunch of numbers, you can use heatmaps / color scales to to find what’s going with it in the quickest & most fun way. Related: Going beyond AVERAGE to summarize data – Podcast part 1 & part 2 2. ![]() You just need to enable it by going to File > Options > Add-ins > Manage Excel Add-ins > Go). If you are lazy (or in a bit of hurry), you can use the Descriptive statistics feature of Data Analysis Tools add-in (this is available in Excel by default. You can calculate all of these with simple Excel formulas. You know…, the good old AVERAGE, COUNT, SUM, MIN, MAX, MEDIAN, and Range of the data. Today let me share 15 quick, simple & very powerful ways to analyze business data. You need to analyze and tell a story about it. You are looking at a spreadsheet full of data.
0 Comments
Read More
Leave a Reply. |