Browse team events

Chicago: Intermediate Excel Corporate Training

Advance your team's spreadsheet expertise with intermediate Excel skills including VLOOKUP, PivotTables, SUMIFS, and advanced charting. Includes lifetime access to video materials for continuous learning and skill reinforcement.

  • Live professional host
  • Instantly bookable
  • Private Event
Provider
CourseHorse Experiences (4.8-star rating across 5,558 reviews)
Location At your location, Chicago
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
  • After you book the event, we will send you a confirmation email and details for the event.
  • For events with materials, we will then collect the addresses of each of the participants and ensure every individual is sent a kit.
  • Our event fulfillment team will be able to answer any questions you have before, during, or after the event.
  • You can customize your event for a $300 customization fee. Customizations include things like combining different games, requesting specific questions or a themed game, or adding something to an event with materials included. Using a different platform that is not Zoom is not a customization.
  • Get a Demo: Not convinced? Book a 20-minute demo of this event for $25 before committing to it for your group. Your payment will apply towards your final purchase.

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.

Policies

Price Match Guarantee

If 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.

Terms and conditions apply

Rescheduling & Cancellation Policy

Reschedule or cancel your event by emailing us at [email protected].

Days before event 3 days or less 7 days or less 30 days or less More than 30 days
Reschedule Days before event: 3 days or less No reschedule allowed 7 days or less $150 fee More than 7 days Reschedule for no fee
Cancellation Days before event: 30 days or less No cancellation allowed More than 30 days 15% fee

Rescheduled events must occur within 1 year of the original event.

Description

Build intermediate Excel skills with VLOOKUP, HLOOKUP, PivotTables and conditional logic for analyzing business data. After class, access the companion video suite on desktop, mobile or tablet.

Prerequisite:
Beginner skills equivalent to Excel Fundamentals, including basic formulas and functions, printing, formatting, charts and tables.

What You'll Learn at a Glance

  • Split and join text using functions such as LEFT, RIGHT, MID, and CONCATENATE, then add data validation and define named ranges for cleaner spreadsheets.
  • Use powerful lookup functions, including VLOOKUP and HLOOKUP to retrieve data from related tables.
  • Apply logical functions, including AND, OR, and nested IF statements to build decision-making formulas.
  • Build Pivot Tables to summarize and analyze large datasets with just a few clicks.
  • Apply statistical functions, including RANK, COUNTIFS, and SUMIFS for flexible data aggregation.
  • Design advanced combination charts by overlaying multiple chart types in a single visualization.
  • Demonstrate mastery of all course concepts through a comprehensive final project.

Custom solutions for every team:
Purchase Vouchers or Group Classes
Group vouchers give your employees the flexibility to attend any course on weeknights, weekdays, or weekends. Our classes are available live online and in person at our Manhattan offices. Larger voucher purchases include a custom registration tracking portal for straightforward enrollment management.

With various courses on our calendar, there is no need to coordinate one session time for everyone. Employees use their vouchers for the class that best fits their proficiency, schedule, and preferred format.

Learn Relevant Skills from Industry Experts
Your team leaves training as proficient, confident Excel users ready to apply their skills the very next day. All course materials are kept permanently as an ongoing reference guide.

Our practical, hands-on curriculum mirrors the real data challenges employees face at work, accommodating every learning style.

We design onsite, Midtown Manhattan, and remote virtual training programs, all of which can be tailored to your organization's specific needs.

Book this Event

Price Details

Your Discount
Total

  • Instantly bookable
  • All inclusive price
  • Price Match Guarantee
  • Live & engaging host

Similar Team Building Activities