Excel PivotTables: Data Summarization and Analysis
- Intermediate
- 16 and older
- $179
- 200 Pine Ave, Long Beach, CA
- 3 hours
Thankfully we have 15 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.
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 5th
7am–1:45pm PDT
Apr 8th
7am–1:45pm PDT
Apr 11th
7am–1:45pm PDT
Apr 16th
7am–1:45pm PDT
Apr 19th
7am–1:45pm PDT
This class has 5 more dates.
Tap here to see more
ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA
Master the essential Excel database features and learn how to create powerful PivotTables with this highly sought-after course. Don't miss your chance to gain valuable data management skills - register now to secure your spot!
Apr 3rd
7am–1:45pm PDT
Apr 11th
7am–1:45pm PDT
Apr 19th
7am–1:45pm PDT
Apr 22nd
7am–1:45pm PDT
Apr 30th
7am–1:45pm PDT
This class has 1 more date.
Tap here to see more
ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA
Master the essential skills of managing large worksheets, creating models, and working with financial, date, and logical functions in Excel with this popular course at ONLC Training Centers. Don't miss out on the opportunity to enhance your Excel skills - register now and secure your spot!
Apr 4th
7am–1:45pm PDT
Apr 12th
7am–1:45pm PDT
Apr 15th
7am–1:45pm PDT
Apr 23rd
7am–1:45pm PDT
May 1st
7am–1:45pm PDT
This class has 1 more date.
Tap here to see more
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.
Apr 15th
9am–4pm PDT
May 13th
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.
Apr 16th
9am–4pm PDT
May 14th
9am–4pm 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.