Information Technologies

Microsoft Excel Dashboards Level





Topics Covered

  • Topic A: Examine Dashboards
  • Topic B: Use Range Names in Formulas
  • Topic C: Use Specialized Functions
  • Topic A: Apply Data Validation
  • Topic B: Work with Forms and Controls
  • Topic A: Use Lookup Functions
  • Topic B: Combine Functions
  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic A: Create Dual-Axis Charts and Trendlines
  • Topic B: Create Sparklines
  • Topic A: Create a PivotTable
  • Topic B: Analyze PivotTable Data
  • Topic C: Present Data with PivotCharts
  • Topic D: Filter Data by Using Slicers
  • minimize course outline