Читать книгу Excel Dashboards & Reports For Dummies - Michael Alexander - Страница 9

Part 1

Getting Started with Excel Dashboards and Reports

IN THIS PART …

Discover how to think about your data in terms of creating effective dashboards and reports and get a solid understanding of the fundamentals and basic ground rules for creating effective dashboards and reports.

Uncover the best practices for setting up the source data for your dashboards and reports and explore the key Excel functions that help you build effective dashboard models.

Explore how pivot tables can enhance your analytical and reporting capabilities as well as your dashboards.

Dive into Power Query and explore some of the ways to incorporate external data into your reporting mechanisms.