Have a question for the event organizer?
Send your message below!
Virtual: Intermediate Excel Corporate Training
Help yout team master advanced Excel functions, Pivot Tables, and data analysis techniques to boost your productivity. This intermediate course teaches you how to work efficiently with large datasets and create professional reports using industry-standard tools.
| Provider | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Location |
Zoom Conference Platform detailsZoom is recommended. For Microsoft Teams, Google Meet or WebEx, provide the meeting link to CourseHorse in advance of the event.
|
|||||||||||||||
| 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 tools including lookup functions, PivotTables, logical statements and statistical functions to summarize and analyze complex datasets.
This course includes access to our comprehensive Excel video library, so you can revisit any topic and review materials at any point after the class.
Prerequisite:
Attendees should have foundational Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, formatting, printing, simple charts, and table management.
Topics Covered at a Glance:
- Splitting and joining text, adding data validation, and naming ranges
- Database lookup functions, including VLOOKUP and HLOOKUP
- Logical statements: AND, OR, and nested IF conditions
- Building PivotTables to quickly summarize and analyze large datasets
- Statistical functions, including RANK, COUNTIFS, and SUMIFS
- Creating advanced combination charts from multiple data series
- Consolidating key concepts through a comprehensive final project
Flexible Training Solutions for Your Team
Group Vouchers and Scheduled Classes
Group vouchers are available so employees can attend sessions at their convenience, with options on weekdays, weeknights, and weekends. Courses run live online and in person at our Midtown Manhattan offices. Larger voucher packages include a custom registration tracking portal for managing enrollment.
With various courses on the calendar, employees can choose sessions that align with their current skill level, schedule, and preferred format.
Practical Skills from Working Industry Professionals
Participants leave training equipped to apply what they have learned right away, with all course files to keep for ongoing reference.
Our hands-on curriculum reflects the real data challenges professionals face at work. Training is available on-site at your office, at our Midtown Manhattan location, or through live virtual instruction, and every program can be customized to your team's needs.