Learn Excel Formulas & Functions Fast
(170+ Free Tutorials)

Learn Excel formulas and functions in the shortest time possible.

Our 170+ tutorials show you exactly how to save time and solve problems with clear, actionable steps.

Ready to become an Excel pro? Start exploring now!

Table of Contents

General Function Overview

Get a comprehensive introduction to the most essential Excel functions.

• 15 Most Common Excel Functions You Must Know – Learn how to use the top 15 most common Excel functions with step-by-step examples.

Basic Formulas

Learn the fundamentals of writing and working with formulas in Excel.

• How to Write a Formula in Excel – A beginner-friendly tutorial for writing your first formula in Excel.
• How to Show Formulas in Excel – Discover four simple methods to display formulas instead of results.
• How to Set Decimal Places in Excel Formula – Learn how to control the number of decimal places displayed by your formulas.
• Does Dragging an Excel Formula Not Work? Here’s Why! – Troubleshoot formula dragging issues and learn how to fix them.
• How to Write an IF Then Formula in Excel – Step-by-step guide to writing IF Then formulas for dynamic decision-making.

Basic Mathematical Functions

Master essential mathematical calculations in Excel with these straightforward guides.

• How to Sum a Column in Excel – Learn how to add numbers in Excel with the SUM function.
• How to Do Subtraction in Excel – Step-by-step guide for performing subtraction in Excel.
• How to Subtract Multiple Cells in Excel – Learn how to subtract multiple values quickly in Excel.
• How to Multiply in Excel – Discover the easy formula for multiplication in Excel.
• How to Divide in Excel – Learn the division formula with practical examples.
• How to Use the MOD Function in Excel – Calculate remainders with the MOD function in Excel.
• How to Use the FLOOR Function in Excel – Round numbers down to the nearest multiple with the FLOOR function.

Date and Time Basics

Master Excel’s date and time functions to organize, calculate, and analyze temporal data effortlessly.

• All Time & Date Functions in Excel Explained – A comprehensive guide covering every time and date function in Excel.
• Today’s Date in Excel – Learn how to use functions and formulas to get today’s date in Excel.
• Excel NOW Function Guide – Get the current date and time dynamically with the NOW function.
• How to Extract Month From Date in Excel – Step-by-step tutorial for extracting the month from a date in Excel.
• Day of Week in Excel: WEEKDAY Function Explained – Learn how to identify the day of the week for any date using the WEEKDAY function.
• How to Get Week Number in Excel – Quick tutorial for determining the week number of any date.

Text Functions

Master Excel’s powerful text functions to manipulate, format, and analyze strings.

• The TEXT Function in Excel – Learn how to convert numbers into text using the TEXT function with practical examples.
• Excel Functions LEFT, RIGHT, MID, and LEN – Extract substrings and analyze text with these essential functions.
• How to Use TEXTJOIN in Excel – Concatenate multiple cells with ease using the TEXTJOIN function.
• How to Concatenate in Excel – Explore various methods to combine text, including CONCAT and ampersands.
• How to Count Words in Excel – Quickly count words in cells with simple formulas.
• How to Count How Many Times a Word Appears in Excel – Use formulas to calculate the frequency of specific words.
• How to Split Text in Formula – Use the TEXTSPLIT function to separate text into different columns or rows.
• How to Add Text to Excel Formula – Learn how to insert custom text into your formulas seamlessly.

Text and String Functions

Easily manipulate and analyze text in Excel with these essential formulas.

• How to Extract First Word in Excel – Quickly extract the first word from any cell in under a minute.
• How to Separate All Sorts of Data Using Excel Formulas – Learn how to split text and data into different cells using formulas.
• How to Count Cells With Specific Text Using a Formula – Use formulas to count cells containing specific words or phrases.

Percentage and Rounding Tools

Easily work with percentages and control number precision in Excel.

• How to Calculate Percent in Excel – Learn how to calculate percentages step by step using Excel formulas.
• How to Calculate Discount Percentage in Excel – Quickly determine discounts and savings with percentage formulas in Excel.
• How to Round Up in Excel (or Down) – A comprehensive guide to rounding numbers in Excel, both up and down.
• EXCEL TRUNCATE: Get Rid of Decimals From Numbers – Learn how to truncate decimals from numbers and trim text with the TRUNC function.

Sorting and Filtering Functions

Organize and refine your data effortlessly with Excel’s sorting and filtering tools.

• How to Add a Filter in Excel – Step-by-step guide to adding filters for quick data analysis.
• Excel SORT Function – Learn how to sort data dynamically using the SORT function in Excel.
• How to Use the FILTER Function in Excel – Master the FILTER function to extract specific data with examples.

Formula Tools

Streamline your workflow with these essential Excel formula tools.

• How to Drag a Formula Down in Excel – Learn the fastest way to drag formulas down a column in Excel.
• How to Apply Excel Formula to Entire Column – Easily apply a formula to an entire column in one step.
• How to Fix Excel Formulas Not Calculating – Troubleshoot and refresh formulas that aren’t calculating properly.
• Auto-Populate Data in Excel Based on Another Cell – Automatically fill data based on specific cell values.

Address and Offset Functions

Learn how to navigate and manipulate your data with Excel’s address and offset functions.

• How to Get Cell Address in Excel – Use the ADDRESS and CELL functions to quickly find the address of any cell.
• Excel INDIRECT Function: Formulas and Examples – Master the INDIRECT function to create dynamic and flexible cell references.
• How to Use the OFFSET Function in Excel – Learn how to navigate your data using the OFFSET function with 3 practical examples.
• How to Use the CHOOSE Function in Excel – Simplify complex formulas by selecting values with the CHOOSE function.
• The Excel ROW Function Explained – Easily find row numbers in your data with the ROW function.

Date Calculations

Simplify date-based calculations in Excel with these practical and powerful formulas.

• Excel Date Formula Explained – Learn how to use and modify date formulas in Excel, including changing date formats.
• How to Insert Dates in Excel Automatically – Automatically insert dates into your spreadsheet with these easy methods.
• Excel DATEDIF Function: Find Difference Between Dates – Discover how to calculate the difference between two dates using the DATEDIF function.
• How to Calculate Age in Excel – Step-by-step guide to calculating age from a given date.
• How to Calculate Years of Service in Excel – Learn how to calculate years of service based on hire dates.
• How to Calculate Business Days in Excel – Use the WORKDAY function to calculate business days between two dates.
• How to Calculate Quarter From a Date – Identify the quarter of the year for any given date using formulas.
• How to Find the First Day of the Month in Excel – Quickly find the first day of any month with this formula.
• Find the Number of Days in a Month – Calculate the number of days in any month with a simple formula.

Time Calculations

Master time-based calculations in Excel to work more efficiently with hours, minutes, and dates.

• How to Calculate Time in Excel – Learn how to use the TIME function to calculate durations and times accurately.
• Add Days to Date Using an Excel Formula – Easily extend or subtract days from any date using simple formulas.
• Convert Time Into Decimals in Excel – Step-by-step guide to converting time into decimals for hours, minutes, or seconds.

Counting and Frequency Functions

Analyze your data by counting values, duplicates, and unique entries with ease.

• How to Use the COUNT Function in Excel – Learn how to count cells with values using COUNT and COUNTA.
• How to Use COUNTIF in Excel – Step-by-step guide to using COUNTIF and COUNTIFS for conditional counting.
• How to Count Not Blank Cells in Excel – Count cells that are not blank using the COUNTIF function.
• How to Count Unique Values in Excel – Discover how to count unique and distinct values in your data.
• How to Count Duplicates in Excel – Identify and count duplicate words or values in Excel.
• How to Count Characters in Cells – Use formulas to count the number of characters in individual cells.
• How to Count Colored Cells in Excel – Learn multiple methods to count cells based on their color.
• How to Make a Frequency Table in Excel – Organize and analyze your data by creating frequency tables in Excel.

Conversion Functions

Easily convert data types in Excel for better compatibility and calculations.

• The VALUE Function Explained: Convert Text to Numbers – Learn how to use the VALUE function to convert text into numbers in Excel.

Binary Functions

Work with Excel’s logical functions to evaluate and manage data with Yes/No decisions.

• How to Add Yes or No Options in Excel – Learn how to create Yes/No options using drop-down lists and checkboxes.
• How to Find Duplicates in Excel Using a Formula – Discover how to identify duplicates in your data with a simple formula.
• Excel AND + OR Functions – Master logical operations with AND and OR functions, including examples with IF formulas.
• How to Use The IF and OR Functions Together in Excel – Step-by-step guide to combining IF and OR functions for advanced decision-making.

Condition-Based Functions

Control your formulas and outputs based on specific conditions for smarter data handling.

• How to Use the IF and AND Function in Excel – Learn how to combine the IF and AND functions to handle multiple conditions.
• How to Use Multiple IF Statements in Excel – Step-by-step guide to using nested IF statements for complex decision-making.
• How to Use “Does Not Equal” in Excel – Easily apply the “does not equal” operator to filter and compare data.
• How to Not Calculate If Cell is Blank in Excel – Ignore formulas when cells are blank with this simple guide.
• How to Leave Excel Cells Blank if They Return Zero – Make your sheets cleaner by displaying blank cells instead of zeros.

Lookup Functions

Quickly find and retrieve data from your Excel sheets with powerful lookup functions.

• How to Use VLOOKUP in Excel – A beginner-friendly guide to using VLOOKUP in four easy steps.
• How to Do VLOOKUP in Excel With Two Spreadsheets – Learn how to perform VLOOKUP across multiple spreadsheets with ease.
• VLOOKUP Not Working? Here Are 5 Methods to Fix It – Troubleshoot and resolve common VLOOKUP errors.
• VLOOKUP with Wildcards in Excel – Use wildcards to make VLOOKUP more flexible and powerful.
• How to Use XLOOKUP in Excel – Step-by-step guide to Excel’s modern and versatile XLOOKUP function.
• How to Use the INDEX Function in Excel – Learn how to retrieve data dynamically using the INDEX function.
• How to Use the MATCH Function in Excel – Find the position of values in a range with the MATCH function.
• How to Use INDEX MATCH With Multiple Criteria – Combine INDEX and MATCH for advanced, criteria-based lookups.
• How to Use the HLOOKUP Function in Excel – Learn to perform horizontal lookups with the HLOOKUP function.

Ranking and Averages

Analyze data rankings and calculate averages with precision using these powerful Excel tools.

• How to Use the MIN and MAX Functions in Excel – Learn how to find the smallest and largest values in your data with the MIN and MAX functions.
• How to Calculate Average in Excel – Step-by-step guide to calculating averages with Excel formulas.
• How to Find the Median in Excel – Learn how to calculate the median value in your dataset.
• How to Use the RANK Function in Excel – Discover how to rank data values in ascending or descending order.
• How to Calculate MEDIAN IF in Excel – Learn how to find the median based on conditions using a “MEDIANIFS” formula.
• How to Do RANK IF in Excel – Learn how to rank data with specific conditions in Excel.
• How to Use the XMATCH Function in Excel – Use XMATCH to find and rank data values dynamically.

Comparison Functions

Learn how to compare and analyze data ranges in Excel with ease.

• How to COUNTIF Between Two Numbers in Excel – Step-by-step guide to counting cells between two numbers using the COUNTIF function.

Data Manipulation Functions

Control and transform your data with these powerful Excel functions.

• If Cell Contains Text Then Return Value in Another Cell – Step-by-step guide to creating formulas that return specific values based on cell content.

Weighted Metrics and Profitability

Analyze profitability and weighted metrics for smarter financial decisions using Excel.

• How to Make a Weighted Average Formula in Excel – Step-by-step guide to calculating weighted averages for data analysis.
• How to Calculate Present Value in Excel – Learn to determine the present value of future cash flows using the PV function.
• How to Calculate Profitability Index in Excel – Discover how to evaluate investment efficiency with the profitability index formula.

Currency and Ratio Metrics

Calculate and convert financial metrics effortlessly with these Excel tools.

• How to Convert Currencies in Excel – Learn how to convert currencies in Excel accurately and for free.
• How to Calculate Ratios in Excel – Step-by-step guide to calculating ratios in Excel using simple formulas.
• How to Easily Calculate EBITDA in Excel – Learn how to calculate EBITDA in Excel with practical examples.

Averaging and Autosum Functions

Quickly calculate totals and averages in Excel with these simple yet powerful functions.

• How to Use AutoSum in Excel – Learn how to use the AutoSum button and shortcut to quickly calculate totals in Excel.
• How to Use the AVERAGEIF Function in Excel – Discover how to calculate averages based on specific conditions with AVERAGEIF.
• How to Use the Subtotal Function in Excel – Step-by-step guide to calculating subtotals for filtered data in Excel.

Logical Functions

Learn how to make smarter decisions and evaluate data with Excel’s logical functions.

• How to Use the IF Function in Excel – Step-by-step guide to using the IF function for decision-making in formulas.
• How to Use the IFS Function in Excel – Simplify complex logic with the IFS function and multiple examples.
• Logical Operators in Excel – Learn how to use operators like less than, greater than, and more in Excel formulas.
• How to Use the Excel Functions TRUE & FALSE – Understand Boolean logic with TRUE and FALSE functions.
• How to Use the Excel Functions ISNUMBER, ISTEXT, and ISNONTEXT – Validate your data with functions that check for specific text or numbers.

Error Checking Functions

Easily identify and handle errors in your Excel formulas with these essential functions.

• How to Use the ISBLANK Function in Excel – Learn how to check if a cell is blank and use the ISBLANK function effectively.
• Excel ISNA Function Guide – Step-by-step guide to detecting #N/A errors using the ISNA function.
• How to Use the IFERROR Function in Excel – Simplify error handling with the IFERROR function, including insights into ISERROR.
• How to Use the IFNA Function in Excel – Handle #N/A errors specifically with the IFNA function.

Advanced Mathematical Functions

Master powerful mathematical functions in Excel to tackle complex calculations and data analysis.

• How to Get Absolute Value in Excel – Learn how to use the ABS function to find the absolute value of numbers in Excel.
• How to Square Root in Excel – Calculate square roots and add the symbol in Excel easily.
• How to do Exponents in Excel – Use exponents in Excel with this simple guide.
• How to Use ‘e’ in Excel (Exponential Function) – Learn how to work with the exponential function “e” in Excel.
• How to Use the CEILING Function in Excel – Round numbers up with the CEILING function and learn its practical uses.
• How to Generate Random Numbers in Excel – Create random numbers using the RAND and RANDBETWEEN functions.
• How to Use the SUMPRODUCT Function in Excel – Combine arrays and calculate weighted sums with the SUMPRODUCT function.
• Find Percentage Difference Between Numbers in Excel – Calculate percentage differences between numbers step by step.
• How to Use the SLOPE Function in Excel – Understand and apply the SLOPE function for linear regression analysis.
• How to Change Negative Numbers to Positive in Excel – Quickly convert negative numbers to positive values in Excel.
• How to Convert Positive Numbers to Negative in Excel – Learn how to switch positive numbers to negative effortlessly.
• How to Convert Excel Formula to Value – Save the result of a formula as a static value in Excel.

Conditional Formatting and Visualization

Use conditional formatting and advanced functions to make your data clearer and more actionable.

• How to Use the SUMIF Function in Excel – Learn how to sum values based on conditions with SUMIF and SUMIFS.
• How to SUM by Color in Excel – Step-by-step guide to summing values in Excel based on cell colors.

Data Distribution and Percentiles

Analyze data distribution and statistical measures efficiently in Excel.

• How to Calculate a Range in Excel – Learn how to find the range of a dataset with simple formulas.
• How to Calculate Relative Frequency in Excel – Step-by-step guide to calculating relative frequencies for data analysis.
• How to Calculate Percentiles in Excel – Quickly calculate percentiles in Excel using built-in formulas.
• How to Calculate Standard Error in Excel – Learn how to calculate standard error with step-by-step instructions.
• How to Calculate a Z-Score in Excel – Use Excel formulas to calculate Z-scores for data standardization.
• How to Perform Linear Interpolation in Excel – Discover how to perform linear interpolation in Excel with practical examples.

Advanced Statistical Measures

Dive into statistical functions in Excel to analyze data with precision.

• Excel SMALL and LARGE Functions – Learn how to find the smallest or largest values in a range using the SMALL and LARGE functions.
• How to Average a Range in Excel and Ignore Zero – Calculate averages in Excel while excluding zeros from your data.
• How to Use MAXIFS and MINIFS in Excel – Step-by-step guide to finding the maximum and minimum values based on specific criteria.
• How to Calculate Standard Deviation in Excel – Learn how to calculate and interpret standard deviation for data analysis.

Statistical Testing and Variability

Analyze and interpret data variability and statistical significance with these powerful Excel tools.

• How to Calculate Variance in Excel – Learn how to measure data variability with Excel’s variance formulas.
• How to Find Coefficient of Variation in Excel – Calculate the coefficient of variation to understand data consistency.
• How to Calculate a Correlation Coefficient in Excel – Discover how to evaluate the strength of relationships between data sets.
• How to do Linear Regression in Excel – Step-by-step guide to performing linear regression for trend analysis.
• How to Calculate a Confidence Interval in Excel – Learn to calculate confidence intervals for precise data estimates.
• How to Calculate P Value in Excel – Step-by-step tutorial to calculate P values for statistical testing.
• How to Calculate and Do an ANOVA Test in Excel – Perform ANOVA tests to analyze variance across multiple groups.

Analysis Tools

Leverage Excel’s powerful analysis tools to extract insights and make data-driven decisions.

• How to Add the Data Analysis Toolpak in Excel – Step-by-step guide to enable and start using the Data Analysis Toolpak in Excel.
• How to Use Goal Seek in Excel – Learn how to use Goal Seek to solve for unknown values in your formulas.
• How to Randomize a List in Excel – Discover how to shuffle or randomize a list in Excel with ease.

Scenario Planning and Optimization

Optimize decision-making and analyze different scenarios using Excel’s advanced tools.

• How to Use the Scenario Manager in Excel – Learn how to create and analyze multiple scenarios in your spreadsheets.
• How to Make a Data Table in Excel – Step-by-step guide to setting up data tables for scenario analysis.
• How to Do Sensitivity Analysis in Excel – Explore how changes in variables affect outcomes with sensitivity analysis.
• Full Guide to Solver in Excel – Master Solver to optimize and find the best solutions for complex problems.

Forecasting and Trend Analysis

Leverage Excel’s tools to predict trends and make data-driven decisions.

• How to Use the Excel FORECAST Function – Step-by-step guide to using the FORECAST function for trend prediction and data forecasting.

Growth Metrics and ROI

Calculate growth and financial performance with these essential Excel formulas.

• How to Calculate Growth Rate in Excel – Step-by-step guide to calculating growth rates using formulas in Excel.
• How to Use The ROI Formula in Excel – Learn how to calculate return on investment (ROI) in Excel with examples.
• Profit Margin Formula in Excel – Discover how to calculate profit margins in Excel step by step.

Loan and Interest Calculations

Master Excel’s financial functions to calculate loans, interest rates, and future value with ease.

• How to Use the PMT Function in Excel – Calculate loan payments with the PMT function, including step-by-step examples.
• How to Use the RATE Function in Excel – Learn how to calculate interest rates for loans using the RATE function.
• How to Calculate APR in Excel – Step-by-step guide to calculating annual percentage rates (APR) in Excel.
• How to Use Excel’s Annuity Formula – Understand and apply the annuity formula to calculate regular payments.
• How to Calculate Future Value in Excel – Use the FV function to determine the future value of investments or savings.
• How to Use the IRR Function in Excel – Calculate internal rate of return (IRR) for investments step by step.
• How to Use the XIRR Function in Excel – Learn how to calculate irregular cash flow returns using the XIRR function.

Valuation and Return Metrics

Evaluate financial performance and value investments with Excel’s advanced financial formulas.

• How to Calculate Compound Interest in Excel – Learn step-by-step how to calculate compound interest with Excel formulas.
• How to Easily Calculate CAGR – Discover how to calculate compound annual growth rate (CAGR) in Excel.
• How to Calculate Your Expected Return in Excel – Use formulas to estimate the return on your investments with ease.
• How to Calculate NPV in Excel – Master the net present value (NPV) formula to assess investment profitability.
• Calculate Yield to Maturity in Excel – Learn to calculate the yield to maturity of bonds using the YIELDMAT function.
• How to Calculate WACC in Excel – Step-by-step guide to calculating the weighted average cost of capital (WACC).

Array and Advanced Formulas

Master complex formulas and advanced Excel techniques to supercharge your spreadsheets.

• How to Use an Array Formula in Excel – Learn the basics of array formulas and see examples of their powerful applications.
• How to Use the SEQUENCE Formula in Excel – Discover how to quickly generate a series of numbers or dates with the SEQUENCE formula.
• How to Apply an Excel Formula to Multiple Cells – Easily apply a single formula across multiple cells in Excel.
• How to Use Multiple Formulas in a Cell – Learn how to combine multiple formulas in a single Excel cell.
• How to Use the “Evaluate Formula” Feature in Excel – Step-by-step guide to debugging and analyzing complex formulas with the Evaluate Formula tool.

Specialized Functions

Unlock unique Excel functionalities with these powerful, specialized tools.

• How to Find Unique Values in Excel – Use the UNIQUE function to identify and extract distinct values from your data.
• How to Use Excel’s HYPERLINK Function – Learn how to create dynamic hyperlinks in Excel for seamless navigation.

Recommended Course: Zero to Hero

Want to master Excel formulas and functions faster than ever?

The Zero to Hero course covers everything you need to know to confidently write, edit, and troubleshoot formulas, as well as leverage Excel’s most powerful functions.

Whether you’re a beginner or ready to dive into advanced calculations, this course will help you transform your productivity and unlock Excel’s full potential.