MS-10994 Data Analysis Fundamentals using Excel

KLUCZOWE ZAGADNIENIA

• Filtrowanie i formatowanie danych
• Tworzenie i edycja wykresów
• Tabele w Excel
• Tabele przestawne
• Dashboardy
• Hierarchie
• Model danych w Excel
  Przemysław Rosłon, Microsoft Certified Trainer

TEMATYKA ZAJĘĆ

• Module 1: Reporting in Excel
  Filtering and Formatting Data
  Charts
  Lab: Create an Excel report

• Module 2: Excel Tables
  Excel Data Tables
  Summarizing Data
  Lab: Create an Excel Table

• Module 3: Pivot Tables and Pivot Charts
  Pivot Tables
  Pivot Charts
  Editing Pivot Tables and Pivot Charts
  Lab: Importing Data from a CSV File

• Module 4: Dashboards
  Creating a Dashboard
  Data Analysis in Excel Pivot Tables
  Lab: Create a Dashboard

• Module 5: Hierarchies
  Hierarchies
  Time Data
  Lab: Creating Hierarchies

• Module 6: The Excel Data Model
  Using an Excel Data Model
  External Data
  Lab: Explore an Excel Data Model