Onsite Microsoft Office Training

Learn all the basics to use Excel as your primary data processing tool. Create charts and tables, get started with formulas and functions, and format and print your output. 

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow.

Become an Excel guru in this hands-on advanced training. You'll make functions more flexible, take Pivot Tables to the next level, automate tasks with macros, and learn advanced analytical tools.

Learn the fundamentals of VBA, Excel's programming language, in project-based training. This VBA course concentrates on the automation of repetitious Excel tasks and reports.

Get comfortable with PowerPoint essentials, from formatting text and visuals to delivering a presentation. By the end of this course, you’ll know how to create and edit PowerPoint files, add and adjust different types of content (photos, icons, tables, charts, shapes and more) and how to present to an audience that’s in-person or online.

In this advanced PowerPoint class, you’ll create a reusable PowerPoint Template, make an easily updatable, engaging, consistent presentation, import charts from Excel, use multimedia and layered objects, and record a slideshow.

Master Microsoft Word's essential shortcuts and techniques in one day. Prepare and send mass emails, letters, and labels with one click. Learn everyday functions used in firms throughout New York City. Eliminate formatting blunders with bullets and page numbers.

Advance your career with training in Microsoft Word's most advanced functions and features. Automate useful tools like mail merge. Record tasks and write macros to save time. Create custom document styles and templates to improve productivity within your entire team. By the end of this course, you'll master advanced techniques that expedite your workflow.

In this beginner Outlook class, you will reduce hours of repetitive work by setting up rules and search folders to automate email, manage your calendar and to-do lists, manage emails and scheduling with ease, and organize your contacts.

In this course, you will configure mail accounts, perform advanced searches, control spam with filters, automate tasks with rules, and learn advanced calendar and contact management skills. This course builds upon the foundational knowledge presented in the Outlook Essentials course and will help you customize a communication system well-suited to your work styles.

The course begins by reviewing the core features and functions of the Access database, so if you’ve never used Access, it’s the perfect place to start! By the end of the course, you’ll know how to work with tables, query data, create forms, and generate reports.

Learn how to write advanced queries and organize your database for maximum efficiency. You’ll be able to join tables, implement data validation techniques, and use advanced reporting functions.

Focuses on the more advanced concepts, including: restructuring data into appropriate tables to ensure data dependency and minimizing redundancy, writing advanced queries to analyze and summarize data, creating and revising Microsoft Access 2016 macros, customizing reports by using various Microsoft Access 2016 features, and maintaining their databases using Microsoft Access 2016 tools.

Learn to manage projects more efficiently, track costs, and allocate resources in Microsoft Project, and review essential project management concepts in this class for PC users.

This advanced Microsoft Project class for PC users is designed to familiarize you with the advanced features and functions of Microsoft Project Professional to track costs, allocate resources, and manage projects.