Discover Classes. Earn Rewards.

Excel Lookups, Functions and Macros is unfortunately unavailable

Thankfully we have 1 other Excel Class for you to choose from. Check our top choice below or see all classes for more options.

Wine Cellar Management

San Francisco Wine School @ 415 Grand Ave, San Francisco, CA

Master the art of maintaining a flawless wine list and running a smooth cellar operation. Enhance your skills in order checking, inventory management, POS programming, and effective communication. Take the first step towards becoming a wine director or cellar master at San Francisco Wine School.

(13) All levels 21 and older
See all Excel classes San Francisco

Excel Lookups, Functions and Macros

  • Advanced
  • 18 and older
  • $350
  • 601 Montgomery St, San Francisco, CA
  • 7 hours

Start Dates (0)

  • $350
  • AcademyX @ 601 Montgomery St #409, San Francisco, CA 94111
  • 7 hours
Showing 10 of 0

Class Description

Description

What you'll learn in this excel class:

This course builds on the concepts and skills of our Excel Intermediate course to provide advanced tools for solving real-world problems in Excel: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, the Power Pivot Data Model, what-if analysis, and macros.

You will benefit the most from this course if you want to use Excel to perform real-world tasks such as getting information from large amounts of data from sources inside and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks.

Logical and Lookup Functions

  • Decision-Making Functions
  • Lookkup and Reference Functions

Advanced Formulas

  • Auditing And Error-Trapping
  • Formula Options

Special Functions

  • Date And Time Functions
  • Text Functions
  • Other Functions

Importing And Exporting

  • The Power Pivot Data Model
  • Exploring Data

Analysis

  • What-If Analysis
  • The Analysis Toolpak

Macros And Forms

  • Recording Macros
  • Running Macros
  • Forms

Internationalization And Accessibility

  • Preparing Workbooks For Internationalization And Accessibility

Prerequisites:

  • Excel Intermediate or the equivalent in work experience.

Refund Policy

Cancellations

We classify cancellations in 3 types depending on whether you give us at least 4 days’ notice:

  1. Timely Cancellations. We will process a full refund of enrollment fees as long as you give us at least 4 days’ (96 hours) notice of the cancellation before the class start time.
  2. Late Cancellations. If you notify us within fewer than 96 hours, we do not offer refunds, but you would still qualify for a “late-reschedule” under the terms below. That said, we do not penalize for “accidental enrollments”: cancellations made within 2 hours of initial enrollment, even if the class is schedule to begin within 96 hours.
  3. No-Shows and Technical Mishaps. If you try to attend on time but you have technical problems (mic/audio, etc.), or if you do not show up to a scheduled class, then we consider this a “late reschedule,” with the policy detailed below.


Reschedules

Similar to cancellations, we classify reschedules into two categories depending on timeliness.

  1. Timely Reschedules. If you notify us, with at least 96 hours’ notice, of your intent to reschedule to a different class we are happy to oblige.
  2. Late Reschedules. If, on the other hand, you give us less than the 96 hours’ notice before the class start time, or no-show or have a technical mishap, then:
  • We still allow a reschedule to a different date, but we shift the onus to you of re-enrolling: you must let us know on the day before the class you’d like to take, and we would re-enroll you in that class on a space-available basis. The reason for most reschedules is that high-priority items pop up on your calendar that interfere with taking one of our classes; by asking you to re-register with only a little time until the class, it reduces the likelihood of new tasks popping up before the class.
  • We do not offer refunds
  • We only allow one late-reschedule. If you late-reschedule a second time, you must re-enroll in the class at a 50% discount, or forfeit the enrollment funds.

Transfers

You may transfer your registration in a scheduled class to anyone else. We sometimes allow the transfer of enrollment funds to a different class, but we don’t guarantee it. In either case, start by contacting us.

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.

Reviews of Classes at Prompt Yes! (64)

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

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Prompt Yes!

Prompt Yes (promptyes.com) offers hands-on, instructor-led workshops in AI tools and prompt engineering: ChatGPT, Midjourney Stable Diffusion, and more.

Read more about Prompt Yes!

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified San Francisco educator.

Prompt Yes!

Prompt Yes!

All classes at this location

Google Map

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