Class / Schedule

-

PC End User

Excel: Creating Dashboards (2 Days)

01-04-D746

Dashboards, also known as “infographics,” are ideal for delivering information in a graphical, dynamic, user-friendly form; and Excel is a familiar, effective application that will enable you to do just that! This class will help you to extract information from your raw data and present it in a visual format that enables decision makers to view key trends and conclusions at a glance. Utilizing various combinations of Excel charts, Pivot Tables, Pivot charts/slicers, conditional formatting, Data Validation, Sparklines, hyperlinks, and advanced formulas, you will be able to synthesize your raw data into meaningful, dynamic visual presentations.



Performance Objectives: 
Upon successful completion of this course, you will be able to create dashboards in Excel by

  • Creating range names and advanced formulas.
  • Automating workbook functionality.
  • Applying conditional logic.
  • Visualizing data by creating basic charts.
  • Creating trend line and Sparkline charts.
  • Using PivotTables, Pivot Charts, and slicers.
  • Building and developing dynamic data models using the above tools in a dashboard and/or report format

Intended Audience:  This course is for Excel users that want to display data from excel in multiple dynamic ways



Recommended Prerequisite
:    This course is a combination of selected topics from the Microsoft Excel 2013/16 Level 2 and 3 courses and is specifically designed to provide students with the skills and knowledge to create effective dashboards.

Completion of the Microsoft Excel 2013/16 Level 1 course or have the equivalent knowledge and experience. In particular, students should have experience in creating workbooks with formulas and functions.

Scheduled Class Location and Dates
City / Facility Date and Time Course Cost Cancel Date Instructor
1 Lacey

SPSCC - LACEY
4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • Dec 2 2019 8:00am-4:30pm
  • Dec 3 2019 8:00am-4:30pm
$290.00 Wed, 11/13/2019 - 16:00 Debbie Lonborg
2 Lacey

SPSCC - LACEY
4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • Feb 26 2020 8:00am-4:30pm
  • Feb 27 2020 8:00am-4:30pm
$290.00 Sun, 02/09/2020 - 16:00 Debbie Lonborg
3 Lacey

SPSCC - LACEY
4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • Mar 25 2020 8:00am-4:30pm
  • Mar 26 2020 8:00am-4:30pm
$290.00 Sun, 03/08/2020 - 17:00 Debbie Lonborg