Calculating Hours Difference of Time in Excel Spreadsheets
When working with Time in Microsoft Excel you may have noticed that there is a problem when you subtract certain numbers. Excel gives you...
Advanced Excel Summation Skills Using SUMIFS and SUMPRODUCT
In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data...
How-to Make a Basic Gantt Chart in an Excel Chart in 7 Easy Steps
Project Managers and Executives love Gantt Charts. They also love Microsoft Excel, Charts and Graphs. So it is a natural to consider how you...
How-to Put Percentage Labels on Top of a Stacked Column Chart
There are times when you are creating your Excel Dashboard Design that you desire something that does not come naturally with the Excel Tools...
How-to Quickly Find and Jump to the Right Worksheet Tab in Your Excel Workbook
As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook. However, if you create...
How-to Add a Hard Return to an Excel Concatenate Formula
Like most Excel users, one of the first formulas that you ever learned to master was the Concatenate Function.
But how do you add other...
Add Vertical Line Between Columns in Excel Stacked Column Chart
Add Vertical Line Between Columns in Excel Stacked Column Chart
In this tutorial, you will learn how to QUICKLY add a vertical line between columns...
How-to Make a Pass Fail Chart in Excel
Last week, I posed a Friday Challenge that was posted in a Q&A for Excel. Here it is:
*****************************************************************
Plotting a line graph to track build...
Fixing Your Excel Chart When the Multi-Level Category Label Option is Missing.
I am so happy to help my fans, and I saw a recent comment on an older posting of mine and I thought I...
How-to Make an Excel Death Star Pie Chart
While fooling around with Excel, I wondered if I could make an Excel chart look like a the Star Wars Death Star. Well, I...
