Discover Classes. Earn 10% Rewards.

Excel Advanced 2: Advanced Formulas is unfortunately unavailable

Thankfully we have 3 other All Software Classes for you to choose from. Check our top choices below or see all classes for more options.

Digital Video Editing with Adobe Premiere Pro (Level 2)

Los Angeles City College See all classes by this school @ 855 N Vermont Ave, Los Angeles, CA

Push your video editing skills further with this intermediate Adobe Premiere Pro course. Step into advanced tools and techniques, including timeline pancaking, media browsing, and working with different resolutions. Build color correction, adjustment layers, and exporting settings for YouTube and Vimeo. The course is built for those already familiar with basic editing and project setup in Premiere Pro.

(935) Intermediate 18 and older
$199

3 sessions

Attend
+1990 pts
Gift it!

Adobe Photoshop: Training for Everyone

Los Angeles City College See all classes by this school @ 855 N Vermont Ave, Los Angeles, CA

Pick up essential concepts and advanced features of Adobe Photoshop in this thorough training course. Develop your graphic design, photo manipulation, and image restoration abilities, and create striking movie posters and pop art pieces. Stand apart from the crowd with strong design and imaging skills.

(935) Beginner 18 and older
$99

2 sessions

Attend
+990 pts
Gift it!

Adobe Illustrator: Training for Everyone

Los Angeles City College See all classes by this school @ 855 N Vermont Ave, Los Angeles, CA

Build your skills in vector graphics and distinctive illustration design using Adobe Illustrator. Get hands-on with painterly brushes, shape-building utilities, path controls, transparency, and gradients across mediums while shaping personalized logos and business cards at Los Angeles City College's hands-on lab.

(935) Beginner 18 and older
$99

2 sessions

Attend
+990 pts
Gift it!
See all All Software classes Los Angeles

Excel Advanced 2: Advanced Formulas

  • Advanced
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 200 Pine Ave, Long Beach, CA
  • 3 hours

Start Dates (0) $195/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 three-hour session for Windows and Mac users, you will learn to write complex formulas using Excel's built-in functions and array formulas. You will expand your library of functions to include financial, text parsing, logical, lookup and database functions. You will also learn to write array formulas, which are capable of performing multiple calculations in a single result. Finally, you will gain essential formula auditing and troubleshooting skills.

Prerequisites

This class is ideally suited for those who have attended the Excel Beginning 2: Simple Formulas class or who are already comfortable creating basic formulas like SUM, AVERAGE, COUNT, LEFT, MID, RIGHT and PMT.

Class Outline

Advanced Formulas using Functions

  • IF to construct conditional logic
  • nesting functions inside functions
  • VALUE to convert strings to values
  • SEARCH to aid in parsing text strings
  • VLOOKUP and XLOOKUP 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

Array Formulas
  • understand array formulas
  • write array formulas that perform multiple calculations to generate a single result
  • write array formulas that calculate multiple results

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

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 Advanced 2: Advanced Formulas

    Loved the class. The instructor was very knowledgeable and explained my questions, and the materials, in very easy to understand ways. I took a lot away from the class and will be using the awesome news formulas right away.
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.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 1950 points. Earn 10% back in reward points!

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