Radu Popa
Radu Popa
Dad, Tech Trainer, HR Consultant
  • Facebook
  • YouTube
Skip to content
  • Online courses
  • Facebook group
  • Contact

Google Sheets

There are 10 posts filed in Google Sheets (this is page 1 of 1).

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 […]

in Google Sheets | 160 Words | Comment

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 […]

in Google Sheets | 93 Words | Comment

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 […]

in Google Sheets | 87 Words | Comment

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 […]

in Google Sheets | 90 Words | Comment

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 […]

in Excel, Google Sheets | 454 Words | 2 Comments

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 […]

in Google Sheets | 430 Words | Comment

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 […]

in Google Sheets | 436 Words | Comment

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 […]

in Google Sheets | 255 Words | Comment

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 […]

in Google Sheets | 748 Words | Comment

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 […]

in Google Docs, Google Sheets | 268 Words | Comment

Top posts

  • Free Excel online course: the ultimate guide
  • Excel Test - Intermediate Level
  • PowerPoint 2016 Zoom - aka Prezi in PowerPoint
  • Protect sheet in Google Sheets
  • Data validation in Google Sheets

Categories

Eventbrite Evernote Excel Gmail Google Docs Google Drive Google Sheets JotForm MailChimp PowerPoint Random Todoist Trello

Follow me on YouTube

Ads

Independent Publisher empowered by WordPress
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we assume that you are happy with it.Ok