Discover Classes. Earn 10% Rewards.

Excel Advanced

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
  • 18 and older
  • $250
  • Earn 10% Rewards
  • Price Lock
  • 6212 Ferris Square, San Diego, CA
  • 7 hours

Express Checkout – $250

Proceed to Checkout

No Booking Fees. Lowest Price Guaranteed. Earn 10% Rewards.

Give as a Gift

Start Dates (2)

  • $250/person
  • 7 hours
25 left
25 left
Showing 12 of 2

Class Description


What you'll learn in this excel class:

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 (4)

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 2500 points. Earn 10% back in reward points!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

Computers Etc Software Training Center

Computers Etc. was founded in 1992 in Poway, California and originally focused on computer sales and service. Two years later we started offering computer classes and began to phase out computer sales and services. By 1996 the company was specializing in software training and the name was changed to...

Read more about Computers Etc Software Training Center

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified San Diego educator.

Computers Etc Software Training Center

Computers Etc Software Training Center

All classes at this location

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a 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.

  • Price Lock Guarantee

    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!

  • Earn 10% Reward Points

    Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!

  • No Added Fees

    Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!

  • Curated Courses

    Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo