Discover Classes. Earn Rewards.

In-Person Excel Intermediate Class

at Computers Etc Software Training Center - Miramar

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

Thu, Oct 13, 9:00am - 4:00pm Pacific Time

Next start dates (5)

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

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.



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 (6)
Start Date Time Teacher # Sessions Price
9:00am - 4:00pm Pacific Time Douglas Bush 1 $225
9:00am - 4:00pm Pacific Time Douglas Bush 1 $225
9:00am - 4:00pm Pacific Time Douglas Bush 1 $225
9:00am - 4:00pm Pacific Time Douglas Bush 1 $225
9:00am - 4:00pm Pacific Time Douglas Bush 1 $225
Start Date Time Teacher # Sessions Price
9:00am - 4:00pm Pacific Time Douglas Bush 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...