Onsite Microsoft Office Training

Build Excel skills for business with hands-on lessons designed to boost your productivity. You’ll learn to create charts and tables, master fundamental formulas and functions like AutoSum and conditional formatting, and format data for clear visual presentations.

Advance your Excel skills with practical lessons focused on streamlining your workflow and enhancing data analysis. You'll master Pivot Tables for data summarization, apply advanced functions, utilize logical statements, and manage data with named ranges.

Level up your Excel skills by mastering sophisticated techniques like advanced Pivot Tables, task automation through macros, and analytical tools. You'll also learn to write nested IF statements, apply arrays, and use conditional formatting with custom formulas.

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.

Enhance your PowerPoint proficiency by mastering presentation skills, from creating and formatting slides to incorporating visuals and graphics. You'll also practice adding photos, charts, SmartArt, and animations, and learn strategies for professional presentations.

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.

Boost your productivity in Microsoft Word with this one-day workshop covering features used across NYC businesses. You'll learn to format text and paragraphs, prepare mass mailings, and create visually appealing documents using images, charts, and page layouts.

Take your Microsoft Word expertise to the next level by mastering advanced features that streamline your workflow. You’ll discover how to automate tasks with mail merges, manage citations and indexes, insert cross-references, and utilize building blocks.

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.