Excel 2021 - pokročilé nástroje – Laurenčík Marek (2025)

Discover the power of Excel 2021 and take your skills to the next level! This book is intended for all MS Excel users who have already worked with the program a bit and need to expand their knowledge. It will guide you through advanced functions and tools, answer frequently encountered problems related to more complex calculations and tables, data analysis and processing, as well as their graphical representation. An important part includes creating queries, exporting and importing data, and using Excel to process data stored in a relational database. The topics described are significantly applicable in business, management, and analytical activities, accounting, and the creation of various reports and forecasts, but also in technical fields. Most chapters contain comprehensive examples that demonstrate the material covered. The book is oriented towards Excel 2021, but it is written in such a way that it can be easily used for earlier versions 2016 and 2019.

The book will answer among other questions
How to perform statistical and financial calculations
How to create various types of formulas and use standard functions in Excel
How to ensure control and protection of entered data and created tables
How to create and use pivot tables and charts
…