Have a question for the event organizer?
Send your message below!
LA: Advanced Excel Corporate Training
Master Excel's most powerful features - from advanced functions and macros to data visualization and analytics - to transform complex data into actionable insights and boost workplace efficiency. This hands-on course elevates Excel skills across any industry.
| Provider | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Location | At your location, Los Angeles | |||||||||||||||
| Pricing |
$1,800 for up to 20 people
We’re happy to discuss your training needs free of charge. Reach out for a free consultation and let us know which skill your team is interested in, your preferred custom training options, and the approximate number of participants you’ll have so we can create a package for you. Send us an email or give us a call today! |
|||||||||||||||
| Duration |
Up to 7 hours For a shortened session, please request desired length in special requests at checkout.
|
|||||||||||||||
| Group Size |
Up to 20 people Group size can be changed after booking if needed.
|
|||||||||||||||
| Materials | None required | |||||||||||||||
| Other |
General Notes
Supported Platforms for Virtual Events: Zoom is our recommended platform, but we can accommodate Google Meets, Microsoft Teams, and WebEx if you provide the meeting link to CourseHorse in advance of the event. PoliciesPrice Match GuaranteeIf you find a similar event with a competitor at a lower price, we’ll gladly match it. This applies to events of comparable description and duration. Simply provide the details when booking, or within 72 hours of your booking, and we’ll ensure you get the best value. Contact an event concierge to get started. Rescheduling & Cancellation PolicyReschedule or cancel your event by emailing us at [email protected].
Rescheduled events must occur within 1 year of the original event. |
|||||||||||||||
Description
Learn advanced Excel lookup and reference functions, macros for automated reporting, and analysis tools for large datasets.
What You'll Learn at a Glance:
- Cell management: locking cells, auditing formulas, and essential keyboard shortcuts
- Date and time calculations for deadlines, scheduling, and elapsed-time analysis
- Complex nested IF statements for multi-condition decision logic
- Advanced analytical tools: data consolidation, pivot charts, and conditional data exclusion
- Advanced database functions: MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH for powerful cross-table lookups
- Recording and running absolute and relative macros for repeatable, automated reporting
- A comprehensive capstone project integrating the course's key skills
Custom solutions for every team:
Purchase Vouchers or Group Classes
Group vouchers allow employees to attend any course at their convenience on weeknights, weekdays, or weekends. Larger blocks include a custom registration tracking portal for easy enrollment management.
With various courses available, there is no need to schedule one time for everyone. Employees use their vouchers for whichever class fits their level, schedule, and preferred format.
Learn Relevant Skills from Industry Experts
Participants leave training as capable, proficient Excel users ready to apply advanced skills the very next day and keep all course materials as a permanent reference.
Our project-based curriculum mirrors real data challenges and serves every learning style.
We design onsite, partner-venue, and remote virtual programs, all customizable to your organization's needs.