Have a question for the event organizer?
Send your message below!
Chicago: Advanced Excel Corporate Training
Elevate your Excel proficiency with advanced functions, macros, and data visualization tools to streamline workflows and uncover deeper insights. Ideal for anyone handling large, complex datasets across any industry.
| Provider | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
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 automating repetitive tasks, and data-analysis tools for large datasets.
What You'll Learn at a Glance:
- Cell management techniques: cell locking, formula auditing, and essential hotkeys for efficiency
- Date and time functions for calculating intervals, deadlines, and scheduling logic
- Advanced logical functions, including complex nested IF statements
- Advanced analytical tools: data consolidation, conditional formatting, and pivot charts
- Powerful lookup and reference functions, including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
- Recording absolute and relative reference macros to automate recurring reporting tasks
- A comprehensive capstone project that applies all key concepts from the course
Custom solutions for every team:
Purchase Vouchers or Group Classes
Group vouchers give 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 purchases include a custom registration tracking portal for simple enrollment management.
With a comprehensive course catalog, there is no need to find one time that works 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 confident, capable, advanced Excel users ready to apply their skills the very next day and keep all course files as a permanent reference guide.
Our hands-on curriculum mirrors the real data challenges employees face on the job, adapting to every learning style.
We design onsite, Midtown Manhattan, and remote virtual programs, all fully customizable to your team's needs.
What Advanced Excel Can Do for You:
The features covered in this course go far beyond what most Excel users ever explore on their own. You will learn to build dynamic lookups with INDEX-MATCH and XLOOKUP, analyze multidimensional data with pivot tables and slicers, automate repetitive processes with macros, and create polished dashboards that update automatically as underlying data changes. These capabilities translate directly into time saved and insights gained in virtually any professional role that involves data, whether in finance, operations, marketing, human resources, or any other field.