Microsoft Office Intermediate Bootcamp
Intermediate to Advanced Microsoft Office Training
Intermediate to Advanced Microsoft Office Training
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.
Knowledge of Microsoft Office equivalent to our Microsoft Office Fundamentals Bootcamp is required.
This is the recommended order, but some courses may be taken in a different order.
Unit 1 6 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 6 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 6 Hours
Unit 4 6 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 6 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.
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
Microsoft Office Intermediate Bootcamp is rated 4.0 stars
In this course, I learned a lot about Excel that I didn't know previously. I would certainly recommend it to those looking to learn more about the software.
Intermediate Excel was great! Our instructor, Mike, was very patient and happy to answer any questions that came up along the way. VLOOKUPS aren't nearly as intimidating now that I've taken the class.
When my job offered these courses I hopped right on board. I am familiar with PowerPoint but I wanted to be sure I refreshed my memory and gain new skills as we know technology changes every second, and I am glad I took the opportunity to enroll as I am now able to do so much more with my presentations.
I would definitely recommend these classes to improve your excel skills. I use excel everyday and having this knowledge will cut time on work significantly.
We could ask as many questions as necessary, and Garfield answered them all.
The Intermediate-Advanced Word class with Mike was terrific! A lot of hands on exercises and very helpful tips.
Excellent classes for all levels of users. Very applicable
I definitely recommend this course for professional development in any field where MS Excel is used.
Life-changing, super helpful! I loved the energy the instructor, Mike, had. It was very interactive and informative. Learned a lot :)
This was a great class, even if you know excel there are formulas/functions that can give you faster results then what you are doing now.
Very good class. Trainer was very good, very patient.
Love this class. Can use what I've learned at work.
After participating in the Intermediate Excel for Business training, I now feel much more confident about using Excel in my job. I've been intimidated by Excel for quite some time but now I see it as a tool to experiment with and learn from!
Never in a million years would've thought that an Excel training workshop would actually be enjoyable!
A fantastic class. Whether you are new to the advanced functions of PowerPoint, or if you are simply trying to brush up on your skills, this class will provide you with the information you need to take that next step. Plus Ade is a great instructor.
An engaging, informative perfect way to learn or refresh your skills!
Thorough, patient, and enthusiastic instructor; super helpful Excel tips for business.
Excel class worth taking.
If you need to use Excel at work, this class will make your life easier and efficient.
Very well paced, easy to follow Excel class!
Adebayo was really helpful. I learned a lot that I did not know prior to taking the class.
Great for business people looking to use advanced Excel features to improve productivity at work.
No prior homework necessary, this class will break down Excel need-to-knows for you and continue building on your new knowledge throughout the course.
I highly recommend this class and the instructor. It will definitely add to your knowledge base, even if you are an experienced user.
The instructor was fantastic! He explained the concepts clearly and patiently, and encouraged questions. I will be able to apply much of what I learned in this class directly to my work.
Showing 25 of 85 reviews
As one of our smaller courses, tuition for this course is due in full before the start date.
Learn the concepts and skills covered in this true or your tuition is on us. See details and terms & conditions.
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
Attend this course in-person in NYC or Live Online via Zoom. Engage with expert instructors, ask questions, and get feedback on your exercises and projects.
Unlike other providers, these are not mass open-enrollment classes. At NYIM Training, you’ll learn in small groups (typically 8-15 students) and receive personalized attention.
Get face-to-face interaction with an instructor and other students when you learn at our NYC campus. Courses are hands-on with a computer and software provided.
Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
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!
Shareable on
We offer a single free retake of any module or the whole program within a year.
You can also access recordings of each session in your student portal within one business day of the session’s end. Recordings are available for one month after the session.
Knowledge of Microsoft Office equivalent to our Microsoft Office Fundamentals Bootcamp is required.
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:
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, so additional discounts do not apply.
These related courses share skills and topics with Microsoft Office Intermediate Bootcamp. Select up to two and tap Compare selected courses to view a side-by-side comparison.
Become an advanced Microsoft Excel user in just three days. This Excel Bootcamp includes 18 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.
We’ve trained thousands of companies!
Let us create the perfect program for your team.
This policy was updated on January 2, 2025
Your privacy is important to us. It is the policy of NYIM Training to respect your privacy regarding any information we may collect from you across our website and other sites we own and operate.
We only ask for personal information when we truly need it to provide a service to you. We collect it by fair and lawful means, with your knowledge and consent. We also let you know why we’re collecting it and how it will be used.
We only retain collected information for as long as necessary to provide you with your requested service. What data we store, we’ll protect within commercially acceptable means to prevent loss and theft, as well as unauthorized access, disclosure, copying, use or modification.
We don’t share any personally identifying information publicly or with third-parties, except when required to by law.
Our website may link to external sites that are not operated by us. Please be aware that we have no control over the content and practices of these sites, and cannot accept responsibility or liability for their respective privacy policies.
You are free to refuse our request for your personal information, with the understanding that we may be unable to provide you with some of your desired services.
Your continued use of our website will be regarded as acceptance of our practices around privacy and personal information. If you have any questions about how we handle user data and personal information, feel free to contact us.
By accessing our websites you are agreeing to be bound by these terms of service, all applicable laws and regulations, and agree that you are responsible for compliance with any applicable local laws. If you do not agree with any of these terms, you are prohibited from using or accessing this site. The materials contained in this website are protected by applicable copyright and trademark law.
In no event shall NYIM Training or its suppliers be liable for any damages (including, without limitation, damages for loss of data or profit, or due to business interruption) arising out of the use or inability to use the materials on NYIM Training’s website, even if NYIM Training or a NYIM Training authorized representative has been notified orally or in writing of the possibility of such damage. Because some jurisdictions do not allow limitations on implied warranties, or limitations of liability for consequential or incidental damages, these limitations may not apply to you.
The materials appearing on NYIM Training’s website could include technical, typographical, or photographic errors. NYIM Training does not warrant that any of the materials on its website are accurate, complete or current. NYIM Training may make changes to the materials contained on its website at any time without notice. However, NYIM Training does not make any commitment to update the materials.
NYIM Training has not reviewed all of the sites linked to its website and is not responsible for the contents of any such linked site. The inclusion of any link does not imply endorsement by NYIM Training of the site. Use of any such linked website is at the user’s own risk.
NYIM Training may revise these terms of service for its website at any time without notice. By using this website you are agreeing to be bound by the then current version of these terms of service.
These terms and conditions are governed by and construed in accordance with the laws of New York and you irrevocably submit to the exclusive jurisdiction of the courts in that State or location.
Each installment is charged to your card on file one week before the start of the associated course. The payment schedule may vary if the courses are taken in a different order.
Installments | List Price | |
---|---|---|
$94.90 | 10% non-refundable deposit | -- |
$249.00 | Intermediate Excel for Business | $249 |
$249.00 | Advanced Excel for Business | $249 |
$249.00 | Advanced PowerPoint for Business | $249 |
$107.10 | Microsoft Word Level II | $249 |
▴ Your 10% deposit has been applied, as well as the certificate discount of $296 | ||
Free | Microsoft Outlook Level II | $249 |
$949.00 | Total You Pay |