# All Excel formulas - URL: https://betteranalyst.com/excel-formulas Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) Browse our complete library of Excel formula guides with syntax, examples, and tips for every function. [Try Formula Generator](https://betteranalyst.com/excel-ai) Working in a browser spreadsheet instead? See our [Google Sheets functions list](https://betteranalyst.com/google-sheets-formulas). 401 Formulas ## Excel functions A–Z - ### [ABS](https://betteranalyst.com/excel/abs-function) [The ABS function returns the absolute value of a number, eliminating any negative sign for precise calculations.](https://betteranalyst.com/excel/abs-function) - ### [ACCRINT](https://betteranalyst.com/excel/accrint-function) [The ACCRINT formula calculates accrued interest for bonds by inputting parameters like issue date, rate, and maturity for precise results.](https://betteranalyst.com/excel/accrint-function) - ### [ACCRINTM](https://betteranalyst.com/excel/accrintm-function) [The ACCRINTM function calculates accrued interest for bonds from issue date to maturity, providing a quick interest assessment.](https://betteranalyst.com/excel/accrintm-function) - ### [ACOS](https://betteranalyst.com/excel/acos-function) [The ACOS function calculates the arccosine of a number, returning the result in radians for accurate mathematical computations.](https://betteranalyst.com/excel/acos-function) - ### [ACOSH](https://betteranalyst.com/excel/acosh-function) [The ACOSH function calculates the inverse hyperbolic cosine of a number, useful for advanced mathematical and statistical analysis.](https://betteranalyst.com/excel/acosh-function) - ### [ACOT](https://betteranalyst.com/excel/acot-function) [The ACOT function calculates the arccotangent of a number, returning the angle in radians for accurate mathematical computations.](https://betteranalyst.com/excel/acot-function) - ### [ACOTH](https://betteranalyst.com/excel/acoth-function) [The ACOTH function calculates the inverse hyperbolic cotangent of a number, useful for advanced mathematical analysis in Excel.](https://betteranalyst.com/excel/acoth-function) - ### [ADDRESS](https://betteranalyst.com/excel/address-function) [The ADDRESS function generates a cell reference based on specified row and column numbers, allowing dynamic referencing in formulas.](https://betteranalyst.com/excel/address-function) - ### [AGGREGATE](https://betteranalyst.com/excel/aggregate-function) [The AGGREGATE function performs advanced calculations while allowing you to ignore errors and customize results for better data analysis.](https://betteranalyst.com/excel/aggregate-function) - ### [AMORDEGRC](https://betteranalyst.com/excel/amordegrc-function) [The AMORDEGRC function calculates depreciation for an asset based on its cost, purchase date, salvage value, and lifespan.](https://betteranalyst.com/excel/amordegrc-function) - ### [AMORLINC](https://betteranalyst.com/excel/amorlinc-function) [The AMORLINC function calculates an asset's depreciation over time, factoring in cost, purchase date, salvage value, and lifespan.](https://betteranalyst.com/excel/amorlinc-function) - ### [AND](https://betteranalyst.com/excel/and-function) [The AND function evaluates multiple conditions in Excel, returning TRUE only if all specified conditions are met for logical tests.](https://betteranalyst.com/excel/and-function) - ### [ARABIC](https://betteranalyst.com/excel/arabic-function) [The ARABIC function converts Roman numeral text into Arabic numbers, streamlining numerical calculations in Excel.](https://betteranalyst.com/excel/arabic-function) - ### [AREAS](https://betteranalyst.com/excel/areas-function) [The AREAS function counts the number of distinct areas in a specified range, aiding in efficient data analysis and management.](https://betteranalyst.com/excel/areas-function) - ### [ARRAYTOTEXT](https://betteranalyst.com/excel/arraytotext-function) [The ARRAYTOTEXT formula converts arrays into text format in Excel, enabling customized formatting for improved data presentation.](https://betteranalyst.com/excel/arraytotext-function) - ### [ASIN](https://betteranalyst.com/excel/asin-function) [The ASIN function calculates the arcsine of a number, returning the angle in radians for inputs between -1 and 1.](https://betteranalyst.com/excel/asin-function) - ### [ASINH](https://betteranalyst.com/excel/asinh-function) [The ASINH function calculates the inverse hyperbolic sine of a number, useful for advanced mathematical analysis in Excel.](https://betteranalyst.com/excel/asinh-function) - ### [ATAN](https://betteranalyst.com/excel/atan-function) [The ATAN function calculates the arctangent of a number, returning the angle in radians for trigonometric calculations in Excel.](https://betteranalyst.com/excel/atan-function) - ### [ATAN2](https://betteranalyst.com/excel/atan2-function) [The ATAN2 function calculates the arctangent of the quotient of two numbers, returning the angle in radians.](https://betteranalyst.com/excel/atan2-function) - ### [ATANH](https://betteranalyst.com/excel/atanh-function) [The ATANH function calculates the inverse hyperbolic tangent of a number for precise mathematical analysis in Excel.](https://betteranalyst.com/excel/atanh-function) - ### [AVEDEV](https://betteranalyst.com/excel/avedev-function) [The AVEDEV function calculates the average of absolute deviations from the mean, helping assess data variability and dispersion in a dataset.](https://betteranalyst.com/excel/avedev-function) - ### [AVERAGE](https://betteranalyst.com/excel/average-function) [The AVERAGE function calculates the mean of a range of numbers, providing insights for accurate data analysis in Excel.](https://betteranalyst.com/excel/average-function) - ### [AVERAGEA](https://betteranalyst.com/excel/averagea-function) [The AVERAGEA function calculates the average of a range, treating text as 0 and logical values as 1, including all data types in the range.](https://betteranalyst.com/excel/averagea-function) - ### [AVERAGEIF](https://betteranalyst.com/excel/averageif-function) [The AVERAGEIF function calculates the average of a range based on specified criteria, enhancing data analysis efficiency in Excel.](https://betteranalyst.com/excel/averageif-function) - ### [AVERAGEIFS](https://betteranalyst.com/excel/averageifs-function) [The AVERAGEIFS function calculates the average of a dataset based on specified criteria, allowing for precise data analysis in Excel.](https://betteranalyst.com/excel/averageifs-function) - ### [BASE](https://betteranalyst.com/excel/base-function) [The BASE function converts numbers to specified bases, allowing customization of radix and minimum length for flexible data representation.](https://betteranalyst.com/excel/base-function) - ### [BIN2DEC](https://betteranalyst.com/excel/bin2dec-function) [The BIN2DEC function converts binary numbers to decimal format, facilitating easier data analysis and calculations in Excel.](https://betteranalyst.com/excel/bin2dec-function) - ### [BIN2HEX](https://betteranalyst.com/excel/bin2hex-function) [The BIN2HEX function converts binary numbers to hexadecimal format, aiding in data analysis and format management in Excel.](https://betteranalyst.com/excel/bin2hex-function) - ### [BIN2OCT](https://betteranalyst.com/excel/bin2oct-function) [The BIN2OCT function converts binary numbers to octal format, allowing for customizable output length with the optional places argument.](https://betteranalyst.com/excel/bin2oct-function) - ### [BINOM.DIST](https://betteranalyst.com/excel/binom-dist-function) [The BINOM.DIST formula calculates the probability of a specific number of successes in a binomial distribution based on trials and success rate.](https://betteranalyst.com/excel/binom-dist-function) - ### [BINOMDIST](https://betteranalyst.com/excel/binomdist-function) [The BINOMDIST formula calculates the probability of achieving a specific number of successes in a binomial distribution scenario.](https://betteranalyst.com/excel/binomdist-function) - ### [BITAND](https://betteranalyst.com/excel/bitand-function) [The BITAND function performs a bitwise AND operation between two numbers, returning a number that represents the common bits set to 1.](https://betteranalyst.com/excel/bitand-function) - ### [BITLSHIFT](https://betteranalyst.com/excel/bitlshift-function) [The BITLSHIFT formula shifts bits to the left, multiplying the number by 2 for each shift, useful for advanced data manipulation.](https://betteranalyst.com/excel/bitlshift-function) - ### [BITOR](https://betteranalyst.com/excel/bitor-function) [The BITOR function performs a bitwise OR operation between two numbers, useful for efficient data manipulation in Excel.](https://betteranalyst.com/excel/bitor-function) - ### [BITRSHIFT](https://betteranalyst.com/excel/bitrshift-function) [The BITRSHIFT function shifts bits of a number to the right, effectively dividing it by powers of two for data manipulation.](https://betteranalyst.com/excel/bitrshift-function) - ### [BITXOR](https://betteranalyst.com/excel/bitxor-function) [The BITXOR function performs a bitwise XOR operation between two numbers, useful for efficient data analysis in Excel.](https://betteranalyst.com/excel/bitxor-function) - ### [BYCOL](https://betteranalyst.com/excel/bycol-function) [The =BYCOL function applies a lambda function to each column in a range, streamlining data analysis and manipulation in Excel.](https://betteranalyst.com/excel/bycol-function) - ### [BYROW](https://betteranalyst.com/excel/byrow-function) [The =BYROW(array, lambda) formula applies a specified function to each row in an array, streamlining data analysis in Excel.](https://betteranalyst.com/excel/byrow-function) - ### [CEILING](https://betteranalyst.com/excel/ceiling-function) [The CEILING function rounds numbers up to the nearest specified significance, ensuring precise calculations in Excel.](https://betteranalyst.com/excel/ceiling-function) - ### [CEILING.MATH](https://betteranalyst.com/excel/ceiling-math-function) [The CEILING.MATH function rounds numbers up to the nearest specified significance, helping to standardize values in calculations.](https://betteranalyst.com/excel/ceiling-math-function) - ### [CEILING.PRECISE](https://betteranalyst.com/excel/ceiling-precise-function) [The CEILING.PRECISE function rounds numbers up to the nearest specified significance, ensuring accurate and precise calculations in Excel.](https://betteranalyst.com/excel/ceiling-precise-function) - ### [CELL](https://betteranalyst.com/excel/cell-function) [The =CELL(info\_type, \[reference\]) formula retrieves details about a cell's formatting, location, or contents in Excel.](https://betteranalyst.com/excel/cell-function) - ### [CHAR](https://betteranalyst.com/excel/char-function) [The CHAR function converts numeric ASCII codes into their corresponding characters, simplifying text manipulation in Excel.](https://betteranalyst.com/excel/char-function) - ### [CHOOSE](https://betteranalyst.com/excel/choose-function) [The CHOOSE function selects a value from a list based on a specified index number, streamlining data retrieval and management in Excel.](https://betteranalyst.com/excel/choose-function) - ### [CHOOSECOLS](https://betteranalyst.com/excel/choosecols-function) [The CHOOSECOLS function selects specific columns from an array, simplifying data analysis by focusing on relevant information.](https://betteranalyst.com/excel/choosecols-function) - ### [CHOOSEROWS](https://betteranalyst.com/excel/chooserows-function) [The CHOOSEROWS function selects specific rows from an array, enhancing data analysis by allowing targeted data retrieval.](https://betteranalyst.com/excel/chooserows-function) - ### [CLEAN](https://betteranalyst.com/excel/clean-function) [The CLEAN function in Excel removes non-printable characters from text, ensuring your data is clean and easy to read in spreadsheets.](https://betteranalyst.com/excel/clean-function) - ### [CODE](https://betteranalyst.com/excel/code-function) [The =CODE(text) formula returns the numeric ASCII code of the first character in a text string, aiding in data analysis and manipulation.](https://betteranalyst.com/excel/code-function) - ### [COLUMN](https://betteranalyst.com/excel/column-function) [The =COLUMN(\[reference\]) formula returns the column number of a specified cell or range, aiding in data analysis and referencing.](https://betteranalyst.com/excel/column-function) - ### [COLUMNS](https://betteranalyst.com/excel/columns-function) [The COLUMNS function counts the number of columns in a specified array or range, providing a quick way to assess data structure.](https://betteranalyst.com/excel/columns-function) - ### [COMBIN](https://betteranalyst.com/excel/combin-function) [The COMBIN function calculates the number of combinations for a given number of items, helping you choose subsets from a larger set.](https://betteranalyst.com/excel/combin-function) - ### [COMBINA](https://betteranalyst.com/excel/combina-function) [The COMBINA function calculates the number of combinations of n items taken k at a time, useful for statistical analysis.](https://betteranalyst.com/excel/combina-function) - ### [COMPLEX](https://betteranalyst.com/excel/complex-function) [The COMPLEX function creates complex numbers from real and imaginary parts, aiding in advanced data analysis in Excel.](https://betteranalyst.com/excel/complex-function) - ### [CONCAT](https://betteranalyst.com/excel/concat-function) [The CONCAT function combines multiple text strings into one, improving data organization and presentation in Excel.](https://betteranalyst.com/excel/concat-function) - ### [CONCATENATE](https://betteranalyst.com/excel/concatenate-function) [The CONCATENATE function combines multiple text strings into one, improving data organization and presentation in Excel.](https://betteranalyst.com/excel/concatenate-function) - ### [CONVERT](https://betteranalyst.com/excel/convert-function) [The CONVERT function is used to change a value from one unit of measurement to another in Excel, simplifying unit conversions.](https://betteranalyst.com/excel/convert-function) - ### [COS](https://betteranalyst.com/excel/cos-function) [The COS function calculates the cosine of an angle in radians, aiding in precise trigonometric analysis within Excel.](https://betteranalyst.com/excel/cos-function) - ### [COSH](https://betteranalyst.com/excel/cosh-function) [The COSH function calculates the hyperbolic cosine of a number, useful in advanced math and engineering contexts.](https://betteranalyst.com/excel/cosh-function) - ### [COT](https://betteranalyst.com/excel/cot-function) [The COT keyword calculates the cotangent of an angle in radians for precise trigonometric analysis using the =COT(number) formula in Excel.](https://betteranalyst.com/excel/cot-function) - ### [COTH](https://betteranalyst.com/excel/coth-function) [The COTH function calculates the hyperbolic cotangent of a number, useful for advanced mathematical analysis and data modeling.](https://betteranalyst.com/excel/coth-function) - ### [COUNT](https://betteranalyst.com/excel/count-function) [The COUNT function in Excel counts numeric entries in a specified range, helping to analyze data effectively.](https://betteranalyst.com/excel/count-function) - ### [COUNTA](https://betteranalyst.com/excel/counta-function) [The COUNTA function counts non-empty cells in a specified range, aiding in effective data analysis and summarization.](https://betteranalyst.com/excel/counta-function) - ### [COUNTBLANK](https://betteranalyst.com/excel/countblank-function) [The COUNTBLANK function counts the number of empty cells in a specified range, helping identify gaps in data entry.](https://betteranalyst.com/excel/countblank-function) - ### [COUNTIFS](https://betteranalyst.com/excel/countifs-function) [The COUNTIF function counts the number of cells in a range that meet a specified condition or criteria.](https://betteranalyst.com/excel/countifs-function) - ### [COUPDAYBS](https://betteranalyst.com/excel/coupdaybs-function) [The COUPDAYBS function calculates the number of days from the settlement date to the next coupon payment date for a bond.](https://betteranalyst.com/excel/coupdaybs-function) - ### [COUPDAYS](https://betteranalyst.com/excel/coupdays-function) [The COUPDAYS function calculates the number of coupon payment days between settlement and maturity dates for a security.](https://betteranalyst.com/excel/coupdays-function) - ### [COUPDAYSNC](https://betteranalyst.com/excel/coupdaysnc-function) [The COUPDAYSNC function calculates the number of days from the settlement date to the next coupon payment date for a security.](https://betteranalyst.com/excel/coupdaysnc-function) - ### [COUPNCD](https://betteranalyst.com/excel/coupncd-function) [The COUPNCD function calculates the next coupon payment date for bonds, based on the settlement and maturity dates provided.](https://betteranalyst.com/excel/coupncd-function) - ### [COUPNUM](https://betteranalyst.com/excel/coupnum-function) [The COUPNUM function calculates the total number of coupon payments between the settlement date and maturity date of a bond.](https://betteranalyst.com/excel/coupnum-function) - ### [COUPPCD](https://betteranalyst.com/excel/couppcd-function) [The COUPPCD function calculates the next coupon payment date for bonds, simplifying bond analysis by providing essential payment timing information.](https://betteranalyst.com/excel/couppcd-function) - ### [CSC](https://betteranalyst.com/excel/csc-function) [The CSC function calculates the cosecant of an angle in radians, useful for trigonometric calculations in Excel.](https://betteranalyst.com/excel/csc-function) - ### [CSCH](https://betteranalyst.com/excel/csch-function) [The CSCH function calculates the hyperbolic cosecant of a number for advanced mathematical analysis in Excel.](https://betteranalyst.com/excel/csch-function) - ### [CUMIPMT](https://betteranalyst.com/excel/cumipmt-function) [The CUMIPMT function calculates cumulative interest payments over a specified period, using rate, periods, present value, and payment timing.](https://betteranalyst.com/excel/cumipmt-function) - ### [CUMPRINC](https://betteranalyst.com/excel/cumprinc-function) [The CUMPRINC formula calculates total principal payments over a period, using interest rate, periods, present value, and payment timing.](https://betteranalyst.com/excel/cumprinc-function) - ### [DATE](https://betteranalyst.com/excel/date-function) [The DATE function creates a date in Excel by specifying the year, month, and day for accurate formatting and calculations.](https://betteranalyst.com/excel/date-function) - ### [DATEDIF](https://betteranalyst.com/excel/datedif-function) [Calculate complete years, months, or days between two dates with DATEDIF, including unit choices, #NUM! behavior, and MD limitations.](https://betteranalyst.com/excel/datedif-function) - ### [DATEVALUE](https://betteranalyst.com/excel/datevalue-function) [The DATEVALUE function converts date text into a serial number for easier date calculations and analysis in Excel.](https://betteranalyst.com/excel/datevalue-function) - ### [DAVERAGE](https://betteranalyst.com/excel/daverage-function) [The DAVERAGE function calculates the average of a specified field in a database that meets defined criteria.](https://betteranalyst.com/excel/daverage-function) - ### [DAY](https://betteranalyst.com/excel/day-function) [The DAY function extracts the day from a date in Excel, helping simplify date analysis and improve data management.](https://betteranalyst.com/excel/day-function) - ### [DAYS](https://betteranalyst.com/excel/days-function) [The DAYS function calculates the number of days between two dates, providing a simple way to find date differences in Excel.](https://betteranalyst.com/excel/days-function) - ### [DAYS360](https://betteranalyst.com/excel/days360-function) [The DAYS360 function calculates the number of days between two dates based on a 360-day year, with options for different day count conventions.](https://betteranalyst.com/excel/days360-function) - ### [DB](https://betteranalyst.com/excel/db-function) [The DB function calculates depreciation for an asset based on its database, field, and specified criteria for precise financial evaluation.](https://betteranalyst.com/excel/db-function) - ### [DCOUNT](https://betteranalyst.com/excel/dcount-function) [The DCOUNT function counts the number of records in a database that meet specified criteria, aiding in precise data analysis.](https://betteranalyst.com/excel/dcount-function) - ### [DCOUNTA](https://betteranalyst.com/excel/dcounta-function) [The DCOUNTA function counts non-empty entries in a database that meet specified criteria, helping analyze data effectively.](https://betteranalyst.com/excel/dcounta-function) - ### [DDB](https://betteranalyst.com/excel/ddb-function) [The DDB function calculates asset depreciation using the double declining balance method, factoring in cost, salvage value, life, and period.](https://betteranalyst.com/excel/ddb-function) - ### [DEC2BIN](https://betteranalyst.com/excel/dec2bin-function) [The DEC2BIN function converts decimal numbers to binary format, allowing customization of output length with the optional places argument.](https://betteranalyst.com/excel/dec2bin-function) - ### [DEC2HEX](https://betteranalyst.com/excel/dec2hex-function) [The DEC2HEX function converts decimal numbers to hexadecimal format in Excel, with an option for padding digits.](https://betteranalyst.com/excel/dec2hex-function) - ### [DEC2OCT](https://betteranalyst.com/excel/dec2oct-function) [The DEC2OCT function converts decimal numbers to octal format in Excel, with an option to specify the number of digit places.](https://betteranalyst.com/excel/dec2oct-function) - ### [DECIMAL](https://betteranalyst.com/excel/decimal-function) [The DECIMAL function converts numbers from a specified base (radix) to decimal format, allowing for easy numerical analysis in Excel.](https://betteranalyst.com/excel/decimal-function) - ### [DEGREES](https://betteranalyst.com/excel/degrees-function) [The DEGREES function converts radians to degrees in Excel, simplifying angle calculations with the formula =DEGREES(radians).](https://betteranalyst.com/excel/degrees-function) - ### [DELTA](https://betteranalyst.com/excel/delta-function) [The DELTA function compares two numbers, returning 1 if they are equal and 0 if they are not, useful for logical tests in Excel.](https://betteranalyst.com/excel/delta-function) - ### [DEVSQ](https://betteranalyst.com/excel/devsq-function) [The DEVSQ function calculates the sum of squared deviations from the mean, aiding in statistical analysis and providing data insights.](https://betteranalyst.com/excel/devsq-function) - ### [DGET](https://betteranalyst.com/excel/dget-function) [The DGET function retrieves a single value from a database that meets specified criteria, aiding in targeted data analysis.](https://betteranalyst.com/excel/dget-function) - ### [DISC](https://betteranalyst.com/excel/disc-function) [The DISC function calculates the discount on a security based on settlement, maturity, rate, yield, redemption, frequency, and basis.](https://betteranalyst.com/excel/disc-function) - ### [DMAX](https://betteranalyst.com/excel/dmax-function) [The DMAX function returns the highest value from a specified field in a database that meets given criteria.](https://betteranalyst.com/excel/dmax-function) - ### [DMIN](https://betteranalyst.com/excel/dmin-function) [The DMIN function finds the minimum value in a database that meets specified criteria, aiding in efficient data analysis.](https://betteranalyst.com/excel/dmin-function) - ### [DOLLAR](https://betteranalyst.com/excel/dollar-function) [The DOLLAR function formats numbers as currency, allowing customization of decimal places for precise financial reporting.](https://betteranalyst.com/excel/dollar-function) - ### [DOLLARDE](https://betteranalyst.com/excel/dollarde-function) [The DOLLARDE function converts fractional dollar amounts to decimal, simplifying financial calculations in Excel.](https://betteranalyst.com/excel/dollarde-function) - ### [DOLLARFR](https://betteranalyst.com/excel/dollarfr-function) [The DOLLARFR function converts decimal numbers into fractional dollar amounts for accurate financial calculations.](https://betteranalyst.com/excel/dollarfr-function) - ### [DPRODUCT](https://betteranalyst.com/excel/dproduct-function) [The DPRODUCT function multiplies values in a specified field of a database that meet defined criteria.](https://betteranalyst.com/excel/dproduct-function) - ### [DROP](https://betteranalyst.com/excel/drop-function) [The DROP function removes designated rows and columns from an array, simplifying data for analysis and enhancing clarity in Excel.](https://betteranalyst.com/excel/drop-function) - ### [DSTDEV](https://betteranalyst.com/excel/dstdev-function) [The DSTDEV function calculates the standard deviation of a specified field in a database that meets given criteria.](https://betteranalyst.com/excel/dstdev-function) - ### [DSTDEVP](https://betteranalyst.com/excel/dstdevp-function) [The DSTDEVP function calculates the standard deviation of a population based on specified criteria in a database for precise statistical analysis.](https://betteranalyst.com/excel/dstdevp-function) - ### [DSUM](https://betteranalyst.com/excel/dsum-function) [The =DSUM function calculates the sum of a specified field in a database that meets defined criteria.](https://betteranalyst.com/excel/dsum-function) - ### [DURATION](https://betteranalyst.com/excel/duration-function) [The DURATION formula calculates a bond's Macaulay duration using settlement, maturity, coupon, yield, frequency, and basis as inputs.](https://betteranalyst.com/excel/duration-function) - ### [DVAR](https://betteranalyst.com/excel/dvar-function) [The DVAR function calculates the variance of a dataset based on given criteria, aiding in precise data analysis.](https://betteranalyst.com/excel/dvar-function) - ### [DVARP](https://betteranalyst.com/excel/dvarp-function) [The DVARP function calculates the variance of a population based on specified criteria within a data set in Excel.](https://betteranalyst.com/excel/dvarp-function) - ### [EDATE](https://betteranalyst.com/excel/edate-function) [The EDATE function calculates future dates by adding a specified number of months to a start date for effective date management.](https://betteranalyst.com/excel/edate-function) - ### [EFFECT](https://betteranalyst.com/excel/effect-function) [The EFFECT formula calculates the effective interest rate from a nominal rate and compounding periods, reflecting true borrowing costs.](https://betteranalyst.com/excel/effect-function) - ### [ENCODEURL](https://betteranalyst.com/excel/encodeurl-function) [The ENCODEURL function converts text into a URL-encoded format, making it suitable for web use by replacing special characters.](https://betteranalyst.com/excel/encodeurl-function) - ### [EOMONTH](https://betteranalyst.com/excel/eomonth-function) [The EOMONTH function calculates the last day of a month, given a start date and a number of months to add or subtract.](https://betteranalyst.com/excel/eomonth-function) - ### [ERROR.TYPE](https://betteranalyst.com/excel/error-type-function) [The =ERROR.TYPE(error\_val) formula identifies specific error types in Excel, aiding in effective data troubleshooting and analysis.](https://betteranalyst.com/excel/error-type-function) - ### [EVEN](https://betteranalyst.com/excel/even-function) [The EVEN function rounds a number up to the nearest even integer, ensuring consistent and accurate data analysis in Excel.](https://betteranalyst.com/excel/even-function) - ### [EXACT](https://betteranalyst.com/excel/exact-function) [The EXACT function compares two text strings for exact matches, returning TRUE for a match and FALSE otherwise.](https://betteranalyst.com/excel/exact-function) - ### [EXP](https://betteranalyst.com/excel/exp-function) [The EXP function calculates the exponential value of a number, useful for advanced math and finance in Excel.](https://betteranalyst.com/excel/exp-function) - ### [EXPAND](https://betteranalyst.com/excel/expand-function) [The EXPAND function resizes arrays by adding rows and columns, allowing for padding of empty spaces to enhance data organization.](https://betteranalyst.com/excel/expand-function) - ### [FACT](https://betteranalyst.com/excel/fact-function) [The FACT function calculates the factorial of a number by multiplying all positive integers up to that number in Excel.](https://betteranalyst.com/excel/fact-function) - ### [FACTDOUBLE](https://betteranalyst.com/excel/factdouble-function) [The FACTDOUBLE function calculates the double factorial of a number, useful for advanced mathematical computations in Excel.](https://betteranalyst.com/excel/factdouble-function) - ### [FALSE](https://betteranalyst.com/excel/false-function) [The =FALSE() formula returns the logical value FALSE, aiding in conditional statements and data validation within Excel.](https://betteranalyst.com/excel/false-function) - ### [FIELDVALUE](https://betteranalyst.com/excel/fieldvalue-function) [The FIELDVALUE function retrieves specific values from a designated field in a data table for efficient data analysis.](https://betteranalyst.com/excel/fieldvalue-function) - ### [FILTER](https://betteranalyst.com/excel/filter-function) [The FILTER function extracts data from a range based on specified criteria, allowing customization for empty results.](https://betteranalyst.com/excel/filter-function) - ### [FILTERXML](https://betteranalyst.com/excel/filterxml-function) [The FILTERXML function extracts data from XML documents using specified XPath queries for efficient data retrieval in Excel.](https://betteranalyst.com/excel/filterxml-function) - ### [FIND](https://betteranalyst.com/excel/find-function) [The FIND function locates specific text within a string, starting from a specified position, returning the text's starting index.](https://betteranalyst.com/excel/find-function) - ### [FIXED](https://betteranalyst.com/excel/fixed-function) [The FIXED function formats numbers with a set number of decimal places and can remove commas for clearer data presentation.](https://betteranalyst.com/excel/fixed-function) - ### [FLOOR](https://betteranalyst.com/excel/floor-function) [The FLOOR function rounds down a number to the nearest specified significance, aiding in precise data analysis and reporting.](https://betteranalyst.com/excel/floor-function) - ### [FLOOR.MATH](https://betteranalyst.com/excel/floor-math-function) [The FLOOR.MATH function rounds numbers down to the nearest specified significance, simplifying calculations in Excel.](https://betteranalyst.com/excel/floor-math-function) - ### [FLOOR.PRECISE](https://betteranalyst.com/excel/floor-precise-function) [The FLOOR.PRECISE function rounds down a number to the nearest specified significance, ignoring any fractional part.](https://betteranalyst.com/excel/floor-precise-function) - ### [FORECAST](https://betteranalyst.com/excel/forecast-function) [The FORECAST function predicts future values using existing x and y data trends, helping to estimate outcomes based on historical data.](https://betteranalyst.com/excel/forecast-function) - ### [FORECAST.ETS](https://betteranalyst.com/excel/forecast-ets-function) [The FORECAST.ETS function predicts future values using historical data and seasonal patterns, enhancing forecasting accuracy in Excel.](https://betteranalyst.com/excel/forecast-ets-function) - ### [FORECAST.ETS.CONFINT](https://betteranalyst.com/excel/forecast-ets-confint-function) [The FORECAST.ETS.CONFINT formula predicts future values and provides confidence intervals based on historical data trends in Excel.](https://betteranalyst.com/excel/forecast-ets-confint-function) - ### [FORECAST.ETS.SEASONALITY](https://betteranalyst.com/excel/forecast-ets-seasonality-function) [The FORECAST.ETS.SEASONALITY formula estimates the seasonal pattern in time series data, helping identify trends over specific intervals.](https://betteranalyst.com/excel/forecast-ets-seasonality-function) - ### [FORECAST.ETS.STAT](https://betteranalyst.com/excel/forecast-ets-stat-function) [The =FORECAST.ETS.STAT formula predicts future values based on historical data, accounting for seasonality and data gaps.](https://betteranalyst.com/excel/forecast-ets-stat-function) - ### [FORECAST.LINEAR](https://betteranalyst.com/excel/forecast-linear-function) [The =FORECAST.LINEAR function predicts future y values based on known x and y values, using linear regression to identify trends.](https://betteranalyst.com/excel/forecast-linear-function) - ### [FORMULATEXT](https://betteranalyst.com/excel/formulatext-function) [The FORMULATEXT function retrieves and displays the formula from a specified cell, aiding in auditing and formula tracking in Excel.](https://betteranalyst.com/excel/formulatext-function) - ### [FREQUENCY](https://betteranalyst.com/excel/frequency-function) [The FREQUENCY formula calculates how often data points fall within defined intervals, or bins, providing a distribution of values.](https://betteranalyst.com/excel/frequency-function) - ### [FV](https://betteranalyst.com/excel/fv-function) [The FV function calculates the future value of an investment based on interest rate, payment periods, and optional present value and type.](https://betteranalyst.com/excel/fv-function) - ### [FVSCHEDULE](https://betteranalyst.com/excel/fvschedule-function) [The FVSCHEDULE function calculates the future value of an investment based on a principal and a series of compound interest rates.](https://betteranalyst.com/excel/fvschedule-function) - ### [GCD](https://betteranalyst.com/excel/gcd-function) [The GCD function calculates the greatest common divisor of two or more numbers, aiding in efficient mathematical problem-solving in Excel.](https://betteranalyst.com/excel/gcd-function) - ### [GEOMEAN](https://betteranalyst.com/excel/geomean-function) [The GEOMEAN function calculates the geometric mean of a range of numbers, providing an accurate average for multiplicative datasets.](https://betteranalyst.com/excel/geomean-function) - ### [GETPIVOTDATA](https://betteranalyst.com/excel/getpivotdata-function) [The GETPIVOTDATA function retrieves specific data from a pivot table, allowing for efficient data extraction and analysis.](https://betteranalyst.com/excel/getpivotdata-function) - ### [GROUPBY](https://betteranalyst.com/excel/groupby-function) [The GROUPBY function organizes data by specified columns and allows for summarization using various aggregation methods.](https://betteranalyst.com/excel/groupby-function) - ### [HARMEAN](https://betteranalyst.com/excel/harmean-function) [The HARMEAN function calculates the harmonic mean of a dataset, providing a more accurate average for rates and ratios in analysis.](https://betteranalyst.com/excel/harmean-function) - ### [HEX2BIN](https://betteranalyst.com/excel/hex2bin-function) [The HEX2BIN function converts hexadecimal numbers to binary, allowing you to specify the number of bits for consistent formatting.](https://betteranalyst.com/excel/hex2bin-function) - ### [HEX2DEC](https://betteranalyst.com/excel/hex2dec-function) [The HEX2DEC function converts hexadecimal numbers to decimal format for easier numerical analysis and data manipulation in Excel.](https://betteranalyst.com/excel/hex2dec-function) - ### [HEX2OCT](https://betteranalyst.com/excel/hex2oct-function) [The HEX2OCT function converts hexadecimal numbers to octal format in Excel, streamlining data conversion tasks efficiently.](https://betteranalyst.com/excel/hex2oct-function) - ### [HLOOKUP](https://betteranalyst.com/excel/hlookup-function) [The HLOOKUP function searches for a value in the top row of a horizontal table and returns a corresponding value from a specified row below.](https://betteranalyst.com/excel/hlookup-function) - ### [HOUR](https://betteranalyst.com/excel/hour-function) [The HOUR function extracts the hour from a time serial number in Excel, aiding in time analysis and calculations.](https://betteranalyst.com/excel/hour-function) - ### [HSTACK](https://betteranalyst.com/excel/hstack-function) [The HSTACK function combines multiple arrays side by side, enhancing data organization and analysis in Excel.](https://betteranalyst.com/excel/hstack-function) - ### [HYPERLINK](https://betteranalyst.com/excel/hyperlink-function) [The HYPERLINK formula creates clickable links in Excel, enabling quick access to web pages or documents directly from the spreadsheet.](https://betteranalyst.com/excel/hyperlink-function) - ### [IF](https://betteranalyst.com/excel/if-function) [The IF function evaluates a condition and returns one value if true and another if false, enabling dynamic decision-making in Excel.](https://betteranalyst.com/excel/if-function) - ### [IFERROR](https://betteranalyst.com/excel/iferror-function) [The IFERROR function is used to return a specified value if a formula results in an error, ensuring cleaner and more user-friendly spreadsheets.](https://betteranalyst.com/excel/iferror-function) - ### [IFNA](https://betteranalyst.com/excel/ifna-function) [The IFNA function returns a specified value when a formula results in #N/A, helping to manage errors in Excel calculations.](https://betteranalyst.com/excel/ifna-function) - ### [IFS](https://betteranalyst.com/excel/ifs-function) [The IFS function evaluates multiple conditions in Excel and returns specified values based on the first true condition met.](https://betteranalyst.com/excel/ifs-function) - ### [IMABS](https://betteranalyst.com/excel/imabs-function) [The IMABS function calculates the absolute value of a complex number in Excel, useful for data analysis and mathematical computations.](https://betteranalyst.com/excel/imabs-function) - ### [IMAGE](https://betteranalyst.com/excel/image-function) [The IMAGE function allows users to insert and customize images in Excel, adjusting alt text, size, height, and width for better presentation.](https://betteranalyst.com/excel/image-function) - ### [IMAGINARY](https://betteranalyst.com/excel/imaginary-function) [The IMAGINARY function extracts the imaginary part of a complex number, aiding in advanced mathematical calculations in Excel.](https://betteranalyst.com/excel/imaginary-function) - ### [IMARGUMENT](https://betteranalyst.com/excel/imargument-function) [The IMARGUMENT function extracts the angle (argument) from a complex number, simplifying calculations involving complex numbers in Excel.](https://betteranalyst.com/excel/imargument-function) - ### [IMCONJUGATE](https://betteranalyst.com/excel/imconjugate-function) [The IMCONJUGATE function calculates the complex conjugate of a complex number for precise mathematical analysis in Excel.](https://betteranalyst.com/excel/imconjugate-function) - ### [IMCOS](https://betteranalyst.com/excel/imcos-function) [The IMCOS function calculates the cosine of a complex number, providing precise results for complex number operations in Excel.](https://betteranalyst.com/excel/imcos-function) - ### [IMCOSH](https://betteranalyst.com/excel/imcosh-function) [The IMCOSH function calculates the hyperbolic cosine of a complex number, useful in advanced math and engineering contexts.](https://betteranalyst.com/excel/imcosh-function) - ### [IMCOT](https://betteranalyst.com/excel/imcot-function) [The IMCOT function calculates the inverse cotangent of a complex number for accurate mathematical analysis in Excel.](https://betteranalyst.com/excel/imcot-function) - ### [IMCSC](https://betteranalyst.com/excel/imcsc-function) [The IMCSC function calculates the inverse of a complex number for accurate mathematical analysis in Excel.](https://betteranalyst.com/excel/imcsc-function) - ### [IMCSCH](https://betteranalyst.com/excel/imcsch-function) [The IMCSCH function calculates the inverse hyperbolic sine of a complex number, aiding in advanced mathematical analysis in Excel.](https://betteranalyst.com/excel/imcsch-function) - ### [IMDIV](https://betteranalyst.com/excel/imdiv-function) [The IMDIV function is used to divide one complex number by another in Excel, returning the result as a complex number.](https://betteranalyst.com/excel/imdiv-function) - ### [IMEXP](https://betteranalyst.com/excel/imexp-function) [The IMEXP function calculates the exponential of a complex number, aiding in advanced mathematical analysis in Excel.](https://betteranalyst.com/excel/imexp-function) - ### [IMLN](https://betteranalyst.com/excel/imln-function) [The IMLN function calculates the natural logarithm of a complex number for advanced mathematical analysis in Excel.](https://betteranalyst.com/excel/imln-function) - ### [IMLOG10](https://betteranalyst.com/excel/imlog10-function) [The IMLOG10 function calculates the base-10 logarithm of a complex number for accurate mathematical analysis in Excel.](https://betteranalyst.com/excel/imlog10-function) - ### [IMLOG2](https://betteranalyst.com/excel/imlog2-function) [The IMLOG2 function calculates the base-2 logarithm of complex numbers in Excel, simplifying complex data analysis tasks.](https://betteranalyst.com/excel/imlog2-function) - ### [IMPOWER](https://betteranalyst.com/excel/impower-function) [The IMPOWER function raises a complex number to a specified power, returning the result as a complex number in Excel.](https://betteranalyst.com/excel/impower-function) - ### [IMPRODUCT](https://betteranalyst.com/excel/improduct-function) [The IMPRODUCT function multiplies multiple numbers together in Excel for efficient calculations and data analysis.](https://betteranalyst.com/excel/improduct-function) - ### [IMREAL](https://betteranalyst.com/excel/imreal-function) [The IMREAL function extracts the real part of a complex number in Excel, aiding in efficient data analysis.](https://betteranalyst.com/excel/imreal-function) - ### [IMSEC](https://betteranalyst.com/excel/imsec-function) [The IMSEC function calculates the imaginary secant of a complex number for accurate mathematical analysis in Excel.](https://betteranalyst.com/excel/imsec-function) - ### [IMSECH](https://betteranalyst.com/excel/imsech-function) [The IMSECH function calculates the inverse hyperbolic secant of a number, useful in mathematics and engineering for solving hyperbolic equations.](https://betteranalyst.com/excel/imsech-function) - ### [IMSIN](https://betteranalyst.com/excel/imsin-function) [The IMSIN function calculates the sine of a complex number in Excel, useful for advanced math and engineering tasks.](https://betteranalyst.com/excel/imsin-function) - ### [IMSINH](https://betteranalyst.com/excel/imsinh-function) [The IMSINH function calculates the hyperbolic sine of a complex number, useful in advanced math and engineering contexts.](https://betteranalyst.com/excel/imsinh-function) - ### [IMSQRT](https://betteranalyst.com/excel/imsqrt-function) [The IMSQRT function calculates the square root of a complex number in Excel, useful for advanced math and engineering tasks.](https://betteranalyst.com/excel/imsqrt-function) - ### [IMSUB](https://betteranalyst.com/excel/imsub-function) [The IMSUB function subtracts one complex number from another in Excel, allowing for efficient calculations with complex values.](https://betteranalyst.com/excel/imsub-function) - ### [IMSUM](https://betteranalyst.com/excel/imsum-function) [The IMSUM function is used to calculate the sum of multiple complex numbers in Excel, simplifying complex number addition.](https://betteranalyst.com/excel/imsum-function) - ### [IMTAN](https://betteranalyst.com/excel/imtan-function) [The IMTAN function calculates the inverse tangent of a complex number in Excel, aiding in complex number analysis and calculations.](https://betteranalyst.com/excel/imtan-function) - ### [INDEX](https://betteranalyst.com/excel/index-function) [The INDEX function retrieves values from a specified array using row and optional column numbers for precise data extraction.](https://betteranalyst.com/excel/index-function) - ### [INDIRECT](https://betteranalyst.com/excel/indirect-function) [The INDIRECT function allows you to create dynamic cell references, enabling flexible data manipulation in your Excel spreadsheets.](https://betteranalyst.com/excel/indirect-function) - ### [INFO](https://betteranalyst.com/excel/info-function) [The INFO function retrieves information about the current Excel environment, such as the version, operating system, and settings.](https://betteranalyst.com/excel/info-function) - ### [INT](https://betteranalyst.com/excel/int-function) [The INT function rounds down a number to the nearest integer, aiding in data analysis and simplifying calculations in Excel.](https://betteranalyst.com/excel/int-function) - ### [INTERCEPT](https://betteranalyst.com/excel/intercept-function) [The INTERCEPT function calculates the y-intercept of a linear regression line based on known y and x values in Excel.](https://betteranalyst.com/excel/intercept-function) - ### [INTRATE](https://betteranalyst.com/excel/intrate-function) [The INTRATE function calculates the annual interest rate of an investment based on settlement, maturity, investment, and redemption values.](https://betteranalyst.com/excel/intrate-function) - ### [IPMT](https://betteranalyst.com/excel/ipmt-function) [The IPMT function calculates interest payments on loans for specific periods, aiding in financial analysis and budgeting.](https://betteranalyst.com/excel/ipmt-function) - ### [IRR](https://betteranalyst.com/excel/irr-function) [The IRR function calculates the internal rate of return for a series of cash flows, helping assess investment profitability over time.](https://betteranalyst.com/excel/irr-function) - ### [ISBLANK](https://betteranalyst.com/excel/isblank-function) [The ISBLANK function checks if a specified cell is empty, returning TRUE for blank cells and FALSE for those containing data.](https://betteranalyst.com/excel/isblank-function) - ### [ISERR](https://betteranalyst.com/excel/iserr-function) [The ISERR function checks for errors in Excel, returning TRUE for all errors except #N/A, aiding in effective data management.](https://betteranalyst.com/excel/iserr-function) - ### [ISERROR](https://betteranalyst.com/excel/iserror-function) [The ISERROR function checks if a value is an error, returning TRUE for errors and FALSE for non-errors in Excel.](https://betteranalyst.com/excel/iserror-function) - ### [ISEVEN](https://betteranalyst.com/excel/iseven-function) [The ISEVEN function checks if a number is even, returning TRUE for even numbers and FALSE for odd ones.](https://betteranalyst.com/excel/iseven-function) - ### [ISFORMULA](https://betteranalyst.com/excel/isformula-function) [The ISFORMULA function checks if a specified cell contains a formula, useful for data validation and error checking in Excel.](https://betteranalyst.com/excel/isformula-function) - ### [ISLOGICAL](https://betteranalyst.com/excel/islogical-function) [The ISLOGICAL function checks if a value is TRUE or FALSE, useful for validating data and performing logical tests in Excel.](https://betteranalyst.com/excel/islogical-function) - ### [ISNA](https://betteranalyst.com/excel/isna-function) [The ISNA function checks if a value is #N/A, allowing you to handle errors and enhance data accuracy in your Excel spreadsheets.](https://betteranalyst.com/excel/isna-function) - ### [ISNONTEXT](https://betteranalyst.com/excel/isnontext-function) [The ISNONTEXT function checks if a value is not text, returning TRUE for non-text values and FALSE for text entries.](https://betteranalyst.com/excel/isnontext-function) - ### [ISNUMBER](https://betteranalyst.com/excel/isnumber-function) [The ISNUMBER function checks if a specified value is a number, useful for validating data and ensuring accuracy in spreadsheets.](https://betteranalyst.com/excel/isnumber-function) - ### [ISODD](https://betteranalyst.com/excel/isodd-function) [The ISODD function checks if a number is odd, returning TRUE for odd numbers and FALSE for even numbers.](https://betteranalyst.com/excel/isodd-function) - ### [ISOMITTED](https://betteranalyst.com/excel/isomitted-function) [The ISOMITTED function checks for omitted values in Excel, returning TRUE if a value is omitted and FALSE if it is present.](https://betteranalyst.com/excel/isomitted-function) - ### [ISOWEEKNUM](https://betteranalyst.com/excel/isoweeknum-function) [The ISOWEEKNUM function calculates the ISO week number for a specified date, helping to organize data by week efficiently.](https://betteranalyst.com/excel/isoweeknum-function) - ### [ISPMT](https://betteranalyst.com/excel/ispmt-function) [The ISPMT function calculates interest paid on a loan for a specific period, simplifying interest calculations in Excel.](https://betteranalyst.com/excel/ispmt-function) - ### [ISREF](https://betteranalyst.com/excel/isref-function) [The ISREF function checks if a value refers to a valid cell or range in Excel, aiding in data validation and error checking.](https://betteranalyst.com/excel/isref-function) - ### [ISTEXT](https://betteranalyst.com/excel/istext-function) [The ISTEXT function checks if a specified value is text, aiding in data validation and ensuring correct data types in spreadsheets.](https://betteranalyst.com/excel/istext-function) - ### [LAMBDA](https://betteranalyst.com/excel/lambda-function) [The LAMBDA function allows users to define custom formulas with parameters, streamlining calculations and boosting productivity in Excel.](https://betteranalyst.com/excel/lambda-function) - ### [LARGE](https://betteranalyst.com/excel/large-function) [The LARGE function retrieves the k-th largest value from a specified array, helping analyze data effectively.](https://betteranalyst.com/excel/large-function) - ### [LCM](https://betteranalyst.com/excel/lcm-function) [The LCM function calculates the least common multiple of two or more numbers in Excel, aiding in efficient data analysis.](https://betteranalyst.com/excel/lcm-function) - ### [LEFT](https://betteranalyst.com/excel/left-function) [The LEFT formula extracts a specified number of characters from the start of a text string in Excel, allowing for easy customization.](https://betteranalyst.com/excel/left-function) - ### [LEN](https://betteranalyst.com/excel/len-function) [The LEN function counts the number of characters in a text string, aiding in efficient data analysis and management in Excel.](https://betteranalyst.com/excel/len-function) - ### [LET](https://betteranalyst.com/excel/let-function) [The LET function allows you to define variables in Excel, improving formula readability and performance by reusing calculations.](https://betteranalyst.com/excel/let-function) - ### [LINEST](https://betteranalyst.com/excel/linest-function) [The LINEST function calculates the statistics for a linear regression model, helping analyze relationships between variables in data sets.](https://betteranalyst.com/excel/linest-function) - ### [LN](https://betteranalyst.com/excel/ln-function) [The LN function calculates the natural logarithm of a specified number, aiding in advanced mathematical analysis and data modeling.](https://betteranalyst.com/excel/ln-function) - ### [LOG](https://betteranalyst.com/excel/log-function) [The LOG function calculates logarithms in Excel, enabling users to define both the number and base for flexible mathematical computations.](https://betteranalyst.com/excel/log-function) - ### [LOG10](https://betteranalyst.com/excel/log10-function) [The LOG10 function calculates the base-10 logarithm of a number, aiding in data analysis and simplifying mathematical computations.](https://betteranalyst.com/excel/log10-function) - ### [LOOKUP](https://betteranalyst.com/excel/lookup-function) [The LOOKUP formula is used to search for a value in a range and return a corresponding value from another range efficiently.](https://betteranalyst.com/excel/lookup-function) - ### [LOWER](https://betteranalyst.com/excel/lower-function) [The LOWER function converts any text string to lowercase, streamlining data formatting in Excel.](https://betteranalyst.com/excel/lower-function) - ### [MAKEARRAY](https://betteranalyst.com/excel/makearray-function) [The MAKEARRAY function generates dynamic arrays by defining rows, columns, and custom calculations using lambda functions.](https://betteranalyst.com/excel/makearray-function) - ### [MAP](https://betteranalyst.com/excel/map-function) [The =MAP function applies a custom lambda function to each element in an array, streamlining data manipulation in Excel.](https://betteranalyst.com/excel/map-function) - ### [MATCH](https://betteranalyst.com/excel/match-function) [The MATCH function locates the position of a specified value within a range, aiding in data analysis and lookup tasks in Excel.](https://betteranalyst.com/excel/match-function) - ### [MAX](https://betteranalyst.com/excel/max-function) [The MAX function in Excel identifies the highest number in a range, streamlining data analysis by quickly highlighting maximum values.](https://betteranalyst.com/excel/max-function) - ### [MAXA](https://betteranalyst.com/excel/maxa-function) [The MAXA function returns the maximum value in a dataset, considering numbers, text, and logical values like TRUE and FALSE.](https://betteranalyst.com/excel/maxa-function) - ### [MAXIFS](https://betteranalyst.com/excel/maxifs-function) [The MAXIFS formula finds the highest value in a range that meets specified criteria, streamlining data analysis with multiple conditions.](https://betteranalyst.com/excel/maxifs-function) - ### [MDETERM](https://betteranalyst.com/excel/mdeterm-function) [The MDETERM function calculates the determinant of a matrix, aiding in data analysis and mathematical computations in Excel.](https://betteranalyst.com/excel/mdeterm-function) - ### [MDURATION](https://betteranalyst.com/excel/mduration-function) [The MDURATION function calculates a bond's modified duration, indicating its sensitivity to interest rate changes.](https://betteranalyst.com/excel/mduration-function) - ### [MEDIAN](https://betteranalyst.com/excel/median-function) [The MEDIAN function calculates the middle value of a data set, efficiently identifying the central point among numbers in Excel.](https://betteranalyst.com/excel/median-function) - ### [MID](https://betteranalyst.com/excel/mid-function) [The MID function extracts characters from a text string by specifying the starting position and the number of characters to return.](https://betteranalyst.com/excel/mid-function) - ### [MIN](https://betteranalyst.com/excel/min-function) [The MIN function identifies the smallest number in a specified range, aiding in efficient data analysis and comparison of values.](https://betteranalyst.com/excel/min-function) - ### [MINA](https://betteranalyst.com/excel/mina-function) [The MINA function in Excel finds the minimum value in a dataset, considering numbers, text, and logical values like TRUE and FALSE.](https://betteranalyst.com/excel/mina-function) - ### [MINIFS](https://betteranalyst.com/excel/minifs-function) [The MINIFS function finds the smallest value in a range that meets specified criteria, allowing for efficient data analysis in Excel.](https://betteranalyst.com/excel/minifs-function) - ### [MINUTE](https://betteranalyst.com/excel/minute-function) [The MINUTE function extracts the minute component from a time value, aiding in time analysis and calculations in Excel.](https://betteranalyst.com/excel/minute-function) - ### [MINVERSE](https://betteranalyst.com/excel/minverse-function) [The MINVERSE function calculates the inverse of a matrix, useful for advanced data analysis and solving linear equations in Excel.](https://betteranalyst.com/excel/minverse-function) - ### [MIRR](https://betteranalyst.com/excel/mirr-function) [The MIRR function calculates the modified internal rate of return using cash flows, finance rate, and reinvestment rate for investment evaluation.](https://betteranalyst.com/excel/mirr-function) - ### [MMULT](https://betteranalyst.com/excel/mmult-function) [The MMULT function multiplies two arrays (matrices) in Excel, enabling advanced data analysis through matrix operations.](https://betteranalyst.com/excel/mmult-function) - ### [MOD](https://betteranalyst.com/excel/mod-function) [The MOD function calculates the remainder of a division, aiding in data analysis and simplifying calculations in Excel.](https://betteranalyst.com/excel/mod-function) - ### [MODE](https://betteranalyst.com/excel/mode-function) [The MODE function identifies the number that appears most often in a data set, helping you analyze frequency easily.](https://betteranalyst.com/excel/mode-function) - ### [MODE.MULT](https://betteranalyst.com/excel/mode-mult-function) [The MODE.MULT function returns multiple modes from a dataset, helping to identify the most frequently occurring values efficiently.](https://betteranalyst.com/excel/mode-mult-function) - ### [MODE.SNGL](https://betteranalyst.com/excel/mode-sngl-function) [The MODE.SNGL function identifies the single most frequently occurring number in a data set, streamlining data analysis in Excel.](https://betteranalyst.com/excel/mode-sngl-function) - ### [MONTH](https://betteranalyst.com/excel/month-function) [The MONTH function extracts the month from a date, returning it as a number for streamlined data analysis and reporting in Excel.](https://betteranalyst.com/excel/month-function) - ### [MROUND](https://betteranalyst.com/excel/mround-function) [The MROUND function rounds a number to the nearest specified multiple, ensuring accurate and precise calculations in Excel.](https://betteranalyst.com/excel/mround-function) - ### [MUNIT](https://betteranalyst.com/excel/munit-function) [The MUNIT function generates a square identity matrix based on the specified array size, useful for advanced mathematical operations.](https://betteranalyst.com/excel/munit-function) - ### [N](https://betteranalyst.com/excel/n-function) [The N function converts text or logical values to numbers in Excel, ensuring accurate calculations and data analysis.](https://betteranalyst.com/excel/n-function) - ### [NA](https://betteranalyst.com/excel/na-function) [The =NA() formula generates a #N/A error in Excel, signaling missing data or unavailable information in your spreadsheets.](https://betteranalyst.com/excel/na-function) - ### [NETWORKDAYS](https://betteranalyst.com/excel/networkdays-function) [The NETWORKDAYS formula calculates working days between two dates, excluding weekends and specified holidays.](https://betteranalyst.com/excel/networkdays-function) - ### [NETWORKDAYS.INTL](https://betteranalyst.com/excel/networkdays-intl-function) [The NETWORKDAYS.INTL function calculates working days between two dates, excluding weekends and specified holidays.](https://betteranalyst.com/excel/networkdays-intl-function) - ### [NOMINAL](https://betteranalyst.com/excel/nominal-function) [The NOMINAL function calculates the nominal interest rate from an effective rate and the number of compounding periods per year.](https://betteranalyst.com/excel/nominal-function) - ### [NORM.DIST](https://betteranalyst.com/excel/norm-dist-function) [The NORM.DIST function calculates the normal distribution probability based on specified mean, standard deviation, and cumulative options.](https://betteranalyst.com/excel/norm-dist-function) - ### [NORM.INV](https://betteranalyst.com/excel/norm-inv-function) [The NORM.INV function calculates the inverse of the normal distribution for a given probability, mean, and standard deviation in Excel.](https://betteranalyst.com/excel/norm-inv-function) - ### [NORM.S.DIST](https://betteranalyst.com/excel/norm-s-dist-function) [The NORM.S.DIST function calculates the standard normal distribution for a given z-score, useful for statistical analysis and probability assessments.](https://betteranalyst.com/excel/norm-s-dist-function) - ### [NORM.S.INV](https://betteranalyst.com/excel/norm-s-inv-function) [The NORM.S.INV function returns the z-score corresponding to a given probability in the standard normal distribution.](https://betteranalyst.com/excel/norm-s-inv-function) - ### [NOT](https://betteranalyst.com/excel/not-function) [The NOT function in Excel reverses a logical value, yielding TRUE for FALSE and FALSE for TRUE, aiding in logical evaluations.](https://betteranalyst.com/excel/not-function) - ### [NOW](https://betteranalyst.com/excel/now-function) [The NOW function displays the current date and time in Excel, updating automatically whenever the worksheet recalculates.](https://betteranalyst.com/excel/now-function) - ### [NPER](https://betteranalyst.com/excel/nper-function) [The NPER function calculates the number of periods for an investment or loan based on rate, payment, present value, and optional future value.](https://betteranalyst.com/excel/nper-function) - ### [NPV](https://betteranalyst.com/excel/npv-function) [The NPV function calculates the net present value of an investment by discounting future cash flows to assess profitability over time.](https://betteranalyst.com/excel/npv-function) - ### [NUMBERVALUE](https://betteranalyst.com/excel/numbervalue-function) [The NUMBERVALUE function converts text to numbers, allowing customization of decimal and group separators for accurate data representation.](https://betteranalyst.com/excel/numbervalue-function) - ### [ODD](https://betteranalyst.com/excel/odd-function) [The ODD function rounds a number up to the nearest odd integer, simplifying data analysis and ensuring consistent odd values.](https://betteranalyst.com/excel/odd-function) - ### [ODDFPRICE](https://betteranalyst.com/excel/oddfprice-function) [The ODDFPRICE function calculates the price of an odd first coupon bond by inputting parameters like settlement date, maturity date, and coupon rate.](https://betteranalyst.com/excel/oddfprice-function) - ### [ODDFYIELD](https://betteranalyst.com/excel/oddfyield-function) [The ODDFYIELD function calculates the yield of an odd coupon bond using parameters like settlement, maturity, and coupon rate.](https://betteranalyst.com/excel/oddfyield-function) - ### [ODDLPRICE](https://betteranalyst.com/excel/oddlprice-function) [The ODDLPRICE function calculates the odd-lot price of a bond by inputting settlement, maturity, rate, yield, and other parameters.](https://betteranalyst.com/excel/oddlprice-function) - ### [ODDLYIELD](https://betteranalyst.com/excel/oddlyield-function) [The ODDLYIELD function calculates a bond's yield based on settlement, maturity, rate, price, redemption, frequency, and basis.](https://betteranalyst.com/excel/oddlyield-function) - ### [OFFSET](https://betteranalyst.com/excel/offset-function) [The OFFSET function allows you to create dynamic cell references by specifying the number of rows and columns to shift from a starting point.](https://betteranalyst.com/excel/offset-function) - ### [OR](https://betteranalyst.com/excel/or-function) [The OR function evaluates multiple conditions in Excel, returning TRUE if at least one condition is true, aiding in data analysis.](https://betteranalyst.com/excel/or-function) - ### [PDURATION](https://betteranalyst.com/excel/pduration-function) [The PDURATION formula calculates the time needed to grow a present value to a future value at a given interest rate.](https://betteranalyst.com/excel/pduration-function) - ### [PERCENTILE](https://betteranalyst.com/excel/percentile-function) [The PERCENTILE function calculates the k-th percentile of a data set, helping analyze distribution for informed decision-making.](https://betteranalyst.com/excel/percentile-function) - ### [PERCENTILE.EXC](https://betteranalyst.com/excel/percentile-exc-function) [The PERCENTILE.EXC function calculates the k-th percentile of a dataset, excluding the minimum and maximum values for accurate analysis.](https://betteranalyst.com/excel/percentile-exc-function) - ### [PERCENTILE.INC](https://betteranalyst.com/excel/percentile-inc-function) [The PERCENTILE.INC function calculates the k-th percentile of a data set, helping to understand the distribution of values within it.](https://betteranalyst.com/excel/percentile-inc-function) - ### [PERCENTOF](https://betteranalyst.com/excel/percentof-function) [The =PERCENTOF formula calculates a number's percentage relative to a total, aiding in data analysis and decision-making.](https://betteranalyst.com/excel/percentof-function) - ### [PERCENTRANK](https://betteranalyst.com/excel/percentrank-function) [The PERCENTRANK function calculates the relative rank of a value in a dataset, indicating its position within the overall distribution.](https://betteranalyst.com/excel/percentrank-function) - ### [PERCENTRANK.EXC](https://betteranalyst.com/excel/percentrank-exc-function) [The PERCENTRANK.EXC function calculates the relative rank of a value in a dataset, excluding the highest and lowest ranks.](https://betteranalyst.com/excel/percentrank-exc-function) - ### [PERCENTRANK.INC](https://betteranalyst.com/excel/percentrank-inc-function) [The PERCENTRANK.INC function calculates the relative rank of a value in a dataset, returning its percentile rank.](https://betteranalyst.com/excel/percentrank-inc-function) - ### [PERMUT](https://betteranalyst.com/excel/permut-function) [The PERMUT function calculates the number of ways to arrange a subset of items from a larger set, aiding in data analysis.](https://betteranalyst.com/excel/permut-function) - ### [PERMUTATIONA](https://betteranalyst.com/excel/permutationa-function) [The PERMUTATIONA function calculates the number of permutations of n items taken r at a time, allowing for repetitions in data analysis.](https://betteranalyst.com/excel/permutationa-function) - ### [PI](https://betteranalyst.com/excel/pi-function) [The PI() function returns the mathematical constant pi (π) for precise calculations in math and engineering applications.](https://betteranalyst.com/excel/pi-function) - ### [PIVOTBY](https://betteranalyst.com/excel/pivotby-function) [The PIVOTBY function dynamically analyzes data, enabling custom pivoting based on specified criteria and value ranges for insightful reporting.](https://betteranalyst.com/excel/pivotby-function) - ### [PMT](https://betteranalyst.com/excel/pmt-function) [The PMT function calculates loan payments by using the interest rate, number of periods, present value, and optional future value/type.](https://betteranalyst.com/excel/pmt-function) - ### [POWER](https://betteranalyst.com/excel/power-function) [The POWER function raises a number to a specified exponent, streamlining calculations and enhancing data analysis in Excel.](https://betteranalyst.com/excel/power-function) - ### [PPMT](https://betteranalyst.com/excel/ppmt-function) [The PPMT function calculates the principal portion of a loan payment for a specific period, aiding in loan and investment management.](https://betteranalyst.com/excel/ppmt-function) - ### [PRICE](https://betteranalyst.com/excel/price-function) [The PRICE function calculates a bond's price based on settlement, maturity, coupon rate, yield, redemption value, payment frequency, and day count basis.](https://betteranalyst.com/excel/price-function) - ### [PRICEDISC](https://betteranalyst.com/excel/pricedisc-function) [The PRICEDISC function calculates the price of a discounted security by considering settlement, maturity, discount rate, and redemption value.](https://betteranalyst.com/excel/pricedisc-function) - ### [PRICEMAT](https://betteranalyst.com/excel/pricemat-function) [The PRICEMAT function calculates the price of a maturity bond based on settlement, maturity, issue dates, rate, yield, and basis.](https://betteranalyst.com/excel/pricemat-function) - ### [PRODUCT](https://betteranalyst.com/excel/product-function) [The PRODUCT formula multiplies multiple numbers in Excel, streamlining calculations for efficient data analysis in your spreadsheets.](https://betteranalyst.com/excel/product-function) - ### [PROPER](https://betteranalyst.com/excel/proper-function) [The PROPER function transforms text to proper case, capitalizing the first letter of each word for enhanced readability in Excel.](https://betteranalyst.com/excel/proper-function) - ### [PV](https://betteranalyst.com/excel/pv-function) [The PV function calculates the present value of an investment or loan based on interest rate, number of periods, payment amount, and future value.](https://betteranalyst.com/excel/pv-function) - ### [QUARTILE](https://betteranalyst.com/excel/quartile-function) [The =QUARTILE function calculates quartiles in a dataset, aiding in data analysis and understanding distribution effectively.](https://betteranalyst.com/excel/quartile-function) - ### [QUARTILE.EXC](https://betteranalyst.com/excel/quartile-exc-function) [The =QUARTILE.EXC function calculates exclusive quartiles, providing precise statistical analysis by excluding the median from the quartile calculations.](https://betteranalyst.com/excel/quartile-exc-function) - ### [QUARTILE.INC](https://betteranalyst.com/excel/quartile-inc-function) [The =QUARTILE.INC function calculates quartiles in a dataset, helping analyze data distribution effectively.](https://betteranalyst.com/excel/quartile-inc-function) - ### [QUOTIENT](https://betteranalyst.com/excel/quotient-function) [The QUOTIENT function divides two numbers and returns the integer part of the result, ignoring any remainder for precise calculations.](https://betteranalyst.com/excel/quotient-function) - ### [RADIANS](https://betteranalyst.com/excel/radians-function) [The RADIANS function converts degrees to radians, simplifying trigonometric and geometric calculations in Excel.](https://betteranalyst.com/excel/radians-function) - ### [RAND](https://betteranalyst.com/excel/rand-function) [The RAND function generates random numbers between 0 and 1, useful for simulations, sampling, and data analysis in Excel.](https://betteranalyst.com/excel/rand-function) - ### [RANDARRAY](https://betteranalyst.com/excel/randarray-function) [The RANDARRAY function generates a dynamic array of random numbers, allowing you to specify the number of rows, columns, and integer range.](https://betteranalyst.com/excel/randarray-function) - ### [RANDBETWEEN](https://betteranalyst.com/excel/randbetween-function) [The RANDBETWEEN formula generates random integers within a specified range, aiding in dynamic data analysis and simulations.](https://betteranalyst.com/excel/randbetween-function) - ### [RANK](https://betteranalyst.com/excel/rank-function) [Rank numbers in Excel with RANK.EQ, choose descending or ascending order, and understand ties, RANK.AVG, and legacy RANK.](https://betteranalyst.com/excel/rank-function) - ### [RANK.AVG](https://betteranalyst.com/excel/rank-avg-function) [The =RANK.AVG formula calculates the average rank of a number in a dataset, allowing for customizable ranking order options.](https://betteranalyst.com/excel/rank-avg-function) - ### [RANK.EQ](https://betteranalyst.com/excel/rank-eq-function) [The RANK.EQ function ranks numbers in a dataset, allowing you to specify whether to order them in ascending or descending order.](https://betteranalyst.com/excel/rank-eq-function) - ### [RATE](https://betteranalyst.com/excel/rate-function) [The RATE function calculates the interest rate for an investment or loan based on payments, present value, and future value inputs.](https://betteranalyst.com/excel/rate-function) - ### [RECEIVED](https://betteranalyst.com/excel/received-function) [The RECEIVED formula calculates the present value of a bond's cash flows using issue number, dates, and discount rate.](https://betteranalyst.com/excel/received-function) - ### [REDUCE](https://betteranalyst.com/excel/reduce-function) [The =REDUCE function aggregates data using a custom initial value and a lambda function for efficient calculations in Excel.](https://betteranalyst.com/excel/reduce-function) - ### [REGEXEXTRACT](https://betteranalyst.com/excel/regexextract-function) [The REGEXEXTRACT function retrieves specific text patterns using a defined regular expression for accurate data extraction in Excel.](https://betteranalyst.com/excel/regexextract-function) - ### [REGEXREPLACE](https://betteranalyst.com/excel/regexreplace-function) [The REGEXREPLACE function replaces text patterns in a string using regular expressions for efficient data manipulation in Excel.](https://betteranalyst.com/excel/regexreplace-function) - ### [REGEXTEST](https://betteranalyst.com/excel/regextest-function) [The REGEXTEST function checks if a text string matches a given regular expression pattern, returning TRUE or FALSE based on the match.](https://betteranalyst.com/excel/regextest-function) - ### [REPLACE](https://betteranalyst.com/excel/replace-function) [The REPLACE function in Excel modifies text by replacing specified characters with new ones, streamlining text editing tasks.](https://betteranalyst.com/excel/replace-function) - ### [REPT](https://betteranalyst.com/excel/rept-function) [The REPT function repeats text a specified number of times, enhancing data presentation and formatting in Excel.](https://betteranalyst.com/excel/rept-function) - ### [RIGHT](https://betteranalyst.com/excel/right-function) [The RIGHT function extracts a specified number of characters from the end of a text string in Excel.](https://betteranalyst.com/excel/right-function) - ### [ROMAN](https://betteranalyst.com/excel/roman-function) [The =ROMAN function converts numbers to Roman numerals in Excel, with an optional second argument to customize the numeral format.](https://betteranalyst.com/excel/roman-function) - ### [ROUND](https://betteranalyst.com/excel/round-function) [The ROUND function rounds a number to a specified number of digits, enhancing accuracy in calculations and improving data presentation.](https://betteranalyst.com/excel/round-function) - ### [ROUNDDOWN](https://betteranalyst.com/excel/rounddown-function) [The ROUNDDOWN function in Excel rounds numbers down to a specified number of digits for accurate data analysis.](https://betteranalyst.com/excel/rounddown-function) - ### [ROUNDUP](https://betteranalyst.com/excel/roundup-function) [The ROUNDUP formula rounds numbers up to a specified number of digits, ensuring accuracy in data analysis and reporting.](https://betteranalyst.com/excel/roundup-function) - ### [ROW](https://betteranalyst.com/excel/row-function) [The ROW function returns the row number of a specified cell or range, helping identify its position in the spreadsheet.](https://betteranalyst.com/excel/row-function) - ### [ROWS](https://betteranalyst.com/excel/rows-function) [The ROWS function counts the number of rows in a specified range or array, providing a quick way to determine row totals in Excel.](https://betteranalyst.com/excel/rows-function) - ### [RRI](https://betteranalyst.com/excel/rri-function) [The RRI function calculates the annual interest rate required to grow an investment from present value (pv) to future value (fv) over a specified period (nper).](https://betteranalyst.com/excel/rri-function) - ### [SCAN](https://betteranalyst.com/excel/scan-function) [The SCAN function in Excel enables cumulative calculations using LAMBDA for dynamic data analysis, enhancing data insights effectively.](https://betteranalyst.com/excel/scan-function) - ### [SEARCH](https://betteranalyst.com/excel/search-function) [The SEARCH function locates specific text in a string, beginning at a specified position, returning the starting index of the found text.](https://betteranalyst.com/excel/search-function) - ### [SEC](https://betteranalyst.com/excel/sec-function) [The SEC function calculates the secant of an angle in radians, useful for precise trigonometric analysis and applications in Excel.](https://betteranalyst.com/excel/sec-function) - ### [SECH](https://betteranalyst.com/excel/sech-function) [The SECH function calculates the hyperbolic secant of a number, useful in advanced math and engineering contexts.](https://betteranalyst.com/excel/sech-function) - ### [SECOND](https://betteranalyst.com/excel/second-function) [The SECOND function extracts the seconds from a time value, aiding in precise time analysis in Excel.](https://betteranalyst.com/excel/second-function) - ### [SEQUENCE](https://betteranalyst.com/excel/sequence-function) [The SEQUENCE function generates a list of sequential numbers in Excel, allowing customization of rows, columns, start value, and step increment.](https://betteranalyst.com/excel/sequence-function) - ### [SHEET](https://betteranalyst.com/excel/sheet-function) [The SHEET function retrieves the sheet number of a specified reference, aiding in efficient data organization and management in Excel.](https://betteranalyst.com/excel/sheet-function) - ### [SHEETS](https://betteranalyst.com/excel/sheets-function) [The SHEETS function counts the total number of sheets in a workbook or a specified reference, helping users manage their data effectively.](https://betteranalyst.com/excel/sheets-function) - ### [SIGN](https://betteranalyst.com/excel/sign-function) [The SIGN function returns 1 for positive numbers, -1 for negative numbers, and 0 for zero, helping identify a number's sign in Excel.](https://betteranalyst.com/excel/sign-function) - ### [SIN](https://betteranalyst.com/excel/sin-function) [The SIN function calculates the sine of an angle in radians, aiding in precise trigonometric analysis in Excel.](https://betteranalyst.com/excel/sin-function) - ### [SINH](https://betteranalyst.com/excel/sinh-function) [The SINH function calculates the hyperbolic sine of a number, useful for advanced mathematical analysis and data modeling in Excel.](https://betteranalyst.com/excel/sinh-function) - ### [SKEW](https://betteranalyst.com/excel/skew-function) [The SKEW function calculates the skewness of a data set, indicating the asymmetry of its distribution around the mean.](https://betteranalyst.com/excel/skew-function) - ### [SKEW.P](https://betteranalyst.com/excel/skew-p-function) [The SKEW.P function calculates the skewness of a dataset, helping to analyze its distribution and identify any asymmetry present.](https://betteranalyst.com/excel/skew-p-function) - ### [SLN](https://betteranalyst.com/excel/sln-function) [The SLN function calculates straight-line depreciation for an asset, providing consistent annual expense for accurate financial tracking.](https://betteranalyst.com/excel/sln-function) - ### [SLOPE](https://betteranalyst.com/excel/slope-function) [The SLOPE function calculates the slope of a linear regression line based on known\_y's and known\_x's data sets in Excel.](https://betteranalyst.com/excel/slope-function) - ### [SMALL](https://betteranalyst.com/excel/small-function) [The SMALL function retrieves the k-th smallest value from a specified array, helping to analyze data efficiently in Excel.](https://betteranalyst.com/excel/small-function) - ### [SORT](https://betteranalyst.com/excel/sort-function) [The SORT function organizes data by defining the sort index, order (ascending/descending), and orientation (rows/columns).](https://betteranalyst.com/excel/sort-function) - ### [SORTBY](https://betteranalyst.com/excel/sortby-function) [The SORTBY function sorts data dynamically based on specified criteria and order preferences, allowing for flexible data organization.](https://betteranalyst.com/excel/sortby-function) - ### [SQRT](https://betteranalyst.com/excel/sqrt-function) [The SQRT function calculates the square root of a specified number, providing a quick method for mathematical analysis in Excel.](https://betteranalyst.com/excel/sqrt-function) - ### [STANDARDIZE](https://betteranalyst.com/excel/standardize-function) [The STANDARDIZE function calculates a normalized value of a data point using its mean and standard deviation for comparison.](https://betteranalyst.com/excel/standardize-function) - ### [STDEV](https://betteranalyst.com/excel/stdev-function) [The STDEV formula calculates the standard deviation of a dataset in Excel, measuring the variability and dispersion of the data points.](https://betteranalyst.com/excel/stdev-function) - ### [STDEV.P](https://betteranalyst.com/excel/stdev-p-function) [The STDEV.P function calculates the population standard deviation, providing insights into data variability for accurate statistical analysis.](https://betteranalyst.com/excel/stdev-p-function) - ### [STDEV.S](https://betteranalyst.com/excel/stdev-s-function) [The STDEV.S function calculates the sample standard deviation, measuring data variability in a dataset by considering a sample rather than the entire population.](https://betteranalyst.com/excel/stdev-s-function) - ### [STDEVA](https://betteranalyst.com/excel/stdeva-function) [The STDEVA function calculates the standard deviation of a dataset, treating text as 0 and logical values as TRUE=1, FALSE=0.](https://betteranalyst.com/excel/stdeva-function) - ### [STDEVP](https://betteranalyst.com/excel/stdevp-function) [The STDEVP function calculates the standard deviation of a population based on a set of numerical values for statistical analysis.](https://betteranalyst.com/excel/stdevp-function) - ### [STDEVPA](https://betteranalyst.com/excel/stdevpa-function) [The STDEVPA function calculates the standard deviation of a dataset, treating text as zero and logical values as TRUE=1, FALSE=0.](https://betteranalyst.com/excel/stdevpa-function) - ### [STOCKHISTORY](https://betteranalyst.com/excel/stockhistory-function) [The STOCKHISTORY formula retrieves past stock prices by specifying the ticker, date range, interval, and additional parameters.](https://betteranalyst.com/excel/stockhistory-function) - ### [SUBSTITUTE](https://betteranalyst.com/excel/substitute-function) [The SUBSTITUTE function replaces specific text in a string, allowing you to target and modify specific instances of that text.](https://betteranalyst.com/excel/substitute-function) - ### [SUBTOTAL](https://betteranalyst.com/excel/subtotal-function) [The SUBTOTAL function calculates results on filtered data, allowing for dynamic analysis without affecting hidden rows.](https://betteranalyst.com/excel/subtotal-function) - ### [SUM](https://betteranalyst.com/excel/sum-function) [The SUMIF function sums values in a range that meet specified criteria, aiding in targeted data analysis and reporting.](https://betteranalyst.com/excel/sum-function) - ### [SUMIF](https://betteranalyst.com/excel/sumif-function) [The SUMIF function sums values in a range that meet specified criteria, allowing for conditional calculations in Excel.](https://betteranalyst.com/excel/sumif-function) - ### [SUMIFS](https://betteranalyst.com/excel/sumifs-function) [The SUMIFS formula sums values in Excel based on multiple specified criteria, enhancing data analysis capabilities.](https://betteranalyst.com/excel/sumifs-function) - ### [SUMPRODUCT](https://betteranalyst.com/excel/sumproduct-function) [The SUMPRODUCT formula multiplies corresponding elements in arrays and sums the results, allowing for efficient calculations across multiple datasets.](https://betteranalyst.com/excel/sumproduct-function) - ### [SUMSQ](https://betteranalyst.com/excel/sumsq-function) [The SQUAREROOT function calculates the square root, while SUMSQ computes the sum of squares of specified numbers.](https://betteranalyst.com/excel/sumsq-function) - ### [SUMX2MY2](https://betteranalyst.com/excel/sumx2my2-function) [The SUMX2MY2 function calculates the sum of the differences between the squares of two arrays for efficient data analysis.](https://betteranalyst.com/excel/sumx2my2-function) - ### [SUMX2PY2](https://betteranalyst.com/excel/sumx2py2-function) [The SUMX2PY2 function calculates the sum of the products of two arrays, aiding in efficient data analysis and comparison.](https://betteranalyst.com/excel/sumx2py2-function) - ### [SUMXMY2](https://betteranalyst.com/excel/sumxmy2-function) [The SUMXMY2 function calculates the sum of the squares of differences between two arrays, aiding in data analysis and comparison.](https://betteranalyst.com/excel/sumxmy2-function) - ### [SWITCH](https://betteranalyst.com/excel/switch-function) [The SWITCH function evaluates multiple conditions and returns a corresponding result, streamlining complex nested IF statements in Excel.](https://betteranalyst.com/excel/switch-function) - ### [SYD](https://betteranalyst.com/excel/syd-function) [The SYD function calculates depreciation by considering the asset's cost, salvage value, useful life, and the specific period of depreciation.](https://betteranalyst.com/excel/syd-function) - ### [T](https://betteranalyst.com/excel/t-function) [The T function converts text to numeric values, ensuring accurate calculations and data analysis in Excel.](https://betteranalyst.com/excel/t-function) - ### [TAKE](https://betteranalyst.com/excel/take-function) [The TAKE function extracts specified rows and columns from an array, streamlining data analysis in Excel.](https://betteranalyst.com/excel/take-function) - ### [TAN](https://betteranalyst.com/excel/tan-function) [The TAN function calculates the tangent of an angle in radians, aiding in accurate trigonometric calculations in Excel.](https://betteranalyst.com/excel/tan-function) - ### [TANH](https://betteranalyst.com/excel/tanh-function) [The TANH function calculates the hyperbolic tangent of a number, useful for advanced mathematical and statistical analysis in Excel.](https://betteranalyst.com/excel/tanh-function) - ### [TBILLEQ](https://betteranalyst.com/excel/tbilleq-function) [The TBILLEQ formula calculates the equivalent yield of a Treasury bill, considering settlement date, maturity date, discount rate, and basis.](https://betteranalyst.com/excel/tbilleq-function) - ### [TBILLPRICE](https://betteranalyst.com/excel/tbillprice-function) [The TBILLPRICE function calculates the price of a Treasury bill using settlement date, maturity date, and discount rate as inputs.](https://betteranalyst.com/excel/tbillprice-function) - ### [TBILLYIELD](https://betteranalyst.com/excel/tbillyield-function) [The TBILLYIELD function calculates the yield of a Treasury bill using settlement date, maturity date, and discount rate inputs.](https://betteranalyst.com/excel/tbillyield-function) - ### [TEXT](https://betteranalyst.com/excel/text-function) [The TEXT function converts numbers to text in a specified format, enhancing data presentation in Excel.](https://betteranalyst.com/excel/text-function) - ### [TEXTAFTER](https://betteranalyst.com/excel/textafter-function) [The TEXTAFTER function extracts text following a specified delimiter, allowing for customizable match modes and additional options.](https://betteranalyst.com/excel/textafter-function) - ### [TEXTBEFORE](https://betteranalyst.com/excel/textbefore-function) [The TEXTBEFORE function extracts text from a string, returning everything before a specified delimiter for better data organization.](https://betteranalyst.com/excel/textbefore-function) - ### [TEXTJOIN](https://betteranalyst.com/excel/textjoin-function) [The TEXTJOIN function combines text from multiple cells using a delimiter, excluding empty cells for cleaner results.](https://betteranalyst.com/excel/textjoin-function) - ### [TEXTSPLIT](https://betteranalyst.com/excel/textsplit-function) [The TEXTSPLIT function divides text into separate cells based on specified delimiters, allowing customization and handling of empty values.](https://betteranalyst.com/excel/textsplit-function) - ### [TIME](https://betteranalyst.com/excel/time-function) [The TIME function creates a time value from given hours, minutes, and seconds for precise time calculations in Excel.](https://betteranalyst.com/excel/time-function) - ### [TIMEVALUE](https://betteranalyst.com/excel/timevalue-function) [The TIMEVALUE function converts a text time into a decimal value for precise time calculations in Excel.](https://betteranalyst.com/excel/timevalue-function) - ### [TOCOL](https://betteranalyst.com/excel/tocol-function) [The =TOCOL formula in Excel converts arrays into a single column, allowing for empty cell exclusion and delimiter customization.](https://betteranalyst.com/excel/tocol-function) - ### [TODAY](https://betteranalyst.com/excel/today-function) [The =TODAY() formula displays the current date in Excel, updating automatically each time the spreadsheet is opened or recalculated.](https://betteranalyst.com/excel/today-function) - ### [TOROW](https://betteranalyst.com/excel/torow-function) [The TOROW function converts an array into a single row, allowing you to ignore empty cells for a neater data display.](https://betteranalyst.com/excel/torow-function) - ### [TRANSPOSE](https://betteranalyst.com/excel/transpose-function) [The TRANSPOSE function changes the orientation of data, switching rows to columns and columns to rows for improved data organization.](https://betteranalyst.com/excel/transpose-function) - ### [TRIM](https://betteranalyst.com/excel/trim-function) [The TRIM function removes extra spaces from text, ensuring clean data for analysis by eliminating leading, trailing, and multiple spaces.](https://betteranalyst.com/excel/trim-function) - ### [TRIMMEAN](https://betteranalyst.com/excel/trimmean-function) [The TRIMMEAN function calculates the average of a dataset while excluding a specified percentage of the highest and lowest values.](https://betteranalyst.com/excel/trimmean-function) - ### [TRUE](https://betteranalyst.com/excel/true-function) [The =TRUE() formula in Excel returns a logical TRUE value, useful for data analysis and setting conditions in formatting rules.](https://betteranalyst.com/excel/true-function) - ### [TRUNC](https://betteranalyst.com/excel/trunc-function) [The TRUNC function in Excel removes decimal places from a number, allowing you to specify how many digits to keep.](https://betteranalyst.com/excel/trunc-function) - ### [TYPE](https://betteranalyst.com/excel/type-function) [The =TYPE(value) formula identifies the data type of a specified value, aiding in data analysis and ensuring accurate data handling.](https://betteranalyst.com/excel/type-function) - ### [UNICHAR](https://betteranalyst.com/excel/unichar-function) [The =UNICHAR(number) formula in Excel displays Unicode characters corresponding to their numeric codes, enhancing spreadsheet visuals.](https://betteranalyst.com/excel/unichar-function) - ### [UNICODE](https://betteranalyst.com/excel/unicode-function) [The UNICODE function retrieves the Unicode value of a specified character in Excel, aiding in data analysis and character encoding tasks.](https://betteranalyst.com/excel/unicode-function) - ### [UNIQUE](https://betteranalyst.com/excel/unique-function) [The UNIQUE function extracts distinct values from a range, allowing for column-wise extraction and exact match options.](https://betteranalyst.com/excel/unique-function) - ### [UPPER](https://betteranalyst.com/excel/upper-function) [The UPPER function converts any text string to uppercase letters, simplifying data formatting in Excel.](https://betteranalyst.com/excel/upper-function) - ### [VALUE](https://betteranalyst.com/excel/value-function) [The VALUE function converts text representations of numbers into numeric values for accurate calculations in Excel.](https://betteranalyst.com/excel/value-function) - ### [VALUETOTEXT](https://betteranalyst.com/excel/valuetotext-function) [The VALUETOTEXT formula converts numeric values to text in Excel, with optional formatting for customization.](https://betteranalyst.com/excel/valuetotext-function) - ### [VAR](https://betteranalyst.com/excel/var-function) [The VAR function calculates the variance of a dataset in Excel, measuring data variability by analyzing multiple input numbers.](https://betteranalyst.com/excel/var-function) - ### [VAR.P](https://betteranalyst.com/excel/var-p-function) [The VAR.P function calculates the population variance of a dataset, providing insights into data dispersion. Input your values for analysis.](https://betteranalyst.com/excel/var-p-function) - ### [VAR.S](https://betteranalyst.com/excel/var-s-function) [The VAR.S function calculates the sample variance of a dataset, providing insights into data variability for statistical analysis.](https://betteranalyst.com/excel/var-s-function) - ### [VARA](https://betteranalyst.com/excel/vara-function) [The VARA function calculates the variance of a dataset, including numbers and text, for precise statistical analysis in Excel.](https://betteranalyst.com/excel/vara-function) - ### [VARP](https://betteranalyst.com/excel/varp-function) [The VARP function calculates the variance of a population by analyzing the specified data range to measure variability.](https://betteranalyst.com/excel/varp-function) - ### [VARPA](https://betteranalyst.com/excel/varpa-function) [The VARPA function calculates the population variance in Excel, considering text and logical values in its computation.](https://betteranalyst.com/excel/varpa-function) - ### [VDB](https://betteranalyst.com/excel/vdb-function) [The VDB function calculates depreciation for an asset, considering cost, salvage value, life, and specific periods for accurate financial reporting.](https://betteranalyst.com/excel/vdb-function) - ### [VLOOKUP](https://betteranalyst.com/excel/vlookup-function) [The VLOOKUP function searches for a value in the first column of a table and returns a corresponding value from a specified column.](https://betteranalyst.com/excel/vlookup-function) - ### [VSTACK](https://betteranalyst.com/excel/vstack-function) [The VSTACK function combines multiple arrays into a single vertical array for streamlined data organization and analysis in Excel.](https://betteranalyst.com/excel/vstack-function) - ### [WEBSERVICE](https://betteranalyst.com/excel/webservice-function) [The =WEBSERVICE(url) formula fetches data from online sources directly into Excel for easy integration and analysis.](https://betteranalyst.com/excel/webservice-function) - ### [WEEKDAY](https://betteranalyst.com/excel/weekday-function) [The WEEKDAY function in Excel returns the day of the week for a given date, allowing for different numbering systems based on user preference.](https://betteranalyst.com/excel/weekday-function) - ### [WEEKNUM](https://betteranalyst.com/excel/weeknum-function) [The WEEKNUM function calculates the week number of a given date, allowing for different return types based on week start preferences.](https://betteranalyst.com/excel/weeknum-function) - ### [WORKDAY](https://betteranalyst.com/excel/workday-function) [The WORKDAY formula calculates future workdays by adding a specified number of days to a start date, excluding weekends and holidays.](https://betteranalyst.com/excel/workday-function) - ### [WORKDAY.INTL](https://betteranalyst.com/excel/workday-intl-function) [The WORKDAY.INTL function calculates workdays by excluding weekends and specified holidays, allowing for customized weekend definitions.](https://betteranalyst.com/excel/workday-intl-function) - ### [WRAPCOLS](https://betteranalyst.com/excel/wrapcols-function) [The WRAPCOLS function organizes data into a specified number of columns, allowing for optional padding to improve readability.](https://betteranalyst.com/excel/wrapcols-function) - ### [WRAPROWS](https://betteranalyst.com/excel/wraprows-function) [The =WRAPROWS function organizes data into specified row counts, allowing for padding and customization of the output format.](https://betteranalyst.com/excel/wraprows-function) - ### [XIRR](https://betteranalyst.com/excel/xirr-function) [The XIRR function calculates the internal rate of return for cash flows with irregular dates, aiding in financial analysis and investment decisions.](https://betteranalyst.com/excel/xirr-function) - ### [XLOOKUP](https://betteranalyst.com/excel/xlookup-function) [The XLOOKUP function retrieves data from a range, allowing for customizable handling of missing values and different search modes.](https://betteranalyst.com/excel/xlookup-function) - ### [XMATCH](https://betteranalyst.com/excel/xmatch-function) [The XMATCH function locates a value's position in a range, allowing for flexible match types and search directions.](https://betteranalyst.com/excel/xmatch-function) - ### [XNPV](https://betteranalyst.com/excel/xnpv-function) [The XNPV function calculates the net present value of cash flows at irregular intervals, factoring in specific dates for each cash flow.](https://betteranalyst.com/excel/xnpv-function) - ### [XOR](https://betteranalyst.com/excel/xor-function) [The XOR function evaluates multiple conditions, returning TRUE if an odd number of its arguments are TRUE, otherwise FALSE.](https://betteranalyst.com/excel/xor-function) - ### [YEAR](https://betteranalyst.com/excel/year-function) [The YEAR function extracts the year from a date, allowing for precise data analysis and reporting in Excel.](https://betteranalyst.com/excel/year-function) - ### [YEARFRAC](https://betteranalyst.com/excel/yearfrac-function) [The YEARFRAC function calculates the fractional year between two dates in Excel, allowing for customizable basis options for precision.](https://betteranalyst.com/excel/yearfrac-function) - ### [YIELD](https://betteranalyst.com/excel/yield-function) [The YIELD function calculates a bond's yield based on settlement, maturity, rate, price, redemption, frequency, and basis inputs.](https://betteranalyst.com/excel/yield-function) - ### [YIELDDISC](https://betteranalyst.com/excel/yielddisc-function) [The YIELDDISC formula calculates the yield of a discounted security using settlement, maturity, discount, and redemption values.](https://betteranalyst.com/excel/yielddisc-function) - ### [YIELDMAT](https://betteranalyst.com/excel/yieldmat-function) [The YIELDMAT function calculates a bond's yield based on settlement, maturity, issue date, coupon rate, price, and day count basis.](https://betteranalyst.com/excel/yieldmat-function) 42 Tutorials ## Excel tutorials - ### [Excel Conditional Formatting](https://betteranalyst.com/excel/excel-conditional-formatting) [Excel Conditional Formatting allows users to apply specific formatting to cells based on their values, enhancing data visualization and analysis.](https://betteranalyst.com/excel/excel-conditional-formatting) - ### [How To Add A Column In Excel](https://betteranalyst.com/excel/how-to-add-a-column-in-excel) [To add a column in Excel, right-click the column header where you want the new column, select "Insert," and a new column will appear.](https://betteranalyst.com/excel/how-to-add-a-column-in-excel) - ### [How To Alphabetize In Excel](https://betteranalyst.com/excel/how-to-alphabetize-in-excel) [To alphabetize in Excel, select your data, go to the "Data" tab, and click "Sort A to Z" for ascending or "Sort Z to A" for descending order.](https://betteranalyst.com/excel/how-to-alphabetize-in-excel) - ### [How To Autofit In Excel](https://betteranalyst.com/excel/how-to-autofit-in-excel) [To autofit in Excel, double-click the boundary line between column headers or select the column(s) and press Alt + H, O, I.](https://betteranalyst.com/excel/how-to-autofit-in-excel) - ### [How to Calculate Percentage in Excel](https://betteranalyst.com/excel/how-to-calculate-percentage-in-excel) [Calculate percentages, percentage change, and increases in Excel with practical formulas and correct percentage formatting.](https://betteranalyst.com/excel/how-to-calculate-percentage-in-excel) - ### [How To Combine Two Columns In Excel](https://betteranalyst.com/excel/how-to-combine-two-columns-in-excel) [To combine two columns in Excel, use the CONCATENATE function or the "&" operator. For example, =A1 & B1 or =CONCATENATE(A1, B1).](https://betteranalyst.com/excel/how-to-combine-two-columns-in-excel) - ### [How To Copy Formula In Excel](https://betteranalyst.com/excel/how-to-copy-formula-in-excel) [To copy a formula in Excel, drag the fill handle (small square at cell corner) down or across to apply the formula to adjacent cells.](https://betteranalyst.com/excel/how-to-copy-formula-in-excel) - ### [How To Count Unique Values In Excel](https://betteranalyst.com/excel/how-to-count-unique-values-in-excel) [To count unique values in Excel, use the formula \`=SUM(1/COUNTIF(range, range))\` or the \`UNIQUE\` function in newer versions.](https://betteranalyst.com/excel/how-to-count-unique-values-in-excel) - ### [How To Create A Pivot Table In Excel](https://betteranalyst.com/excel/how-to-create-a-pivot-table-in-excel) [To create a Pivot Table in Excel, select your data, go to the "Insert" tab, click "PivotTable," choose your settings, and analyze your data.](https://betteranalyst.com/excel/how-to-create-a-pivot-table-in-excel) - ### [How To Divide In Excel](https://betteranalyst.com/excel/how-to-divide-in-excel) [To divide in Excel, use the formula \`=A1/B1\`, replacing A1 and B1 with your cell references. Press Enter to see the result.](https://betteranalyst.com/excel/how-to-divide-in-excel) - ### [How To Enable Macros In Excel](https://betteranalyst.com/excel/how-to-enable-macros-in-excel) [To enable macros in Excel, go to File > Options > Trust Center > Trust Center Settings > Macro Settings, then select "Enable all macros."](https://betteranalyst.com/excel/how-to-enable-macros-in-excel) - ### [How To Filter In Excel](https://betteranalyst.com/excel/how-to-filter-in-excel) [To filter in Excel, select your data range, click the "Data" tab, then "Filter." Use dropdown arrows to choose criteria and display specific data.](https://betteranalyst.com/excel/how-to-filter-in-excel) - ### [How To Find Circular References In Excel](https://betteranalyst.com/excel/how-to-find-circular-references-in-excel) [To find circular references in Excel, go to the "Formulas" tab, click "Error Checking," and select "Circular References" to identify them.](https://betteranalyst.com/excel/how-to-find-circular-references-in-excel) - ### [How To Find Duplicates In Excel](https://betteranalyst.com/excel/how-to-find-duplicates-in-excel) [To find duplicates in Excel, select your data, go to the "Data" tab, click "Remove Duplicates," or use "Conditional Formatting" to highlight them.](https://betteranalyst.com/excel/how-to-find-duplicates-in-excel) - ### [How To Freeze A Row In Excel](https://betteranalyst.com/excel/how-to-freeze-a-row-in-excel) [To freeze a row in Excel, select the row below it, go to the "View" tab, click "Freeze Panes," then choose "Freeze Top Row."](https://betteranalyst.com/excel/how-to-freeze-a-row-in-excel) - ### [How To Freeze Panes In Excel](https://betteranalyst.com/excel/how-to-freeze-panes-in-excel) [To freeze panes in Excel, select the row or column below/next to where you want the freeze, then go to View > Freeze Panes.](https://betteranalyst.com/excel/how-to-freeze-panes-in-excel) - ### [How To Highlight Duplicates In Excel](https://betteranalyst.com/excel/how-to-highlight-duplicates-in-excel) [To highlight duplicates in Excel, select your data range, go to "Home," click "Conditional Formatting," choose "Highlight Cells Rules," then "Duplicate Values."](https://betteranalyst.com/excel/how-to-highlight-duplicates-in-excel) - ### [How To Insert Checkbox In Excel](https://betteranalyst.com/excel/how-to-insert-checkbox-in-excel) [To insert a checkbox in Excel, go to the "Developer" tab, click "Insert," select the checkbox icon, then click on the desired cell to place it.](https://betteranalyst.com/excel/how-to-insert-checkbox-in-excel) - ### [How To Insert Multiple Rows In Excel](https://betteranalyst.com/excel/how-to-insert-multiple-rows-in-excel) [To insert multiple rows in Excel, select the same number of existing rows, right-click, and choose "Insert." New rows will appear above the selected ones.](https://betteranalyst.com/excel/how-to-insert-multiple-rows-in-excel) - ### [How To Lock A Row In Excel](https://betteranalyst.com/excel/how-to-lock-a-row-in-excel) [To lock a row in Excel, select the row, go to the "View" tab, click "Freeze Panes," and choose "Freeze Top Row" to keep it visible while scrolling.](https://betteranalyst.com/excel/how-to-lock-a-row-in-excel) - ### [How To Lock Cells In Excel](https://betteranalyst.com/excel/how-to-lock-cells-in-excel) [To lock cells in Excel, select the cells, right-click, choose Format Cells, go to the Protection tab, check "Locked," then protect the sheet.](https://betteranalyst.com/excel/how-to-lock-cells-in-excel) - ### [How To Make A Copy Of An Excel Sheet](https://betteranalyst.com/excel/how-to-make-a-copy-of-an-excel-sheet) [To copy an Excel sheet, right-click the sheet tab, select "Move or Copy," check "Create a copy," and click "OK."](https://betteranalyst.com/excel/how-to-make-a-copy-of-an-excel-sheet) - ### [How To Make A Graph In Excel](https://betteranalyst.com/excel/how-to-make-a-graph-in-excel) [To make a graph in Excel, select your data, go to the "Insert" tab, choose a chart type, and customize it as needed.](https://betteranalyst.com/excel/how-to-make-a-graph-in-excel) - ### [How To Make A Histogram In Excel](https://betteranalyst.com/excel/how-to-make-a-histogram-in-excel) [To create a histogram in Excel, select your data, go to the "Insert" tab, choose "Histogram" from the Chart options, and customize as needed.](https://betteranalyst.com/excel/how-to-make-a-histogram-in-excel) - ### [How To Make A Line Graph In Excel](https://betteranalyst.com/excel/how-to-make-a-line-graph-in-excel) [To create a line graph in Excel, input your data, select it, click "Insert," choose "Line Chart," and customize as needed.](https://betteranalyst.com/excel/how-to-make-a-line-graph-in-excel) - ### [How To Make A Pie Chart In Excel](https://betteranalyst.com/excel/how-to-make-a-pie-chart-in-excel) [To create a pie chart in Excel, select your data, go to the "Insert" tab, click "Pie Chart," and choose your preferred style.](https://betteranalyst.com/excel/how-to-make-a-pie-chart-in-excel) - ### [How To Make A Table In Excel](https://betteranalyst.com/excel/how-to-make-a-table-in-excel) [To create a table in Excel, select your data range, then go to the "Insert" tab and click "Table." Confirm the range and click "OK."](https://betteranalyst.com/excel/how-to-make-a-table-in-excel) - ### [How To Merge Cells In Excel](https://betteranalyst.com/excel/how-to-merge-cells-in-excel) [To merge cells in Excel, select the cells, then click "Merge & Center" in the Home tab. This combines them into one larger cell.](https://betteranalyst.com/excel/how-to-merge-cells-in-excel) - ### [How To Multiply In Excel](https://betteranalyst.com/excel/how-to-multiply-in-excel) [To multiply in Excel, use the formula =A1\*B1, replacing A1 and B1 with your cell references. Press Enter to see the result.](https://betteranalyst.com/excel/how-to-multiply-in-excel) - ### [How To Password Protect An Excel File](https://betteranalyst.com/excel/how-to-password-protect-an-excel-file) [To password protect an Excel file, go to File > Info > Protect Workbook > Encrypt with Password, then enter and confirm your desired password.](https://betteranalyst.com/excel/how-to-password-protect-an-excel-file) - ### [How To Remove Blank Rows In Excel](https://betteranalyst.com/excel/how-to-remove-blank-rows-in-excel) [To remove blank rows in Excel, select your data, go to the "Data" tab, click "Filter," then uncheck "Blanks" and delete the visible rows.](https://betteranalyst.com/excel/how-to-remove-blank-rows-in-excel) - ### [How To Remove Duplicates In Excel](https://betteranalyst.com/excel/how-to-remove-duplicates-in-excel) [To remove duplicates in Excel, select your data, go to the "Data" tab, click "Remove Duplicates," and follow the prompts to clean your dataset.](https://betteranalyst.com/excel/how-to-remove-duplicates-in-excel) - ### [How To Separate Names In Excel](https://betteranalyst.com/excel/how-to-separate-names-in-excel) [To separate names in Excel, use the "Text to Columns" feature under the Data tab. Choose a delimiter (like space or comma) to split names.](https://betteranalyst.com/excel/how-to-separate-names-in-excel) - ### [How To Sort In Excel](https://betteranalyst.com/excel/how-to-sort-in-excel) [To sort in Excel, select your data, go to the "Data" tab, click "Sort," choose your sorting criteria, and click "OK" to organize your data.](https://betteranalyst.com/excel/how-to-sort-in-excel) - ### [How To Split Cells In Excel](https://betteranalyst.com/excel/how-to-split-cells-in-excel) [To split cells in Excel, select the cell, go to the "Data" tab, click "Text to Columns," choose a delimiter, and follow the prompts.](https://betteranalyst.com/excel/how-to-split-cells-in-excel) - ### [How To Strikethrough In Excel](https://betteranalyst.com/excel/how-to-strikethrough-in-excel) [To strikethrough text in Excel, select the cell, press Ctrl + 1, go to the Font tab, and check the "Strikethrough" option. Click OK.](https://betteranalyst.com/excel/how-to-strikethrough-in-excel) - ### [How To Subtract In Excel](https://betteranalyst.com/excel/how-to-subtract-in-excel) [To subtract in Excel, use the formula =A1-B1, replacing A1 and B1 with your cell references. Press Enter to see the result.](https://betteranalyst.com/excel/how-to-subtract-in-excel) - ### [How To Transpose Data In Excel](https://betteranalyst.com/excel/how-to-transpose-data-in-excel) [To transpose data in Excel, select the data, copy it, right-click where you want to paste, choose "Paste Special," and select "Transpose."](https://betteranalyst.com/excel/how-to-transpose-data-in-excel) - ### [How To Unhide Columns In Excel](https://betteranalyst.com/excel/how-to-unhide-all-columns-in-excel) [To unhide columns in Excel, select the columns around the hidden ones, right-click, and choose "Unhide" from the context menu.](https://betteranalyst.com/excel/how-to-unhide-all-columns-in-excel) - ### [How To Unhide Rows In Excel](https://betteranalyst.com/excel/how-to-unhide-all-rows-in-excel) [To unhide rows in Excel, select the rows around the hidden ones, right-click, and choose "Unhide" from the context menu.](https://betteranalyst.com/excel/how-to-unhide-all-rows-in-excel) - ### [How To Unprotect Excel](https://betteranalyst.com/excel/how-to-unprotect-excel) [To unprotect an Excel sheet, go to the "Review" tab, click "Unprotect Sheet," and enter the password if prompted. If forgotten, use recovery tools.](https://betteranalyst.com/excel/how-to-unprotect-excel) - ### [How To Wrap Text In Excel](https://betteranalyst.com/excel/how-to-wrap-text-in-excel) [To wrap text in Excel, select the cell, go to the Home tab, and click "Wrap Text" in the Alignment group. This adjusts the cell height automatically.](https://betteranalyst.com/excel/how-to-wrap-text-in-excel) ## Need help with an Excel formula? Get AI-powered formula generation, explanations, and data analysis. [Get Started Free](https://app.betteranalyst.com/signup)