In this article, I will show you how to import an HTML table into Excel. This will work for any data from a local HTML file or online URL that is stored in a table. I will import the HTML table in a way that the data can be updated if it changes, which is particularly valuable for online data. This will be done using a Get & Transform Query. As such, this method is only compatible with the Windows version of Microsoft Excel.Continue reading “Import an HTML Table into Excel”
Adding an SSH key to GitHub is a great way to authenticate yourself without having to type in your password every time you push. With Git Bash and the following commands, you can be setup in no time.Continue reading “Add a GitHub SSH Key on Windows”
In this tutorial we do some web scraping with Python and Beautiful Soup 4. The results are then saved to a CSV file which can be opened and analyzed in Microsoft Excel or another spreadsheet program. I show you how to select elements from the page, deal with 403 Forbidden errors by faking your user agent, and overcome cases where the website is poorly laid out for web scraping. The example used here is SocialBlade.Continue reading “BeautifulSoup 4 Python Web Scraping to CSV Excel File”
In this tutorial, we are going to create a basic CSS Grid layout using
inline-block is a great tool to use when you need items to display next to each other with good browser support. While inline block elements layout similar to inline (text) elements, they respect padding and margins like a block element.