• Email info@koenig-solutions.com
  • WhatsApp +91 81307 98752
  • Phone +1 877 226 2244

Excel 2013 Analytics with Power Tools

  • Overview

    This course is intended for the analysts and end users who are willing to explore the self-service business intelligence tools in SharePoint Server and Excel. This training is best suited for all business professionals: developers, IT professional, project leads, managers, team leads, and project managers.

    Course Objectives

    • Comprehend the PowerPivot user interface
    • Build a cascading relationship
    • Build and configure Time Intelligence
    • Build a report using Power View
    • Build a relationship between tables from different sources
    • Explore and connect to data sources using Power Query
    • Hide columns, sort, change data types, and filter
    • Create calculated fields and calculated columns
    • Add a calculated field from the pivot table
    • Extract and transform data using Power Query
    • Manage data sources and queries

    Course Content / Exam(s)

    Schedule for Excel 2013 Analytics with Power Tools
    Course Regular Track
    Excel 2013 Analytics with Power Tools 2
    Total 2
    • Working Experience With Excel.
    Recommended Courses and Certification:
  • Students Reviews
    Abraham Akuei Makuac  Koenig IT Training Student

    I'm Abraham Akuei from South Sudan. I attended MCSA SQL Server 2008 training with my colleague Kachuol Run Arol at Koenig, which was quite good for the benefit of my Company (Dar Petroleum) and...

    Read MoreAbraham Akuei Makuac South Sudan
    Samuel  E. Calys-Tagoe Koenig IT Training Student

    It was a delight being at Koenig Dubai for Microsoft Exchange Server 2013 training. First the trainers were very friendly and were willing to tailor the lessons for me to understand and were ready...

    Read MoreSamuel E. Calys-TagoeGhana
    Roufai   Ouma Koenig IT Training Student

    My name is Roufai Ouma. I came at Koenig Solutions Delhi for the course of MCSE 2012: Server Infrastructure. The duration of my course was from 24th October to 10th November.I enjoyed my stay at...

    Read MoreRoufai OumaNiger
    Robert  Nieuwenhuis Koenig IT Training Student

    I'm Robert Nieuwenhuis, Infrastructure Architect at the Royal Dutch telephone company and working for more than 15 years in IT. I’m responsible for the architecture of several hosting...

    Read MoreRobert NieuwenhuisNetherlands
    Vladmir Soares  Fortes Koenig IT Training Student

    When I heard about Koenig from friends, advertisements and Google, and how Koenig is a preferred training center around the world, I thought it was not such a giant as they thought. But I ended up...

    Read MoreVladmir Soares FortesAngola
    View All Testimonials
  • Schedule & Prices
    Classes will be conducted from 09:00 am - 05:00 pm at Your Local Time
    Price includes Official Curriculum.
    For any Query or Custom Plan info@koenig-solutions.com +1 877 226 2244
  • Enquire Now
    * Required Fields