As I do, I meandered the web and found this page as a result of reading about a particular businessman. I download the data, cleaned it, formatted it, created some derived data/analysis and then summarised it this way:

excelmster_challenge_01062018

To do this I used

  • Combo Box
  • Sparklines
  • VLOOKUP
  • IFERROR
  • Rates of change ratios
  • Percentages of a sum
  • Percentages of a given value
  • As well as layout and formatting of data
  • I could have used Get & Transform but did not in this case!

Why not try this challenge and see if you can do what I did! Why not improve on it and share it here by way of a comment?

Duncan Williamson

1st June 2018

 

%d bloggers like this: