Advanced Excel for Business covers the advanced applications of Excel used frequently by business professionals. This course is perfect for those with strong working knowledge and practice in Excel looking to apply more complex Excel features. In this advanced Excel course, you will learn Goal Seek, Data Tables, advanced functions, and basic macros. You will build upon intermediate-level concepts, making your lookup functions more flexible, taking Pivot Tables to the next level, and facilitating workflow with cell management techniques and Hot Keys.

The Illustrator Essentials class concentrates on the most common topics that you will need to quickly create vector graphics. When you are finished with this class you will be able to create vector art for design and websites, create Perspective Drawings, and control your brushes to create a more natural brush stroke. This class is perfect to Graphic Designers, Amateur and Professional Graphic Artists, and Advertising Designers.

The InDesign Essentials class concentrates on the most common topics that we see in NYC businesses using on a daily basis. By the end of this training course, you will feel confident in laying out a multiple page document, inserting photos, creating text styles, master documents and pages, flow in copy from Microsoft Word, sending a document off to print. This class is perfect to those seeking to feel comfortable with most InDesign tasks and duties, those looking to interview for positions that require solid InDesign skills, and those going into the Print, Advertising, Graphic Design or Business Industry.

Excel for Business Fundamentals covers the essential applications of Excel used frequently by business professionals. In this introductory Excel course, you will learn basic and multi-input functions, absolute references, charts and tables. We will help you produce polished and presentable work with formatting and printing techniques, while learning crucial tricks to facilitate the workflow.
In this hands-on class you will work on real-world examples, reinforcing the concepts with practice throughout the class, as well as a cumulative project at the end. Each attendee will receive access to our revolutionary Excel Fundamentals video suite, with lifetime access to several hours of premium content.

This SQL Bootcamp package includes our Beginner, Intermediate, and Advanced SQL classes. In this bootcamp, you will use SQL as a tool to implement logic, define instructions and compose queries. You will create advanced queries and manipulate and index tables, and learn techniques for writing decision-making code using advanced functions.

In this beginner PowerPoint course, you'll create and run dynamic presentations; add images, shapes, animations and layered objects; create tables and charts; and prepare the slideshow for presentation.
This class includes our revolutionary PowerPoint video suite with several hours of premium content. Review the course materials with high-quality video with lifetime access on desktop, tablet or mobile, a $95 value.

The Photoshop Essentials class concentrates on the aspects of Photoshop most commonly used by NYC businesses on a daily basis. By the end of this training course, you will feel confident in creating graphics for the web, retouching damaged photography, and using Text, Layers and Drawing Tools to create images. This class is perfect to those looking to build websites, and for photographers both amateur and professional.

Excel Specialist Certification Package: Excel Courses & Specialist Exam:
Boost your credentials today and get certified in Microsoft Excel. NYIM offers the perfect Excel Specialist Certification bundle which includes three Excel courses (fundamentals, intermediate, and advanced), two hours of private training, and the Specialist Exam with a free retake. You'll also receive access to our premium video suite, the perfect source to prepare for the exam.
- Excel for Business Fundamentals group class with a Free Retake & revolutionary Beginner Excel video suite
- Intermediate Excel for Business group with a Free Retake & revolutionary Intermediate Excel video suite
- Advanced Excel for Business group class with a Free Retake & revolutionary Advanced Excel video suite
- Two hours of private training
- Proctored Specialist Certification exam with a free retake

Intermediate Excel for Business covers the essential applications of Excel used frequently by business professionals. This course is perfect for those with familiarity with basic formulas and functions, charts, and workbook management techniques. In this intermediate-level course, you will learn Pivot Tables, database functions including VLOOKUP and SUMIFS, and logical and statistical functions. We will show you crucial database management tools including Named Ranges, Sort & Filter, and Data Validation.
Throughout the class we'll show you tricks and techniques to work more efficiently, including navigational and keyboard shortcuts. In this hands-on course you will work on real-world examples, reinforcing the concepts with practice throughout the class, as well as a cumulative project at the end. Each attendee will receive access to our revolutionary Excel Fundamentals video suite, with lifetime access to several hours of premium content.

Learn essential finance & accounting concepts while building a comprehensive valuation model in Excel. This financial modeling class blends finance, accounting and Excel concepts into an intensive 2-day course. Build a valuation model on a real public company, while learning how to analyze its business, financial statements, and future growth prospects.

Go from beginner to pro in our 3-day Excel bootcamp. This bootcamp package includes three one-day Excel classes - Fundamentals, Intermediate, and Advanced - at a 15% discount. You'll also receive access to our premium video suite, and each class comes with a Free Retake within six months of the class.

Create a dynamic website or blog in NYIM's leading WordPress courses in New York City. WordPress is a free and open-source content management system, and NYIM's WordPress training classes will show you how to utilize this popular system.

The Excel Programming with VBA course concentrates on practical automation of repetitious Excel tasks and reports. In this VBA & Macros training course, you will write macros to automate your Excel tasks even if the data is not consistently formatted, create custom Excel applications and environments, and create custom Excel Add-ins to increase the functionality of the program. This VBA course is perfect for those consistently working with Excel who need to automate repetitive tasks.

NYIM Training