Using FF to parse raw numbers into phone format will be super useful. The date trick was also neat. Heck, the whole thing is super impressive! Thanks for the tutorial.
Your videos are so good it crazy, after just few months I managed to pull out live data from SAP and create live excel dashboard connected to SAP. (VBA + Power Query)
Great Stuff once again - I had a file at work where Flash fill kept suggesting nonsense dont know why - I will dig it out and send it on if you want. Just random words from rows above, Never figured it out! Anyway another very useful video - I love the split numbers example.
As always, inspiratinal - thanks Use it a lot, but the tip about CTRL-E I did not know, will save me time and many mouse clicks In cases of telephone numbers though, I rather use custom formatting ####-#### (we have eight digits in in our telephone nr.)
Absolutely Brilliant, Mynda!! Thanks to your course, I know how to do this in Power Query but I had no clue as to the fact that it could be done in an Excel spreadsheet. Do you know the identity of the businesswoman who sparked this development?
The "Flash Fill" tutorial is timely: I started with Excel years ago and did a good enough job, but the newish features that save me having to work as hard to be clever are welcome. But why the T-Shirt saying "I simply spread sheets"?