Everyone thinks of Excel differently, and its full potential is often untapped. Businesses tend to decide to invest heavily in proper BI tools, perhaps wrongfully assuming that Excel has a minimal role in that industry. Excel can be used effectively to collect, refresh, transform, and visualize your data in beautiful and eye-catching ways. This book covers building those skills and unlocking Excel and your potential in just seven days. The book explores the process of cleaning your data to ensure accuracy, using formulas to enhance and prepare the same for PivotTables. It will also help you understand how to use data visualization to create clear charts to communicate insights effectively and construct interactive dashboards for user exploration, including elements like slicers and timelines. The book also dives into discovering design principles for easy-to-understand dashboards, while gaining knowledge on maintaining and updating them for ongoing usability.
A deep dive into dashboarding in Excel, understanding the opportunities and limitations of Excel as a BI solution. Guiding the reader to understand more about data requests and the stakeholders that make them.
