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.

Continue reading angle-line

warning-standard-solid This course has a prerequisite

Students must have Microsoft Office proficiency equivalent to our Microsoft Office Fundamentals Bootcamp.

The Microsoft Office Intermediate Bootcamp includes

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.

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. 

Advanced PowerPoint for Business

In this advanced PowerPoint class, you’ll 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

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.

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.