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
Filed under Easy tricks …
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
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
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
Boolean logic in Excel: TRUE/FALSE instead of IF functions
A new version of this article has been published here: http://easy-excel.com/?p=638 Why use the IF function when there is an easier way to do it? If you’re looking for a TRUE or FALSE answer, you don’t need it! Let’s use Boolean logic instead – it will save you a lot of time and struggle. Let’s look at an … Continue reading
Copy as Picture in Excel
If you copy and paste from an Excel workbook into e.g. Word, everything suddenly looks different. The gridlines disappear, and Word might also change the width of the columns and the height of the rows. What we want to do is to take a snapshot; to copy as a picture. But how? In Excel 2007 … Continue reading
Excel is easy! 