Excel Formulas List (Basic + Advanced)
- Change to Sentence Case in Excel
- Excel 3D Reference/Range (Write 3D-Formulas)
- Convert Text to Date in Excel
- Excel’s DATEDIF Function
- Custom Date Format in Excel
- Star Rating Template in Excel
- Calculate Compound Interest in Excel
- R1C1 Reference Style in Excel
- Add Leading Zeros in Excel (Before the Number)
- Calculate the Weighted Average in Excel
- Remove Extra Spaces in Excel (Leading and Trailing)
- VLOOKUP MATCH Combination in Excel
- SUMPRODUCT IF to Create a Conditional Formula in Excel
- IF and OR Functions in Excel
- IF and AND Functions in Excel
- Perform Two-Way Lookup in Excel
- Conditional Ranking in Excel using SUMPRODUCT Function [RANKIF]
- Quickly Generate Random Letters in Excel
- Calculate Ratio in Excel
- SUMIF / SUMIFS with an OR Logic in Excel
- OR Logic in COUNTIF/COUNIFS in Excel
- Get Month Name from a Date in Excel
- Get the End of the Month Date in Excel
- SUMIFS Date Range (Sum Values Between Two Dates Array)
- Wildcards with VLOOKUP in Excel
- Separate names in Excel (Split First & Last Name)
- IFERROR with VLOOKUP in Excel to Replace #N/A in Excel
- CONCATENATE a RANGE of Cells [Combine] in Excel
- VLOOKUP with Multiple Criteria in Excel
- MAX IF in Excel
- Count Words in Excel
- Hide Formula in Excel
- Get Total Days in Month in Excel
- Average TOP 5 Values in Excel
- Get Day Name from a Date in Excel
- Highlight Dates Between Two Dates in Excel
- Calculate SQUARE ROOT in Excel + Insert Symbol
- SUMIF with Wildcard Characters in Excel
- Reverse VLOOKUP in Excel (Right to Left)
- Calculate the Time Difference Between Two Times in Excel
- Get Quarter from a Date in Excel
- Concatenate with a Line Break in Excel
- Round to Nearest .5, 5. 50 (Down-Up) in Excel
- Count Greater than 0 in Excel (COUNTIF – COUNTIFS)
- Separate Date and Time in Excel
- Count Between Two Numbers (COUNTIFS) in Excel
- Add Years to Date in Excel in Excel
- Capitalize the First Letter in Excel
- Add-Subtract Week from a Date in Excel
- IF Negative Then Zero (0) – (Formula in Excel)
- Military Time (Get and Subtract) in Excel
- INDIRECT with SUM in Excel
- Check IF a Cell Value Starts with a Text or a Number (Formula in Excel)
- Calculate Weeks Between Two Dates in Excel
- Combine Date and Time in Excel
- Extract Year from Date in Excel
- Count Filtered Rows in Excel (Visible Rows)
- Check IF a Cell Contains a Partial Text in Excel
- SUMIF to Sum Blank Values or Empty Cells
- Sum IF Cell Contains a Specific Text (SUMIF Partial Text)
- SUMIF By Date (Sum Values Based on a Date)
- SUMIF Non-Blank (Sum Values for Non-Empty Cells)
- Combine VLOOKUP with SUMIF
- Sum Values Based on Year (SUMIF Year)
- Add a Total Row in Excel
- Add Seconds to Time in Excel
- AutoSum in Excel
- Average Number but Exclude Zeros (0) in Excel
- Average But Ignore Errors (#N/A and Other Errors) in Excel
- Average Only Non-Blank Cells in Excel
- Calculate Average Percentage in Excel
- Calculate the Average of the Time Values in Excel
- Count Characters in Excel (Cell and Range)
- Calculate the Cumulative Sum of Values in Excel (Running Total)
- Get Current Time in Excel
- Count Days Between Two Dates (COUNTIF Date Range) in Excel
- Extract Last Word from a Cell in Excel
- Calculate MEDIAN IF in Excel
- Convert Month Name to Number in Excel
- Remove Line Break from a Cell in Excel
- Remove Parentheses in Excel (Brackets)
- Find the Smallest Value from a Range (Smallest Number) in Excel
- Sum Values that are Greater Than Zero (SUMIF)
- Sum Values Less Than a Particular Value (SUMIF Less Than)
- Sum Time in Excel
- Convert Time Value into a Decimal Number (Hours) in Excel
- Convert Time Value into Minutes in Excel
- Convert Time Value into Seconds in Excel
- VLOOKUP Dates (VLOOKUP for a Date from Data) in Excel
- Calculate Business Days in a Month in Excel
- Convert Date into a Text in Excel
- Get the Value from a Cell in Excel
- Find the Lowest Value from a List of Numbers (N) in Excel
- Convert Minutes into Hours & Minutes (HH:MM) in Excel
- Get the Most Frequent Number(s) from an Array in Excel
- Calculate Nth Root in Excel
- Round Percentage Values in Excel
- Flip the First & Last Names and Add a Comma Between
- Add-Subtract Percentage from a Number in Excel
- Excel Formula to Count Days from Date to Today Automatically
- Create a Dynamic Hyperlink in Excel
- Check IF a Cell Value is a Number in Excel
- Remove Numbers from a Cell in Excel
- Get Sheet Name in Excel
- Get Day of Year in Excel
- Create a Date Range in Excel
- Calculate Cube Root in Excel
- Add Minutes to Time in Excel
- Count Cells Not Equal To (COUNTIF) in Excel
- Compare Two Dates in Excel
- Convert Date to Number in Excel
- Calculate Years of Service in Excel
- Add Months to a Date in Excel
- Change Time Format in Excel
- Concatenate (Combine) Cells with a Comma in Excel
- Quickly Concatenate Two Dates in Excel
- Sum an Entire Column or a Row in Excel
- Count the Number of Cells in Excel
- Get File Name in Excel
- Random Date Generator in Excel
- Sum Greater Than Values (SUMIF-SUMIFS)
- Sum Not Equal Values (SUMIFS)
- Check IF a Value Exists in a Range (Formula in Excel)
- Use COUNTIF for Blank Cells Count in Excel
- COUNT Less Than (COUNTIF – COUNTIFS) in Excel
- Count Cells that are Not Blank (Non-Empty)
- Count Specific Characters (Formula in Excel)
- Round a Number to Nearest 1000, 100, and 10 in Excel
- Sum Random Cells in Excel
- Add Hours into Time in Excel
- Get First Day (Beginning) of the Month in Excel
- Change Column to Row (Vice Versa) in Excel
- Calculate Percentage Variance (Difference) in Excel
- Square a Number in Excel
- Sum Only Visible Cells in Excel
- Count Cells with Text in Excel
- Count Unique Values in Excel
- Check IF 0 (Zero) Then Blank (Formula in Excel)
- Calculate Coefficient of Variation (CV) in Excel
- Does Not Equal Operator in Excel
- IF Cell is Blank (Empty) using IF + ISBLANK (Formula in Excel)
- Count Number of Months Between Two Dates in Excel
- Randomize a List (Shuffle Data using Random Sort) in Excel
- Create a Horizontal Filter in Excel
- Calculate Simple Interest in Excel
- #VALUE! Error in Excel
- Calculate the Number of Years Between Two Dates in Excel
- Compare Two Cells in Excel
- COUNT Vs. COUNTA
- #DIV/0! Error in Excel (Fixing) (Divide by Zero Error)
- Add New Line in a Cell in Excel (Line Break)
- Ignore All the Errors in Excel
- #SPILL! Error in Excel
- Add Quotes Around Text in Excel
- Get File Path in Excel
- Convert Seconds to Hours & Minutes in Excel
- Sum Values Based on the Month (SUMIF)
- Lookup for the Cell Address Instead of the Value in Excel
- Add Commas [Cell-Text] in Excel using a Formula
- Calculate VAT in Excel
- Gross Profit (Margin and Ratio) in Excel
- Lookup Last Value from a Column or a Row in Excel
- #N/A Error in Excel (Understanding and Fixing)
- Generate Random Groups in Excel
- #REF! Error in Excel (Understanding and Fixing)
- Split a Text using a Space Between in Excel
- Use SUBTOTAL with IF (Conditional SUBTOTAL) in Excel
- Remove Unwanted Characters in Excel
- Add Space (Single and Multiple) in Excel
- Convert to Julian Date in Excel
- Substitute Multiple Values (Nested) in Excel
- Convert Time to Decimals in Excel
- Compare Two Strings (Text) in Excel
- Use CONCATENATE IF (Combine with Condition) Formula in Excel
- Count Rows in Excel (All, Blank, Non-Blank, & with Numbers)
- Convert a Date into a Month and Year in Excel
- Get the Domain from the Email ID in Excel
- Get Previous Sunday in Excel
- Remove the Last Character from a String in Excel
- Calculate the Running Total in Excel
- Sum Values by Group
- Applying VLOOKUP from Another Sheet (Between Sheets) in Excel
- Arithmetic Operators in Excel
- Change Text Case (Upper, Lower, Proper) in Excel
- Using Greater Than (>) and Equal To (=) Operator in Excel
- Extract Text After and Before a Character in Excel
- Extract Only Numbers from a Text (String) in Excel
- Learn to use INDIRECT with VLOOKUP in Excel
- Match/Compare Two Columns with VLOOKUP in Excel
- Remove Commas in Excel
- Calculate Sum of Squares in Excel
- XLOOKUP Return All Matches. Possible? (Formula in Excel)
- Use XLOOKUP with Multiple Criteria in Excel
- Excel Wildcard Characters (Asterisk, Question Mark, and Tilde)
- Understanding TRUE and FALSE in Excel (Boolean Values)
- Perform Divide in Excel
- Get the Latest Stock Price in Excel
- Combine VLOOKUP and COUNTIF to Count the Occurrences in Excel
- Check IF a Date is Before a Particular Date in Excel
- Less Than and Equal To Operator in Excel
- Get Max Date from a List of Dates in Excel