Data Analytics Webinar – Presentation Download with reference links

image

Download the Presentation (3 MB). I have added lots of links to related articles and external references including books written by stalwarts in Excel analytics field.

Presentation was used for delivering the webinar. You can download the webinar video from here. Or view it on YouTube using this link.

Reversing row order in Excel data

Two simple approaches. One is to add an extra column with serial numbers and then sort on that column in descending order. This works for small amount of data. For large data it is best to import it in Power Query and choose Transform tab – Reverse Rows.

image

Benefit of Power Query? It works on a smaller sample of data and then applies the transformation when you choose Save and Load option. This is much faster than getting all the data and then trying to sort it (which is the first method).

Why is this required? Usually required with logs where the first transactions or rows are at the bottom. So the data is received in reverse chronological order. Twitter feeds, Timeline Updates, Live blogs – all follow this pattern.

This method works independent of the time-stamp column. What is wrong with timestamp? It may be in different time formats, some rows may have same timestamp and some rows may have no timestamp at all.

How to use pictures in Excel reports (Power View)

This is available only with Excel 2013 Professional Edition and Office 365 Edition. Try it out right now. Enhance your reports. Make them more visual and easier to interpret. Use logos, product shots, country flags, features, people, locations, buildings, spare parts, posters, icons, anything visual.