Sign In   |   View Cart   |     |   Help
 
Course Catalog
 
Print Course information
E-mail to a friend
Return to Course Catalog

Courses and Programs > Computers > Microsoft Products

Creating Dashboards in Excel   NEW!

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.

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.

    Audience: This course is for Excel users that want to display data from excel in multiple dynamic ways
    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.
  •  

    Creating Dashboards in Excel NEW!

    Item: C209 Debbie Lonborg
    8:00 AM - 4:30 PM ONLINE
    Sessions: 2 W Th Location: ONLINE
    , WA
    12/2/2020 - 12/3/2020 Fee: $290.00

    This class is offered online using Zoom and Excel.

    Zoom Requirements:

  • Access to a computer with speakers & microphone (or the ability to call in via phone).
  • A web camera (suggested but not required).
  • Access to high-speed internet.

  • Zoom link will be sent prior to the start of class. You must have Excel installed on your computer to participate in the class.

    Refund Policy: Cancellations must be received 5 business days prior to the 1st day of class in order to receive a full refund.

     

    Creating Dashboards in Excel

    Item: C390 Debbie Lonborg
    8:00 AM - 4:30 PM ONLINE
    Sessions: 1 Tu Location: ONLINE
    , WA
    3/9/2021 - 3/9/2021 Fee: $290.00
    This class is offered online using Zoom and Excel.

    Zoom Requirements:
  • Access to a computer with speakers & microphone (or the ability to call in via phone).
  • A web camera (suggested but not required).
  • Access to high-speed internet.


  • Zoom link will be sent prior to the start of class. You must have Excel installed on your computer to participate in the class.


    Registration for this class will open soon.