5 Easy Steps to Make Your Excel Charts Look Professional

Why do Excel charts usually look so ugly? Ok, they look a lot better in newer versions of Excel than they did before, but you still need to make a few changes if you want them to look good enough for a presentation.

These are the 5 things you need to do to make your Excel chart look professional:

READ MORE

Create a dynamic drop-down menu in Excel in 4 easy steps

 

In a previous post we learned how to make an Excel drop-down menu in 3 minutes. In this post I will show a very easy way to make a drop-down list in Excel that changes depending on what you have chosen in another cell. It’s easy, and it only takes five minutes!

Step 1: Enter the data

It is absolutely critical that the data table is set up correctly: The main category (the countries in this example) should be in one column, and the sub-categories (the cities) in the other columns, with the countries repeated as headings.

READ MORE

Create a report in Excel in 5 minutes – Beginner’s tutorial

Even if you have never used Microsoft Excel before, it only takes 5 minutes to learn how to make a simple report. Once you have done the exercise below, you will be able to create your own sales reports, commission reports, or household budget.

In this post we will create a sales report in 5 steps. You will be amazed by how easy it is!

Let’s get started!

READ MORE

Create a Search Box in Excel without VBA

Is it possible to create a search box in Excel, without using VBA?

Yes, and it’s easy!

We will use Conditional Formatting to highlight the fields that match the search string. For example, if you look at the table below, we want to highlight row 8, 11, 15 and 25 if we search for “RG”, because “RG” is part of the product name in those rows.

READ MORE