Have a question for the event organizer?
Send your message below!
NYC: Advanced Excel Corporate Training
Unlock the full power of Excel by mastering advanced functions, macros, and data analysis tools to streamline workflows and uncover deeper insights. This group workshop is perfect for professionals ready to tackle complex data and boost productivity across any industry.
| Provider | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Location | or Online, New York | |||||||||||||||
| 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
Build on core spreadsheet skills to organize and present complex data, work more efficiently and identify patterns.
Manage complex spreadsheets, analyze data and program macros. Learn MATCH, VLOOKUP-MATCH and INDEX-Double MATCH for work involving large datasets.
Why Develop Advanced Excel Skills?
Advanced Excel skills support data analysis and other roles that involve organizing and interpreting business information.
Excel is a foundation for data analysis and finance careers; a career change may require additional training.
Core Topics and Skills Summary
- Complete cell administration covering cell restrictions, diagnostic tools, and keyboard shortcuts
- Specialized date calculations and formatting techniques
- Apply sophisticated calculations, such as conditional IF statements with multiple criteria
- Utilize sophisticated analytical methods for combining data, conditional filters to remove specific data, and pivot-based charts
- Master sophisticated data retrieval functions, such as MATCH, VLOOKUP-MATCH combinations, and INDEX-Double MATCH structures
- Develop and save macros and adaptable reference macros for custom reporting
- Design a capstone assignment that demonstrates expertise in key course material
Organizational training
Group vouchers let employees choose weeknight, weekday or weekend classes live online or at our Manhattan location. Larger purchases include a voucher tracking portal. Employees select sessions by skill level, schedule and location.
Experienced practitioners teach hands-on workplace tasks, with course resources yours to keep. Private curricula can be customized for your office, our Midtown Manhattan center or live online delivery.