Tag Archives: Flash Fill

edX – Microsoft: DAT206x: Analyzing and Visualizing Data with Excel

For years I’ve been the resident Excel guru who knows how to run a pivot table and not stuff up a vlookup.

This year I thought I would take my meagre skills and try and super charge them by adding buzz words like analysing and visualization. And now I’m a data scientist and paid a million dollars a year! So I’m still no data scientist but I have learnt some nifty Excel tips and tricks and heap of things that I didn’t know were possible.

Format As Table

What does this do?

Continue reading edX – Microsoft: DAT206x: Analyzing and Visualizing Data with Excel