Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

The REGEX functions are available for people using Excel for Microsoft 365 on Windows or Mac, as well as those using Excel ...

The first function anyone should know tells Excel to carry out basic arithmetic. Let’s say you wanted the numbers in cell A2 and cell B2 to be added together in cell C2. All you’d do is enter ...

As a stand-alone function, UNIQUE() returns a list of unique values using the syntax. UNIQUE(array, [by_col], [exactly_once]) The array argument is the Excel range you want to reduce to a unique list.

How to create a bulleted list using a function in Excel. Follow the steps below on how to create a bulleted list using a function in Excel: Launch Microsoft Excel. Enter data or use existing data.

In cell E2, enter the UNIQUE function, defining B2:B101 (all the customers) as the array. That’s it! The formula will list each unique customer one time in a vertical list. The UNIQUE function can ...

Master Excel's IF, AND, and OR functions to automate decisions, reduce errors, and simplify workflows. Learn practical tips and examples now!

Excel has built-in functions for sine and cosine, the two core trigonometric functions, and for hyperbolic sine and hyperbolic cosine, their hyperbolic counterparts. It also has built-in functions ...