Fun
Things You Probably Didn’t Know About Excel
Things you didn't know about Excel and Lotus 1-2-3
EXPLORE THE LIBRARY
/author/admin/page/7/
How-To
Fastest Way to Open a New Workbook in Excel
How to video on creating a new workbook in excel with keyboard shortcuts
Bar Chart
Add Multiple Percentages Above Column Chart or Stacked Column Chart
I recently posted a tutorial on how you can put a percentage at the top of a Stacked Column Chart. You can see the tutorial and video demonstration of this technique here: How-to Put Percen
Connect Line Data Points
How-to Connect Gaps in a Line Chart in Excel
How to connect Excel line charts when you have missing data, gaps in data or blanks in data.
Column Chart
How-to Create Sales Quota Threshold Horizontal Lines in an Excel Column Chart
Video tutorial on how to create a horizontal line chart combined with an Excel 2D Clustered Column Chart.
Chart
How-to Make Longer Legend Color Bars in an Excel Chart Video Tutorial
Video tutorial of an Excel Tip and Trick to make a longer color bar in your Excel Legend.
Chart
Create a Dynamic Excel Pie Chart
Use the offset formula to create a dynamic pie chart or a dynamic pie graph in excel spreadsheets
Number Format
Remove The Zero Point or Make a Hole in an Excel Radar Chart
As my lovely wife recently stated, Excel Radar Charts are COOL! I kind of agree. That is why when I recently saw an Excel question posted in a forum it peaked my interest. The user wanted
Chart
Why Does Excel Switch Rows/Columns in My Chart?
Excel can do some crazy things to your Dashboard Templates, Charts and Graphs, but most of the time we just roll with the punches. But have you ever wondered why Excel does what it does and
Dates
What are the first and last dates in Excel?
what is the maximum date in excel? What is the earliest date?