The book "Advanced Functions and Programming of Excel 2016" is a practical guide that will help users of this popular application to make the most of its capabilities. It is aimed at every professional, scientist, or student who wants to effectively use Excel to process and analyze data and draw reliable conclusions.

You will learn how to work with databases, create charts, and analyze data with pivot tables, and you will discover the new capabilities of business intelligence for collecting and analyzing data from multiple sources. Using appropriate tools, you will learn to find trends in data series, use goal seeking and problem-solving, and create scenarios. You will become familiar with statistical data analysis tools that assist in quantitative research, as well as the capabilities for controlling and protecting worksheets, and you will learn to collaborate with others by leveraging the shared use of workbooks.

You will learn to write and edit VBA code in order to customize the application to your needs, automate your tasks, and create your own custom functions.

Finally, the appendix of the book provides descriptions and examples for more than 100 Excel functions, the correct use of which is a powerful asset for data processing.

With step-by-step instructions and hundreds of images in the book, everything is clear. The examples are realistic and understandable, while brief and accurate tips at selected points in the book will help you work even more productively.