How to create a progress bar chart in Excel

Lately I’ve been very interested in Excel charts. In this article I will show you how to create a progress bar chart in Excel. Progress bar chart? I want to create a chart that allows me to monitor progress towards a target. In the image above, the target is represented by the gray bar, and […]

Highlight whole row with conditional formatting

A part of my jos is to teach people how to use Excel. I get many questions and one that seemed interesting for me was this one: “Radu, how can I highlight a whole row with conditional formatting?” About conditional formatting Let’s start with the begining, what is conditional formatting in Excel? it’s pretty simple, it’s […]

Excel Test – Intermediate Level

So, how good are you with Excel? In this article you will find a test that can help you evaluate your skills. Disclaimer I deliver Excel trainings for a living. I understand that a test like this is somewhat limited. Knowing how to use Excel is more about solving problems than knowing the theory. The […]

Think you are good in Excel? here is what you should know

Have you ever received the following question during an interview? “so, how well do you know to work in MS Excel?” Like most people, you probably said:“I am pretty good, I know how to use Excel”. Hmm, really What does good really mean? some people thing that good is knowing how to work with filters and […]

How I organize my consulting projects with Trello

Let’s start with a bit of context, I work as an HR consultant in Romania. A part of my job is about training, another part is about recruitment and the third part is about other stuff. Most of my work is around projects and probably if you are working as a consultant or a freelancer your […]

Get rid of ads with Evernote Clearly

Let me start with an obvious thing: I use ads on my site. I try to make the ad blocks suck less, but let’s face it, few people like them. So if the ads on my site bother you, let me introduce a solution, Evernote clearly. Evernote Clearly is a browser extension that helps you focus on the content […]

So what is the deal with Excel Pivot Charts

Ok, so what is the deal with Excel Pivot Charts? That was the question I tried to answer in this session of my Excel Data Analyst course that I posted on Udemy. Don’t think that I should have a great intro here, if you want to answer the question above, and if you want a step by […]

How to organize Evernote: 5 ways and a bonus

I’ve been using Evernote for a few years now, and as I am writing this article I have 3722 notes in my account and about 600+ in trash. I know there are more heavy users than me out there, but even in my case as the notes count grew, I found finding the stuff I needed started […]

66 places to go to for online software training – a massive list

Developers have built great apps to make our work and personal life much easier. There is an app for almost anything that we can think of, the only challenge lies in our skill to use these apps. Maybe this is why online training has really took of in the past years. I was curious to see where […]

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