SERIESSUM function returns the sum of a power series based on the formula. Learn how to use the SERIESSUM function in Excel.

Learn how to create a fixed formula using the FIXED function, which is a Text function, in Microsoft Excel. There are 3 ways.

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

Appending records from different data sets into a single list or data range can be tedious if you’re doing it manually. Instead, use Microsoft Excel’s VSTACK() function.

How to Use Excel to Interpolate. Interpolation is a powerful tool used to determine values that do not appear within a given set of numbers. A business owner can take numbers concerning future ...

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.