Discover Classes. Earn 10% Rewards.

Excel Intermediate

Take your Excel skills to the next level with our Intermediate course. Dive into advanced features like linking, consolidation, and conditional formatting to enhance data analysis and presentation. Unlock the power of pivot tables, multiple sorts and filters, and password protection, equipping yourself with essential tools for efficient spreadsheet management and manipulation.

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

  • $250/person
  • 7 hours
14 left
Book
14 left
Book
25 left
Book
25 left
Book
Showing 14 of 4

Class Description

Description

What you'll learn in this excel class:

This course is designed for Excel users who are ready to move beyond the basics and take advantage of intermediate-level features like Linking, Consolidation, 3D formulas, and Absolute Cell References to create more complex formulas. You’ll also learn how to use other tools like Pivot Tables & Pivot Charts to analyze large spreadsheets, and how to apply multiple sorts & filters, group & outline data, and more. Use Conditional Formatting to make important values stand out (make negative numbers turn red or change the background/fill color of a cell based on a value). Password Protect a workbook to prevent unauthorized changes to specific areas of a spreadsheet.

Topics Covered:

  • Create more complex formulas
  • Formula Syntax (proper use of special characters in formulas)
  • Absolute Cell References (lock in an address so it won’t change)
  • Order of Operations (control the order of math operations)
  • 3-D Formulas (combine data from different worksheets)
  • Link workbooks (dynamic link between files so they instantly update)
  • Consolidate worksheets or workbooks
  • Data Validation (set limits on data entry)
  • Deep Dive into Pivot Tables & Pivot Charts (summarize large spreadsheets)
  • Create a Pivot Table / Pivot Chart Dashboard (interactive main menu)
  • Group and Outline data
  • Sub-Total data
  • Multiple Sorts and Filters
  • Subtotal data
  • Formula Auditing (resolve errors, view the relationship between cells, etc.)
  • Templates
  • Conditional Formatting (use color to make important values stand out)
  • Password Protect all or part of a workbook


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