• Start der nächsten ICT-LehrgängeSamstag, 28.09.2019
  • DigitalisierungSind Sie bereit für die digitale Zukunft?
  • Jetzt aktuell: ITIL Foundation 4Start am 23.10.2019
  • Windows 10 Modern DesktopDie neuesten Schulungen zu Windows 10
  • Bildungswegefür Ihre Karriereplanung
  • IT SERVICES
  • Microsoft 365Rollenbasierte Kurse & Zertifizierungen
  • IT TRAINING
  • Exchange Server & MessagingKurse, Bundles & more
  • Aktuelle News & Hinweise in unseren aktuellen Blogs
  • Kurs-Highlights
  • Cloud & Azure-Schulungenlaufend neue Kurse, Bundles & Bootcamps
  • Kurs-Übersicht

Analyzing Data with Microsoft Excel 20779,
Kurs MS20779

Ziel

Dieser 3-Tages-Kurs zeigt Ihnen wie man BI Techniken zu Excel Daten Analysen addiert. Dieser Kurs geht durch die Kapazität der Tabellen und Charts und macht sich Pivot Charts, Excel Data Model und Power BI zu Nutze.

Voraussetzungen

Folgende Kenntnisse wären erforderlich:
  • Basis-Wissen von Windows
  • Wissen von relationalen Datenbanken
  • Wissen von Excel Tabellen mit Formeln, Chartes, Filtern, Sortierung
  • Basiswissen von Daten-Analysen in Excel wie z.B. aus unseren Kursen:
    • Optimierung von Geschäftsprozessen mit Microsoft Excel "Erweiterte Funktionen und Features zur Effizienzschaffung" (EXCF)
    • Produktivitätssteigerung mit Microsoft Excel "Gezieltes Analysieren und Auswerten in Excel" (EXCF1)
    • Data Analyis Fundamentals using Excel (MS10994)

Kurs-Inhalte

  • Module 1: Data Analysis in Excel
  • Module 2: The Excel Data Model
  • Module 3: Importing Data from Files
  • Module 4: Importing Data from Databases
  • Module 5: Importing Data from Excel Reports
  • Module 6: Creating and Formatting Measures
  • Module 7: Visualizing Data in Excel
  • Module 8: Using Excel with Power BI

Prüfungen

Prüfungs-Nummer
  • 70-779 Analyzing Data with Microsoft Excel

Weiterführende Kurse

  • Analyzing Data with Power BI (MS20778)
  • Data Analysis Fundamentals using Excel (MS10994)
  • Analyzing Data with SQL Server Reporting Services (MS10990)
  • Analyzing Big Data with Microsoft R (MS20773)
  • Perform Cloud Data Science with Azure Machine Learning (MS20774)
  • Microsoft Azure Big Data Analytics Solutions (MS552241)
  • Operationalize Cloud Analytics Solutions with Microsoft Azure (MS552242)
  • Performing Data Engineering on Microsoft HD Insight (MS20775)
  • Data Driven Marketing: Big Data gezielt nutzen (BDDM)
  • Analyzing Data with Excel (MS20779)
  • Microsoft Cloud Workshop: Big Data & Visualization (MS40502)
  • Cleveres Zusammenarbeiten mit Microsoft Teams unter Office 365 (OFFT)
  • Office 365 Administration und Troubleshooting (MS10997)
  • Microsoft 365 Fundamentals (MS-900T01)

Microsoft 365 Certified: Teamwork Administrator Associate

  • Managing Office 365 Content Services (MS-300T01)
  • Managing SharePoint Online (MS-300T02)
  • Enabling Microsoft Teams for Collaboration (MS-300T03)
  • Enabling Office Workloads for Collaboration (MS-300T04)
  • Bundle: Microsoft 365 Certified Teamwork Administrator Associate (Paketpreis) (MS-TeamsBD)

Microsoft 365 Certified: Modern Desktop Administrator Associate

  • Installing Windows 10 (MSMD-100T01)
  • Configuring Windows 10 (MSMD-100T02)
  • Protecting Windows 10 (MSMD-100T03)
  • Maintaining Windows 10 (MSMD-100T04)
  • Deploying the Modern Desktops and Devices (MSMD-101T01)
  • Managing Modern Desktops and Devices (MSMD-101T02)
  • Protecting Modern Desktops and Devices (MSMD-101T03)
  • Intensivkurs (Bootcamp) zum Microsoft 365 Certified Modern Desktop Administrator Associate (MSMD-AdminI)
  • Bundle: Microsoft 365 Certified Modern Desktop Administrator Associate (Paketpreis) (MSMD-AdminBD)

Microsoft 365 Certified: Security Administrator Associate

  • Managing Microsoft 365 Identity and Access (MS-500T01)
  • Implementing Microsoft 365 Threat Protection (MS-500T02)
  • Implementing Microsoft 365 Information Protection (MS-500T03)
  • Administering Microsoft 365 Built-in Compliance (MS-500T04)

Microsoft 365 Certified: Messaging Administrator Associate

  • Understanding the Modern Messaging Infrastructure (MS-200T01)
  • Managing Client Access and Mail Flow (MS-200T02)
  • Managing Messaging High Availability (MS-200T03)
  • Defining a Hybrid Messaging Strategy (MS-201T01)
  • Managing Messaging Security, Hygiene, and Compliance (MS-201T02)
  • Intensivkurs (Bootcamp) zum Microsoft 365 Messaging Administrator Associate (MS-MessageI)
  • Bundle: Microsoft 365 Messaging Administrator Associate (Paketpreis) (MS-MessageBD)

Microsoft 365 Certified Enterprise Administrator

  • Office 365 Management (MS-100T01)
  • Microsoft 365 Tenant & Service Management (MS-100T02)
  • Microsoft 365 Identity Management (MS-100T03)
  • Microsoft 365 Security Management (MS-101T01)
  • Microsoft 365 Compliance Management (MS-101T02)
  • Microsoft 365 Device Management (MS-101T03)
  • Bundle: Microsoft 365 Certified Enterprise Administrator (Paketpreis) (MS-365CEAEBD)
  • Intensivkurs (Bootcamp) zum Microsoft 365 Certified Enterprise Administrator) (MS-365CEAEI)
  • Berufsbegleitender Lehrgang zum Microsoft 365 Certified Enterprise Administrator) (MS-365CEAEBB)

Microsoft Azure Administrator:

  • Microsoft Azure Administrator AZ-103 (MSAZ-103T00)
  • Intensivkurs (Bootcamp) mit Best Practice und Prüfungsvorbereitung zum Microsoft Azure Administrator (MSAZ-AdminI)
  • Berufsbegleitender Lehrgang zum Microsoft Azure Administrator mit Best Practice und Prüfungsvorbereitung (MSAZ-AdminBB)

Microsoft Azure Developer:

  • Select the appropriate Aure Tchnology Development Solution (MSAZ-200T01)
  • Develop for Azure Storage (MSAZ-200T02)
  • Develop Azure Platform as a Services Solution (MSAZ-200T03)
  • Implement Security in Azure Development Solution (MSAZ-200T04)
  • Develop for an Azure Cloud Model (MSAZ-201T01)
  • Implement Azure Development Integration Solutions (MSAZ-201T02)
  • Develop Azure Cognitive Services, Bot, and IoT Solutions (MSAZ-201T03)
  • Bundle: Microsoft Azure Developer (Paketpreis) (MSAZ-DevBD)
  • Intensivkurs (Bootcamp) zum Microsoft Azure Developer (MSAZ-DevI)
  • Berufsbegleitender Lehrgang zum Microsoft Azure Developer (MSAZ-DevBB)

Microsoft Azure Solutions Architect:

  • Developing and Configuring Infrastructure (MSAZ-300T01)
  • Implementing Workloads and Security (MSAZ-300T02)
  • Understanding Cloud Architect Technology Solutions (MSAZ-300T03)
  • Creating and Deploying Apps (MSAZ-300T04)
  • Developing for the Cloud (MSAZ-300T06)
  • Designing for Identity and Security (MSAZ-301T01)
  • Designing a Cloud Platform Solution (MSAZ-301T02)
  • Designing for Deployment, Migration and Integration (MSAZ-301T03)
  • Designing an Infrastructure Strategy (MSAZ-301T04)
  • Bundle: Microsoft Azure Architect (Paketpreis) (MSAZ-ArchBD)
  • Intensivkurs (Bootcamp) zum Microsoft Azure Architect (MSAZ-ArchI)
  • Berufsbegleitender Lehrgang zum Microsoft Azure Architect (MSAZ-ArchBB)

Workshops:


Ort Preis Datum
Alle Preise in CHF zzgl. MwSt.

Kunden, die dieses Training angesehen haben, haben auch folgende Kurse | Lehrgänge aufgerufen:

     

Kunden, die dieses Training besucht haben, haben auch folgende Kurse | Lehrgänge gebucht:

     
© 2018 Microwin AG