Complete Microsoft Office Bootcamp in NYC or Live Online

Courses in this Package

This is the recommended order, but some courses may be taken in a different order.

• Unit 1
  7 Hours

  Excel for Business Fundamentals

  Master the core Microsoft Excel functions in this one-day course. Automate calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets while learning tricks to accelerate your workflow.

• Unit 2
  7 Hours

  Intermediate Excel for Business

  Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Use tools and formulas to format text. Manipulate data visuals with advanced charting skills. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of intermediate Excel, you'll unlock powerful techniques that will help you complete tasks more quickly.

• Unit 3
  7 Hours

  Advanced Excel for Business

  Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with macros. Utilize Excel's most important tools with training in core database functions. If you have a strong working knowledge in Excel and want to save even more time with custom shortcuts and advanced features, this is the perfect course for you. 

• Unit 4
  7 Hours

  PowerPoint for Business

  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.

• Unit 5
  7 Hours

  Advanced PowerPoint for Business

  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.

• Unit 6
  7 Hours

  Microsoft Outlook Level I

  This one-day class concentrates on how to use Outlook quickly and effectively for daily work tasks or to become an Official Microsoft Certified Outlook Specialist. By the end of this class, you will be able to reduce hours of repetitive work by setting up rules and search folders to automate email, manage your calendar and to-do lists, manage huge amounts of email with ease, manage complex scheduling, organize all your contacts and track your correspondence.

• Unit 7
  7 Hours

  Microsoft Outlook Level II

  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.

• Unit 8
  7 Hours

  Microsoft Word Level I

  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. By the end of this class, you'll be able to apply shortcuts that save hours on daily tasks and optimize your time in Microsoft Word. 

• Unit 9
  7 Hours

  Microsoft Word Level II

  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. If you use Microsoft Word daily, this course provides essential training in everything you need to know.