909.981.6331
Excel

Excel

Word

Word

Access

Access

PowerPoint

PowerPoint

Outlook

Outlook

Publisher

Publisher

Quickbooks

Quickbooks

Windows & Computers

Windows & Computers

Internet & Cloud

Internet & Cloud

Specialty

Specialty

Excel Dashboarding

Dashboards take raw data and transform it into a meaningful, visual overview of critical business information. Many companies or organizations use dashboards to monitor their KPIs (Key Performance Indicators). Utilizing all of Excel’s powerful tools, dashboards can help you view data relevant to a particular objective or business process. The best data dashboards answer important questions about your business. Dashboards are designed for quick analysis and informational awareness.

NEXT AVAILABLE CLASS DATES:
December 11th & 12th 2019
Cost: $198 till December 31, 2019

Scheduled Dates

This class is scheduled on an as-needed basis. Please call us at (909) 981-6331 for more information.

Skills Covered:

  • Best Dashboard Design, Prep and Maintenance
  • Using Excel’s Charts and Graph’s to create powerful and clear visualization of data
  • Make key elements interactive, by utilizing Excel’s built in Form controls. (ie, Drop Down boxes, Scroll bars, List boxes)
  • Creative Formatting to emphasis key points in your dashboard elements
  • Create Pivot Tables to consolidate data
  • Write Formulas to calculate / display results

Course Prerequisites:

*This is an advanced Excel class. Participants are required to have a working knowledge of the following Excel elements:

  • Charts and Graphs (Excel Intermediate)
  • Advanced Formula writing (Excel Formulas / IF and VLOOKUP Workshop)
  • Pivot Tables (Excel Advanced)

California Computer Schools, Inc.

Location 3290 East Guasti Road
Suite 110
Ontario, CA 91761
Phone: 909.981.6331 Hours: Monday – Friday: 9:00 AM – 4:00 PM (PST)

Contact Us

View Cart (0)