How To Import FLV Files into Adobe Premiere CC

If you’ve ever tried to use an FLV file, perhaps a screen recording from OBS, in Premiere, you may have come across and annoying dialog box letting you know that the file format is not supported. Fear not, it’s simple to get the footage converted and working in Adobe Premiere.

Continue reading “How To Import FLV Files into Adobe Premiere CC”

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”

Import JSON Data in Excel 2016 or 2019 or Office 365 using a Get & Transform Query

If you have data stored in JSON format that you would like to import into Excel, it’s now very easy and doesn’t require any VBA to import data locally from the disk or from a web API. Watch the video or read the steps below!

Continue reading “Import JSON Data in Excel 2016 or 2019 or Office 365 using a Get & Transform Query”