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: Formula
Averageif
Friday Challenge – AverageIf NOT Blank or NOT Zero with Negative Values for Non-Contiguous Ranges
In a recent Friday Challenge, you were tasked with creating a formula that would work out for a non-contiguous (not connected) range that ignored Zero and Ignored Blanks. But, what we didn
Challenge
How-to Make a Dynamic Hotel Ballroom Occupancy Chart
See how to create a hotel occupancy chart using advanced date functions, countif formulas and conditional formatting. Also included is finding out how many days are in any month and if any d
Challenge
Friday Challenge – Splitting Up Email Address Text with Excel Formulas
How to separate names from email addresses using formulas in Excel spreadsheets
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
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
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
HLookup
VLookup Week at ExcelDashboardTemplates.com
Learn how to make and understand Excel Lookup Functions like Index/Match, Vlookup, Hlookup, Left VLookup