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 2 of 3).

Post navigation

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

in Excel | 85 Words | Comment

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

in Excel | 190 Words | Comment

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

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

Get rid of #N/As with IFERROR

I am starting a series of articles on formulas in Excel and Google Sheets. I am putting these 2 together because most of the formulas work on both platforms pretty much the same way. I will skip the basics, like SUM or AVERAGE and will try to write about the formulas that do not get invited […]

in Excel | 176 Words | Comment

How to add data to a chart in Excel

Let me start this post by describing the steps most people take when creating a chart in Excel: Prepare a table that contains the data set Select that table Click on the insert chart icon Hope that the chart will look exactly like I want it to Don’t get me wrong, I don’t have anything against […]

in Excel | 130 Words | Comment

Post navigation

Follow me on YouTube

Top posts

  • Think you are good in Excel? here is what you should know
  • Date warning in Excel
  • Population pyramid chart in Excel

Categories

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

Ads

Independent Publisher empowered by WordPress