Discover Classes. Earn Rewards.

Excel Intermediate

Take your Excel skills to the next level at Computers Etc Software Training Center and learn how to create advanced formulas, combine data from different sheets or files, use Validation for accurate data entry, password protect your sheets, analyze large spreadsheets with PivotTables, and more. Enhance your Excel proficiency and become a master in data manipulation and analysis.

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

No Booking Fees. Lowest Price Guaranteed. Earn Rewards.

Give as a Gift Save to WishList

3 people wishlisted

Start Dates (4)

  • $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
14 seats left
Book
Showing 14 of 4

Class Description

Description

What you'll learn in this excel class:

Take your Excel skills to the next level and create formulas using parentheses, combine information from different sheets or files, use Validation to create look-up lists and limit what users can input, password protect all or part of a sheet, use Conditional Formatting to make important values stand out, and analyze large spreadsheets with PivotTables. 

Advanced Formulas

  • Create more complex formulas using Absolute Cell References and the Order of Operations.

3-D FORMULAS

  • Combine data from different sheets located within the same workbook (file).

Link Workbooks & Consolidate Data: 

  • Link data from different workbooks (files).

Validation

  • Use Validation to improve speed and accuracy of data entry, set limits on what can be entered, add drop-down lists and pop-up explanation boxes.

Pivot Tables

  • Use Pivot Tables to summarize rows of data for reports. We will spend several hours on Pivot Tables.

Group / Outline / Sort / Filter / Subtotal Data:

  • Sort and Filter data, Subtotal data, Group and Outline data.
  • Create Forms to speed up data entry, editing, and searching.

Templates

  • Create and edit a Workbook Template so you can base new spreadsheets on it.

Conditional Formatting

  • Use Conditional Formatting to change the appearance of values or cell background colors.

Protect a Worksheet/Workbook:

  • Protect a Worksheet or Workbook so it cannot be changed, etc.
  • Allow users to change certain cells.


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)

(4.8-star rating across 4 reviews)
  • Excel Intermediate

    Reviewed by claire f. on 1/25/2023
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.
  • 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...