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.
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
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.
Garfield is very knowledgeable in Excel and communicates the information and content of the course in a manner that makes it easier to understand and follow the material. I appreciate him taking the time to go over the content to have the information in the recording. Thank you!
What a wonderful experience! I never thought I could love Excel more, but I'm hooked after learning with Noble Desktop! I'd love to take another course. Although it was a full day of learning, it didn't feel that way because the professor was engaging and made learning Excel a lot of fun.
I feel more confident using Excel. The teacher was very informative and clear and made learning fun.
It was very clear and easy to understand the instructor's teaching methods. I also appreciated the great sense of humor. I learned many Excel shortcuts and things I will apply in my everyday life. I feel a lot more proficient, thank you!
Garfield was very helpful and knowledgeable, teaching us quicker methods to navigate in Excel.
Vincent's energy is great.
Very informative class, and the professor really takes his time going over any questions.
The instructor is informative, and the class was good.
The instructor was very knowledgeable.
There was a lot of material to cover, but the instructor was very knowledgeable and patient.
My overall experience was great. Professor Ty is very helpful and explains everything thoroughly.
The instructor was very nice and provided informative information.
I learned all the material that I was expecting fairly quickly. The instructor was very kind and informative and explained my most anticipated topics very well.
Great information and a very helpful instructor.
Vincent was easy to understand, and he was very attentive to the class. I learned new tasks that I can apply at work.
I loved all the class content and the fact that I could review the Zoom classes anytime I got stuck. I have learned so much that I can really see myself applying it in my day-to-day work. I wish I had known about it sooner.
Garfield is very knowledgeable and transmits information in a very clear and dynamic manner. I appreciate the time he took to go over the material. Thank you!
Garfield was highly knowledgeable and helpful in navigating the class to better understand Excel Level II.
The teacher was knowledgeable in the subject, patient, and gave practical advice.
It was intimidating due to my own inexperience, but Abe was great! The class presented many possibilities for future presentations after some practice.
The class and the teacher were both a lot of fun and overall, it was a great and unique experience.
The instructor really kept me engaged. I can honestly say I enjoyed it!
I would highly recommend this class. My experience was great, and the class provided valuable information for working with Excel.
Well-structured course, great learning experience!
Ade is a very patient and knowledgeable instructor, super helpful! I highly recommend him for your classes, and I will definitely take a few more.
Showing 25 of 123 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 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 veterans of their field 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.
Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge 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.
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.
