Here are a total of 187 Excel articles,
tutorials, and examples for learning how to create, work with,
and use Excel Formulas.
These learning materials are hosted by three Excel tutorial
sites: MrExcel, Chip
Pearson, and John
Walkenbach, which host over 500 excellent Excel
Articles and Tutorials.
187 Excel Formula
Tutorials and Examples
- Absolute References
- Adding every other cell in a column with =SUM(MOD…
- Array to Columns
- Array-CSE Further Uses
- Array-CSE Uses
- Array-CSE Entering using Conditional Sum Wizard
- Arrays-CSE
- Attendance Tracker using COUNTIF
- AutoAverage - using the dropdown next to AutoSum to access other functions
- Automatically add a character in a cell
- Automatically get the date and time with =NOW() Function
- Auto-Update Charts upon entering new data
- Averaging Highest-Lowest
- Averaging Range Values
- Avoid error displays in formulas
- Avoiding error displays in formulas
- Calculating a conditional average
- Calculating Age and Birthdays
- Car Loan Payments in Excel with =PMT() function.
- Calling a Function
- Cell Value vs. Displayed Text
- Change a Cell Value without Changing the Formula
- Changing #N/A to “Your Response” text with =IF()
- Changing ‘All Caps’ to proper text with =PROPER()
- Changing Cell References
- Changing grades (in numeric format) to Letter Grades with =VLOOKUP
- Changing Numbers to Text
- Color -Shading Cells
- Compare ranges by using an array-CSE-formula
- Concatenate values: (Bringing two cell Values together as one)
- Concatenating a cell with text and a cell with a date
- Concatenation
- Conditional Formatting – Referencing another sheet
- Conditional Sum Wizard
- Convert 11.5 to 11 minutes and 30 seconds
- Convert Text to Proper Case
- Coordinates - Degrees, Minutes, Seconds
- Count Between Two Values
- Count Text or Numeric Entries with COUNTA instead of COUNT
- CountIF in an Array-CSE
- CountIf or Sumif with two conditions
- Counting Cells with specific content with =COUNT
- Counting distinct entries in a range
- Creating a “Mega-formula”
- Creating proper names format with =PROPER()
- Custom Function: Parsing with characters
- Dates in Excel from TechTV
- DATEDIF to find the difference between dates
- Dates -Adding and Subtracting
- Dates -As Intervals
- Dates - Calculating # of Days from Today
- Dates -Creating a Series
- Dates -DATEDIF Function
- Dates -Day of the Week(Month)
- Dates -Day of the Week(Year)
- Dates -Determining Quarters
- Dates -Difference Between
- Dice in Excel using RANDBETWEEN
- Dates -Distributing
- Dates -Easter Calculation
- Fill a Range with Weekdays
- Dates -First and Last Day of the Month
- Dates -First Monday
- Dates -Julian
- Dates -Leap Years
- Dates -Number of days in a month
- Dates -Thanksgiving Calculation
- Dates -The day of the year and days remaining
- Dates - Live formula to calculate Today
- Dates -Two Digit Year
- Dates -Week Numbers (ISO)
- Duplicate Entry – Identify
- Duplicate Tooltip over DDE Formula
- Dynamic Range
- Find and Replace
- Find the elapsed time between two time entries
- Find the longest entry in a range of text entries
- Finding an average between two data sets
- Finding Minimum and Maximum Values
- Force a global recalculation
- Formatting Time Values
- Formula Auditing
- Formula to add years to a given date
- Fractions in Excel
- Grades -Calculating and Converting
- Have an IF statement return “Yes”-”No” with =IF
- Hiding your formulas
- High and Low Values – =MAX
- Holidays -Calculating
- How to calculate and display the largest value with =MAX
- How to create a “Top 9″
- How to Reverse the Sign on a Difference
- INDEX(MATCH())
- INDIRECT
- Joining two Columns
- Joining Text in two columns with the Concatenation Operator
- Keeping a running total in an adjacent column with =SUM
- Latitude and Longitude
- Lists -Auto-Numbering
- Lists -Common to Two Lists
- Lists -Minimum and Maximum Values
- Lists -Transpose (Reverse) Order
- Lists -Unique to One of Two
- Loan Payments in Excel with =PMT() function.
- Lookup -Closest Match
- Lookup -Multiple Criteria
- Lookup -Return Value to Left
- Magic Squares in Excel
- Math Exercise Sheets in Excel using RANDBETWEEN
- Matching Lists vith VLOOKUP
- Merge Values to One (using Area Code and Phone Number)
- Most or Least Common Value
- Multiply Hours by Rate
- Named Range
- Naming a Worksheet as the value of a target cell with =INDIRECT Function
- Nested Function
- No Blank Cells
- Ordinal Numbers
- Parsing Dates with =MID Function
- Parsing -Names
- Parsing -Phone Numbers
- Parsing phone numbers with =MID Function
- Paste Special Values to prevent #REF! errors
- Perform two-way table lookups
- Pricing -Bracketing and Progressive
- Proper Case – Changing a Name to Proper Case
- PROPER() function to convert text to upper and lower case
- Random Samples with RAND
- Range -Convert to Columns
- Range -Dynamic
- Range -Named
- Range -Transpose
- Range -Used Cells
- Range -Variable
- Ranking Data
- Ranking without repetitive ranks with =RANK and =COUNTIF
- Referencing a sheet indirectly
- Referencing Cells
- Relative Cell References
- Return End Of Month Date with =DATE
- Return File Name
- Return Nth Value
- Returning specific data on examining a range
- Returning Zero instead of #N/A with =IF()
- Round time to the nearest quarter hour
- Round values to the nearest fraction
- Rounding Numbers with =CEILING
- Rounding numbers with =ROUND
- Rounding time to a specific value
- Rounding to n significant digits
- select Random numbers from a column with =RAND()
- Show Formulas
- Splitting the contents of a cell/column into two distinct cells/columns
- Strings -Counting Characters
- Strings -Counting Characters
- Strings -Extracting Words from a String
- Strings -Most or Least Common
- Sum Every Nth Value
- Sum only the visible cells
- Sum the largest values in a range
- SUMIF in an Array – CSE
- SUMIF to conditionally sum data
- SumIf with two conditions
- Summing times that exceed 24 hours
- Text and values in one cell
- Text value response to input with =IF
- Time -Adding and Subtracting
- Time - Adding When Total is over 24 hours
- Time -Between Two Dates
- Time -Calculating Overtime
- Time -Quick Entry Method
- Time -Range last Updated(Not available after Excel ’97)
- Time -Rounding
- Transforming Data With Formulas
- Transpose a Range
- Unique Entries -Counting
- Unique Entries -Extracting
- Unique Entries -Ranking
- Use Index and Match to lookup a cell to the left of your key cell
- VLOOKUP
- Use absolute references when tracking student grades
- Working with Dates with =DATE
- Working with time formats with =TEXT
- Worksheets -Referencing Previous and Next
- Worksheets -Return Sheet Name
- Write a Formula that always points to the same column, but is free to move to different rows as it is copied
- Zero Values-Ignoring
Popularity: 96% [?]
Related Posts:
Tags for this post>> Excel