Excel Function Reference Book

Question

Hello:

Does anyone know where I can buy or get the latest paperback edition of the Microsoft Excel Worksheet Function Reference Book? I have a really old version and would love to upgrade, especially with all the new functions that came out with Office365.

thanks,

Answer 1

MS doesn't do paper manuals any more. Especially since 365 is such a moving target. Get used to working with e-copies.

.

Dave has given you the links to the best MS resources. At least MS keeps them reasonably up to date.

.

There are other similar sites that are worth finding. They have links to other sets of tutorial articles.

.

If you want paper, copy one (or both) of those links and print it. But keep the e-copy as it will have to be updated for new 365 functions as they come out.

.

Personally, I like to copy the Category page and use it as the base for collecting other links and articles to more detailed instructions for the functions.

.

PS: These links only cover native Excel functions. Don't forget the lists of PowerQuery M functions and PivotTable/PowerBI DAX. The function lists for each of these Excel 2 features are at least as long as the native Excel function list ...

MS Power Query M function reference

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

01/18/2022

The Power Query M function reference includes articles for each of the over 700 functions. The reference articles you see here on docs.microsoft.com are auto-generated from in-product help. To learn more about functions and how they work in an expression, see Understanding Power Query M functions.

.

Data Analysis Expressions (DAX) in Power Pivot

https://support.microsoft.com/en-us/office/data-analysis-expressions-dax-in-power-pivot-bab3fbe3-2385-485a-980b-5f64d3b0f730
.

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013
.

Data Analysis Expressions (DAX) sounds a little intimidating at first, but don’t let the name fool you. DAX basics are really quite easy to understand. First things first - DAX is NOT a programming language. DAX is a formula language. You can use DAX to define custom calculations for Calculated Columns and for Measures (also known as calculated fields). DAX includes some of the functions used in Excel formulas, and additional functions designed to work with relational data and perform dynamic aggregation.
.

DAX function reference (by Category)

https://docs.microsoft.com/en-us/dax/dax-function-reference

12/17/2021

The DAX function reference provides detailed information including syntax, parameters, return values, and examples for each of the over 250 functions used in Data Analysis Expression (DAX) formulas.

.

DAX formulas are very similar to Excel formulas. To create one, you type an equal sign, followed by a function name or expression, and any required values or arguments. Like Excel, DAX provides a variety of functions that you can use to work with strings, perform calculations using dates and times, or create conditional values.
.

However, DAX formulas are different in the following important ways:

• If you want to customize calculations on a row-by-row basis, DAX includes functions that let you use the current row value or a related value to perform calculations that vary by context.
• DAX includes a type of function that returns a table as its result, rather than a single value. These functions can be used to provide input to other functions.
• Time Intelligence Functions in DAX allow calculations using ranges of dates, and compare the results across parallel periods.

Answer 2

Hi Ward555

I am Dave, I will help you with this.

Because Microsoft are constantly adding new functions to 365, there is not really a book that will list all the 365 functions, there is one for Excel 2021, but it do not include a list of the 365 exclusive functions.

Microsoft do provide a full listing of all functions on the two links below.

https://support.microsoft.com/en-us/office/exce...

https://support.microsoft.com/en-us/office/exce...