Class Schedule

NYC Live Online

Take your Excel skills up a level with this Intermediate Excel course. Learn important Excel functions like VLOOKUP, SUMIFs, and Pivot Tables in this hands-on training. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation.

Learn more advanced editing techniques with Premiere Pro in this hands-on class and kick your video editing skills up a notch. Create custom transitions, light leaks, and other visual effects. Work more with audio, edit action sequences, and work with vertical video.

This course is geared for people with HTML & CSS coding experience. WordPress enables you to create and maintain a website or blog, even with no web design background, but web developers who know code have even greater control. This is our most extensive WordPress training and will teach you how to use WordPress from scratch. You’ll learn both sides of using WordPress (with and without coding).

Learn to extract info from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You’ll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL

Go from novice to expert in our three-day comprehensive Excel Bootcamp. You’ll learn advanced database functions, calculations, and formulas, shortcuts, Pivot Tables and scripts, and macros for automating tasks with ease. 

The Excel Specialist Certification program includes our three Excel courses (Fundamentals, Intermediate, and Advanced), two hours of private training, and the Excel Specialist Exam fee with a free retake.

This certification program will prepare you for the Excel Expert certification exam. This program includes three group classes, four hours of private training, and the Excel Expert Exam with a free retake.

Get comfortable with After Effects by creating standalone videos, animations, special effects, animated titles, and more. Make professional videos for web and TV broadcast in no time at all.

This After Effects course will have you up and running quickly, as you learn to create animated GIFs, logos, transitions, and more. You'll get hands-on experience in a small class led by a leading motion graphics instructor.

Get going with the basics of Excel and start working on projects in Excel. Get practice with calculations and formulas, charts and tables, worksheet and workbook formatting, and basic hotkeys to accelerate your workflow.