Excel 2021

If you already have basic experience working with MS Excel and need to move to a more professional level, you have the right book in your hands. It focuses primarily on a unified approach of the MS Excel program to data obtained from various sources, namely data written directly on an Excel sheet or located in another database system. Users can thus take advantage of all the options that Excel offers: sorting, filtering, summaries, working with contingency tables and contingency charts, regardless of the origin of the processed data. Data access uses all the tools included in Excel 2021: new features, direct query creation, combination of different data sources and use of the Excel data model and DAX language functions.

The book will answer the following questions:
How to work efficiently with large tables
How to use sorting, filtering and searching in tables
How to obtain various statistical characteristics and predictions in the time evolution
How to create and use formatted tables
How to work with queries using Power Query
How to use data located in external databases, text files, and XML files
How to create a contingency table and chart
How to use Power Pivot effectively
How to use DAX calculations to enhance the capabilities of contingency tables