Microsoft Office Intermediate Bootcamp
Hands-on Training from Experts
NYC or Live Online
Intermediate to Advanced Microsoft Office Training
This course includes
- 30 hours of live, project-based training from experts
- 5 modules
- Retake for free within 1 year
- Access to class recordings (30 days)
- Verified digital certificate of completion
- Small class sizes
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.
- Intermediate Excel for Business - Summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow.
- Advanced Excel for Business - Make functions more flexible, take Pivot Tables to the next level, and automate tasks with macros.
- Advanced PowerPoint for Business - 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.
- Microsoft Word Level II - 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.
- Microsoft Outlook Level II - Configure mail accounts, perform advanced searches, control spam with filters, automate tasks with rules, and learn advanced calendar and contact management skills.
To register for this discounted package of courses, choose a preset schedule or customize your own schedule at checkout.
This course has a prerequisite
Knowledge of Microsoft Office equivalent to our Microsoft Office Fundamentals Bootcamp is required.
Courses in this Package
This is the recommended order, but some courses may be taken in a different order.
Unit 1 6 Hours
Intermediate Excel for Business
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 2 6 Hours
Advanced Excel for Business
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 3 6 Hours
Advanced PowerPoint for Business
Advanced PowerPoint for Business
- Design Custom PowerPoint Themes
- Work with Theme Colors, Fonts, Backgrounds, & Slide Layouts
- Add Animations for Stand Out Presentations
- Incorporate Video
- Customize the Look of Charts & Animate Charts
- Bring in Tables from Excel
- Manage Large Presentations with Sections, Hidden Slides, and Custom Shows
- Collaborate with Others using Comments
Unit 4 6 Hours
Microsoft Word Level II
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.
Unit 5 6 Hours
Microsoft Outlook Level II
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.
Program Reviews
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
-
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
Learn the Skills Guarantee™
Learn the concepts and skills covered in this true or your tuition is on us. See details and terms & conditions.
Hands-on training in small groups
Work on projects proven to boost retention
Time-tested curriculum and supporting materials
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.
Learn from industry experts with teaching experience
Experienced educators who are driven to help you succeed
Retake the course for free within one year
Refresh the materials and gain additional practice
Interactive Training
Learn in Real-Time with Small Class Sizes
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.
On Campus in NYC 185 Madison Ave, NYC
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.
- Live, interactive class
- Experienced instructor in the room with you
- Computer and software provided
Live Online Remote, from anywhere
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.
- Live, interactive class
- Experienced instructor teaching over Zoom
- Remote setup assistance provided
Earn a Certificate of Completion
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
Free Retake & Class Recordings
Missed a session or need a refresher? We have you covered!
Free Retake
We offer a single free retake of any module or the whole program within a year.
Class Recordings
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.
Frequently Asked Questions
Is this course open to beginners?
Knowledge of Microsoft Office equivalent to our Microsoft Office Fundamentals Bootcamp is required.
Do you offer payment plans or student financing for this course?
This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
Can I take this course online (remote learning)?
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).
How does attending “live online” work?
- Students can attend this training remotely through screen sharing software (we use Zoom).
- Participants can hear the instruction, ask questions, and even share their screen with the instructor.
- For audio you can use your computer’s microphone/speakers or call a phone number that we’ll provide.
- Classes are activity-based and taught by a live instructor, so we strongly encourage students who are local to the area to attend in person!
- You will need your own computer and copy of any required software. If you don’t have the software, you can usually do a free trial or purchase your own license. If you need assistance, contact us at nyc@careercenters.com
What happens if I need to miss a session?
You have some options:
- You can watch a recording of the session. We will provide any course materials.
- If you can’t come into the classroom but can still attend remotely, we will provide you with the Zoom login information.
- You can use your free retake to make up any missed class time.
What’s included with my tuition?
- A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement
- Expert instructors who are industry professionals and experienced educators that are driven to help you succeed
- A comprehensive program with 5 in-depth course modules designed to build your skills progressively
- Top-notch curricula that have been tried and tested over many cohorts and are consistently improved for an optimal learning experience
- A 1-year free retake policy which allows students to retake any part of the course or program for free to refresh the materials and gain additional practice
- 30-day access to class recordings to review material at your own pace
- A certificate of completion to verify your accomplishment
Are there any additional fees or expenses?
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.
Do you offer any discounts for this course?
This program is a discounted package of classes that is 15–25% off the individual class prices, so additional discounts do not apply.
