PowerPivot for Microsoft Excel 2010 2017-09-15T14:22:12+00:00

Project Description

Loading...
Welkin Course Code: PP10

Course Features

Power Pivot is an extension to Excel where you use it to perform more powerful data analysis and create sophisticated data models. It can go through large amounts of data from various sources but still produce analysis quickly and share insights easily. This course will go through from the basics of installing Power Pivot to more advanced topics of Power Pivot usage. The course covers:

  • Preparing and installing Power Pivot
  • Managing data in Power Pivot
  • Creating and managing relationships
  • Using data sheet view
  • Building Pivot Tables
  • Tips and tricks for Pivot Table and Power Pivot

Completing this course would allow you to be more productive and effective in processing data and information to achieve the required summary.

  • Qualified and experienced instructors
  • Weeknight and weekend classes available

Learn from the Experts

Get Professional Recognition

mos-certificate

Certify your Excel skills with Microsoft Office Specialist Excel certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.

Remark: The course fee does not include the certification exam.

Further Study

After completing this course you may further develop your knowledge and skills in Microsoft Excel with the CEF reimbursable course Data Analysis with Microsoft Excel.

Course Fee

$1380

Course Duration

6 Hours

Course Prerequisites

Course participants should have basic knowledge of Microsoft Windows and Microsoft Excel.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement.

Schedule & Online Enrolment
Enquiry/Booking
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
PP10-6A9C
 Central
 Cantonese / PC
9/12~16/12
1000-13006 hrs/
2 sessions
SAT1,380.00
PP10-24C16K
 Mongkok
 Cantonese / PC
16/1~18/1
1900-22006 hrs/
2 sessions
TUE, THU1,380.00
PP10-6A27C
 Central
 Cantonese / PC
27/1~3/2
1000-13006 hrs/
2 sessions
SAT1,380.00
PP10-35C21C
 Central
 Cantonese / PC
21/2~23/2
1900-22006 hrs/
2 sessions
WED, FRI1,380.00
PP10-6A17K
 Mongkok
 Cantonese / PC
17/3~24/3
1000-13006 hrs/
2 sessions
SAT1,380.00
PP10-6A7C
 Central
 Cantonese / PC
7/4~14/4
1000-13006 hrs/
2 sessions
SAT1,380.00
PP10-45C3K
 Mongkok
 Cantonese / PC
3/5~4/5
1900-22006 hrs/
2 sessions
THU, FRI1,380.00
PP10-12C28C
 Central
 Cantonese / PC
28/5~29/5
1900-22006 hrs/
2 sessions
MON, TUE1,380.00
PP10-24C19K
 Mongkok
 Cantonese / PC
19/6~21/6
1900-22006 hrs/
2 sessions
TUE, THU1,380.00
PP10-6A14C
 Central
 Cantonese / PC
14/7~21/7
1000-13006 hrs/
2 sessions
SAT1,380.00
PP10-6A4K
 Mongkok
 Cantonese / PC
4/8~11/8
1000-13006 hrs/
2 sessions
SAT1,380.00
PP10-51C31C
 Central
 Cantonese / PC
31/8~3/9
1900-22006 hrs/
2 sessions
MON, FRI1,380.00
PP10-45C32K
 Mongkok
 Cantonese / PC
20/9~21/9
1900-22006 hrs/
2 sessions
THU, FRI1,380.00
PowerPivot for Microsoft Excel 2010
Complete your Enrol
How to enrol/pay online

Understanding Power Pivot will allow you to create more complex data model through a collection of of tables with relationships. It is interchangeable with Excel, but allows for more sophisticated data modelling by working in the Power Pivot window. This 6-hour course is designed for those who have some background knowledge in Excel but would like to use more advanced add-ins of Excel to enhance work productivity and effectiveness.

[/fusion_text]
  1. Downloading and Installing PowerPivot
    • System Requirements
    • Installing PowerPivot
    • Uninstalling PowerPivot
  2. The Promise of PowerPivot
    • Preparing Your Data for PowerPivot
    • Getting Your Data into PowerPivot
    • Define Relationships
    • Add Calculated Columns Using DAX
    • Build a Pivot Table
    • World-Class Data Compression
    • Asymmetric Reporting with PowerPivot
  3. Why Wouldn’t I Build Every Future Pivot Table in PowerPivot?
    • Great Reasons to Use PowerPivot
    • The Downside of PowerPivot
    • Bottom Line
  4. Getting Your Data into PowerPivot
    • Getting Excel Data into PowerPivot
    • Importing Data from SQL Server
    • Importing a Text File
    • Importing from Atom Data Feeds
    • Importing from Other Sources
  5. Creating and Managing Relationships
    • Trying to Autodetect Relationships
    • Manually Defining a Relationship
    • Calculating Between Tables
    • Defining a Difficult Relationship
    • Building a Concatenated Key Relationship
    • Is This Harder Than a VLOOKUP?
    • Questions About Relationships
[/fusion_text]
  1. Using Data Sheet View
    • Working with Data in the PowerPivot Window
    • Adding New Columns Using DAX Formulas
    • DAX Function Reference
    • Grabbing Values from a Related Table
    • Using the Recursive Functions
    • Using Other Functions
  2. Building Pivot Tables
    • Elements of a Pivot Table
    • Building a Pivot Table
    • Explanation of Column B
    • Two Important Rules with Pivot Tables
    • Working with Pivot Charts
    • Behind the Scenes with PowerPivot Field List and Add-In
  3. Cool Tricks Native to Pivot Tables
    • Applying Sorting Rules to Pivot Tables
    • Showing the Top Five Customers
    • Changing the Calculation in the Pivot Table
    • Pivot Table Formatting
    • Applying Data Visualizations and Sparklines
  4. Cool Tricks New with PowerPivot
    • Building a Report with Two Pivot Charts
    • Adding Slicers and Understanding Slicer AutoLayout
    • Adding a Pivot Chart to an Existing Layout
    • Adding a Pivot Table to an Existing Layout
  1. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
  2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.

You may also be interested in