course

Pivot Tables: Renaming Fields

Not Yet Rated
New Course
0.2 Hours (On-Demand)
CPE Not Available

Recent research released by Microsoft shows that 80% of Excel users have yet to use pivot tables. In these micro courses, Excel expert David H. Ringstrom, CPA, covers the basics of creating and using Excel pivot tables. You'll quickly be able to instantly summarize lists of data into meaningful reports with just a few clicks of your mouse. As with many aspects of Excel, pivot tables have several nuances that can frustrate new users, so David will be sure to bring these to your attention so that you can use the feature effectively. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Pivot Tables: Introduction
Pivot Tables: Interfaces
Pivot Tables: Managing Subtotal Positions
Pivot Tables: Renaming Fields
Pivot Tables: Top 10 Filters
Pivot Tables: 4 Ways to Remove Fields
Pivot Tables: Delete Report Filter Worksheet
Pivot Tables: Expanding & Collapsing
Pivot Tables: Correcting Number Fields Treated As Text

Note: Nano CPE Coming Soon

Learning Objectives
  • Explore the basics of creating and using Excel pivot tables.
Last updated/reviewed: September 24, 2024
Prerequisites
Course Complexity: Foundational
No advanced preparation or prerequisites are required for this course.
Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Instructor for this course
Course Syllabus
COURSE MATERIAL
  Renaming Fields8:52
  Slides: Pivot Tables: Renaming FieldsPDF
  Workbook: Excel Efficiency: Pivot TablesXLSX
  Pivot Tables: Renaming Fields GlossaryPDF
REVIEW AND TEST
  REVIEW QUESTIONquiz
 FINAL EXAMexam