Discover Classes. Earn 10% Rewards.

Excel Lookups, Functions and Macros is unfortunately unavailable

Thankfully we have 3 other All Software Classes for you to choose from. Check our top choices below or see all classes for more options.

Adobe Illustrator: Training for Everyone

Los Angeles City College See all classes by this school @ 855 N Vermont Ave, Los Angeles, CA

Build your skills in vector graphics and distinctive illustration design using Adobe Illustrator. Get hands-on with painterly brushes, shape-building utilities, path controls, transparency, and gradients across mediums while shaping personalized logos and business cards at Los Angeles City College's hands-on lab.

(935) Beginner 18 and older
$99

2 sessions

Attend
+990 pts
Gift it!

Digital Video Editing with Adobe Premiere Pro (Level 2)

Los Angeles City College See all classes by this school @ 855 N Vermont Ave, Los Angeles, CA

Push your video editing skills further with this intermediate Adobe Premiere Pro course. Step into advanced tools and techniques, including timeline pancaking, media browsing, and working with different resolutions. Build color correction, adjustment layers, and exporting settings for YouTube and Vimeo. The course is built for those already familiar with basic editing and project setup in Premiere Pro.

(935) Intermediate 18 and older
$199

3 sessions

Attend
+1990 pts
Gift it!

Adobe Photoshop: Training for Everyone

Los Angeles City College See all classes by this school @ 855 N Vermont Ave, Los Angeles, CA

Pick up essential concepts and advanced features of Adobe Photoshop in this thorough training course. Develop your graphic design, photo manipulation, and image restoration abilities, and create striking movie posters and pop art pieces. Stand apart from the crowd with strong design and imaging skills.

(935) Beginner 18 and older
$99

2 sessions

Attend
+990 pts
Gift it!
See all All Software classes Los Angeles

Excel Lookups, Functions and Macros

  • Advanced
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    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!

  • 915 Wilshire Blvd, Los Angeles, CA
  • 7 hours & 30 minutes

Start Dates (0) $350/person

No upcoming dates are currently available.

Book a Private 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.

Class Description

Description

Macros, collaboration, security are the foundations of this advanced Excel class. You will learn about different scenarios and how to use what if analysis. 

Advanced functions and much more are also covered:

  • Using IF, SUMIF, and COUNTIF to process data based on rules
  • Using the VLOOKUP, INDEX and MATCH functions to find data in related worksheets
  • Auditing: how to find errors using tracing, IFERROR, and other functions
  • Defining arrays and using array functions to work with groups of data
  • Advanced functions for manipulating dates, times, text
  • Statistical and financial functions
  • Importing external data from the web
  • Scenarios using goal seek, scenario manager and input data tables
  • Using the Analysis Toolpack for correlations and histograms
  • Recording and replaying macros and basic VBA code
  • Creating a form with buttons to add interactivity to your spreadsheet

This course builds on the concepts and skills of our Excel Intermediate course to provide advanced tools for solving real-worl 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! (68)

(4.8-star rating across 68 reviews)

This class: 5.0 out of 5 from 4 reviews

  • Excel Lookups, Functions and Macros

  • Excel Lookups, Functions and Macros

  • Excel Lookups, Functions and Macros

    Excellent instructor. Class materials were just right.
  • Excel Lookups, Functions and Macros

See reviews for other classes at Prompt Yes!
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 3500 points. Earn 10% back in reward points!

Prompt Yes!

Prompt Yes is a website that provides interactive workshops on AI tools and prompt engineering. Their hands-on, instructor-led sessions cover topics such as ChatGPT and Midjourney Stable Diffusion.

View school profile
Prompt Yes!
Vetted by CourseHorse

A verified Los Angeles educator.

Loading...