The CoinMarketCap Pro API is a great source for cryptocurrency data on current and historical prices, exchange information and more. If it is your wish to use Excel to import CoinMarketCap API data, and have it updated live, look no further. In this article, I will show you how to use a query to import current prices into Excel and have them updated regularly using the methods shown in the Import JSON Data in Excel article. Be aware that this works best with Excel 2016 or greater, and doesn’t work with Excel for Mac. If you are using Excel 2013 or prior, you will need to install Power Query before attempting these steps.Continue reading “Excel Import CoinMarketCap API Data with Query”
In this article, we will create an Excel function to calculate the distance between two addresses using the Google Maps directions API. This will allow you to get the travel time between the two locations. The format of the function will be as follows:
=TRAVELTIME(origin, destination, api_key),
=TRAVELDISTANCE(origin, destination, apikey). The origin and destination will be strings, and can be either an exact address or the name of a place. In order to use the function, an API key is required. The “Getting Started” page can help you with this: http://bit.ly/googlemapsgettingstarted. Create a new project and make sure the Directions API is added.
If you have a list of email addresses in Excel that you need to validate follow proper format, or would like to prevent other Excel users from entering invalid addresses in a column, use Data Validation. By using a custom formula as the validation criteria, email address validation can be done. To get started, with the cells you need validated selected go to Data > Data Validation.Continue reading “Excel Email Validation with Data Validation Tools”
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”
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.Continue reading “How To Use Excel Data Types and When You Might Not Want To”
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”
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.
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”