Learn all of the most complex features of Microsoft Excel in this advanced training course. Once you've gotten the hang of the basics of building and organizing spreadsheets using Excel, you can learn to manipulate and visualize that data to improve your workflow and draw deeper insights.
In this class, you will find out how to manage spreadsheets, utilize advanced analytics tools, and write macros to improve efficiency. You will also become familiar with complex Excel functions, including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH. The tools you'll learn in this class will apply to virtually any job setting where you must organize large amounts of complex data.
Why Learn Excel?
Excel is one of the most commonly used business applications on the planet, so no matter what field you work in, learning Excel has the potential to help optimize your workflow and improve your productivity. Whether working as a professional Data Analyst or just working at a company with a lot of information to catalog and organize, learning Excel can pay long-term dividends.
Very few jobs strictly use Excel, so anyone looking to start a new career will need supplemental training. However, learning Excel is foundational for anyone hoping to work in a data analytics or financial career.
What You'll Learn at a Glance
- Cell management including cell locking, auditing, and hotkeys
- Special formatting for calculating dates
- Use advanced functions such as nested IF statements
- 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
- Create a 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.
Our hands-on curriculum and focused instruction cater to every learning style. We simulate the 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 training needs.
