Protect sheet in Google Sheets

Ok, so you crafted a really nice spreadsheet that you want to share with others. And you know what happens when others have access, formulas get broken, formatting also, very fun. This is when you start googling Protect sheet Google Sheets You probably know how to do it in Excel, let’s see how it is done in Google […]

Import range in Google Sheets [video]

If you have worked in Excel and you got to a more advanced level, you probably found the import features, MS Query and ODBC very usefull. If you since moved to Google Sheets you probably looked for an alternative to get information from one sheet / document to another. Look no more, this is what the […]

Tracking changes in Google Sheets [Video]

There are times when we want to know what were the latest changes that were made to a document. Maybe we are working on a very important document, one that will stop world hunger, cure cancer or let us know the latest of celebrity gossip. In this brief video I describe the features that Google Sheets […]

Data validation in Google Sheets [video]

One of the strenghts of Google Sheets lies in its collaboration options. We can all work together on the same document, etc. you know the story. When however you have too many chefs in the kitchen with no rules, things can go bad. In this short video you will see how you can set validation rules in Google […]

Excel / Google Sheets formulas: LEFT, RIGHT, SEARCH, LEN, CONCATENATE

I am continuing a small series of articles about formulas that we can use in both Excel and Google Sheets. I find formulas very useful in helping me automate complex tasks and be overall more efficient. In this post I am want to put into context 4 formulas that deal with text: left, right, search, concatenate. I’ve […]

Data validation in Google Sheets

Let’s talk about a practical situation, you have decided that from now on, you and your Finance department will register all the company expenses in Google Sheets. Because everyone can edit things can be simpler from now on. On the other hand, if anyone can now edit, you should also think about some data validation rules, in order not to […]

Project budget template in Google Sheets

I have to admit that I like budgets, I don’t know why, but this is it. People laugh when I tell them that I used a budget in Excel for my wedding and while building my home and I don’t write my expenses on a piece of paper or a notebook like everyone else. Rigid budget templates I have seen many […]

Import Range in Google Sheets

Excel has some nice data import features, I used them to build more complex reports that interact. As I started using Google Sheets more I needed an equivalent for the import from Microsoft Query feature. The thing I was looking for is called Import Range and this is how you can use it. When is it useful Duplicating information is not […]

How to build a free CRM using Google Sheets

Let’s talk about the client you forgot to call back and lost to the competition, or the one that got angry on you or your business because you didn’t remember you called yesterday about the same promotion. Life would be much easier if you had a system that reminded you about all these things, there is […]

New mobile apps for Google Drive – so what

Google announced that they are creating standalone apps for Google Sheets, Google Docs. Google Slides is on its way and will be coming soon. Let’s see what are the implications of this. So what That was my first reaction also, I assumed that nothing changed and they just cloned the apps that were already included in the Drive […]