Have a question for the event organizer?
Send your message below!
LA: Intermediate Excel Corporate Training
Advance your spreadsheet skills with PivotTables, VLOOKUP, SUMIFs, and more in this practical intermediate Excel course. Includes lifetime access to our Excel video suite for continued learning and daily reference.
| 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 intermediate Excel lookup functions, Pivot Tables and statistical formulas with multiple conditions. After class, access the Excel video suite on any device.
Prerequisite:
Beginner skills equivalent to Excel Fundamentals, including basic functions, formatting, printing, charts and tables.
What You'll Learn at a Glance:
- Text functions for splitting and combining data, data validation tools, and named ranges for cleaner spreadsheets.
- Lookup functions, including VLOOKUP and HLOOKUP, for retrieving data across related tables.
- Logical functions, including AND, OR, and nested IF statements for conditional calculations.
- Pivot Tables: how to design, build, and update them to summarize large databases quickly.
- Statistical functions including RANK, COUNTIFS, and SUMIFS for flexible, multi-condition aggregations.
- Combination charts that overlay multiple chart types in a single, informative visualization.
- A final capstone project that demonstrates mastery of all key intermediate skills.
Custom solutions for every team:
Purchase Vouchers or Group Classes
Group vouchers allow employees to attend any course on weeknights, weekdays, or weekends at their own pace. Larger blocks include a custom registration tracking portal for straightforward management.
With a broad course catalog, there is no need to find one time that fits everyone. Employees use their vouchers for the class that best matches their proficiency, schedule, and preferred format.
Learn Relevant Skills from Industry Experts
Your team will leave training as confident, capable intermediate Excel users ready to apply their skills the next day and retain all course materials as a permanent reference guide.
Our hands-on curriculum mirrors real spreadsheet challenges and adapts to every learning style.
We design onsite, partner-venue, and remote virtual programs, all customizable to your organization's specific training needs.