Ribbon Navigation Menu

ribbon navigation menu

Improve user experience (UX) using the ribbon navigation menu. Learn how to create stunning navigation with minimal programming knowledge. Prototyping your navigation menu before building an excel dashboard enables you … Read more

Find errors in a range

find errors and blanks in a range excel

Learn how to find errors in a range using conditional formatting. We will apply a simple formula to identify missing or incorrect data. Manual data entry in Excel is not … Read more

Excel Add-in Ribbon Disappears

Excel Add-in Ribbon Disappears After Installation

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

How to install an Excel Add-in

how to install an excel add-in feat

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

Extract Matches and Differences

extract matches differences vba fi

This tutorial will 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 Excel … Read more

Color ranking in Excel

color ranking excel

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

Create Heat Map in Excel

heat map

Use a heat map in Excel for rapid visualizations! We’ll show you various solutions to create heat maps and dynamic colored shapes. First, this tutorial will provide a detailed introduction … Read more

How to compare two columns in Excel

compare two columns in excel higlhlight matches

Learn how to compare two columns in Excel to highlight matches and differences using functions and conditional formatting! It can be a challenge to use the most effective way to … Read more

How to sort by color in Excel

sort by color excel

We frequently ask: How to sort by color in Excel? The answer is easy. Be smart! We will show you the most used tricks. In this tutorial, we’ll start from the ground up. We hope you may find helpful when you want to use time-saving solutions to sort data by color.

Excel Sorting Data Tips

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.