TechCrunch: Dropbase can help turn your messy spreadsheet into queryable SQL database

TechCrunch: Dropbase can help turn your messy spreadsheet into queryable SQL database. “It’s not unusual for a tech company to be born by accident. Famously, Slack was created as a byproduct of a now defunct gaming company. Similarly, when Dropbase founders Jimmy Chan and Ayazhan Zhakhan were in the Y Combinator Winter 20 batch, they were testing the product they had built at the time and accidentally stumbled upon the thing that would become Dropbase.”

Ars Technica: Excel esports on ESPN show world the pain of format errors

Ars Technica: Excel esports on ESPN show world the pain of format errors. “The Financial Modeling World Cup (FMWC) hosts regular international competitions, both invitational and open to anyone, in which Excel pros strive to solve as many questions as possible from a complex task. You can download all three of the tasks used in last weekend’s battle for free. ESPN showed a 30-minute edited version of the full two-hour-and-48-minute all-star battle between previous champions.”

ZDNet: Microsoft makes sharing Excel workbooks in Teams happen in real-time with ‘Excel Live’

ZDNet: Microsoft makes sharing Excel workbooks in Teams happen in real-time with ‘Excel Live’. “Microsoft is continuing to make real-time collaboration actually work inside Teams. Its latest effort in this space is called Excel Live. This feature will be available in public preview at the end of August. Microsoft officials announced Excel Live on Day 1 of the company’s annual Inspire partner conference on July 19.”

Search Engine Land: 11 Google Sheets formulas SEOs should know

Search Engine Land: 11 Google Sheets formulas SEOs should know. “While it’s not great at plotting ranking data (inverting the y-axis is always ugly), there are numerous ways to use Google Sheets for SEO. Here are 11 of the formulas and tips I find myself using for SEO on an almost daily basis – for keyword management, internationalization, content/URL management and dashboards.” Just ignore the SEO part. This is an excellent roundup of Google Sheets functions with quick, digestible examples.

Digital Inspiration: How to Auto-Download Podcasts to Google Drive with Google Sheets

Digital Inspiration: How to Auto-Download Podcasts to Google Drive with Google Sheets. “This tutorial describes how you can use Google Sheets to build your own podcast manager. You can specify a list of your favorite podcast shows in Google Sheets and it will automatically download new episodes to your Google Drive in neatly organized folders. The setup is very simple, the app is completely open-source and you need no programming language.”

Global Investigative Journalism Network: Video Resources for Data Investigations

Global Investigative Journalism Network: Video Resources for Data Investigations . “For 20 years, GIJN conferences have helped spread data journalism around the world. Our last Global Investigative Journalism Conference — GIJC21, held in November — was no different. GIJN’s first fully online conference featured a full track of data workshops and panels, ranging from analysis with spreadsheets and SQL to programming with R and Python, from tips on scraping and cleaning to data visualization and social network mapping. The sessions were led by a team of all-star trainers from seven countries. This is the second installment of GIJC21 videos, which until now have been available only to conference attendees.” All the videos I spot-checked had captions.

Android Police: Google Sheets cell limit doubles in new update, inching closer to Microsoft Excel

Android Police: Google Sheets cell limit doubles in new update, inching closer to Microsoft Excel. “How many cells would you say Google Sheets has? Take a wild guess — one million, maybe two? That used to be the case until Google increased the total number of cells in the spreadsheet from two million to five million in 2019. In an insane move, the company is now taking sheets from five million cells to 10 million to give users more space to work with.”

MakeUseOf: The 9 Best Google Sheets Formatting Tips for Creating Professional-Looking Spreadsheets

MakeUseOf: The 9 Best Google Sheets Formatting Tips for Creating Professional-Looking Spreadsheets. “There are so many ways to make Google Sheets look beautiful to impress with your data visuals. The majority of spreadsheet apps focus on the computation part, leaving the data visualization and formatting to the user. Therefore, if you don’t format your spreadsheet carefully, the audience may find it boring, since plain and simple data is not interesting. The same goes for Google Sheets.”

MakeUseOf: How to Input Data Into Excel Spreadsheets Using Your Phone’s Camera

MakeUseOf: How to Input Data Into Excel Spreadsheets Using Your Phone’s Camera. “Your phone camera can do much more than just take and edit selfies. You can use it to scan QR codes, search for photos on Pinterest, or identify anything using advanced image recognition technology. But did you also know that you can use your phone camera to input data into your Excel spreadsheets? This simple but powerful technique can save you time and improve your productivity with sheets.”

PC World: Top Excel experts will battle it out in an esports-like competition this weekend

PC World: Top Excel experts will battle it out in an esports-like competition this weekend. “No, this isn’t a joke. The Financial Modeling World Cup will be held this weekend entirely in Microsoft Excel. And the finals (the quarterfinals, semifinals, and the final match) will all be broadcast live as they happen at 9 AM PT. Everyone’s playing for a total prize of $10,000 — funded by Microsoft, of course.”

MakeUseOf: The 10 Best Google Sheet Quick Hacks You Probably Didn’t Know

MakeUseOf: The 10 Best Google Sheet Quick Hacks You Probably Didn’t Know . “You might have been using Google Sheets for storing and visualizing numerical data for both personal and collaborative work. However, it’s not only a spreadsheet tool with many rows, columns, and formulas. You can also use it to do various cool stuff to wow your audience. In this article, we’ll introduce you to some of the best Google Sheet hacks you need to know to become a master of the platform.” Nice roundup.