Office Productivity Classes in NYC, New York

In this intermediate Excel course, master tools such as pivot tables, formulas, macros, data analysis & more with hands-on exercises. You'll also learn some advanced formatting tools such as conditional formatting, sorting and filtering, and some major time-saving tips like freeze panes. Materials Needed to Fully Participate: Microsoft Excel...

Have you been wanting to learn Excel, but never had time for a long training course?  Do you have a project that requires Excel, but don’t know how to get started?  Are you looking to add another skill to your resume and give yourself a competitive advantage?  In this course you will learn how to get started and gain confidence with...

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create drop-down menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class,...

This hands-on introductory course details the most essential Adobe Photoshop features for beginner level users. Topics include basic image editing, transformation, retouching, enhancement, and compositing.  TOPICS Understanding File Formats & Resolution Selections Techniques Image Transformations Layer Management Layer Masking &...

This hands-on introductory course details the most essential Adobe Illustrator features for beginner level users. Students will learn how to create and manipulate vector shapes with a variety of tools. The course also covers text, color, effects, and layers. TOPICS Understanding Vector Graphics Creating & Transforming Paths Working With...

The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard...

Explore more advanced features of Microsoft Powerpoint 2010. Topics include automating your slideshows, using transitions, adding a soundtrack, and much more. You will receive an email 2 hours prior to the start of the class with the link to join the virtual class.

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!

Explore more advanced features of Microsoft Word 2010. Topics include mail merge, tables, text boxes, headers and footers, footnotes and endnotes. Prerequisite: Basic mouse and keyboarding skills Please Note: Arrival to class 10 minutes after start time results in the forfeiture of your seat. These are registration based classes and spots may fill...

Students will learn how to customize Outlook and work with address books. They will search and filter mail folders, and apply and customize categories. Students will also work with personal, public, and offline folders. Finally, students will organize folders and set rules.

PowerPoint is used to develop presentation materials. We’ll create text, charts and graphs to be used in electronic presentations or handouts. We’ll also work with slide masters and templates, create objects and use clip art. You will also learn how to apply transitions for electronic presentations.

Acquire essential skills to create presentations in Microsoft PowerPoint, including aligning images and creating shapes, tables, and charts. First, you'll dive into the PowerPoint user interface, including customizing the ribbon. Then you'll learn how to incorporate appealing visuals using images, SmartArt, layered objects, tables, and charts. Hands-On...

Develop expertise in Excel’s most advanced features and become a resident Excel expert. Maximize the power of Pivot Tables, save hours by automating tasks with macros, and develop experience with advanced database functions. By the end of this course, you'll have knowledge and skills above and beyond the requirements of most analyst roles. Practice-Based...

Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...