Excel Lookups, Functions and Macros
- Advanced
- 18 and older
- $350
- Earn 3,500 reward points
- 915 Wilshire Blvd, Los Angeles, CA
- 7 hours & 30 minutes
Thankfully we have 10 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
ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA
Gain the essential skills needed to create and format spreadsheets in Excel. Learn to enter data, use formulas, and format worksheets with ease in this comprehensive introductory course. Perfect for anyone looking to enhance their ability to create and manipulate basic spreadsheets.
Apr 30th
7am–1:45pm PDT
May 2nd
7am–1:45pm PDT
May 10th
7am–1:45pm PDT
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.
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.