Or log in to access your purchased courses

Microsoft Excel Dashboards and Reports

Learn how to use Excel dashboards and reports to better conceptualize data

Introduction 引言

Excel dashboards and reports are powerful means to improve Excel data visualization. A dashboard report is a way to visually present important data in summary form so that you can make quick and effective decisions, in much the same way that a car dashboard works. Because of its flexibility, you can virtually design any dashboard in Excel exactly the way you want. This course is designed for Excel users who want to perform data modeling and create interactive reports by making the best use of the dashboard and reporting features in Excel 2010.

Course Objectives 課程目標

  • Building data models for dashboards and reports
  • Planning and building eye-catching dashboards
  • Using effective chart types to present different types of business data
  • Customizing charts for professional presentation
  • Creating PivotCharts
  • Creating Sparklines to show data trends or distribution
  • Advanced charting techniques to create interactive charts and with dynamic contents
  • Using Macros in manipulating dashboards