Microsoft Office Intermediate Bootcamp
Intermediate to Advanced Microsoft Office Training
Jul 19–Sep 16
Choose another date
NYC or Live Online
We are open! Classes are running in-person (socially distanced) and live online. Secure your seat today
Learn the intermediate and advanced functions of the essential Microsoft Office programs in this 5-day bootcamp. This package includes our intermediate and advanced Excel, advanced PowerPoint, Word, and Outlook classes at a 15% discount.
To register for this discounted package of courses, choose a preset schedule or customize your own schedule at checkout.
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
Excellent classes and excellent venue! It has just the right level of personal attention and class participation. I would highly recommend NYIM and look forward to taking future classes there. – Hazel S.
Experienced educators who are driven to help you succeed
Refresh the materials and gain additional practice
As one of our smaller courses, tuition for this course is due in full before the start date.
There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.
However, if you plan to take the course live online, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.
This program is a discounted package of classes that is 15–25% off the individual class prices.
Unit 1 7 Hours
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 2 7 Hours
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 3 7 Hours
Unit 4 7 Hours
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.
Unit 5 7 Hours
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.
This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).
You have some options:
Select up to two courses and tap Compare selected courses to view a side-by-side comparison of Microsoft Office Intermediate Bootcamp with your selected courses.
Become an advanced Microsoft Excel user in just three days. This Excel Bootcamp includes 21 hours of hands-on training in formulas, functions, Pivot Tables, macros & more.
Learn to design, build and present PowerPoint presentations. Create and run dynamic presentations, prepare slideshows for presentation, create reusable templates, and more. This PowerPoint Bootcamp includes our beginner and advanced classes at a 10% discount.
Learn the fundamentals of the essential Microsoft Office programs in this 4-day bootcamp. This package includes our beginner Excel, PowerPoint, Word, and Outlook classes at a 15% discount.
Learn the complete Microsoft Office suite in this 9-day bootcamp. This package includes three levels of Excel, two levels of PowerPoint, two levels of Word, and two levels of Outlook classes at a 15% discount.
Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.