Learn how to find errors in a range using conditional formatting. We will apply a simple formula to identificate missing or incorrect data. Manual data entry in Excel, not the … Read more
A recent Microsoft Office security update (for July 2016) has caused add-in Ribbon Menu Bars to disappear when Excel is opened. What a frustrating issue! This article explains the possible … Read more
Today’s article explains everything you need to know about how to install an excel add-in – or plugin, as it’s also known. We’ll show you what it is, why it’s … Read more
In this tutorial, we’ll show you how to extract matches and differences using lists. The article is a part of our in-depth tutorial about how to compare two columns in … Read more
Discover how to align and group shapes in Excel! Learn how to use the ‘bring the front’ and the ‘send to back’ functions. Now that we have explained the role … Read more
Learn how to use dynamic color ranking in Excel using conditional formatting and RANK function. In this article, we will discover how to apply the Rank function in Excel and … Read more
Use a heat map in Excel for rapid visualizations! We’ll show you various solutions to create heat maps and dynamic colored shapes. This tutorial will provide a detailed introduction of … Read more
Sometimes we are faced with this question: How to compare two columns in Excel? It can be a challenge to use the most effective way to reach the result. The … Read more
Conditional formatting enables us to apply special formatting to cells and ranges that meet a given criterion. Excel contains a large library of predefined formulas. But if these are just … Read more
In this tutorial, we’ll explain how to highlight every other row in Excel. We’ll show you how to improve the readability of your spreadsheet and shade alternate rows. As first, you’ll learn how to highlight every other row using conditional formatting. After that, we’ll introduce the excel-table based solution. Finally, we’ll write a short macro to get the work even faster for shading every other row.
Excel Sorting Data Tips – With the help of Excel Sorting Data Tips we looking for solutions for very interesting problems today. How to sort dynamically a list containing two columns (‘Product’ and ‘Sales’ columns) at will only using excel functions? On the second worksheet we will show you a solution based on the on the fly sorting technique. It is well capable of give us help in creating an excel dashboard or other visualization tasks especially when available space is scarce.