This five-day bootcamp is built for anyone ready to move beyond the basics and get serious about Microsoft Office, bundling intermediate and advanced Excel, advanced PowerPoint, Word, and Outlook into one discounted package. In Excel, you'll learn how to summarize data with PivotTables, write advanced functions like VLOOKUP, and pick up techniques that speed up your workflow, including how to make functions more flexible and automate repetitive tasks with macros. PowerPoint goes deep on the features that make presentations truly polished, covering how to build reusable templates, import charts from Excel, work with multimedia and layered objects, and record a slideshow for easy delivery.
Word focuses on the tools that save time and improve consistency across your whole team, including mail merge automation, recorded tasks, macros, and building custom document styles and templates. Outlook rounds out the bootcamp with a set of skills that make managing a busy inbox and calendar much more manageable, from configuring mail accounts and performing advanced searches to controlling spam with filters, automating tasks with rules, and handling advanced calendar and contact management. By the end of the five days, you'll have a genuinely advanced command of all four applications.
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
Take your Microsoft Word skills to the next level with this advanced training course. You'll learn to automate tasks, create custom styles and templates, and work efficiently with long and complex documents.
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.
A lot was covered, and it was challenging, but with practice, hopefully I'll feel comfortable enough not to break out into a cold sweat whenever I open a spreadsheet! I really appreciate directions specifically for Mac.
I learned a lot about Excel! At work, I usually use Google Sheets, and it was very cool to see how much more you can do in Excel!
Good pace and activity times with very practical content.
Ade explained concepts effectively and was very patient when it came to questions.
The class and instructor were very helpful. This condensed a large amount of information into only three courses.
I highly recommend people take this class. Quick paced and very informative.
Best instructor and class ever! Very funny and knowledgeable. Goes at a slow enough pace so that you can absorb the material.
It was a very detailed course.
The course was very detailed. The instructor was also clear and concise!
The instructor was very thorough and enthusiastic.
I really enjoyed the PowerPoint class with Grace. She was really great and was able to fit the whole content into our 6-hour class. We learned a lot about Master slide layouts and themes, how to customize them, and adjust colors, fonts, animations, and transitions. It was overall very educational.
The instructor was so nice and knowledgeable!
Very good class to take. Ade is great instructor.
Overall, a very good class and I learned a lot. The instructor was very good and covered the material clearly. I would take another course with Garfield without question.
Adebayo is a great instructor! I enjoyed taking the class.
I would recommend this course for anyone who has used Excel in its basic format their whole career and never understood -- life could have been way easier many years ago :)
This class was a great way to enhance my Excel skills. I feel more confident in my knowledge. The instructor was very thorough and explained all topics very well. Overall, the class was very good and helped me understand a lot of functions I use every day, as well as taught me new ways to engage with Excel.
I greatly appreciated this instructor. The in-depth analysis was really helpful.
Amazing!
This class was a good intermediate course that allowed you to build on your Excel skills. You learn new things and get to expand your knowledge in an engaging way!
It was fun and challenging.
Adebayo is the best! Highly recommend.
The course and instructor were really easy to follow!
Jeanette is very knowledgeable and answers all questions. She was very clear during the lessons and for each topic. The examples used in the course were great and definitely applicable in my career
Overall, the remote learning option was smooth. The class content covered intermediate Excel formulas and functions. I was able to pick up on a lot of new skills that I didn't know before. Jeanette is very knowledgeable and teaches in an approachable way. I definitely learned valuable information.
Showing 25 of 348 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 or as self-paced training. 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.
Learn at your own pace with pre-recorded video lessons and hands-on exercises. Work through the material on your schedule with access to course content and resources.
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.
