Fetch Cat and Dog Facts with Power Query in Excel (+ free download)
Автор: Excel University
Загружено: 2026-01-07
Просмотров: 611
Описание:
Learn Power Query in Excel with Cat & Dog Facts! 🐱🐶 | Excel Web API Tutorial 🎓 Get confident in Excel fast with our full online course, try it free for 7 days 🔥 👉 https://www.excel-university.com/yt
Want to learn Power Query and have fun doing it? In this beginner-friendly Excel tutorial, Jeff shows you how to pull live data from the web using Power Query—featuring real-time cat and dog facts! 🐾 Whether you're an Excel enthusiast or just curious about web APIs, this hands-on demo is a perfect starting point.
👉 By the end of the video, you’ll know how to:
Connect to web APIs in Excel using Power Query
Import JSON data from cat and dog fact URLs
Transform and format the data into a clean table
Refresh your workbook for new daily facts!
Even if you're not a pet lover, this lesson teaches powerful Excel skills that are useful in both business and personal projects. Plus, Jeff shares tips on JSON parsing, using “From Web,” and structuring your worksheet like a pro.
Chapters in this video
00:00 Introduction
00:23 Exercise 1
01:05 Exercise 2
01:54 Exercise 3
🔔 Subscribe for more Excel tips, Power Query tutorials, and real-world examples.
#ExcelTutorial #PowerQuery #ExcelForBeginners #WebAPI #ExcelTips #CatFacts #DogFacts #DataImport #JSON #ExcelTraining
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
