How to import and clean data from a web page with Power Query into Excel | Excel Automation | L0023

Опубликовано: 16 Февраль 2025
на канале: Celia Alves - Solve & Excel

1,087

We will look at an example of connecting to a web page and go through several data cleansing challenges.
Importing data from a web page may come with a lot of challenges. In this class, we will deal with non-printable characters and dates prior to January 1st, 1900 which are not recognized by Excel but can easily be dealt with within Power Query.

----
Get access to the EXERCISE FILES by joining our Telegram Group at https://t.me/celiaalvessolveexcel
Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn:   / celiajordaoalves
Facebook:   / solveandexcel
Twitter: @celia_excel
Instagram: @solveandexcel
YouTube: https:www//   / celiaalvessolveexcel

#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA