Excel 2013

The book is intended for readers who have already gained basic experience with MS Excel. Its basic point is a unified access of MS Excel to data obtained from different sources, namely to data written directly on the Excel sheet or located in another database system. This allows you to take advantage of all the possibilities that Excel has to offer: sorting, filtering, summaries, contingency tables and contingency charts, regardless of the origin of the processed data. It also allows you to combine data from multiple tables.

The book contains the following topics:
- Sorting, filtering, creating summaries and removing duplicates in large tables
- Access to external data in databases of various types (MS Access, MS SQL Server)
- Use of XML files
- Creating contingency tables and graphs
- Working with the Excel data model

The book will answer the questions:
- How do we use the data in the external database?
- How do we work with text files and XML files?
- How do we create a contingency table and chart?
- How we work with interconnected