Have a question for the event organizer?
Send your message below!
Virtual: Advanced Excel Corporate Training
Boost your team's Excel proficiency with advanced training in complex formulas, analytics, and macros. Learn sophisticated data management techniques that streamline workflows and unlock insights from complex datasets.
| 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
Build on spreadsheet fundamentals with advanced Microsoft Excel techniques for manipulating, analyzing and visualizing complex data. Learn to improve your workflow and find useful insights in large datasets.
In this advanced class, you will discover how to manage spreadsheets effectively, utilize advanced analytics tools, and write macros to improve efficiency dramatically. You will also become familiar with complex Excel functions, including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH formulas. The powerful tools you'll learn in this class will apply to virtually any job setting where you must organize and analyze large amounts of complex data.
Why Learn Excel?
Excel is one of the most commonly used business applications on the entire planet, so no matter what field you work in, learning Excel has the tremendous potential to help optimize your workflow and improve your productivity significantly. Whether working as a professional Data Analyst or working at a company with a lot of information to catalog and organize, learning Excel can pay substantial long-term dividends and career advancement.
Very few jobs strictly use Excel exclusively, so anyone looking to start a new career will need supplemental training. However, learning Excel is foundational for anyone genuinely hoping to work in a data analytics or financial career pathway.
What You'll Learn at a Glance:
- Cell management, including cell locking, auditing, and keyboard hotkeys
- Special formatting for calculating dates and time periods
- Use advanced functions such as nested IF statements and conditional logic
- Learn advanced analytical tools for data consolidation, conditions to exclude data, and pivot charts
- Use advanced database functions, including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
- Record macros and relative reference macros for ad hoc reporting and automation
- Create a comprehensive project that applies key concepts from the class
Custom Solutions for Every Team:
Purchase Vouchers or Group Classes
You can purchase group vouchers so your employees can attend any of our courses at their convenience on weeknights, weekdays, or weekends. Our classes are live online or in person at our Manhattan offices. When you invest in a large block of vouchers, you'll also receive a custom registration tracking portal to manage them.
With various courses on our calendar, you don't have to worry about coordinating with each employee to find a class that works for them. Your employees can use their vouchers to enroll in classes that fit their proficiency, schedule, and location needs.
Learn Relevant Skills from Industry Experts
Your employees will leave our training as proficient users who can implement what they've learned the next day. Your employees will also have our course files to keep forever so they can continue using their training as a guide for their day-to-day tasks and ongoing projects.
Our hands-on curriculum and focused instruction cater to every learning style imaginable. We simulate the real challenges your employees will actually face on the job.
We have extensive experience developing curricula for various training sessions, either onsite at your office, in our Midtown Manhattan offices, or through remote virtual training. Our programs can be completely customized to suit your specific training needs.