Discover Classes. Earn 10% Rewards.

Excel 2016 (Mac) Session 3 is unfortunately unavailable

Thankfully we have 1 other Tech Class for you to choose from. Check our top choice below or see all classes for more options.

Artificial Intelligence (AI) Business Essentials Certificate Program

American Management Association See all classes by this school @ 25 Burlington Mall Rd, Burlington, MA

Gain a practical foundation in the technologies, applications, and strategic implications of artificial intelligence in today's business environment. This certificate program covers the current AI landscape, key use cases, and the organizational opportunities that AI opens up. A focused and forward-thinking program for professionals ready to lead in an AI-driven world.

(8) All levels 21 and older
$2,795

2 sessions

Attend
Earn 27,950 points
Gift it!
See all Tech classes Los Angeles

Excel 2016 (Mac) Session 3

  • Advanced
  • 16 and older
  • Earn 10% back in points
  • Price Lock

    If you find the same class on the same dates for less on another site within 48 hours of booking, send us the link. We match the price as credit or the difference.

  • 200 Pine Ave, Long Beach, CA

Start Dates (0) $99/person

No upcoming dates are currently available.

Book a Private Group Event

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.

Class Description

Description

In this half-day session, you will learn Excel's data management and summarization tools, which let you turn large amounts of raw data into concise, meaningful reports and charts.

This course will let you import external data, convert data into a table, apply automatic totals and use AutoFilter to show only rows that meet your criteria. You will sort by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals. Finally, you will create PivotTables and PivotCharts to automatically and fluidly summarize data by three or more variables.

Course Outline  

Working with Data in Tables:
  • importing data from text files
  • converting data into a table
  • applying tables styles and totals row
  • using AutoFilter to find records
  • creating custom AutoFilter criteria
  • sorting tables by one or many fields 
Summarizing with Subtotals:
  • generating sub- and grand totals 
  • outlining to show only sub- and grand totals
  • creating multi-level subtotals
Summarizing with PivotTables:
  • creating PivotTables
  • formatting numbers and labels
  • rearranging PivotTable fields
  • using report fields
  • refreshing PivotTable data 
  • creating calculated fields 
  • creating and using PivotCharts
Audience: This class is suited for people who have taken Excel sessions 1 and 2 or been using Excel (any version) for a year or more and want to learn Excel's powerful tools for managing and summarizing long lists of data.

Refund Policy

  • You may cancel or reschedule a class registration at least 8 business days prior to the class without incurring any penalty.
  • After 8 business days, we may charge a penalty of up to 100% of the registration cost.
In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

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.

Reviews of Classes at Accelerate Computer Training (33)

(4.9-star rating across 33 reviews)

This class: 5.0 out of 5 from 1 review

  • Excel 2016 (Mac) Session 3

See reviews for other classes at Accelerate Computer Training
loading...
Hide Reviews

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • No booking fees. You pay the school's price, with nothing added at checkout.
  • Price Lock. If you find the same class on the same dates for less on another site within 48 hours of booking, send us the link. We match the price as credit or the difference.
  • This class will earn you 990 points. Earn 10% back in points. 100 points = $1 off a later class.

Accelerate Computer Training

Accelerate Computer Training offers hands-on computer training classes in Long Beach, California. Their experienced trainers provide personalized instruction in a variety of software applications, allowing students to improve their skills and enhance their work efficiency.

View school profile
Accelerate Computer Training
Vetted by CourseHorse

A verified Los Angeles educator.

Loading...