Description

In this intermediate Excel class, you'll learn functions such as VLOOKUP and SUMIFs; summarize data with Pivot Tables; Sort & Filter databases; and split and join text.

The course comes with our revolutionary Excel video suite, so that you can review the materials anytime after the class.

Prerequisite:
Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.

What You'll Learn at a Glance

• Learn to split and join text, add data validation, and name ranges.
• Use database functions such as VLOOKUP & HLOOKUP.
• Add logical statements, including AND, OR, and IF statements.
• Create Pivot Tables to quickly summarize large databases.
• Use statistical functions such as Ranking, COUNTIFS, and SUMIFS.
• Create advanced combo charts from multiple charts.
• Review key concepts by creating a final project.

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.