Excel Dynamic Sorted Chart

Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.

Excel Dynamic Organizational Chart

Quickly create a data linked organizational chart in Excel with this new free tool available in Excel for Office 365. This free Visio addin can take data from an Excel table and visualize it as an Org chart.

Excel DGET Function

Quickly learn how to use Excel's DGET Function to lookup one or more criteria. DGET can also do a left lookup (unlike VLOOKUP). It's a forgotten Excel database function. Can you apply DGET to a range of cells? Find out in this article.

Progress Circle using Excel Doughnut Chart

Progress Circle using Excel Doughnut Chart When displaying progress, it is common to represent the percentage complete with an advancing bar. To make the visual more interesting, we can connect the ends together and form a circle. This looks eerily like an

Excel Fun – Mosaic Chart

GUESS what's HIDDEN in Excel? (Cool Trick) Who says Excel can’t be fun? We will show how you can bring some fun to your next meeting or lecture using only Excel and some creative uses of Excel features. We want to play

Project Plan in Excel with Gantt Chart

Project Plan in Excel with Gantt Chart 3 Views (Plan, Actual & Progress) in 1 View This article will show how to create a Gantt Chart in Excel that displays Actual and Planned task information in a single view.  The chart will

CHOOSE the RIGHT Chart Animation in PowerPoint

CHOOSE the RIGHT Chart Animation in PowerPoint Have you ever been tasked with presenting a chart or a graph in a meeting? If you are using PowerPoint during the presentation, the way you setup the PowerPoint slide matters. Let’s look and a

Excel Data Entry Form

SUPER EASY Excel Data Entry Form (NO VBA) In this post we will look at creating data entry forms in Excel. The best part is… NO VBA! Suppose you need to input data into an Excel table and you want to make

Charting Survey Results in Excel

Charting Survey Results in Excel (Visualize Employee Satisfaction results) This post spotlights a practical way to visualize survey results in Excel, particularly surveys that follow a “like/hurt” format.  Surveys, like employee surveys, that provide a range of choices between “Strongly Disagree” to

Highlight Max & Min Values in an Excel Line Chart

Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts) Is it possible to call attention to the highest and lowest values in a line chart dynamically?  Can we color or accent these values in the line chart