Course Code: 1337

Excel Dashboards and Reports

Class Dates:
12/21/2018
2/12/2019
Length:
1 Days
Cost:
$295.00
Class Time:
Technology:
Office
Delivery:

Overview

  • Course Overview
  • Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. Dashboards are often called as management dashboards or information dashboards or dashboard reports.

    The course covers features of Excel Dashboards, such as display and visualization principles for clear dashboard creation, using interactive controls to keep information informative and relevant, analyzing and automating information for a fully functional and complete dashboard. It also includes key considerations for distributing dashboards like password protections, locking and unlocking cells and protecting workbooks.
  • Audience
  • What is the target audience?

    This course is not for complete beginners, but if you’ve put together any type of report in Excel before then you will definitely benefit from the time saving tips and data visualisation techniques I share with you.

    Ideally you already know how to use Excel and are familiar with basic formulas and how to build them. You’ve created basic charts using the standard ones available in Excel, and you’re familiar with Pivot Tables and Pivot Charts but not an expert.

Prerequisites

  • Dashboards are fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.

    In order to learn Excel Dashboard students should have access to Excel 2007 or later. Students should also be familiar with putting together any type of report in Excel to be able to apply the time saving and visualization techniques taught here. Students should be able to build and apply basic formulas in Excel as well. Pivot Table and Pivot Chart knowledge is helpful, but expertise is not necessary to take this course.

  • Recommended Courses:

Course Details