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 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!

Microsoft has published its roundup of all the features it added to Excel this month early this time, likely due to the holiday period kicking off in many countries around the globe next week.