Invoice tracker in Excel [download]

In this article I want to give you a clever tool that I`ve use in the last 12 months for invoice tracking, free, no email sign-up or page like required. Why do I need such a thing? If you are a freelancer or small business owner (like me) you probably send out lots of invoices (hopefully). In […]

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

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

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

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

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

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

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