Excel: Create a Refreshable Olympic Games Medals Table Using Power Query on Mac
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
Watch video Excel: Create a Refreshable Olympic Games Medals Table Using Power Query on Mac online without registration, duration hours minute second in high quality. This video was added by user Mike Thomas 11 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 40 once and liked it 2 people.