Averageif
How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs
A quick tutorial that teaches how to create an AverageIF Formula that will exclude Zero (0) and blank values when averaging across many Excel Worksheet Tabs
EXPLORE THE LIBRARY
Tag: Index
Averageif
How-to AverageIf Excluding Zeros and Blanks for Non-Contiguous Ranges in Excel
In our last Friday Challenge, I asked you figure out a way to calculate an average for a non-contiguous (non-adjacent) range that will exclude blanks and zeros. This came from a user questio
Chart
How-to Make a Dynamic Excel Pie Chart with 4 steps in less than 4 minutes
This is an awesome guest post from our great friend Pete. He came up with this awesome technique to make a dynamic pie chart without the use of offset. THANKS PETE! Recently I saw some com
Challenge
Show Only Selected Data Points in an Excel Chart
Tutorial on how to show or hide specific data points in an Excel Chart using an offset function with index.
Dynamic
How-to Create a Dynamic Excel Chart that Only Displays Non-Blank Values
How-to Create a Dynamic Excel Graph that Displays Only Non-Blank Values
Chart Title
Customizing the Standard Excel Chart Titles
Additional formating techniques for Excel Dashboard Charts
Dashboard Design
Excel VLOOKUP–Left or Right and HLOOKUP Up or Down
Understanding and learning the Left Vlookup functionality in Excel by using Index/Match Functions and Formulas
HLookup
VLookup Week at ExcelDashboardTemplates.com
Learn how to make and understand Excel Lookup Functions like Index/Match, Vlookup, Hlookup, Left VLookup