Microsoft Excel: Dashboards

Hours: 6.00 | Estimated Cost: $179.00

This seminar is designed for participants who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of the data analysis functionality. Microsoft Excel: Dashboards will expand your knowledge by utilizing functions, charts, and PivotTables, and using visualizations in charts and dashboards in Excel.

    Additional Information

  • Learn About
    * Performing data analysis fundamentals
    * Visualizing data with Excel
    * Analyzing data with formulas and functions
    * Analyzing data with PivotTables
    * Presenting visual insights with dashboards in Excel
  • Benefits & Outcomes
    * Learn how to analyze data with formulas, functions and PivotTables
    * Learn how to create effective visuals to help others gain insights into your data
  • Training Outline
    **Data Analysis Fundamentals**
    * Introduction to Data Science
    * Create and Modify Tables
    * Sort and Filter Data
    **Visualizing Data with Excel**
    * Visualize Data with Charts
    * Modify and Format Charts
    * Apply Best Practices in Chart Design
    **Analyzing Data with Formulas and Functions**
    * Analyze Data with Formulas and Named Ranges
    * Analyze Data with Functions
    * Implement Data Validation, Forms, and Controls
    * Create Conditional Visualizations with Lookup Functions
    **Analyzing Data with PivotTables**
    * Create a PivotTable
    * Analyze PivotTable Data
     **Presenting Visual Insights with Dashboards in Excel**
    * Visualize Data with PivotCharts
    * Filter Data Using Slicers and Timelines
    * Create a Dashboard in Excel
Business & Industry Services (BIS)
5 N. Systems Drive
Appleton, WI 54914-1655

P: 888-458-0449
P: 920-735-2525
F: 920-735-4771