How-to Create and Copy a Table in Google Mail (Gmail) from Excel
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
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
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
For almost every Excel Dashboard you will want to make a Chart template Dynamic. Meaning that as you add new data, the chart updates...
