Excel Formulas

Text Manipulation:

  • Add a New Line in Cell Formula – Learn how to add a new line within a cell formula in Excel for improved readability and formatting.
  • Add Commas – Easily add commas in Excel using formulas like SUBSTITUTE and REPLACE.
  • Add Leading Zeros – Learn different methods for adding leading zeros to numbers in Excel. Understand how to force Excel to treat values as text, use custom formatting, apply the TEXT function, and utilize the CONCATENATE function.
  • Add Text to Date Cell – Easily add text to date cells in Excel using a simple formula. Improve your Excel skills with this helpful tip.
  • Capitalize the First Letter – Capitalize the First Letter Excel Formulas, Examples, VBA, Functions, and Shortcuts. Fix inconsistent data quickly.
  • Check if a Cell Contains a Substring – Learn how to check if a cell contains a substring in Excel using formulas. Case-insensitive and case-sensitive options available.
  • Check if a Cell Contains Space – Find out how to check if a cell contains a space in Excel with the help of formulas and functions.
  • Combine Text with Formula – Combine text with formulas in Excel using the ampersand operator and the CONCAT function to create dynamic strings inside a single cell.
  • Compare Two Strings – Compare two strings in Excel using the comparison operator and the EXACT function to see the differences in results.
  • Concatenate Double Quotation Marks – Adding double quotation marks to your text in Excel with these helpful tips. Explore different methods to concatenate and format your data easily.
  • Concatenate Numbers And Percentages – Easily combine numbers and percentages in Excel using CONCATENATE or “&” sign.
  • Concatenate vs & – Learn about the differences between the concatenate function and the ampersand sign in Excel for joining strings. Understand how to use both methods for clearer and more readable formulas.
  • Convert Text to ASCII – Easily convert text to ASCII in Excel using CHAR and CODE functions. Convert numbers from 32 to 126 into corresponding ASCII codes effortlessly.
  • Convert Text to Year – Easily convert text to year in Excel using the TEXT function with this helpful guide. Improve your Excel skills today.
  • Create Insert Statement – Efficiently insert data from Excel into an SQL table with a simple formula. Explore how to automate the process for multiple rows.
  • Excel Convert Date to Text– Easily convert Excel dates to text with these simple tricks and formulas. No need to download any files, just follow along and enhance your Excel skills.
  • Excel if Cells Contain Specific Text – Increase your Excel skills by learning how to check if cells contain specific text with these helpful formulas and examples. Master VBA, functions, and shortcuts.
  • Extract Domain from URL – Learn how to easily extract domain names from URLs in Excel using different methods. Improve your data analysis and reporting by efficiently processing large lists of web addresses.
  • Extract Text Before or After a Character – Find out how to extract text before or after a character.

Mathematical Operations:

  • Add or Subtract Multiple Cells – Add or Subtract Multiple Cells in Excel Without Hassle or Errors.
  • Adding Hexadecimal Numbers – Learn how to add hexadecimal numbers in Excel with this step-by-step guide. Convert to decimal, perform the addition, and then convert back to hex if needed.
  • Average Positive or Negative Numbers – Find out how to calculate the average of positive or negative numbers in Excel using 4 different methods in this informative content.
  • Average Rate of Change – Calculate the average rate of change in Excel with this informative content that includes formulas and examples.

Mathematical Calculations:

Date Calculations:

Financial Calculations:

  • Calculate GST – Easily calculate GST in Excel using simple formulas and examples. Learn how to determine the tax amount on goods and services.
  • Excel Profit Margin Formula – Learn how to calculate profit margin using Excel with examples and formulas. Understand the concept behind profit margin and how to apply it in your business.
  • Calculate the Original Loan Amount – Learn how to calculate the original loan amount in Excel using the PV function with this helpful guide. Discover the necessary steps to determine the loan amount based on interest rate, payment periods, and payment amount per period.
  • Calculate VAT – Easily calculate VAT in Excel using different tax rates or a single tax rate with these simple methods. Save time and reduce errors in your calculations.

Number Conversions:

  • Convert HEX Values – Easily convert hexadecimal values in Excel using built-in functions. Learn how to convert between decimal, hexadecimal, octal, and binary numbers efficiently.
  • Convert Numbers to Text With Commas – Easily convert numbers to text with commas in Excel using three different methods explained in this post. Improve readability of your data with these techniques.
  • Convert Month Number to Month Name – Convert month numbers to month names in Excel using simple formulas. Manipulate data easily and efficiently in Excel.

Cell, Row and Column Operations:

Conditional Operations:

List Operations:

Lookup and Reference Functions:

Retrieving Information:

  • Finding the Maximum Value With HLOOKUP – Learn how to find the maximum value in an Excel table using the HLOOKUP function in this helpful Excel tutorial.
  • Get Cell Value From Address – Easily retrieve cell values with Excel’s Address function and examples included.
  • Get Column and Row Numbers – Identify Column and Row Numbers in Excel.
  • Get nth Match with INDEX, MATCH, and SMALL – Discover how to find nth matches in Excel using INDEX, MATCH, and SMALL functions. Explore examples and step-by-step instructions for data analysis in Excel.
  • Get the First x Characters – Learn how to extract the first x characters in Excel with these simple methods. Improve your data analysis and modeling skills with these tips.
  • Get Cell Value – Learn how to retrieve cell values in Excel using the ADDRESS and INDIRECT functions. Improve your data analysis and financial modeling skills with this simple technique.
  • Get Value from an Array – Discover how to effectively retrieve values from arrays in Excel without any hassle. Explore various formulas and examples to enhance your data analysis skills.
  • Lookup the Nth Value – Lookup the Nth Value in Excel using different methods and formulas without the need for additional downloads or tutorials.
  • Return Cell Reference Instead of Value – Discover how to return the cell reference instead of the value in Excel with this helpful guide. Get the details on using formulas to locate specific data within your spreadsheet.
  • Return Value If Cell Is Blank – Discover how to return a value in Excel if a cell is blank without downloading any files. Explore different methods using the IF function and ISBLANK function to identify empty cells in your data.
  • Use Countif with Dates – Learn how to count dates in Excel using the COUNTIF function. Understand how Excel treats dates as numbers and use the ISNUMBER function for accurate results.
  • Use Index and Match in Table – Master how to utilize Index and Match functions in Excel to enhance your data analysis skills. Discover the power of these functions together in deriving data from a table effortlessly.
  • INDEX and MATCH with the LARGE Function – Utilize INDEX and MATCH with the LARGE Function in Excel to analyze and extract specific data in your dataset.
  • INDEX MATCH Column Name – Learn how to use INDEX and MATCH functions in Excel to retrieve column names instead of index numbers. Improve your data analysis and financial modeling skills with these Excel tips.
  • INDEX-MATCH or VLOOKUP to Return Multiple Values – Learn how to use INDEX-MATCH or VLOOKUP to return multiple values in Excel with this helpful guide. Master Excel formulas and functions easily.
  • Match Date to a Range of Dates and Times – Easily match dates in Excel with a range of dates and times using VLOOKUP function, even if your data is formatted as text.
  • Match Two Columns and Return a Third – Match columns in Excel to find corresponding values and return a third column value.
  • Pivot Table Count Unique Values – Count unique values in a Pivot Table using Excel. Easy steps and formulas provided.
  • Range Based on Cell Value – Calculate Excel ranges based on cell values with this formula tutorial. Easily handle exceptions and errors in your calculations.
  • Return Min, Max, or Average Using Vlookup – Learn to return the min, max, or average using VLOOKUP in Excel with this helpful guide.
  • Round to Nearest Value – Round numbers to nearest value in Excel with simple formulas and examples.
  • Round Value to the Nearest Quarter – Easily round values to the nearest quarter in Excel using simple functions.
  • Set Due Date Reminder Formula – Set due date reminder in Excel using formulas and conditional formatting.
  • Sheet Formula – Discover how to use SHEET and SHEETS functions in Excel for sheet indexing and counting, without navigating through Excel Tutorials.
  • Show Formulas – Learn how to show formulas in Excel with different techniques in this informative content.
  • Sorting Order in the VLOOKUP function – Understand how to adjust the sorting order in the VLOOKUP function in Excel with this informative guide.
  • Sum Only If Value in Cell Is Number and Not Text – Learn how to sum only numeric values in Excel cells and ignore text using the SUM function.
  • Sum Values Between Two Dates – Easily sum values between two dates in Excel with a simple formula.
  • Sumproduct – Learn how to use the SUMPRODUCT function in Excel for calculating the sum of products of corresponding ranges.
  • Target Formula – Elevate your Excel skills by learning how to set and calculate targets using formulas in Excel. Discover how to compare target figures with actual results using existing Excel functions for effective data analysis.
  • The OR Function in Conditional Formatting – Highlight how to use the OR function in conditional formatting in Excel to highlight specific categories in a spreadsheet.
  • Timestamp – Improve your Excel skills with timestamp formulas, examples, VBA, functions, and shortcuts.
  • Transpose VLOOKUP – Learn how to transpose the VLOOKUP function in Excel to return data from horizontal ranges with this helpful guide.
  • Use If with Values in a List – Learn how to use the IF function with values in a list in Excel for better data analysis and results.
  • Use Index Match in Multiple Sheets – Master the use of Index Match in Excel across multiple sheets to efficiently retrieve data without the limitations of VLOOKUP.
  • Use SUMIF with Wildcard Characters – Learn how to utilize COUNTIF with dates in Excel for effective data analysis. Explore examples demonstrating the counting of dates within a specified range using COUNTIF functions.
  • Use SUMPRODUCT and COUNTIF together – Learn how to efficiently use SUMPRODUCT and COUNTIF functions together in Excel for various calculations. Examples provided for counting duplicate items, cells with specific values, and unique values in a cell range.
  • Use VLOOKUP and INDIRECT Functions Together – Learn how to combine VLOOKUP and INDIRECT functions in Excel to search for values across different worksheets or workbooks.
  • Use VLOOKUP if Cell Contains Word within Text – Learn to use VLOOKUP in Excel to find data based on text within cells.
  • Using HLOOKUP to Retrieve Text Values – Learn how to use HLOOKUP in Excel to retrieve text values with the asterisk wildcard character in this informative guide.
  • Using the LINEST function – Perform linear regression analysis in Excel using the LINEST function to calculate statistics and best-fit trendlines for data points.
  • VLOOKUP by Column Name – Efficiently use VLOOKUP with Column Names in Excel for accurate data retrieval.
  • VLOOKUP for Rows – Learn how to utilize VLOOKUP for rows in Excel with this helpful guide. Find out how to search for information in rows using this function.
  • VLOOKUP from Another Sheet – Enhance your Excel skills by using VLOOKUP between different sheets to efficiently manage and analyze data.
  • VLOOKUP if Blank Returns Blank – Learn how to handle blank spaces in Excel VLOOKUP function with this useful guide. Master the IF function to return a custom result when VLOOKUP is blank.
  • VLOOKUP on Two (or More) Columns – VLOOKUP with multiple criteria in Excel explained with examples and formulas.
  • VLOOKUP with CONCATENATE – Combine VLOOKUP and CONCATENATE in Excel for efficient data analysis and financial modeling.
  • Year Over Year Growth – Improve your company’s performance analysis by calculating year-over-year growth in Excel with this easy and efficient method.
  • z score – Learn how to calculate z-scores in Excel using simple formulas and examples for data analysis.

Data Manipulation:

  • Highlight Duplicate Rows – Discover how to highlight duplicate rows in Excel using various methods and formulas.
  • Break Formula – Break Excel formulas into multiple lines for easier editing and readability.
  • Change Month from Text to Number – Learn how to easily convert month names to numbers in Excel using a simple formula.
  • Concatenate Date – Merge text from different cells into one cell in Excel using the CONCATENATE function.
  • Convert Time String to Time – Converting time strings to time and date in Excel explained with examples and formulas.
  • Extract Date – Extracting dates in Excel explained with formulas and examples, including how to extract year, month, day, and convert extracted text to date.
  • Ignore #NA Values With Formulas – Learn how to deal with #NA values in Excel formulas and improve your user experience while working with Excel. Discover the best formulas to ignore #NA values and get accurate results.
  • Keep a Number Constant – Learn how to keep a number constant in Excel by using absolute cell references. No need to worry about values changing when dragging cells.
  • Multiply Percentages – Improve Excel skills by learning how to multiply percentages efficiently in Excel.
  • Return Multiple Values in One Cell – Learn how to return multiple values in one cell in Excel using the TEXTJOIN formula.
  • Use Find and Replace in Formulas – Improve your Excel skills by learning how to use Find and Replace in Excel formulas effectively.
  • Use Transpose and Concatenate Together – Learn how to use the Transpose and Concatenate functions together in Excel to achieve great results.
  • Ignore Text in Formula – Learn how to ignore text in Excel formulas to avoid errors and work only with numeric values using functions and substitutions.
  • Increment Date [day, week, month] – Easily increment date in Excel using simple formulas for day, week, or month increments.
  • Leave a Cell Blank if the Condition Is False – Learn how to leave a cell blank in Excel if a certain condition is not met.
  • Merge Two Columns – Discover efficient methods to merge two columns in Excel seamlessly. Explore various techniques, including formulas, functions like CONCAT, and utilizing external tools like Notepad for quick merging tasks.
  • Remove #N/A – Fix your #N/A errors in Excel with this simple solution. Learn how to handle lookup function errors effectively.
  • Remove Blank Rows – Quickly remove blank rows in Excel using simple steps without the need for manual deletion.
  • Remove Leading and Trailing Spaces – Clean imported data in Excel by removing leading and trailing spaces with functions like TRIM, CLEAN, SUBSTITUTE, and Find & Replace.
  • Remove Leading Zeros – Learn how to remove leading zeros in Excel spreadsheets and convert text values into numbers effortlessly with these helpful tips and tricks.
  • Return Blank Cell Instead of Zero in Formulas – How to return blank cells instead of zeros in Excel formulas using the IF function.
  • Split Text to Columns With Formulas – Learn how to split text into columns using formulas in Excel. Manipulate strings with functions like SEARCH, MID, and SUBSTITUTE to customize your text splitting needs.
  • Sum and Ignore Errors – Discover how to sum and ignore errors in Excel using three different techniques. Learn to combine functions, use SUMIF, and utilize the AGGREGATE function to get accurate totals in your spreadsheets.
  • Trim and Combine Spaces – Easily remove extra spaces in Excel data with these 5 methods without using functions or formulas.

Calculations:

  • Ignore Zero when Calculating the Average Number – Calculate the average number in Excel while ignoring zeros using simple formulas and conditions.
  • Linear Interpolation – Understand linear interpolation in Excel and learn how to estimate values between two data points using formulas and functions. Master this method for accurate data analysis.
  • Midpoint Formula – Learn how to calculate the midpoint in Excel using different formulas. Find out how to use the AVERAGE function and a simple formula to get accurate results.
  • Mood’s Median Test – Easily perform Mood’s Median Test in Excel to compare medians of independent samples. Learn how to calculate medians, deviations, ranks, and interpret the results.
  • Net Loss Ratio Formula – Calculate the Net Loss Ratio in Excel to evaluate an insurance company’s profitability and financial health. Learn how to use formulas and named ranges for accurate results.
  • Number Match – Improve number matching in Excel using EXACT and MATCH functions. Learn how to compare numbers accurately with examples and explanations.
  • Produce Multiple Outputs in an IF Statement – Discover how to produce multiple outputs in an IF statement in Excel using various functions and examples.
  • Use If Function With Dates – Learn how to use the IF function with dates in Excel to compare and analyze your data effectively. Explore different scenarios to determine loan repayment dates and make informed decisions.
  • Apply Percentage Formula in Multiple Cells – Learn how to calculate percentages in multiple cells in Excel easily with this step-by-step guide.

Other:

  1. Convert UTC to EST – Easily convert Coordinated Universal Time to Eastern Standard Time in Excel using simple formulas.
  2. Empirical Probability – Learn how to calculate empirical probability in Excel using the PROB function. Understand the probabilities of events and how to use lower and upper limits for accurate results.