PopSugar: Celebrate Pride at Your 9 to 5 With This Google Sheets Hack That’ll Transform Any Spreadsheet

PopSugar: Celebrate Pride at Your 9 to 5 With This Google Sheets Hack That’ll Transform Any Spreadsheet. “Pride 2021 is here, and it’s a time to celebrate both on and offline! While parades and parties are a huge part of the month to celebrate and uplift the LGBTQ+ community, sometimes our computers call and we must answer. Luckily, Google Sheets is just as ready to partake in Pride festivities as we are, and the newest hack we learned just made sitting at our desks much more enjoyable.”

MakeUseOf: How to Make a 3D Map in Excel

MakeUseOf: How to Make a 3D Map in Excel. “When visualizing and exploring geographic data, you can use Microsoft 3D Maps in Excel to project and analyze the data in a more meaningful way. Excel includes the Microsoft 3D Maps, a brand new tool to plot 3D charts using geographical data. This tool is available to Excel users from the 2016 version of Microsoft Office. Microsoft 3D Maps tool enables you to explore geodata in a new and effective approach.” You might see the first three numbered paragraphs and think, “Ugh, shallow overview article with no how-to.” Keep going; Tamal Das gets to the good Excel stuff pretty quick.

VentureBeat: Rows raises $16 million and launches next-gen spreadsheets with built-in data integrations

VentureBeat: Rows raises $16 million and launches next-gen spreadsheets with built-in data integrations . “Founded out of Berlin in 2016 as Dashdash before its rebrand just a few months back, Rows is targeting business teams with a new online spreadsheet platform that features native integrations with third-party services such as Salesforce, Slack, Stripe, Google Maps, and LinkedIn, while also making it easy to transform the spreadsheet into a fully functional web app in a single click. Moreover, Rows supports all the familiar Excel functions, such as SUMIFs, that business users are already accustomed to.”

The nightmare is real: ‘Excel formulas are the world’s most widely used programming language,’ says Microsoft (The Register)

The Register: The nightmare is real: ‘Excel formulas are the world’s most widely used programming language,’ says Microsoft. “Microsoft will let users create custom functions in Excel using the number wrangler’s own formula language….Dubbed LAMBDA, the feature (currently rolling out to beta customers) will be a lifesaver for anyone charged with maintaining herds of increasingly complicated spreadsheets, who have doubtlessly been wondering how it could be that Excel was missing such a seemingly obvious ability for so many decades.”

Dev: How to Use Google Sheets as a Database (Responsibly)

Dev: How to Use Google Sheets as a Database (Responsibly). “While database technology and other tools have come a long way, it’s still tough to beat the humble spreadsheet’s versatility and intuitiveness. While using them for sensitive, critical applications like storing COVID-19 patient data is ill-advised, the fact that everyone knows how to use a spreadsheet means they’re great for smaller cross-functional projects where a non-developer might need to examine or edit data. In this guide, I’ll show you how to use Google Sheets as a database, complete with an API interface accessible over HTTP.”

VentureBeat: Google’s Area 120 launches Tables, a rules-based automation platform for documents

VentureBeat: Google’s Area 120 launches Tables, a rules-based automation platform for documents. “Google’s Area 120 incubator today launched Tables, a work-tracking tool with IFTTT-like automation features and support for Google products, including Google Groups, Google Sheets, and more. Currently in beta in the U.S., Tables automates actions like collating data, checking multiple sources of data, and pasting data into other docs for handoff.”

Digital Inspiration: How to Highlight Duplicates in Google Sheets and Remove

Digital Inspiration: How to Highlight Duplicates in Google Sheets and Remove. “The Email Extractor app pulls emails addresses of your contacts from Gmail into a Google Sheet. You can then use Mail Merge or Document Studio to send personalized emails to your contacts from within the sheet itself. That said, the imported mailing list may sometimes have duplicate email addresses and it is thus be a good idea to clean up the data in your Google Sheet by removing duplicates before sending out the emails.”

More Digital Inspiration: Measure Core Web Vitals of your Websites with Google Sheets

More Digital Inspiration, because it’s too Amit to quit: Measure Core Web Vitals of your Websites with Google Sheets. “If you are looking to automatically measure core web vitals for multiple websites, maybe that of your competitor’s websites as well, here’s a Google Sheet that can help. The spreadsheet will not only help you measure vitals for multiple URLs but you can also visualize the change in various metrics over time with the help of sparklines.”

The Verge: Scientists rename human genes to stop Microsoft Excel from misreading them as dates

The Verge: Scientists rename human genes to stop Microsoft Excel from misreading them as dates. “There are tens of thousands of genes in the human genome: minuscule twists of DNA and RNA that combine to express all of the traits and characteristics that make each of us unique. Each gene is given a name and alphanumeric code, known as a symbol, which scientists use to coordinate research. But over the past year or so, some 27 human genes have been renamed, all because Microsoft Excel kept misreading their symbols as dates.”