Table Of Contents
TEXT Formulas
- Create a Star Rating Template in Excel
- Get the File Name in Excel
- Get Sheet Name in Excel
- Remove First Character from a Cell in Excel
- Quickly Generate Random Letters in Excel
- Randomize a List (Random Sort) in Excel
- Remove Extra Spaces in Excel
- Separate Names in Excel – (First and Last Name)
- Flip the First & Last Names with a Comma
- Get File Path (Excel Formula)
- Get the Value from a Cell
- Add New Line in a Cell in Excel (Line Break)
- Add New Line in a Cell in Excel (Line Break)
- Capitalize First Letter in Excel
- Change Column to Row (Vice Versa) in Excel
- Change to Sentence Case in Excel
- Concatenate (Combine) Cells with a Comma in Excel
- Concatenate (Combine) a Range of Cells in Excel
- Concatenate with a Line Break in Excel
- Create a Horizontal Filter in Excel
- Count Characters in Excel (Cell and Range)
- Add Leading Zeros in Excel
- Create a Dynamic Hyperlink
- Extract Last Word from a Cell
- Remove Line Break from a Cell
- Remove Parentheses in Excel (Brackets)
LOOKUP Formulas
- IFERROR with VLOOKUP in Excel to Replace #N/A
- Perform Two Way Lookup in Excel
- Reverse VLOOKUP (Backward: Right to Left) in Excel
- VLOOKUP Dates (VLOOKUP for a Date from Data)
- VLOOKUP MATCH Combination in Excel
- VLOOKUP with Multiple Criteria in Excel
- Wildcards with VLOOKUP
- Lookup for the Cell Address Instead of the Value
CONDITIONAL Formulas
- Check IF 0 (Zero) Then Blank in Excel
- Check IF a Value Exists in a Range in Excel
- Combine IF and AND Functions in Excel
- Combine IF and OR Functions in Excel
- Compare Two Cells in Excel
- Check IF a Cell Value is a Number
- If a Cell Value Starts with a Text or a Number
- Conditional Ranking in Excel (SUMPRODUCT -RANKIF)
- IF Cell is Blank (Empty) using IF + ISBLANK in Excel
- IF Negative Then Zero (0) in Excel
- SUMPRODUCT IF - Conditional Formula in Excel
- Check IF a Cell Contains a Partial Text
- Median with IF – Conditional Criteria
COUNT Formulas
- Count Between Two Numbers (COUNTIFS) in Excel
- Count Blank (Empty) Cells using COUNTIF in Excel
- Count Cells Less than a Particular Value (COUNTIF)
- Count Cells Not Equal to in Excel (COUNTIF)
- Count Cells that are Not Blank in Excel
- Count Cells with Text in Excel
- Count Greater Than 0 (COUNTIF) in Excel
- Count Specific Characters in Excel
- Count the Total Number of Cells from a Range in Excel
- Count the Total Number of Cells from a Range in Excel
- COUNT Vs. COUNTA
- Count Words in Excel
- OR Logic in COUNTIF/COUNIFS in Excel
- Count Filtered Rows in Excel
- Count Unique Values in Excel
SUM Formulas
- Sum an Entire Column or a Row in Excel
- Sum Greater than Values using SUMIF
- Sum Not Equal Values (SUMIFS) in Excel
- Sum Only Visible Cells in Excel
- Sum Random Cells in Excel
- SUMIF / SUMIFS with an OR Logic in Excel
- SUMIF with Wildcard Characters in Excel
- SUMIFS Date Range (Sum Values Between Dates Array)
- AutoSum in Excel
- Sum Values Less than a Particular Value (SUMIF Less Than)
- Add a Total Row in Excel
- Combine VLOOKUP with SUMIF
- Sum IF Cell Contains a Specific Text (SUMIF Partial Text)
- Sum Values Based on Year (SUMIF Year)
- SUMIF By Date (Sum Values Based on a Date)
- SUMIF Non-Blank (Sum Values for Non-Empty Cells)
- SUMIF to Sum Blank Values or Empty Cells
- Sum Values that are Greater Than Zero (SUMIF)
- INDIRECT with SUM
- Sum Values Based on the Month (SUMIF)
DATE Formulas
- Add Month to a Date in Excel
- Add Years to Date in Excel
- Add-Subtract Week from a Date in Excel
- Calculate Age using Date of Birth in Excel
- Compare Two Dates in Excel
- Convert Date to Number in Excel
- Convert Text to Date in Excel
- Count Years Between Two Dates in Excel
- Create a Date Range in Excel
- Custom Date Formats in Excel
- Get Day Name from a Date in Excel
- Get Day Number of Year in Excel
- Get End of the Month Date in Excel
- Business Days in a Month
- Convert Date into a Text
- Combine Date and Time in Excel
- Extract (Get) Year or Month from a Date in Excel
- Years Between Dates in Excel
- Years Between Dates in Excel
- Quickly Concatenate Two Dates in Excel
- Number of Months Between Two Dates in Excel
- Highlight Dates Between Two Dates in Excel
- Get Years of Service in Excel
- Get Total Days in Month in Excel
- Get Quarter from a Date [Fiscal + Calendar] in Excel
- Get Month from a Date in Excel (Extract Month)
- Get the First Day of the Month (Beginning Day)
- Random Date Generator
- Countdown Days
- Convert Month Name to Number
- Count Days Between Two Dates
MATHS Formulas
- Average Top 5 Values in Excel
- Calculate Compound Interest in Excel
- Calculate Cube Root in Excel
- Calculate Percentage Variance (Difference) in Excel
- Calculate Simple Interest in Excel
- Calculate SQUARE ROOT in Excel + Insert Symbol
- Calculate Weighted Average in Excel
- Calculate Coefficient of Variation (CV) in Excel
- Add-Subtract Percentage from a Number
- Average But Ignore Errors (#N/A and Other Errors)
- Average Number but Exclude Zeros
- Average Only Non-Blank Cells
- Does Not Equal Operator in Excel
- MAX IF in Excel
- Quickly Calculate Ratio in Excel
- Round a Number to Nearest 1000, 100, and 10 in Excel
- Round to Nearest .5, 5. 50 (Down-Up) in Excel
- Square a Number in Excel
- Round a Number to Nearest 1000 in Excel
- Calculate the Average of the Percentage Values
- Calculate the Average of the Time Values
- Find the Lowest Value from a List of Numbers
- Find the Smallest Value from a Range of Cells
- Calculate the Cumulative Sum of Values
- Calculate Nth Root
- Get the Most Frequent Number(s) from an Array
- Round Percentage Values
TIME Formulas
- Add Hours to Time in Excel
- Add Minutes to Time in Excel
- Time Difference Between Two Times in Excel
- Convert Time Value into a Decimal Number (Hours)
- Convert Minutes into Hours and Minutes (HH:MM)
- Convert Time into Minutes
- Change Time Format in Excel
- Military Time (Get and Subtract) in Excel
- Separate Date and Time in Excel
- Convert Time into Seconds
- Get Current Time
- Sum Time in Excel
- Add Seconds to Time
- Convert Seconds to Hours and Minutes