Take your Excel skills to the next level in this intermediate course covering high-value functions and tools used by business professionals every day. You will learn powerful lookup functions, build PivotTables to summarize complex data, work with logical statements, and use statistical functions to extract meaningful insights from large 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 a wide variety of 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.
