Excel Formulas

1. Common Mathematical Operations
Calculating Percent of Goal
Calculating Percent Variance
Calculating a Percent Distribution
Calculating a Running Total
Applying a Percent Increase or Decrease to Values
Dealing with Divide-by-Zero Errors
Basic Rounding of Numbers
Rounding to the Nearest Penny
Rounding to Significant Digits
Counting Values in a Range
Creating a Conversion Table

2. Manipulating Text with Formulas
Joining Text Strings
Setting Text to Sentence Case
Removing Spaces from a Text String
Extract Parts of a Text String
Finding a Particular Character in a Text String
Counting Specific Characters in a Cell
Adding a Line Break within a Formula
Cleaning Strange Characters from Text Fields
Padding Numbers with Zeros
Formatting the Numbers in a Text String
Editing Cell Content
Undo and Redo
Using Autofill
Sorting a Cell Range
Searching and Replacing Data

3. Working with Dates and Times
Getting the Current Date and Time
Calculating the Number of Days between Two Dates
Calculating the Number of Workdays between Two Dates
Generate a List of Business Days Excluding Holidays
Extracting Parts of a Date
Calculating the Number of Years & Months between Dates
Calculating the Percent of Year Completed and Remaining
Returning the Last Date of a Given Month
Calculating the Calendar Quarter for a Date
Calculating the Fiscal Quarter for a Date
Calculate the Date of the Nth Weekday of the Month
Calculate the Date of the Last Weekday of the Month
Extracting Parts of a Time
Calculating Elapsed Time
Rounding Time Values
Converting Decimal Hours, Minutes, or Seconds to a Time
Adding Hours, Minutes, or Seconds to a Time