Excel Lookups, Functions and Macros
- Advanced
- 18 and older
- $350
- Earn 3,500 reward points
- Price Lock Guarantee
- 601 Montgomery St, San Francisco, CA
- 7 hours
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.
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!
Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!
Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!
Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!
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.