Discover Classes. Earn Rewards.

Excel Advanced

Take your Excel skills to the next level with this comprehensive course that covers advanced functions and tools. Master functions like VLookup and If, learn how to analyze data with What-If tables, and automate tasks with Macros. Join us at Computers Etc Software Training Center and become an Excel pro.

  • Advanced
  • 18 and older
  • $250
  • 6212 Ferris Square, San Diego, CA
  • 7 hours
Excel Advanced
Book Now

No Booking Fees. Lowest Price Guaranteed. Earn Rewards.

Give as a Gift Save to WishList

2 people wishlisted

Start Dates (3)

  • $250
  • AGC San Diego Chapter @ 6212 Ferris Square, San Diego, CA 92121
  • 7 hours
14 seats left
Book
14 seats left
Book
14 seats left
Book
Showing 13 of 3

Class Description

Description

What you'll learn in this excel class:

This class is intended for:

  • PC/Windows Users: Excel 2010-2013-2016-2019-365
  • Course Materials: FREE
  • Certificate of Completion (optional): $5
  • Course Length: 1 Day

Basic Functions:

  • Average (average a range of cells)
  • Max (display highest number in a range cells)
  • Min (display lowest number in a range of cells)
  • Sum (sum or total of a range of cells)

Count Functions:

  • Count (count cells containing numbers)
  • CountA (count cells containing text)
  • CountBlank (count blank cells)
  • CountIf (count cells that meet a single criteria - a word, a number, etc.)
  • CountIfs (count cells that meet multiple criteria - words, numbers, etc.)

Sum Functions:

  • SumIf (add cells that meeta single criteria - a word, a number, etc.)
  • SumIfs (add cells that meet multiple criteria - words, numbers, etc.)
  • SumProduct (sum cells meeting multiple criteria - words, numbers, etc.)

Average Functions:

  • Average (average numbers)
  • AverageIf (average cells that meet a single criteria - words, numbers, etc.)
  • AverageIfst (average cells that meet multiple criteria - words, numbers, etc.)

If Functions:

  • If (assign a true or false result to cells that meet a single criteria)
  • And (assign a true or false value to rows that meet multiple criteria)
  • Or (assign a true or false value to rows meet one or another criteria)

HLookup & VLookup Functions:

  • HLookup (look up data in a row)
  • VLookup (look up data in a column)

Financial Functions:

  • Pmt (calculate payments and interest rates on a loan)
  • FV (calculate the future value of an investment)

Text Functions:

  • Concatenate (combine data from multiple cells into one cell)
  • Trim (remove extra blank spaces between Concatenated text)
  • Upper (convert all text to uppercase)
  • Lower (convert all text to lowercase)
  • Proper (capitalize first letter of each word)
  • Left (extract a number of characters from the left side of a cell)
  • Right (extract a number of characters from the right side of a cell)
  • Mid (extract a number of characters from the middle of a cell)

Date /Time Functions:

  • Date (calculate days/months/years between two different dates)
  • Month (display the month)
  • Year(display the year)

Misc:

  • "Nest" functions (combine functions - place one function within another)
  • Round Function (round off results to a given number of decimal places)

"What-If" Tools:

Goal Seek allows you to calculate an unknown value in a given formula, but is only useful for problems that involve finding a single variable. When the desired result of a calculated cell is known, but not the input value that calculation needs to reach that result, you can use Goal Seek.

Solver is a tool that helps you find solutions to problems involving multiple variables.

Scenarios are part of a group of commands that can be called what-if analysis tools. A scenario is a set of values that a user can create and save and then substitute at any time in the worksheet. The user can then switch to any of these new scenarios to view different results in the worksheet. To compare several scenarios, you can create a report that summarizes them on the same page.


What-If Tables allow you to analyze data and produce a table to show the results. When a single variable like the unit price changes, use a one-input What-If Table. If the unit price AND number of units sold changes, use the two-input What-If Table.

Macros:

Create Absolute and/or Relative Macros to automate common, repetitive tasks.

WorkBook Controls:

Add buttons, sliders, and checkboxes to a worksheet to create a "user-friendly" interface for less experienced users.

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. Points give you money off your next class!

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.

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