Discover Classes. Earn 10% Rewards.

Excel 2016 (Mac) Session 5 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 5

  • 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 create sophisticated charts and complex formulas using functions. You will learn to chart noncontiguous data, create dual-axis charts for comparing vastly disparate data sets, and combine column and areas markers on the same chart.

You will learn how to make 3-D charts more effective by controlling the stacking order of the series, and add trendlines to 2-D charts.

You will also expand your ability to write complex formulas that include financial, text, logical, lookup and database functions, and gain essential formula auditing and troubleshooting skills.

Course Outline

Advanced Charting Capabilities
- charting non-adjacent ranges of cells
- rotating and exploding pie charts
- optimizing Excel charts for use in other programs
- creating dual-axis combination charts
- adding and rearranging series of data
- altering the view of 3-D charts
- adding trendlines and forecasts

Writing Formulas Using Functions
- PMT and PV for financial calculations
- LEFT, MID and RIGHT to extract text
- nesting functions inside functions
- VALUE to convert strings to values
- IF to construct conditional logic
- SEARCH to aid in parsing text strings
- VLOOKUP to retrieve values from a table
- INDEX and MATCH for more dynamic lookups
- creating in-cell drop-down menus
- DSUM to sum table data filtered by criteria

Troubleshooting Advanced Formulas
- editing formulas
- auditing your formulas
- tracing precedents and dependents
- inserting comments
- using the Watch window

Pre-requisites: This class is ideally suited for those who have attended up to Session 3 or who are already comfortable creating basic formulas (SUM, AVERAGE, COUNT, etc) and simple charts.

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 5

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...