Standardization and Modification of URLs in Excel & Google Docs

Zdeněk Nešpor Excel Leave a Comment

A practical tutorial on how to standardize and modify URL datasets in Excel, Google Sheets, or other table processors. I’ll teach you how to clean up trailing slashes, WWW subdomain, change HTTP to HTTPS, and much more useful tricks for trimming or concatenating URLs. You’ll appreciate this information during work with the complex datasets, preparing redirection tables, or experimenting.

Data, Information, Visualisation – Vol I.

Zdeněk Nešpor Visualisation Leave a Comment

Collection of five exciting data visualizations, infographics, and tips for working with data. This time we’re looking at people migration, text analytics, air traffic, and fonts. In each section, you will find necessary information, author Twitter accounts, links for used technologies, data downloads, and sources.