Tutorials

The following guide explains the basics of creating an Excel Chart and saving it as a template using a few easy steps.

Using multiple rules in Excel conditional formatting is not rocket science. Learn how the rules hierarchy and overlapping are works.

Discover how to drill down into a Pivot table in Excel. Then, let us take a closer look and learn how to use the Quick Explore function.

In this article, you will learn about key performance indicators. Is it easy to create a KPI? From the technological view, yes.

As developers, it’s a challenge to pick the right color combinations for Dashboards. This guide shows the best color schemes and palettes.

Learn how to use conditional formatting based on another cell and create a rule that depends on another cell value in Excel.

This tutorial will show you how to consolidate multiple worksheets into one Pivot table using Microsoft Excel.

This tutorial will explain how to show protected cells in Excel using conditional formatting, Microsoft Inquiry, or Search and Replace.

This step-by-step tutorial covers how to insert VBA code in Excel to add and run a macro or a custom function.

Use a few steps to learn how to change shape color based on cell value in Excel. Get the VBA example or use conditional formatting!

This tutorial will show you how to fill a cell or a range using RGB color in Excel to create a gradient scale.

This article explains how to sort by color in Excel using conditional formatting, filter function, or VBA automation.

Learn how to compare two columns in Excel to find, highlight, or extract matches and differences using various methods.

Use Excel Tables to simplify your work! Learn how to create dynamic ranges with easy-to-read formulas using tables.

Our definitive guide will show you 15 ways to clean data in Excel. Learn more about data cleansing through useful examples.

Improve user experience (UX) using the ribbon navigation menu. Learn how to create stunning navigation with minimal programming knowledge.

Learn how to find errors in a range using conditional formatting. We will apply a simple formula to identify missing or incorrect data.

A recent Microsoft Office update has caused add-in Ribbon Menu Bars to disappear when Excel is opened. This article explains the possible solutions to fix it.

Today’s article explains everything you need to know about how to install an excel add-in – or plugin, as it’s also known.

Discover how to align and group shapes in Excel! Learn how to use the ‘bring the front’ and the ‘send to back’ functions.

Use conditional formatting and the RANK function to learn how to use dynamic color ranking in Excel.

Use a heat map in Excel to create quick data visualizations! Today’s guide will be about how to build maps using conditional formatting.

How to combine multiple workbooks into one worksheet?

The Excel Table is a relatively seldom-used and underrated feature in Excel. But in today’s article, we’ll show you its advantages.

In today’s example we’ll introduce data entry with the help of the UserForm.

Learn how to enable the Developer tab on the Ribbon in Excel.

The Excel drop-down list is a great tool in the data validation group. It can be used in almost all Excel spreadsheets.

Create an Excel frequency distribution table in seconds with the help of our free DataXL automation add-in!