Excel Pivot Tables Made Easier
3.8 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
16 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Pivot Tables Made Easier to your Wishlist.

Add to Wishlist

Excel Pivot Tables Made Easier

This course provides information on how to create Pivot Tables using Microsoft Excel.
3.8 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
16 students enrolled
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 7 Articles
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Transform raw data into the ideal format for pivot table analysis.
  • Simplify pivot table maintenance by way of Excel's Table feature.
  • Contrast different methods for performing calculations within and outside of pivot tables.
View Curriculum
Requirements
  • Basic Proficiency with Excel.
Description

Many Microsoft Excel users feel that pivot tables are somehow beyond their grasp, yet this is one of Excel's easiest and best features. In this course Excel expert David Ringstrom, CPA, shows you how to whip ugly raw data into a format ready for analysis with a pivot table. You'll quickly be dragging and dropping fields to instantly create reports from lists of data. For this session David offers four different handouts that are specific to Excel 2013, 2010, 2007, and 2003, respectively. 

You learn how to:

  • Quickly whip unwieldy data into the format required for pivot table analysis.
  • Use a simple keyboard shortcut to post the same formula to multiple cells at once.
  • See how the Table feature can vastly improve the integrity of pivot tables in Excel.
  • Explore the basics of pivot table creation.
  • See the nuances of subtotaling data within a pivot table.
  • Dig deeper into the numbers by using the Report Filter command to create break-out tables.
  • Incorporate calculations within, or alongside, pivot tables.
  • Disable the GETPIVOTDATA function if you don't need it.
  • See how pivot tables differ from worksheet formulas and the importance of the Refresh command.
Who is the target audience?
  • Anyone interested in learning more about Excel pivot tables.
  • Anyone in Accounting, Finance, or related fields.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
16 Lectures
01:56:39
+
Getting Started
9 Lectures 01:56:29


Table Feature; Creating a Pivot Table; Removing Fields
06:20

Subtotaling; Expanding-Collapsing Fields
08:55

Renaming Fields; Report Filter feature
08:20

Pivot Table Calculations
11:41

Refreshing Pivot Tables
06:53

Closing Remarks
02:47

Excel Efficiency: Pivot Tables Full Video
58:14
+
Supporting Materials
7 Lectures 00:09
Slides: Excel Efficiency Pivot Tables-Excel 2003
00:01

Slides: Excel Efficiency Pivot Tables-Excel 2007
00:01

Slides: Excel Efficiency Pivot Tables-Excel 2010
00:01

Slides: Excel Efficiency Pivot Tables-Excel 2013
00:01

Excel Efficiency: Pivot Tables Glossary/Index
00:01

Excel Efficiency Pivot Tables-Excel 2003
00:01

Excel Efficiency Pivot Tables-Excel 2007-2013
00:01
+
REVIEW AND TEST
0 Lectures 00:00

REVIEW QUESTIONS: Excel Efficiency: Pivot Tables

REVIEW QUESTIONS
3 questions

FINAL EXAM: Excel Efficiency: Pivot Tables

FINAL EXAM
5 questions
About the Instructor
Illumeo Learning
4.2 Average rating
66 Reviews
611 Students
159 Courses
Condensed and Efficient Courses for Busy Professionals

Illumeo, incorporated in 2009, is revolutionizing the hide-bound world of corporate learning. Illumeo works with corporate professionals and organizations of all sizes to build the skills and capabilities that help everyone be an expert at their job.

Based in Silicon Valley, CA, Illumeo serves thousands of corporations and corporate professionals across Finance, Accounting, Human Resources, Sales and Marketing. The platform offers assessments, industry-benchmarked competency analyses, hundreds of expert-developed courses, collaborative tools, and the ability for companies to self-publish internal courses that promote institutional knowledge retention and dissemination.

Illumeo is the place for expertise management and we are dedicated to the proposition that everyone can be an expert at their job.

David Ringstrom (Illumeo)
4.0 Average rating
5 Reviews
49 Students
14 Courses

David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet and database consulting firm that he started in 1991. David teaches 180 live webinars annually on Microsoft Excel, along with occasionally speaking at conferences. He is the co-author of Idiot's Guides: Introductory Accounting, and has served as the technical editor for over 30 books on accounting software. Some of his hundreds of freelance articles on spreadsheets have been published internationally. 

Experience

President : Accounting Advisors, Inc. - [1991-12 to Current]
David offers spreadsheet, database, and accounting software consulting services nationwide. He focuses on streamlining complex business processes via a combination of training, tools, and custom programming. 

Education

Bachelor of Business Administration, Accounting : J. Mack Robinson College of Business (at Georgia State University )