How to Clean Data in Excel

how-to-clean-data-in-Excel

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

Gauge Chart Add-in

Gauge chart add-in

The Gauge Chart Add-in is a powerful tool for creating advanced Key Performance Indicator (KPI) dashboards in Excel.

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.

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.

Excel Add-in Ribbon Disappears

Excel Add-in Ribbon Disappears After Installation

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.

How to install an Excel Add-in

How to install an Excel Add-in

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

Color ranking in Excel

color ranking excel

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

Create Heat Map in Excel

heat map

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

Drop-down list in Excel

drop-down-list-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.

Excel Formula Audit Tool

excel-formula-audit-feat

The Excel Formula Audit Tool only covers the basic functions. Let us see an effective solution with large tables and formulas.

Excel Sorting Data Tips

Excel Sorting Data Tips

How to sort dynamically a list containing two columns (‘Product’ and ‘Sales’ columns) at will only using excel functions?

Excel Sparklines

excel-sparklines

How to insert sparklines in Excel? In this article, you will learn all about sparklines. Get some useful examples!

Use sparklines to show data trends! In a nutshell, sparklines are tiny in-cell graphs. With its help, you can offer powerful insights in a small space, which is important if you want to tell your story on a single page. We use three types in Excel: line, column, and win/loss.

Gantt Chart

gantt chart excel template

Gantt chart templates are useful tools for managing and scheduling projects in Excel.