Data Analysis & Dashboarding with Microsoft Excel

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!

About the Author
Jasmeen Kaur is an experienced business intelligence professional passionate about supporting management’s decision-making with quantitative evidence. She has worked with data for over eight years and is keen on sharing her knowledge of the most business-relevant Excel features with her readers. She has a master’s degree from McGill University, Canada and currently works in the public service.