Chart
How-to Eliminate Statistical Outliers in an Excel Line Chart
Learn how to create a dynamic Excel chart where you can hide outliers in a Line chart or Line graph. Free Excel Template download file
EXPLORE THE LIBRARY
Formulas category
Challenge
Friday Challenge – Eliminating outliers in and Excel Chart
how to make an excel chart that ignores outliers when plotted in a line chart. Do this without manually deleting the data points.
FIND Function
Getting to Know Excel Text Fuctions and Functions
See how to use a combination of the Excel Find Function, MID Function and Value to get a text ranking from text.
Array
Removing Array Formulas Around Your Excel Charts and Dashboards
Excel dashboard protection tip and trick using array formulas
Chart
Case Study – Creating a Dynamic Chart in Excel Using Offset Formula
detailed how-to create a dynamic excel graph and chart using excel offset functions and formulas
Chart
The Tricks to Writing a Conditional Formatting Rule Formula
The best tips and tricks about wrting excel conditional formattting rules and formulas for spreadsheet dashboards.
CSV
What to Do When Formulas Don’t Work from an Exported Salesforce.com Report or CSV Text Spreadsheet
How to fix formulas to display values instead of formula text in an excel spreadsheet when working with a downloaded or exported Salesforce.com Report or file
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
Formulas
Excel Formulas: Average a Range and Ignore Zero’s (0 Value)
How to use Excel 2003, 2007 and 2010 formula to calculate the average of a range excluding zeros from the average
Cell References
How-to Show All Formulas in Excel Spreadsheet
How-to see your formulas in an Excel spreadsheet by pressing Ctrl+~