Data Analytics with Excel PowerPivot
Courses Certificates Corporate Education I-20 Visa Programs ESL American Business Program Sign In / Register
Sign In   |   View Cart   |     |   Help
 
Print Course information
E-mail to a friend
Return to Course Catalog

Course Catalog

Data Analytics with Excel PowerPivot  

This Power Pivot course will teach you how to use Excel to analyze and manipulate very large sets of data imported from a variety of popular relational data bases (e.g. Oracle, SQL Server etc.).

By the end of the course you will be able to:

  • Set up relationships between tables in a data model.
  • Use formulas to create calculated columns, measures and hierarchies.
  • Create various meaningful pivot tables and charts.
  • Create interactive dashboard reports.
  • This course only requires basic knowledge of Excel and is ideal for professionals across all business sectors who want to be able to aggregate, summarize, and present data efficiently and in a way that provides better business insights and informed decision making.

     

    F19ITS602901 $399.00
    (3 Sessions) Day: Sa
    11/23/2019-12/14/2019 9:30 AM-3:30 PM
    KIEU MY GIANG 6-155 55 Lexington Avenue
     

    SP20ITS602901 $399.00
    (3 Sessions) Day: Sa
    3/21/2020-4/4/2020 9:30 AM-3:30 PM