Excel 2021 - Práce s databázemi a kontingenčními tabulkami – Laurenčík Marek (2024)

If you already have basic experience working with MS Excel and need to advance to a more professional level, you have the right book in your hands. It focuses primarily on the unified approach of MS Excel to data obtained from various sources, whether the data is entered directly on the Excel sheet or located in another database system. Users can thus take advantage of all the possibilities that Excel offers: sorting, filtering, summaries, working with pivot tables and pivot charts, regardless of the origin of the processed data. The data access utilizes all the tools included in Excel 2021: new functions, direct query creation, combining various data sources, and using Excel's data model and DAX language functions. ***** The book will answer these questions: * How to work efficiently with large tables * How to use sorting, filtering, and searching in tables * How to obtain various statistical characteristics and forecasts over time * How to create and use formatted tables * How to work with queries using Power Query * How to utilize data located in external databases, text files, and XML files * How to create a pivot table and chart * How to use effectively...