Using PowerPivot to Pump-Up the Power of Pivot Tables

webinar Using PowerPivot to Pump-Up the Power of Pivot Tables

You Will Learn:

  • What PowerPivot is and how to get it
  • Best way to build tables and PivotTables in PowerPivot
  • How to add data and work with calculations
  • Dates and Times and what to do with a Date Table
Watch the pre-recorded web conference
$269.00
 

Do you need to connect, visualize and analyze massive amounts of data? Then you need PowerPivot.

PowerPivot dramatically extends the powers of “normal” Excel, and more importantly, the powers of people who use it … and it snaps right into Excel as if it had been there from the beginning.

In the past, you’d have to pay big bucks and be a technological whiz to have power like this at your fingertips!

Today, with this FREE add-in you can take your reporting to the next level, by allowing you to work with extremely large data sets. In fact, PowerPivot goes well beyond Excel's 1 million rows of data.

Learning Objectives

PowerPivot delivers the quickest, easiest, and most cost-effective way to import massive amounts of data from different sources and mash it together to create useful reports. This interactive webinar will guide you through:

  • PowerPivot requirements
  • Installing the PowerPivot Add-in
  • Importing capabilities
  • Introduction to PowerPivot Relationships

In just one hour, we’ll show you how this Business Intelligence (BI) tool delivers unmatched computational power directly within the application that you already know and love – Excel.

  • How to add data with PowerPivot
  • Dates and Times and what to do with a Date Table
  • Working with calculations
  • Learn what DAX is
  • Using PivotTable with PowerPivot and we won’t forget the slicers
  • Trouble shooting errors and messages

Product ID: 15411

Bonus Material

But that’s not all! You also get the quick-tip guide – Keyboard Shortcuts – FREE!

This must-have tool includes frequently used shortcut keys for several Office programs, including:

  • Windows 10
  • Desktop
  • Word
  • Excel
  • Outlook
  • PowerPoint

So don’t delay! Reserve your seat TODAY for this power-packed webinar to learn time-saving functions and techniques that can speed you through your spreadsheet work!

Learn How to Pump Up the Power of Microsoft Excel with PowerPivot!

Get it on demand now

Faculty

Staci Warne
Staci Warne
Microsoft Certified Trainer

Staci Warne is a highly skilled Microsoft Certified Trainer (MCT) with over 15 years of experience in training individuals, at any skill level.  She obtained her MCT certification in 2008 and also holds an array of other certifications such as Microsoft Certified Professional (MCP) and Microsoft Office master Instructor, and Ic3 Internet and Core computer instructor certifications.

Continuing Education Units

  • cpe

    Receive 1.25 CPE credits by attending the live Audio Conference! C4CM 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 addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN, 37219-2417. Web site: www.nasba.org

    Recordings of the program do not qualify for CPE credits. For more information regarding administrative policies such as complaint and refund, please contact our offices at 877-900-C4CM (2426).

    • Program Level : Intermediate
    • Prerequisites : This course is for participants with some exposure to the subject.
    • Advanced Preparation : None
    • Delivery : Group Live

Learn How to Pump Up the Power of Microsoft Excel with PowerPivot!

Get it on demand now

Stay Up To Date