Excel Lookups, Functions and Macros
- Advanced
- 18 and older
- $350
- 601 Montgomery St, San Francisco, CA
- 7 hours
Thankfully we have 1 other Excel Class for you to choose from. Check our top choice below or see all classes for more options.
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.
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
Advanced Formulas
Special Functions
Importing And Exporting
Analysis
Macros And Forms
Internationalization And Accessibility
Prerequisites:
Cancellations
We classify cancellations in 3 types depending on whether you give us at least 4 days’ notice:
Reschedules
Similar to cancellations, we classify reschedules into two categories depending on timeliness.
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.
Get quick answers from CourseHorse and past students.
Prompt Yes (promptyes.com) offers hands-on, instructor-led workshops in AI tools and prompt engineering: ChatGPT, Midjourney Stable Diffusion, and more.
This school has been carefully vetted by CourseHorse and is a verified San Francisco educator.
Prompt Yes!
FINANCIAL DISTRICT
601 Montgomery St #409
Btwn Merchant & Clay Streets
San Francisco, California 94111 FINANCIAL DISTRICT
601 Montgomery St #409
Btwn Merchant & Clay Streets
San Francisco, California 94111
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.
More in Microsoft Office
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.