The Conversation: Excel autocorrect errors still plague genetic research, raising concerns over scientific rigour

The Conversation: Excel autocorrect errors still plague genetic research, raising concerns over scientific rigour. “Autocorrection, or predictive text, is a common feature of many modern tech tools, from internet searches to messaging apps and word processors. Autocorrection can be a blessing, but when the algorithm makes mistakes it can change the message in dramatic and sometimes hilarious ways. Our research shows autocorrect errors, particularly in Excel spreadsheets, can also make a mess of gene names in genetic research.”

Google Workspace Updates: New intelligent suggestions for formulas and functions in Google Sheets

Google Workspace Updates: New intelligent suggestions for formulas and functions in Google Sheets. “Formula suggestions will make it easier to write new formulas accurately and help make data analysis quicker and easier. Simply begin inserting a formula in Sheets—suggestions will be automatically displayed and as you continue to type. You can view additional incremental suggestions in the drop-down menu.”

Search Engine Journal: How to Use Google Sheets for Web Scraping & Campaign Building

Search Engine Journal: How to Use Google Sheets for Web Scraping & Campaign Building. “According to Google’s support page, IMPORTXML ‘imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.’ Essentially, IMPORTXML is a function allows you to scrape structured data from webpages — no coding knowledge required. For example, it’s quick and easy to extract data such as page titles, descriptions, or links, but also more complex information.”

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.”