Discover Classes. Earn 10% Rewards.

Excel Advanced is unfortunately unavailable

See all Tech classes San Diego

Excel Advanced

Computers Etc Software Training Center
4.8 5 reviews

Elevate your Excel skills to mastery with our Advanced course. Delve into 40 essential functions, including SumIf, Concatenate, and VLookup, empowering you to streamline data analysis and manipulation tasks. Explore advanced features such as "What If" tools and Worksheet Controls to revolutionize your spreadsheet capabilities and become an indispensable asset in any professional setting.

  • Advanced
  • Small class sizes
  • 18 and older
  • Earn 10% back in points
  • Price Lock

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

  • 6212 Ferris Square, San Diego, CA
  • 7 hours
Excel Advanced
Excel Advanced
Sold Out
Book Private Class Save to WishList

2 people wishlisted

Start Dates (0) $275/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 Cancellation Policy

Description

Become the office Excel Diva or Guru by learning how to unlock the power of functions. Learn 40 must-know functions like SumIf, Concatenate, If, VLookup, and many more. Nest (combine) functions to take them to the next level. Learn how to use Excel’s “What If” tools (Goal Seek, Solver, Scenarios, & Data Tables), create simple recorded Macros, and add user-friendly Worksheet Controls to your spreadsheets such as buttons, sliders, checkboxes, and spin buttons.

Topics Covered:

  • Basic Functions: Sum, Average, Max, and Min
  • Counting Functions: Count, CountA, CountBlank, CountIf, & CountIfs
  • Summing Functions: SumIf, SumIfs, & SumProduct
  • Average Functions: AverageIf & AverageIfs
  • If Functions: If, Ifs, IfError, If And, & If Or
  • Lookup Functions: VLookup, HLookup, & XLookup
  • Financial Functions: PMT & FV
  • Text Functions: Concatenate, Text Join, Trim, Upper, Lower, Proper, Left, Right, & Mid
  • Date & Time Functions: Today, Now, Day, Month, & Year
  • Nested Functions (combine different functions)
  • "What If" Tools: Goal Seek, Solver, Scenarios, & Data Tables
  • Basic Recorded Macros
  • Worksheet Controls: Buttons, Sliders, Checkboxes, & Radio Buttons Sign in Gift vouchers Category

Refund Policy

Transfer Policy:

  • You can transfer free-of-charge to another class provided that you give us at least 2 business days advance notice by phone or e-mail.
  • You can also send someone else in your place. Please inform us who will attend the class.

Refund Policy:

  • If you feel a class isn't right for you, just let the instructor know during the first break. We will issue a full-refund, transfer you to another class, or issue a full credit for the class - Your choice. You must inform the instructor during the first break!

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 Computers Etc Software Training Center (5)

(4.8-star rating across 5 reviews)
See reviews for other classes at Computers Etc Software Training Center
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 within 48 hours of booking, send us the link. We match the price as credit or the difference.
  • This class will earn you 2750 points. Earn 10% back in points. 100 points = $1 off a later class.

Computers Etc Software Training Center

Computers Etc. Software Training Center, founded in 1992, specializes in software training for popular programs such as Access, Excel, Outlook, PowerPoint, Word, and QuickBooks. They differentiate themselves from other training companies by offering small classes, affordable prices, a convenient schedule, and a supportive atmosphere.

View school profile
Computers Etc Software Training Center
Vetted by CourseHorse

A verified San Diego educator.

Give an experience worth remembering

One CourseHorse gift card. Thousands of classes to choose from.

  • Instant or scheduled delivery
  • No expiration date
  • Earn 15% reward points
Buy a Gift Card
gift card with the CourseHorse logo
Loading...