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 discount.
Use Excel to summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. You'll also learn how to make functions more flexible and automate tasks with macros.
Find out how to 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.
With Microsoft Word, find out how to 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.
Build Outlook skills like the ability to configure mail accounts, perform advanced searches, control spam with filters, automate tasks with rules, and advanced calendar and contact management skills.
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
Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.
Unit 2 6 Hours
Learn all of the most complex features of Microsoft Excel in this advanced training course—Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.
Unit 3 6 Hours
Unit 4 6 Hours
This advanced PowerPoint course is designed for users ready to take their presentation skills to the next level. Learn how to build professional themes, streamline design with Slide Master, and enhance visual storytelling through animation, video, and advanced chart customization.
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.
Amazing teachers, digestible and concise instruction for a breadth of knowledge you can use in any field, and it is optimal for any computer user (e.g, they accommodate written and in-person instructions for both pc and Mac users).
Very engaging.
It was helpful, and I feel more comfortable in PowerPoint, which was the goal. The materials will be very helpful to reference.
Very organized and very helpful.
Great course to take to organize your Outlook account!
The instructor has been patient and courteous to class questions or concerns.
Learned a lot of new content. I've heard of these functions and terms, but didn't know how to use them.
Excellent - can't wait to use these skills at work!
The teacher is very patient and speaks clearly, and knows the material well.
I learned so much in this class and wish I had taken this class sooner. Highly recommend.
Class is very informative, and it is very beneficial to be able to go back and review your information and the instructor's information.
Everyone in the working world needs to take this class. Everyone who wants to be in the working world should take this class. Everyone should take this class.
Answered all questions and had useful examples that easily relate to day-to-day work.
Very detail-oriented, and the instructor doesn't mind repeating something.
Great balance between learning some simpler things and some more complex features.
Great learning opportunity. Hope I can retain most of it and apply what I have learned. Being able to repeat the class again within the year is a great perk!
Excellent intructor.
Great!
The instructor spoke articulately and fluently. The course was seamless.
Instructor was very detailed and stopped to review complex instructions. Great teacher!
The instructor was great and really explained things well! He answered all the questions thrown at him.
Wonderful online learning experience!
Ade was amazing!
The instructor is very good and clearly explains the class.
Mike was a great instructor! It was easy to follow the class, and he was able to answer all the questions I had.
Showing 25 of 293 reviews
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
The teaching method at Noble Desktop is perfect and the classes provide you with infinite knowledge that makes you eager to take everything they offer. I love Noble!
—Ivonne Ackerman
Experienced educators who are driven to help you succeed
Refresh the materials for free within one year
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 Noble Desktop, 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 185 Madison Ave, 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.
Our instructors are industry experts and experienced educators, driven to help you succeed.
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.
Sorry, but this training is not available online.
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.
This program is a discounted package of classes that is 15–25% off the individual class prices, so additional discounts do not apply.
