Discover Classes. Earn Rewards.

In-Person Excel Advanced Class

at Computers Etc Software Training Center - Miramar

(3)
Course Details
Price:
$225 14 seats left
Start Date:

Wed, Jul 20, 9:00am - 4:00pm Pacific Time

Location:
Miramar
6920 Miramar Road Suite 206
Production Ave
San Diego, California 92121
(Map)
Purchase Options
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 6

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.


Still have questions? Ask the community.

Refund Policy

Transfer Policy: You can transfer free-of-charge to another class provided that you give us at least 24 hours 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!

Map

Google Map

Computers Etc Software Training Center

All classes at this location

From 805: Go east on Miramar Road. Look for Jack in the Box, Flooring Wholesalers, and Starbucks. Turn left at stoplight onto Production Ave and continue just past railroads tracks. Turn left into parking lot. Do not park in reserved spaces. From 15: Go west on Miramar Road. Look for Jack in the Box, Flooring Wholesalers, and Starbucks. Turn right at stoplight onto Production Ave and continue just past railroads tracks. Turn left into parking lot. Do not park in reserved spaces.

Start Dates (1)
Start Date Time Teacher # Sessions Price
9:00am - 4:00pm Pacific Time TBD 1 $225

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 2250 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Computers Etc Software Training Center (3)

Similar Classes

School: Computers Etc Software Training Center

Computers Etc Software Training Center

Computers Etc. was founded in 1992. We teach popular computer programs such as Access, Excel, Outlook, PowerPoint, Word, and QuickBooks. Over 25,000 students have attended our computer classes over the years. Our mission is to offer the finest computer classes at the lowest possible prices. From the...

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.

Ready to take this class?
BOOK NOW
Booking this class for a group? Find great private group events here
Loading...