How To Use Excel Data Types and When You Might Not Want To

Microsoft recently introduced a feature called “Data Types” into Excel 365. Unlike the regular Excel data types like Dates, Numbers, and Text, this feature relies on the internet to bring external data points into your Excel sheets. They call them linked data types. The implementation is a lot easier to use than creating a query or using VBA to bring data to Excel, but it’s pretty limited in its current form and probably wouldn’t be very valuable to most users. Right now, it’s limited to Stock and Geography data.

Converting a set of stock tickers to the Stocks data type.
Continue reading “How To Use Excel Data Types and When You Might Not Want To”

BeautifulSoup 4 Python Web Scraping to CSV Excel File

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”

CSS display: inline-block Explained by Creating a Grid

In this tutorial, we are going to create a basic CSS Grid layout using display: inline-block. 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.

Continue reading “CSS display: inline-block Explained by Creating a Grid”