Excel Lookups, Functions and Macros
- Advanced
- 18 and older
- $350
- Earn 3,500 reward points
- Price Lock Guarantee
- 915 Wilshire Blvd, Los Angeles, CA
- 7 hours & 30 minutes
Thankfully we have 9 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.
Training Connection @ 915 Wilshire Blvd, Los Angeles, CA
Learn how to create, modify, format, and print Excel worksheets and workbooks in this hands-on beginner class at Training Connection. Discover basic formulas and functions, manipulate data, and add charts to your spreadsheets. Ideal for those new to Excel who need to produce reports, budgets, and lists.
May 13th
9am–4pm PDT
Jun 17th
9am–4pm PDT
Training Connection @ 915 Wilshire Blvd, Los Angeles, CA
Enhance your Excel skills with this intermediate course that teaches you to share, filter, and sort data as well as create PivotTables, apply conditional formatting, and more. Join us for a live instructor-led class and take your Excel knowledge to the next level.
May 14th
9am–4pm PDT
Jun 18th
9am–4pm PDT
Training Connection @ 915 Wilshire Blvd, Los Angeles, CA
Take your Excel skills to the next level with a hands-on course that covers advanced functions, data analysis, importing/exporting, and automation. Join us for a live, face-to-face class to learn from experienced instructors and enhance your proficiency in Excel 2013, 2016, 2019, or 365. No minimum class size - all classes are guaranteed to run!
May 15th
9am–4pm PDT
Jun 19th
9am–4pm PDT
Training Connection @ 915 Wilshire Blvd, Los Angeles, CA
Enhance your Excel skills with this instructor-led course that will teach you how to write and debug powerful VBA code to automate Excel operations. Learn to create interactive forms, handle run-time errors, and more. Prerequisite: Completion of Excel Advanced or equivalent experience.
May 16th
9am–4pm PDT
Jun 20th
9am–4pm PDT
Los Angeles City College @ 855 N Vermont Ave, Los Angeles, CA
The leader in creating spreadsheets and data presentation, topics include: Basic worksheet navigation Entry techniques Cell references Using the command groups & settings Formulas & Functions Charts & Graphs Simple database operations Continuing classes include a overview of Excel's vast collection of formulas and functions.
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:
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
Advanced Formulas
Special Functions
Importing And Exporting
Analysis
Macros And Forms
Internationalization And Accessibility
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.
People who viewed this class also viewed the following classes
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 Los Angeles educator.
Prompt Yes!
Downtown, Downtown/Northeast
915 Wilshire Blvd Ste #1800
Near Francisco St
Los Angeles, California 90017 Downtown, Downtown/Northeast
915 Wilshire Blvd Ste #1800
Near Francisco St
Los Angeles, California 90017
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.