Power Pivot for Excel by Rob Collie (20 CPE, 1 Year)

(PPExcel)

Overview

If you use PivotTables or VLOOKUP, your workbooks and reports can probably benefit from Power Pivot. Power Pivot provides a new data source for PivotTables that can include multiple tables and formulas. Power Pivot effectively combines the flexibility of formula-based reports with the power of PivotTables. Once set up, reports are updated each period with a simple click of the Refresh command :-)

 

 

 

 

  • Outline

    • Lesson 1: Warm-up & Fundamentals
    • Lesson 2: Calculate Function
    • Lesson 3: All Function
    • Lesson 4: Multiple Tables
    • Lesson 5: Disconnected Slicers
    • Lesson 6: Time Intelligence
    • Lesson 7: Filter/Table Purpose & Values Function
    • Lesson 8: Custom Calendars
    • Lesson 9: Cube Functions
    • Lesson 10: X Functions
    • Lesson 11: Power Techniques
    • Lesson 12: Applications
  • Author

    Rob Collie, Microsoft MVP
  • Subject

    Microsoft Power Pivot for Excel
  • Benefits

    Begin Now: begin training immediately
    Certificate: download and print your certificate instantly upon completion
    Pause and Resume: pause and resume training as needed
    Exam: unlimited exam attempts
  • Software

    Featuring Microsoft Excel for Windows (2010 or higher required; Excel for Mac not supported)
  • Format

    On-Demand
  • Access Begins

    Immediately
  • Duration

    Online enrollment provides access for one year.
  • Certificate of Completion

    Download instantly once a passing score on the final exam is achieved. You may re-attempt the final exam as many times as necessary.
  • Enrollment Period

    Your enrollment is valid for one year.

 

  • Lesson 1: Warm-up & Fundamentals
  • • Welcome and Overview (0:18:37)
  • • Lecture (1:15:16)
  • • Lab Overview (0:06:28)
  • • Lab Solutions (0:28:20)
  • • Exercises, Quiz, and Additional Resources

  • Lesson 2: Calculate Function
  • • Lecture (1:03:59)
  • • Lab Overview (0:02:52)
  • • Lab Solutions (0:17:35)
  • • Exercises, Quiz, and Additional Resources

  • Lesson 3: All Function
  • • Lecture (0:43:53)
  • • Lab Overview (0:01:00)
  • • Lab Solutions (0:27:34)
  • • Exercises, Quiz, and Additional Resources

  • Lesson 4: Multiple Tables
  • • Lecture (1:45:53)
  • • Lab Overview (0:02:23)
  • • Lab Solutions (0:28:58)
  • • Exercises, Quiz, and Additional Resources

  • Lesson 5: Disconnected Slicers
  • • Lecture (0:19:40)
  • • Lab Overview (0:01:29)
  • • Lab Solutions (0:11:32)
  • • Exercises, Quiz, and Additional Resources

  • Lesson 6: Time Intelligence
  • • Lecture (1:04:23)
  • • Lab Overview (0:01:33)
  • • Lab Solutions (0:20:04)
  • • Exercises, Quiz, and Additional Resources

  • Lesson 7: Filter/Table Purpose, Values Function
  • • Lecture - Part 1 (0:25:39)
  • • Lecture - Part 2 (0:48:53)
  • • Lab Overview (0:02:04)
  • • Lab Solutions (0:15:12)
  • • Exercises, Quiz, and Additional Resources

  • Lesson 8: Custom Calendars
  • • Lecture (0:10:28)
  • • Lab Overview (0:01:23)
  • • Lab Solutions (0:04:48)
  • • Exercises, Quiz, and Additional Resources

  • Lesson 9: Cube Functions
  • • Lecture (0:34:23)
  • • Lab Overview (0:01:28)
  • • Lab Solutions (0:06:52)
  • • Exercises, Quiz, and Additional Resources

  • Lesson 10: X Functions
  • • Lecture (0:20:06)
  • • Lab Overview (0:0:53)
  • • Lab Solutions (0:06:52)
  • • Exercises, Quiz, and Additional Resources

  • Lesson 11: Power Techniques
  • • Lecture (0:16:59)
  • • Lab Overview (0:00:45)
  • • Lab Solutions (0:09:25)
  • • Exercises, Quiz, and Additional Resources

  • Lesson 12: Applications
  • • Intro (0:00:37)
  • • Solutions (0:20:24)
  • • Exercises and Quiz

  • Final
  • • Final Exam
  • • Certificate of Completion
  • • Course Evaluation

  • Bonus Lessons
  • • Performance and Optimization (1:35:46)
  • • Macros (1:07:29)
  • • Additional Resources

Materials

The course includes the following course materials:

  • • Online lecture videos
  • • Lab Exercises
  • • Online Solution Videos
  • • Power Pivot Reference Guide PDF
  • • Glossary
  • • Index
  • • E-book: Power Pivot and Power BI by Rob Collie & Avi Singh

Comments from participants

  • • “I cannot imagine work without the things I’ve learned about Power Pivot in this course. ” - E. Lim

  • • “I really appreciate your attention to detail and your unassuming approach. Mind blowing stuff! My life will be so much easier now.” - Guruprasad D.

  • • “ This curriculum is unique and very valuable. Actually priceless. Big thank you.” - R. Abay

  • • “ This course is absolutely the best I’ve taken. What a value!! I’ve paid twice as much for classes with half the content. Your ability to communicate complicated ideas without technical jargon and heavy theory is remarkable.” - J. Raines

  • • “ The content in this course is super accessible, so retention is high and you want to keep going to each next lesson. I’ve come away from literally each one with something I put to use right away. Worth Every penny.” - J. Hoffner

NASBA QAS CPE Microsoft Excel LogoObjectives

  • • Recognize an action that tends to cause the Excel file size to grow the most
  • • Identify the downside of using copy/paste to create a Power Pivot table
  • • State what is meant by asymmetric reporting

Program Level

Advanced

Prerequisites

Comfortable with traditional PivotTables

Advance Preparation Needed

Ensure you have access to Excel for Windows and Power Pivot. Excel for Mac is not supported. More Info.

Delivery Method

QAS Self-study

Recommended CPE Credits

20

Field of Study

Computer Software & Applications

Expiration

Program enrollment is valid for one year and participant must complete the final exam within this time period.

Registration

To register, add this course to your cart by clicking the Buy Now button and then complete the checkout process.

Refund Policy

Full 30-day refund; refund for any course cancellations or registration into upcoming session if preferred.

Complaint Resolution

For information regarding adminstrative policies such as complaint resolution, please contact Jeff Lenning CPA CITP at 949-200-7688 or via email info@excel-university.com

Official Registry Statement

Excel University, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

 

Price: $347.00
Buy 2 or more for $277.60 each
Quantity: