Modern Data Analytics in Excel

Modern methods of data cleaning, analysis, and visualization in Microsoft Excel are considered. Power Query tools for creating reproducible data preparation processes, Power Pivot tools for building relational models and configuring analytical metrics are described. Practical examples of using dynamic arrays, artificial intelligence-based functions, and integration with Python are provided. It shows how to create reports and analytical materials that were previously considered difficult to accomplish in Excel. The book is aimed at data specialists, business analysts, and Excel users interested in enhancing their capabilities