How-to Create and Copy a Table in Google Mail (Gmail) from Excel

30
On a recent project of mine, I tasked a team member with creating a communication to send out to users.  This communication involved making...

How-to Insert Slicers into an Excel Pivot Table

In my last post, Think-like-a-database-designer-before-creating-an-excel-dashboard-chart we described the best way to configure your data to easily create your next dashboard. In this post, we explore the...

Friday Challenge Solution – Excel 2013 Data Labels on a Range

In our last Friday Challenge, Friday Challenge – Showing More Categories in an Excel Chart we were trying to help Kevin with his problem. He had followed...

Think Like a Database Designer Before Creating an Excel Dashboard Chart

Recently, a fan asked for some help.  However, when I got their file, I saw that they needed some help with basic concepts, so...

Case Study – Creating a Dynamic Chart in Excel Using Offset Formula

2
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function.  So Mili sent me the...

The Tricks to Writing a Conditional Formatting Rule Formula

0
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...

Friday Challenge – Analyzing Attendance Records with Six Sigma Charts

The following is a guest post from Pete on his answer to the most recent Friday Challenge. Pete applied his knowledge of Six Sigma to...

How-to Fake an Excel Chart Data Table

Fake an Excel Chart Data Table Yesterday, I showed you how you can use the Horizontal Axis option of “Multi-level Category Labels” to create a...

How-to Add a Shape to a PowerPoint Table and Make it Move and Size...

As a project manager or business analyst, we are often called upon to create dashboard type views in status reports for Executives. Typically, company executives...

How-to Make Dynamic Excel Dashboard Charts Using Tables

1
For almost every Excel Dashboard you will want to make a Chart template Dynamic.  Meaning that as you add new data, the chart updates...