Excel 2016 and 2019 - Advanced Tools

The book is intended for all users of the most widely used spreadsheet calculator MS Excel, who are already somewhat familiar with Excel and need to expand their knowledge with more advanced operations. The reader will find answers to frequently solved problems related to the preparation of more complex tables, more complex calculations, more extensive use of standard Excel functions, data analysis and processing, and graphical representation. An important part of this is the export and import of data and the use of Excel to process data stored in the relational database.

The topics covered in the book will have significant application in business, management and analytical activities, accounting and the production of various reports and forecasts. However, they can also be useful for technical disciplines. A number of chapters include complex examples to demonstrate the material covered. The book is oriented towards Excel 2019, but is written so that it can be used for earlier versions 2013 and 2016 without problems.

The book will answer the following questions, among others How to create different types of formulas and use standard Excel functions How to perform statistical and financial calculations How to control and protect the data you enter and the tables you create How to create and use contingency tables and charts How to make full use of charting capabilities Create special chart types How to use the capabilities of Excel to process data residing in relational databases How to perform various analyses on the entered data How to customize Excel to work efficiently and conveniently