Formatting
Excel Formula Formatting Quick Tip
Learn the best Excel Formula Formatting technique so that you can quickly edit them in the future! You will use these simple techniques for all of your Excel Formulas going forward.
EXPLORE THE LIBRARY
Formatting
Formatting
How-to Display Military Time in an Excel Spreadsheet
A few days ago, I had a user ask me a question on the blog about how she can display military time in Excel. It is pretty simple to display in Excel but only if you know how Excel treats tim
Excel tutorial
Friday Challenge Answers – The Boss Says…
I received some great responses from lots of fans. Thank you so much for all your great comments. I agree with most and my solution was very similar to Peter R.’s below. BUT, as always, P
Axis Formating
Date and Time Series Issues in Excel Charts
If your chart in Excel is showing every date and you only want to show the dates in your data series on the Horizontal X Axis
Chart
How-to Make a Conditional Column Chart in Excel
A quick way to make a conditional column chart showing red and green bars in an excel spreadsheet
Axis Formating
Using the Camera Tool to Create a Vertical Line Chart in Excel
Using the Camera Tool to Make a Dynamic Dashboard Vertical Line Chart in Excel
Chart
How-to Format Chart Axis for Thousands or Millions
Excel Dashboard Format Design for Millions or Thousands Chart Axis number categories
Formatting
Excel Line Break/Hard Return within a Cell
Most people don’t know that you can put a Hard Return (Line Break) within a cell because when they hit enter Excel takes them to a new cell. It is pretty simple to learn how to do this and
Chart
Group Column Chart with Lines for Excel Dashboard Presentations
Yesterday a user in the MrExcel.com Forums asked how he could make a Column Chart in Excel and then Group those Columns with a Line and Label the Line. Here was the sample picture presented