Gmail
How-to Create and Copy a Table in Google Mail (Gmail) from Excel
How-to make or copy a table into Google email without losing formatting from an Excel table. Tip & trick on how to make a table with borders in Gmail from Excel
EXPLORE THE LIBRARY
Month
Conditional Chart
How-to Make a Non-Chart Excel Dashboard Chart (Heat Index)
Tutorial and video on how to make an non-chart excel chart using conditional formatting techniques, tips and tricks. A NOAA National Weather Service Heat Index
Column Chart
How-to Create a Sick Leave Excel Dashboard Chart
Learn how to use custom markers and offset formulas to create a sick leave chart for an Excel Dashboard.
Excel Dashboard
How-to Make a WSJ Excel Pie Chart with Labels Both Inside and Outside
Learn How-to Make an Excel Pie Chart with Labels where the labels are both Inside and Outside of the pie slices. This was from a Wall Street Journal infographic.
How-To
How-to Add Label Leader Lines to an Excel Pie Chart
Learn how-to create label leader lines that connect pie labels that are outside of the pie slice to the appropriate pie section. It is a simple tip and trick.
Array
Removing Array Formulas Around Your Excel Charts and Dashboards
Excel dashboard protection tip and trick using array formulas
Array
Protecting Your Excel Charts and Dashboards with Array Formulas
Using Arrays can protect you from getting reference errors when users delete or insert rows or columns in your Excel Dashboards