Author Archives: Audun Danielsen

How to Find Duplicates and Triplicates in Excel

Posted on by
20

Is there an easy way to locate and highlight duplicates in a list in Excel?

If you just want to remove the duplicates, the easiest way is to use the Advanced Filter or the built-in Remove Duplicates feature on the Data ribbon, but what if you want to find the duplicates in the list, keep them and highlight them with a different colour? That almost sounds like a job for a professional Excel consultant, but there’s no need for that – you can easily do it yourself! I’ll show you one easy way and one super-easy way:

READ MORE

How to Create an HTML Table with Excel

Posted on by
1

If you write something for a webpage, chances are that you write the text in HTML code. If you’re used to it, it often turns out to be easier than writing the text in a What-you-see-is-what-you-get-editor (WYSIWYG). In my experience, the WYSIWYG-editors never really work the way you want, so the HTML editor turns out to be better after all.

But what if you want to use a table that you have created in Excel? How can you transform an Excel table into a piece of HTML code that looks like this?

READ MORE

How to use Excel to Count Characters in a Text String

Posted on by
Reply

We often need to measure the length of a text, for example if we write a text that will appear on a website. Typically, in a web shop the product introduction text has to be of a certain length in order to fit within the frames.

Of course, the easiest way to do this is in Excel. This is extremely easy – it only takes a few seconds:

READ MORE

5 Easy Steps to Make Your Excel Charts Look Professional

Posted on by
Reply

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 can do to make your Excel chart look professional:

READ MORE

Today’s Shortcut: Open Format Cells Dialog Box

Posted on by
Reply
EasyExcel_19_Format Cells Dialog Box

There is one dialog box I use more than any other: The Format Cells dialog box. You don’t want to use the mouse to click your way through the menus every time you need this box, so here’s the most important shortcut in Excel:

Open Format Cells Dialog Box: Ctrl + 1

EasyExcel_19_Ctrl+1

Other Shortcuts:

Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.

How to avoid #DIV/0 and other Error Messages in Excel

Posted on by
Reply
EasyExcel_18_1_Avoid Error Messages

What does the error message #DIV/0 mean? Take a look at this table. It’s a sales report, with the total sales in column B, the number of hours in column C, and finally Sales per hour in column D.

Sales per hour is the total sales divided by the number of hours, and if the Hours field is empty, we are basically telling Excel to divide something by zero. Obviously, that’s impossible, and Excel returns an error message: #DIV/0.

The error message is there for a very good reason, but if we want to show this report to someone else, it would definitely look a lot better if it wasn’t there. Let’s see what we can do about it:

READ MORE