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
Tag: Format
Tips and Tricks
My Excel Worksheet Only has 65000 Rows When Saving As Excel 2013 Workbook
When working between Excel 2003 and Excel 2007 or Excel 2013 formats you may run into errors. Here is an error that I recently received and how to fix it.
Chart
The Quickest Way to Select an Data Series in an Excel Chart
If you have you ever had a problem selecting a series in an Excel Chart? This is the quickest way to select a data series that is very difficult if not impossible to select with your mouse.
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
Candle Stick
Problems Creating an Excel Open-High-Low-Close (Candle Stick) Stock Chart
Video tutorial showing you how to format and make an Excel Candle Stick or Open-High-Low-Close Chart or Graph
Axis Formating
How-to Make a Wall Street Journal Horizontal Panel Chart in Excel
Tutorial on how to make a Wall Street Journal Type graph in Microsoft Excel using standard excel dashboard techniques utilizing 2-D Clustered Column charts
Chart
Add % Difference Data Labels to Excel Horizontal Tornado Chart
Okay, the client is always requesting changes. How do you deal with these? I suggest increasing the contracted hours. In this case, I decided to double the rate and double the billable ho
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