Traditional PivotTables are incredible . but, they do have limitations. If you have ever encountered one of these limitations, you’ll be excited to learn that by using Power Pivot, you’ll be able to bypass many of the restrictions that exist with traditional PivotTables. Power Pivot is included in current versions of Excel for Windows (unavailable in Excel for Mac). Power Pivot enables you to build PivotTables that were previously not practical. In this webcast, we’ll build PivotTables from multiple tables and create measures. If you frequently build PivotTables and would like to do more with them, you’ll want to understand how to use Power Pivot to enhance your reports. Key Topics: Review the Power Pivot function.
Review the Power Pivot function
Recall the steps to access the Power Pivot window, Identify the process to create table relationships, State the procedure for creating measures.
Jeff Lenning, CPA, CITP Click Consulting / Seal Beach, CA
Jeff Lenning, author of Excel University, is an award-winning Excel instructor who has provided continuing education to thousands of CPAs nationwide over the past 10 years.
He is a Microsoft Certified Excel Expert, and his Excel articles have been featured in trade publications such as the Journal of Accountancy and California CPA.
He is a former chair of the California CPA State Technology Committee, and has held a variety of other leadership positions within his local CalCPA chapter.
He worked at Arthur Andersen, Gateway computers, and Interpore Cross International. In 2000, he started Click Consulting, a technology consulting firm.
Non-Member Price $119.00
Member Price $99.00