This post is for all you people out there who have subscribed to e-mail updates when I publish new posts: This is probably the last update you will get! A while ago I purchased my own domain at http://www.easy-excel.com, and that is where you will find my Excel articles in the future. If you have … Continue reading
Posted by Audun Danielsen …
New post at the new blog
I know a lot of you still follow me on this blog, maybe even wondering why I never update it anymore. Actually, I do update my blog, but it has moved to another address: easy-excel.com! Here’s today’s article: Use a wildcard in Excel to make SUMIFS and COUNTIFS more flexible If you’re using a non-English version … Continue reading
A New Blog!
When I started this blog I didn’t expect more than a few readers a week. Actually, I thought a blog would be a good means of structuring my thoughts and ideas, and I was happy if anyone bothered to read it. After a while, it turned out that a lot more than a few people … Continue reading
Trace Dependents before you delete a cell in Excel
An updated version of this post has been published here: http://easy-excel.com/?p=356 Have you ever deleted something from an Excel Workbook, only to discover that all your formulas suddenly return #REF or #VALUE, or something else you didn’t expect? There is an easy way to avoid that. Before you delete a cell, always check first if … Continue reading
How to protect cells in your Excel report in 3 easy steps
A new version of this post has been published here: http://easy-excel.com/?p=561 Why is it important to protect cells? If you create an Excel report for someone, it is important that you somehow visualise which cells they are allowed to change, and which cells they should not touch. The common way to do this is to use … Continue reading
How VLOOKUP can get you in trouble and how to solve it
An updated version of this post has been published here: http://easy-excel.com/?p=683 An Extra Column Means Trouble If you want to find a value in a table in Excel, a simple VLOOKUP function is usually a good and easy way to do it. But you have to be careful – if you insert a new column … Continue reading
Save Time By Changing Default Chart Template in Excel
Save your favourite chart settings As I wrote in a previous post, the default charts in Excel don’t look very nice, and I described how you can make a column chart look great in just a few minutes. If you find yourself doing the same amendments every time you make a chart, it might be … Continue reading
The Easy Way to Calculate Grades in Excel
An updated version of this post has been published on my new site: http://easy-excel.com/?p=730 How can we calculate the grades (A-F) in Excel if we have the test results as numbers? We know that a score of 90% or higher is an A, 80-89% is a B, 70-79% is a C, 65-69% is a D … Continue reading
Excel Line Chart: How to prevent the line from dropping to zero
A new version of this article has been published here: http://easy-excel.com/?p=526 Let’s say you have a table where you enter new sales figures every day, and a line chart connected to it. The sales figures for the last few days in the table have not yet been filled out, so the last six values for the … Continue reading
Highlight Entire Row In Excel Based On One Cell
A NEW VERSION OF THIS POST HAS BEEN PUBLISHED HERE: http://easy-excel.com/?p=337 Do you want to highlight the entire row in your Excel report based on the value of one of the cells in the row? There is an easy way to do this in Excel: Conditional Formatting. It’s easy, and it only takes 3 minutes! … Continue reading
Find Duplicates and Triplicates in Excel
A NEW VERSION OF THIS POST HAS BEEN PUBLISHED HERE: http://easy-excel.com/?p=503 Is there an easy way to highlight duplicates in a list in Excel? If you just want to remove duplicates, you can use the Advanced Filter or the built-in Remove Duplicates feature, but what if you want to keep the duplicates in the list and … Continue reading
Create a search field in Excel in 5 minutes
A NEW VERSION OF THIS POST HAS BEEN PUBLISHED HERE: http://easy-excel.com/?p=158 Is it possible to create a search field 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 … Continue reading