NetAssist Services Pte Ltd
+65 6272 2662
training@netassist.com.sg
Login

Registration

Course Details

Course Type: Big Data, AI and Analytics

Name: Power Pivot with Microsoft Excel

Category: Modern Workplace

Duration: 1 day

Venue: 298 Tiong Bahru Road #08-05 Central Plaza Singapore 168730

Fee (inclusive of GST): $640.93

Contact Details

NetAssistNetAssist
  • About Us
    • Award
    • Accreditations
  • Courses
    • Big Data, AI and Analytics
    • Cybersecurity
    • Microsoft Cloud
    • Open Source Development
    • Service Management
  • Certifications
    • CISSP
    • Microsoft Role-based Certifications
      • Purchase Microsoft Exam
    • Qualified Information Security Professional (QISP)
  • Funding Programs
  • Promotions
    • Now Boarding
    • I’m Microsoft Certified!
    • Purchase Microsoft Exam
  • Insights
    • Announcements
    • Articles
      • Why Get Certified?
    • Events
  • Contact Us
    • Computer Lab Rental
    • Purchase Microsoft Exam
    • Personal Data Protection Policy
    • Personal Data Protection Statement
    • General Terms and Conditions
      • Cart

        0
    • About Us
      • Award
      • Accreditations
    • Courses
      • Big Data, AI and Analytics
      • Cybersecurity
      • Microsoft Cloud
      • Open Source Development
      • Service Management
    • Certifications
      • CISSP
      • Microsoft Role-based Certifications
        • Purchase Microsoft Exam
      • Qualified Information Security Professional (QISP)
    • Funding Programs
    • Promotions
      • Now Boarding
      • I’m Microsoft Certified!
      • Purchase Microsoft Exam
    • Insights
      • Announcements
      • Articles
        • Why Get Certified?
      • Events
    • Contact Us
      • Computer Lab Rental
      • Purchase Microsoft Exam
      • Personal Data Protection Policy
      • Personal Data Protection Statement
      • General Terms and Conditions

    Big Data, AI and Analytics

    • Home
    • All courses
    • Big Data, AI and Analytics
    • Power Pivot with Microsoft Excel
    Print Friendly, PDF & Email

    Power Pivot with Microsoft Excel

    Big Data, AI and Analytics, Microsoft 365, Modern Workplace
    $640.93
    Power Pivot with Microsoft Excel
    DURATION FEE (S$ before GST)
    1 day 599.00
    COURSE CODE
    NA-PWRPVT
    VENUE
    298 Tiong Bahru Road #08-05 Central Plaza Singapore 168730
    Training Hours
    9.00am to 5.00pm

    Course Overview

    Course Overview

    At Course Completion

    • Create simple, elegant data models in PowerPivot.
    • Use these data models to create pivot tables based on multiple tables.
    • Use queries to build queries to extract, transform and load data (this used to be called Power Query, but is now integrated in Excel).
    • Understand what Power BI Desktop is, and how it is the same in many ways as PowerPivot / Power Query.
    • Create visualisations in Power BI Desktop (tables, charts and matrices).
    • Understand how to publish Power BI Desktop reports to the cloud, and pin tiles to dashboards.

    Audience Profile

    This course is designed to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Power Pivot, Pivot Charts, the Excel Data Model, and briefly introduces Power BI.

    Pre Requisite

    Before attending this course, students must have:

    • Basic knowledge of the Microsoft Windows operating system and its core functionality.
    • Working knowledge of relational databases.
    • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
    • Basic knowledge of data analytics using Excel including Pivot Table, Pivot Charts.

    Course Details

    Module 1         An Introduction to advanced features in Microsoft Excel

    Module 2         An Introduction to Power Query and Power Pivot

    Module 3         Data transformation using Power Query

    Module 4         Data modelling in Power Pivot

    Module 5         Creating Report

    Module 6         Interface with Power BI

    Course Schedule

    N/A
    • Description
    • Curriculum
    • Instructors
    $640.93
    • Share:

    All Courses

    • Big Data, AI and Analytics
    • Cybersecurity
    • Microsoft Cloud
      • Azure
      • Data, AI & Analytics
      • Microsoft 365
        • Exchange Online
        • SharePoint
      • Microsoft Business Applications
        • Dynamics 365
        • Power Platform
      • Modern Workplace
      • Security, Compliance and Identity
      • Windows Server
    • Office Applications Skills
      • Excel
    • Open Source Development
    • Service Management
      • ITIL

    Newly Released Courses

    PL-300 Microsoft Power BI Data Analyst

    PL-300 Microsoft Power BI Data Analyst

    $1,605.00
    QISP Qualified Information Security Professional

    QISP Qualified Information Security Professional

    $2,675.00
    NA-CSE Cybersecurity Essentials

    NA-CSE Cybersecurity Essentials

    $1,712.00
    NetAssist

    +65 6272 2662

    training@netassist.com.sg

    298 Tiong Bahru Road
    #08-05 Central Plaza
    Singapore 168730

    Links

    • Courses
    • Certifications

    Like us on Facebook

    NetAssist Singapore

    Copyright © 2020 NetAssist Services Pte Ltd

    WhatsApp us