A lot about my work is related to delivering MS Excel trainings, the last one was just yesterday actually. I get all kinds of questions, one that stuck with me was: Radu, how can I prevent someone from inserting new rows or columns in a sheet and, in the same time, enable them to fill […]

Radu, how do I get the decimal value from a number using Excel? Well, there is the short answer and then there is the long answer. Here is the short one, see image bellow. And in case you missed the formula here it is. If you are familiar with Excel, probably it’s pretty easy to […]

Radu, is there a simple way to send emails from Excel? I have a file with approvals and I want the people involved in the process to be nitified when we someone hits the “approve” button. This was a question I received from one of the participants in one of my advanced Excel courses. My […]

Radu, how to you create a population pyramid chart in Excel? This is a question that I received a while ago from one of the cool people I met during one of my Excel courses that I deliver in Romania. Great question, let’s see how. Population pyramid? First things first, what is a population pyramid […]

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

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

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