Practical use of functions in Excel

Microsoft Excel has been one of the most widely used tools for creating and processing data for more than 20 years. The book works with the latest version of Excel 2019 CZ or Microsoft Excel 365 CZ.

Thanks to his experience as a lecturer and webmaster, the author has taken into account the most frequently recurring questions, explained them with examples, attached specific answers to the questions and described how to work with the functions. The creation of formulas is described from the beginning to advanced examples, requiring only basic PC skills from the reader.

Among other things, the book will teach you how to use the features effectively: how the new features work with dynamic fields, how to create dynamic calendars including conditional formatting, how to split first and last names, how to find out the number of duplicate values and much more.


The book will, among other things, answer your questions How to create dynamic ranges How to efficiently search tables using search functions How to create matrix formulas How to make elegant use of the neglected SUM function. SCALAR (SUMPRODUCT) How to validate data based on dependent conditions How to do counts and sums based on different conditions How to find errors in nested functions