Office Productivity Classes in NYC, New York

Master the number one accounting system for small and medium size businesses. Create a truly portable QuickBooks company accessible over the internet anywhere. In this class we’ll compare the features of the available QuickBooks versions and their costs. You’ll learn the basic QuickBooks architecture and navigation system and practice using QuickBooks...

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great...

This course builds on the fundamentals in the Excel 2016 Basic course. In this class, you will create financial outlines and subtotals, create and manage cell range names, as well as create and modify column and pie charts. Sorting, filtering and calculations using calendar date functions will be covered as well as Pivot tables and charts. You'll also...

Learn how to build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

In this class you’ll learn how to create and send messages, sort emails, work with e-mail messages, schedule appointments, insert events, add and edit contacts, create and edit tasks, work with calendar features, and much more!

In this class you will work with formulas that span across multiple worksheets and use the VLOOKUP and INDEX functions. You'll create and modify macros, protect workbooks, and use Excel's data validation features. Prerequisite: You must have expertise in using range names and/or have successfully completed the Excel 2016 Basic and Intermediate...

This course is designed to provide students with a basic to mature ability to collect, enter, and perform calculations with data in MS-EXCEL spreadsheets, and to utilize basic statistical techniques to analyze and present the data in words, graphs and charts. These skills will be useful in securing entry level IT positions in industry. Key topics...

This class will be held remotely through live videoconferencing. Excel 2016, the most popular spreadsheet program, has powerful features that allow you to analyze and manipulate financial and mathematical data. It’s great for budgets, simple bookkeeping, an easy database, or making charts and graphs.  In this hands-on beginning class, you’ll...

MS Word for Windows allows you to create and format personal and professional documents and tables of all kinds. Level 1 teaches basic skills to create, edit, and format texts. Students must have MS Office Word software installed on their computer. Previous knowledge or experience: Understanding of the basics of Windows. Note: Class...

Excel is our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment,...

We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.  This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants...

Adobe Illustrator CC is a vector-based image creation software used in illustration, technical drawing, animation, special effects, logo and T-shirt design and motion graphics. Topics include Bezier curves, color and gradients, dynamic type and gradient mesh tool, live trace, live paint, creating custom workspaces, control palette and integration...

This class will be held remotely through live videoconferencing. This hands-on intermediate class picks up where the basic Excel 2016 class left off. Topics include calculations and built-in functions, sorting data, creating templates, renaming and moving worksheets, inserting and deleting cells, rows and columns, and adding graphs and charts. ...