EU Startups: Berlin-based Layer raises €5 million to build an innovative productivity platform for spreadsheets

EU Startups: Berlin-based Layer raises €5 million to build an innovative productivity platform for spreadsheets “Layer allows spreadsheet users to request data and input from colleagues and give granular access down to individual cells, improving collaboration and overall productivity. The web app can be used within seconds without any additional plugins or installations and sits on top of your existing Microsoft Excel and Google Sheets files.”

TechCrunch: Google Sheets will soon be able to autocomplete data for you

TechCrunch: Google Sheets will soon be able to autocomplete data for you. “Google today announced a couple of updates to Google Sheets that will make building spreadsheets and analyzing data in them a little bit easier. The most interesting feature here, surely, is the upcoming launch of Smart Fill. You can think of it as Smart Compose, the feature that automatically tries to finish your sentences in Gmail, but for spreadsheets. The idea here is that Smart Fill, which will launch later this year, can autocomplete your data for you.”

Digital Inspiration: How to Add Options in Google Forms Questions from Google Sheets

Digital Inspiration: How to Add Options in Google Forms Questions from Google Sheets. “As with everything else in the world of Google Forms and Google Sheets, we can easily automate the process of adding question choices in Google Forms in bulk with the help of, you guessed it right, Google Apps Script.”

Digital Inspiration: How to Get Hidden and Filtered Rows in Google Sheets with Google Script

Digital Inspiration: How to Get Hidden and Filtered Rows in Google Sheets with Google Script. “You can hide entire rows in Google Sheets manually or use filters to hide any rows that matches the specified criteria. For instance, if you have a sheet containing orders from different countries, you can set up a country filter to hide all rows where the country is not the United States. If you have a Google Script that iterates through each row in the Google Sheet for performing actions on the row, like sending emails or merging documents, you can check for the hidden and filtered rows and easily skip them from the workflow.”

Towards Data Science: How to Download a Specific Sheet by Name from a Google Spreadsheet as a CSV File

Towards Data Science: How to Download a Specific Sheet by Name from a Google Spreadsheet as a CSV File. “In the past two tutorials on Google Drive API with Python, we have covered how to obtain credentials here and search for a specific file in Google Drive by its name here. In this tutorial, we are going to learn how to download a specific Sheet by name from a Google Spreadsheet into a csv file. A use case for this: you need to generate a report, which data are stored in a Google Spreadsheet that has many Sheets, but you only need one or two of them. So, instead of downloading the whole Google Spreadsheet, you can handpick the Sheets that you need.”

Digital Inspiration: How to Use Formulas with Google Form Responses in Sheets

Digital Inspiration: How to Use Formulas with Google Form Responses in Sheets. “When people submit your Google Form, a new row is inserted in the Google Sheet that is storing the form responses. This spreadsheet row contains a Timestamp column, the actual date when the form was submitted, and the other columns in the sheet contain all the user’s answers, one per column. You can extend the Google Forms sheet to also include formula fields and the cell values are automatically calculated whenever a new row is added to the sheet by the Google Form.”

Analytics Vidhya: 10+ Simple Yet Powerful Excel Tricks for Data Analysis

Analytics Vidhya: 10+ Simple Yet Powerful Excel Tricks for Data Analysis. “I’ve always admired the immense power of Excel. This software is not only capable of doing basic data computations, but you can also perform data analysis using it. It is widely used for many purposes including the likes of financial modeling and business planning. It can become a good stepping stone for people who are new to the world of business analytics.”

Holy sheet: Even YOU can budget… with Google Sheets (The Next Web)

The Next Web: Holy sheet: Even YOU can budget… with Google Sheets. “There are lots of budgeting spreadsheet templates available on the web. Many of them require quite a bit of work, like filling in all of the specific transactions you conduct. However, that isn’t really necessary for a consistent, personal budget, especially if you have a fairly consistent stream of income and expenses. So we’re here to provide you with an accessible way to budget — a very simple though effective (if you stick to it, of course) template; one that doesn’t require much maintenance, and still gives you a concise glance at what comes in, what goes out, and how much you’re saving per month.”

Holy sheet: How to track your stock portfolio with Google Sheets (The Next Web)

The Next Web: Holy sheet: How to track your stock portfolio with Google Sheets. “Recently, millennials have been bombarded with a slew of new personal finance apps. It seems as if budgeting, saving, and investing is all the rage nowadays, and that everyone’s aiming for FIRE (Financial Independence Retire Early). But again, you don’t really need a fancy app to do all of that.”

The Verge: You can now make sick beats in Microsoft Excel

The Verge: You can now make sick beats in Microsoft Excel. “Late last year, electronic musician and YouTuber Dylan Tallchief made a functional drum machine in Microsoft Excel after a bunch of Excel DAW memes made their way around social media. Now, Tallchief is back with an even more ambitious project that fully realizes the original meme’s potential: an Excel DAW he calls xlStudio. (For those outside the audio world, DAW stands for ‘digital audio workstation’ and is a software suite like Ableton or FL Studio used for making music.)”

Towards Data Science: Analyze and Track Freelance Revenue with Google Calendar and Pandas

Towards Data Science: Analyze and Track Freelance Revenue with Google Calendar and Pandas. “My life and work schedules are run by Google Calendar — this includes all of my private classes, bike/photography tours, academy work, governmental positions, translation gigs, and random freelance jobs. Every ‘unit’ of paid work is in the calendar; I simply needed to figure out a way to directly access the Google Calendar data and rebuild my spreadsheet into a sustainable analyzing machine. In my previous corporate life, I worked exclusively in the world of Pandas Notebooks (Python framework for analyzing data) — therefore it was a natural solution to leverage those tools to access my class schedule from Google Calendar and utilize Pandas to process and analyze the revenue data.”

CBR: Forced Google Sheets Migration Leaves Users Fuming Over Broken Services

CBR: Forced Google Sheets Migration Leaves Users Fuming Over Broken Services. “Developers are up in arms over a forced migration to version four of Google Sheets in March 2020, saying the migration breaks numerous functionalities…. A key feature used by programmers in Google Sheets v3 was the ability to run structured queries on Sheets that returned only matching rows.”

Lifehacker: Preserve Data From Your Apps on a Spreadsheet

Lifehacker: Preserve Data From Your Apps on a Spreadsheet. “My spreadsheet recaptures much of the information collected by my apps—workflow, scheduling, finances, health, and so on—in a document that I both control and update myself. I started developing this spreadsheet in 2013, and am now beginning my sixth year of record-keeping. The current version of the spreadsheet includes separate sheets for my daily schedule and workflow, my Getting Things Done action item list, my finances, my meal planning, and my health.”

CNBC: This developer was surprised that Apple Card didn’t let him download spending data, so he built a fix

CNBC: This developer was surprised that Apple Card didn’t let him download spending data, so he built a fix. “The Apple Card was designed to be loaded into a user’s iPhone, with spending history living inside the Wallet app and transaction data arranged in a colorful interactive interface. But consumers who want to analyze their transactions in Microsoft Excel or Google Sheets for tax or budgeting purposes, a tool that many credit card companies offer, are out of luck.”