Power Pivot for Excel by Rob Collie (20 CPE)

• 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

Objectives

• 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.