Follow my journey to build a life that can handle any storm that comes it's way
Automate Web Scraping in Excel
I've been a power Excel user since the late 90s and even in the early days I found myself copying and pasting data from websites into spreadsheets so I can run analytics on them.
Many moons ago Microsoft added a feature in Excel to help automate this, and recently it got a big upgrade. In this video (linked above) you can learn how to automate pulling in data from websites as well as processing it along the way.
Let me know if you find this useful!
Cheers,
Ben
Hi! I'm Ben Sullins!
Building a Bulletproof Life
Follow my journey to build a life that can handle any storm that comes it's way
My friend Matthew Miller at Tableau challenged me to recreate several charts using Excel and ChatGPT in 24 hours otherwise I'd have to profess my love of pie charts. Watch now to find out if I made it! Learn data skills at our academy and elevate your career. Start for free at https://ftdacademy.com/
Today we look at my home-based power plant using solar panels and FranklinWH batteries. Check out Franklin more here https://bit.ly/Ben-Sullins After implementing this I was able to protect my family against power outages as well as save a huge amount on my monthly energy bill. Subscribe for more and make sure to use #bulletprooflife in your comments for a heart!
Check out the video above and learn about the 9 highest paying Data jobs in 2023 (per indeed.com) Here are the jobs in reverse order, check the video for a breakdown of every role and sign up below if you'd like to start working towards one of these careers! Data Analyst ($70,676) Business Intelligence Analyst ($82,559) Statistician ($86,960) Business intelligence developer ($94,253) Data modeler ($102,376) Data scientist ($124,693) Data architect ($125,977) Big data engineer ($128,631)...