Radu Popa
Radu Popa
Tech trainer, father of two
Skip to content
  • Online courses
  • Facebook group
  • Contact

Excel

There are 25 posts filed in Excel (this is page 1 of 3).

Post navigation

Compare Excel tables using Consolidate

Ever needed to compare tables in Excel. Hope you never did it row by row. 🙂 If you know a few things about Excel, you probably know hot to compare tables using VLOOKUP. You need 2 of them actually and then with a filter, you can get the job done. Comparing using Consolidate This method […]

in Excel | 116 Words | Comment

Free Excel online course: the ultimate guide

Searching for a free Excel online course? Check out my collection of Excel tutorials that will help you go from zero to ninja in Excel. Best I could find As there are lots of free tutorials about Excel on YouTube what I did in this article was to put the best together into a framework […]

in Excel | 1,660 Words | Comment

Protect sheet structure in Excel

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

in Excel | 171 Words | Comment

Get decimal value in Excel

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

in Excel | 310 Words | Comment

How to send emails from Excel (VBA code included)

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

in Excel | 433 Words | Comment

Population pyramid chart in Excel

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

in Excel | 224 Words | 2 Webmentions | Comment

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

in Excel | 167 Words | 6 Comments

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

in Excel | 194 Words | Comment

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

in Excel | 213 Words | 2 Webmentions | Comment

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

in Excel | 903 Words | Comment

Post navigation

Follow me on YouTube

Top posts

  • How I used Evernote while building my house
  • How to send emails from Excel (VBA code included)
  • Free Excel online course: the ultimate guide

Categories

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

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