Excel PivotTables: Data Summarization and Analysis
- Intermediate
- 16 and older
- $179
- Earn 1,790 reward points
- 200 Pine Ave, Long Beach, CA
- 3 hours
Thankfully we have 10 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.
Training Connection @ 915 Wilshire Blvd, Los Angeles, CA
Learn how to create, modify, format, and print Excel worksheets and workbooks in this hands-on beginner class at Training Connection. Discover basic formulas and functions, manipulate data, and add charts to your spreadsheets. Ideal for those new to Excel who need to produce reports, budgets, and lists.
May 13th
9am–4pm PDT
Jun 17th
9am–4pm PDT
Training Connection @ 915 Wilshire Blvd, Los Angeles, CA
Enhance your Excel skills with this intermediate course that teaches you to share, filter, and sort data as well as create PivotTables, apply conditional formatting, and more. Join us for a live instructor-led class and take your Excel knowledge to the next level.
May 14th
9am–4pm PDT
Jun 18th
9am–4pm PDT
Training Connection @ 915 Wilshire Blvd, Los Angeles, CA
Take your Excel skills to the next level with a hands-on course that covers advanced functions, data analysis, importing/exporting, and automation. Join us for a live, face-to-face class to learn from experienced instructors and enhance your proficiency in Excel 2013, 2016, 2019, or 365. No minimum class size - all classes are guaranteed to run!
May 15th
9am–4pm PDT
Jun 19th
9am–4pm PDT
Training Connection @ 915 Wilshire Blvd, Los Angeles, CA
Enhance your Excel skills with this instructor-led course that will teach you how to write and debug powerful VBA code to automate Excel operations. Learn to create interactive forms, handle run-time errors, and more. Prerequisite: Completion of Excel Advanced or equivalent experience.
May 16th
9am–4pm PDT
Jun 20th
9am–4pm PDT
ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA
Gain the essential skills needed to create and format spreadsheets in Excel. Learn to enter data, use formulas, and format worksheets with ease in this comprehensive introductory course. Perfect for anyone looking to enhance their ability to create and manipulate basic spreadsheets.
Apr 30th
7am–1:45pm PDT
May 2nd
7am–1:45pm PDT
May 10th
7am–1:45pm PDT
A PivotTable is Excel's most powerful data summarization tool. In this three-hour session for Windows and Mac users, you will learn what kinds of data works best for PivotTables and how to prepare your data. You will create PivotTables based on various data sources, summarize data by multiple categories using sum, average and count, format the PivotTable, rearrange columns and rows, apply filters, slicers and grouping (both manual and automatic). You will apply built-in calculations like Show as % of Grand Total, as well as create custom calculated fields. You will also create PivotCharts and refresh a PivotTable if its source data changes.
This class is suited for people who have taken our Excel Beginning or Intermediate Excel classes or have been using Excel (any version) for a year or more and want to learn how to use PivotTables.
Class Outline
Preparing Data and Creating PivotTables
In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.
Students find the classes at Excel PivotTables: Data Summarization and Analysis incredibly beneficial and worthwhile. The instructors, Peter and Sue, receive high praise for their knowledge, teaching style, and ability to simplify complex concepts. Notably, students have found the class particularly useful, whether brushing up on existing knowledge or seeking to learn more about Excel Pivot Tables. The instructors are highly informative and patient, ensuring they cater to the student's individual learning needs. Beyond just imparting knowledge, the instructors have been successful in creating an engaging and enjoyable learning environment. By the end of the class, students feel more confident and proficient in using Excel PivotTables. Here are some standout quotes from students: "Peter can make Excel simple to learn. Hands down, his class was very useful." "Sue was terrific! She was very informative, helpful, and a pleasure to learn from." "They care about your needs and really do a great job."
People who viewed this class also viewed the following classes
Get quick answers from CourseHorse and past students.
Accelerate Computer Training, based in Long Beach, California, provides hands-on computer training classes to Southern California, Los Angeles County, Orange County and the Inland Empire in accelerated small group, instructor-led classes. Through progressive, hands-on training exercises, you learn skills...
Read more about Accelerate Computer Training
This school has been carefully vetted by CourseHorse and is a verified Los Angeles educator.
Accelerate Computer Training
Long Beach, Other Suburbs/Cities
200 Pine Ave Ste 280
Btwn E 3rd St & E Broadway
Long Beach, California 90802 Long Beach, Other Suburbs/Cities
200 Pine Ave Ste 280
Btwn E 3rd St & E Broadway
Long Beach, California 90802
Booking this class for a group? Find great private group events
Or see all Excel Group Events
Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.
More in Microsoft Office
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.