Data Analysis & Visualization with Microsoft Excel (D.A.V.E.)

Home/Data Analysis & Visualization with Microsoft Excel (D.A.V.E.)
Data Analysis & Visualization with Microsoft Excel (D.A.V.E.)2020-09-11T13:31:45-04:00

Summary

Data is the lifeblood of every business and understanding data through descriptive, predictive, and prescriptive analytics is critical to driving business success in a data driven economy. Creating great visualizations is another key to extracting maximum value out of their data. This 2-day class teaches you all these techniques and more.

• Data Analysis Fundamentals
• How to Visualize Data in Excel
• Using Formulas and Functions to analyze data
• Analyzing data with Pivot Tables
• Presenting Dashboards
• Creating Geospatial Visualizations
• Statistical Analysis
• Getting and Transforming Data
• Modelling Data with Power Pivot
• Presenting Insight with Reports

  • Dates: Oct 27, 2020- Oct 28, 2020
  • Times: 9:00 am - 4:30 pm
  • Location: Lexington
  • Seats: 10
  • Price: $650

Outline

  • Lesson 1: Data Analysis Fundamentals

    • Topic A: Introduction to Data Science
    • Topic B: Create and Modify Tables
    • Topic C: Sort and Filter Data
  • Lesson 2: Visualizing Data with Excel

    • Topic A: Visualize Data with Charts
    • Topic B: Modify and Format Charts
    • Topic C: Apply Best Practices in Chart Design
  • Lesson 3: Analyzing Data with Formulas and Functions

    • Topic A: Analyze Data with Formulas and Named Ranges
    • Topic B: Analyze Data with Functions
    • Topic C: Implement Data Validation, Forms, and Controls
    • Topic D: Create Conditional Visualizations with Lookup Functions
  • Lesson 4: Analyzing Data with PivotTables

    • Topic A: Create a PivotTable
    • Topic B: Analyze PivotTable Data
  • Lesson 5: Presenting Visual Insights with Dashboards in Excel

    • Topic A: Visualize Data with PivotCharts
    • Topic B: Filter Data Using Slicers and Timelines
    • Topic C: Create a Dashboard in Excel
  • Lesson 6: Creating Geospatial Visualizations with Excel

    • Topic A: Create Map Charts in Excel
    • Topic B: Customize Map Charts in Excel
  • Lesson 7: Performing Statistical Analysis

    • Topic A: Visualize Trendlines and Sparklines with Excel
    • Topic B: Analyze Data with the Data Analysis ToolPak
  • Lesson 8: Getting and Transforming Data

    • Topic A: Connect to Data with Queries
    • Topic B: Clean and Combine Data
    • Topic C: Shape and Transform Data
  • Lesson 9: Modeling and Analyzing Data with Power Pivot

    • Topic A: Install Power Pivot in Excel
    • Topic B: Create Data Models with Power Pivot
    • Topic C: Create Power Pivots
    • Topic D: Perform Advanced Data Analysis and Visualization
  • Lesson 10: Presenting Insights with Reports (Optional)

    • Topic A: Plan a Report
    • Topic B: Create a Report