Cell References
How-to Show All Named Ranges/Formulas in a List
this will show you how to use the F3 key to paste a list of all the named ranges and defined names including formulas in Excel Spreadsheet
EXPLORE THE LIBRARY
Formulas category
Cell References
How-to Easily Paste a Defined Name in Chart Dialog Box
Using Function Key f3 in Excel to add Defined Names to Charts and Graphs
Cell References
How-to Make Excel STOP Selecting Range/Extending Range
While building your Excel Dashboard Templates, have you had the frustrating problem where Excel keeps highlighting a range of cells as you click on a new cell or change cells with the arrow
Chart
How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section
Hiding Excel Pie Chart Slice when equal to 0 also how to hide stacked bar chart section using NA()
Chart
How-to Make a Dynamic Chart Using Offset Formula
Offset function to make a dynamic chart for Excel dashboard templates
Cell References
Find the Last Row or Last Column for Dynamic Excel Dashboards
In a previous post “ This is the Bomb: or How I came to love the Offset function ” I showed you all about the Offset Formula. Understanding the Offset Formula is critical to understanding h
Cell References
This is the Bomb: or How I came to love the Offset function
Learn how to make Excel Dashboard Template Charts using Offset Formulas to define Dynamic ranges.
Concatenate
How NOT to use Concatenate Function to build Dynamic Text in your Excel Dashboard Templates
Advice and Ways to build Concatenate formulas in your Excel Dashboard Templates.
Cell References
QUICKLY Change Microsoft Excel Dashboard Template Cell References
How to optimize your cell references in Excel Dashboard Template Formulas