As the 2024 Olympic Games conclude today, you might wonder: do you really need to know how to create a refreshable Olympic medals table in Excel? Perhaps not, but if you're someone who enjoys extracting concepts and principles from tutorials, this week's YouTube video offers skills that can be applied to countless other scenarios. By watching the video, you’ll learn how to:

Import data into Excel from a web page using Excel for Mac
Load data from a range in a worksheet into the Query Editor in Excel for Mac
Use the Excel for Mac Query Editor to split and merge columns
Use the Excel for Mac Query Editor to return the last character of a column
Generate a list of flags associated with the list of countries
Address Refresh issues in Excel for Mac

🗒 Notes and Resources
Download a copy of the file used in this video: https://app.box.com/s/8osrrk4ra5m8to8...
BBC web page: https://www.bbc.co.uk/sport/olympics/...
Geographic Data Type video:    • Geographic Data Type: Your Very Own G...  

✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk

🙋‍♂️ Let's connect on social
Twitter:   / theexceltrainer  
Facebook:   / theexceltrainer  
LinkedIn:   / thomasmik  

#excel #mac #powerquery