Data Analysis and Dashboarding with Microsoft ExcelКНИГИ » ОС И БД
Название: Data Analysis and Dashboarding with Microsoft Excel Автор: Jasmeen Kaur Издательство: Jasmeen Kaur Год: 2022 Формат: PDF Страниц: 181 Размер: 30 Mb Язык: English
With the world brimming with data, data analysis is one of the most in-demand digital skills today. Microsoft Excel remains the most popular number-crunching tool across all businesses of any size and type. This book will teach you a highly desirable combination of data analysis with Excel skills by walking you through the data analytics lifecycle. You will download practice spreadsheets and follow step-by-step instructions to learn powerful Excel features relevant to data analysis, including Cleaning and organizing data, Analyzing data with basic and advanced functions, Exploring aggregated data interactively with PivotTables and PivotCharts, Visualizing data with charts, and Creating professional and interactive dashboards. The book is designed in a way that previously covered features are recalled in future chapters to ensure you solidify your understanding of how those features tie together as building blocks of the data analytics lifecycle. You will also develop a couple of cool dashboards from scratch!