Tag Archives: google sheets

How to sync data using Google Apps Script in Google Sheets

In episode 12, I talked about how you can use the IMPORTRANGE() function in Google Sheets to import data form a source Google Sheet to a target Google Sheet. In this episode, I get a little more technical and discuss how you can import data using Google Apps Script. If you want to read the […]

How to import data from one Google Sheet to another

Have you ever wanted to share data from one Google Sheet with another Google Sheet? Maybe you are a freelancer and have multiple clients, and keep all the payment data in one Google Sheet but need to send updates to your clients without sharing all your clients’ data. In this scenario, setting up one individual […]

Should you ditch Microsoft Excel for Google Sheets?

Google Sheets or Microsoft Excel? An age-old question since Google Sheets came onto the scene in 2006. Many saw Google Sheets just as a copycat of Excel that lacked most of Excel’s features. Over the years, Google Sheets has caught up with Excel’s many features including the number of formulas, PivotTables, and even macros. To […]

Productivity Apps to Help Your Team

Following the last post about productivity tools and cloud computing, I did some more research on productivity apps to help your team collaborate and work more effectively. The main criteria are that the app had to be 1) browser-based (reasons for this mentioned in the previous post) and 2) multi-user collaboration is allowed. Having been an early […]

Microsoft Excel’s Autocorrect Feature Is Causing Geneticists Headaches

The summer is coming to a close, and we have some really awesome blog posts coming up that will blow your data-driven/Excel minds! We’re going to be reviewing an awesome tool someone sent us that shows you how to remember shortcuts, and a new tool to help you ladies out there plan your bachelorette parties. […]

Excel Shortcuts From Lifehacker & Microsoft Excel Online

Hope your summer is off to a great start! Whether you just graduated from school or getting ready for your summer vacation, we hope you keep your Excel skills–and more broadly–your analytical skills up to speed. We discovered a really cool site called MBA Excel which shows a bunch of tips and tricks in Excel. […]

sumproduct formula

Splitting Costs With Friends Just Got Easier In A Spreadsheet [+Template]

How many times have you gone on a group trip with friends, and figure out the costs at the end of the trip? Maybe one person pays for the hotel, one person pays for the rental car, and someone else pays for the dinners. Or maybe one person pays for everything, making splitting costs much […]