Der Hauptzweck dieses 2-Tages-Kurses besteht darin, den Teilnehmern die Möglichkeit zu geben, Excel-Tabellen, Excel-Funktionen hinzuzufügen und Ihnen eine Grundlage zu bieten, um erweiterte Datenanalysen mit Excel oder Power BI zu erlernen.

Dieser Kurs richtet sich an alle, die die Datenanalysetechnologien in Excel über Formeln hinaus erweitern und erweiterte Funktionen wie Dashboards, Hierarchien und Beziehungen hinzufügen möchten.

• SQL Server | Data Management Bildungswege
• Microsoft 365 Bildungswege
• Office & Office 365 Bildungswege
• Cloud & Microsoft Azure Bildungswege

Folgende Kenntnisse wären erforderlich:

• Basis-Wissen von Windows
• Wissen von relationalen Datenbanken
• Wissen von Excel Tabellen mit Formeln, Chartes, Filtern, Sortierung
• von Vorteil 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)

• Module 1: Reporting in Excel
• Module 2: Excel Tables
• Module 3: Pivot Tables and Pivot Charts
• Module 4: Dashboards
• Module 5: Hierarchies
• Module 6: The Excel Data Model

Prüfungs-Nummer

• nach dem Folgekurs MS20779: 70-779 Analyzing Data with Microsoft Excel

• Analyzing Data with Power BI (MS20778)
• Analyzing Data with Excel (MS20779)
• 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)
• 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

• Windows 10 (MSMD-100T00)
• Managing Modern Desktopss (MSMD-101T00)
• 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

• Microsoft 365 Identity and Services (MS-100T00)
• Microsoft 365 Mobility and Security (MS-101T00)
• 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:

• Develop Azure Infrastructure as a Service compute solutions (MSAZ-203T01)
• Develop Azure Platform as a Service compute solutions (MSAZ-203T02)
• Develop for Azure Storage (MSAZ-203T03)
• Implement Azure security (MSAZ-203T04)
• Monitor, troubleshoot, and optimize Azure solutions (MSAZ-203T05)
• Connect to and consume Azure, and third-party, services (MSAZ-203T06)
• 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 DevOps Engineer Expert:

• Implementing DevOps Development Processes (MSAZ-400T01)
• Implementing Continuous Integration (MSAZ-400T02)
• Implementing Continuous Delivery (MSAZ-400T03)
• Implementing Dependendy Management (MSAZ-400T04)
• Implementing Application Infrastructure (MSAZ-400T05)
• Implementing Continuous Feedback (MSAZ-400T06)
• Designing a DevOps Strategy (MSAZ-400T07)
• Bundle: Microsoft Azure DevOps Engineer (Paketpreis) (MSAZ-OPSBD)

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:

• Microsoft Cloud Workshop: Big Data & Visualization (MS40502)
• Microsoft Cloud Workshop: Enterprise Ready Cloud (MS40503)
• Microsoft Cloud Workshop: Intelligent Vending Machines (MS40504)
• Microsoft Cloud Workshop: Internet of Things (MS40505)
• Microsoft Cloud Workshop: Lift and Shift/Azure Resource Manager (MS40506)
• Microsoft Cloud Workshop: Microservices & Serverless Architecture (Infrastructure Edition) (MS40507-1)
• Microsoft Cloud Workshop: Microservices & Serverless Architecture (Developer Edition) (MS40507-2)
• Microsoft Cloud Workshop: Modern Cloud Apps (MS40508)
• Microsoft Cloud Workshop: OSS DevOps (MS40509)
• Microsoft Cloud Workshop: SQL Server Hybrid Cloud (MS40510)
• Microsoft Cloud Workshop: Intelligent Analytics (MS40516)
• Microsoft Cloud Workshop: Azure Security, Privacy, and Compliance (MS40527)
• Microsoft Cloud Workshop: Serverless Archtiecture (MS40535)
• Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack (MS20537)
• Windows Server 2019 Bildungswege
• Microsoft Exchange Server Bildungswege
• Cloud & Microsoft Azure Bildungswege
• Microsoft 365 Bildungswege
• Office & Office 365 Bildungswege
• SQL Server | Data Management Bildungswege
• Sicherheit & Datenschutz Bildungswege
  
• Digitalisierung Bildungswege
• Microsoft Windows 10 Bildungswege
• Windows Server 2016 Bildungswege
• Microsoft Server Bildungswege
• Microsoft Exchange Server Bildungswege
• Microsoft Skype for Business Bildungswege
• SharePoint Bildungswege
• Development Bildungswege
• Apple Bildungswege
• CompTIA Bildungswege
• Eidg. ICT Fachausweise Bildungswege
• ITIL® Bildungsweg
• Publishing | Adobe | Web Technologien Bildungswege
• Projekt-Management Bildungswege
• Management | Führung Bildungswege
• Digitales Marketing | SEO Bildungswege