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

Time tracking DIY for small business

I just came out of my „Excel factory” where I have been working on a simple time tracking model. Since not all companies have implemented a system based on retina scan or an access card to get information on time spent at work, I made a simple model in Excel, which is an easier way for tracking […]

in Excel | 259 Words | Comment

Building a free applicant tracking system [video]

An important part of my job is about recruitment. I offer recruitment services to my clients, and of course they give me the “easy” jobs. I always needed a good applicant tracking system that was both simple and inexpensive, could’t find one. This is why I build a simple one myself, using Evernote. You can see how, […]

in Evernote | 71 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

INDEX + MATCH Excel functions

In this article we will talk about the INDEX and MATCH formulas, which are two useful lookup functions when others (such as VLOOKUP) reach their limits. Do you like examples? I do, let’s be practical: Example The report below, which I know it’s very complicated, hard to understand (not). We see that the Sales box is empty, […]

in Excel | 540 Words | Comment

The F4 key in Excel

One thing you are probably using in Excel is multiplying formulas, you know, that thing that happens when you drag from the botton-right part of a cell. In this article we will try to understant the “mistery” behind formula multiplication. We can take the image above as an example, we have 2 columns and want to apply […]

in Excel | 416 Words | Comment

Date warning in Excel

Recently a friend who works in tourism asked me for a little Excel related help. He is working in the housekeeping department in a relatively large hotel and needed help with keeping track with the expiry date of products. He had a report that had all the rooms in the hotel and expiry dates for each product. He wanted […]

in Excel | 385 Words | 3 Comments

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

Pareto chart in Excel

In case you didn’t hear about Pareto, let me shed a little light. He is the person that gave us the Pareto principle, also known as the 80/20 rule or the uneven distribution principle. It’s not my point to tell you the story of his life, you with a short Googl’ing session you can find out […]

in Excel | 436 Words | Comment

Post navigation

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