Microsoft Office Intermediate Bootcamp
IDCMI

Hands-on Training from Experts Live Online

Expand your proficiency in Excel, PowerPoint, and Word with hands-on training in functions like VLOOKUP, PivotTables, formatting tools, and slide master design. Strengthen your ability to create polished presentations, manage data efficiently, and produce professional documents for business use.

View Schedule & Enroll

This course includes

  • 29 hours of live, project-based training from experts
  • Learn from an Adobe Certified Professional
  • Access to class recordings (30 days)
  • Verified digital certificate of completion
  • Learn at an accredited institution
  • Small class sizes

Advance your skills with the intermediate and advanced features of the core Microsoft Office programs in this 5-day bootcamp. This package includes our intermediate and advanced Excel, advanced PowerPoint, Word, and Outlook classes at a discounted rate.

In Excel, learn to summarize data with PivotTables, write advanced functions like VLOOKUP, and apply techniques to speed up your workflow. You’ll also discover ways to make functions more adaptable and automate processes using macros.

In PowerPoint, master creating reusable templates, building engaging and consistent presentations that are easy to update, importing charts from Excel, incorporating multimedia and layered objects, and recording slideshows.

With Microsoft Word, learn to automate processes such as mail merge, record and run macros to save time, and design custom document styles and templates to boost productivity across your team.

In Outlook, develop advanced skills such as configuring mail accounts, running detailed searches, filtering spam, automating tasks with rules, and managing calendars and contacts at an expert level.

Read more

Join the Complete Microsoft Office Bootcamp to learn intermediate and advanced Microsoft Office skills too:

Courses in this Package

This is the recommended order, but some courses may be taken in a different order.

Download Syllabus PDF

Unit 1 6 Hours

Excel Level II: Intermediate

Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort and Filter databases, and split and join text.

  • Learn to split and join text, add data validation, and use named ranges
  • Use database functions such as VLOOKUP and HLOOKUP
  • Add logical statements, including AND, OR, and IF statements
  • Create PivotTables to quickly summarize large databases
  • Use statistical functions such as RANK, COUNTIFS, and SUMIFS
  • Create advanced combo charts from multiple charts
  • Review key concepts by creating a final project

Unit 2 6 Hours

Excel Level III: Advanced

Learn all of the most complex features of Microsoft Excel in this advanced training course.

  • Understand cell management, including cell locking, auditing, and hotkeys
  • Learn special formatting for calculating dates
  • Use advanced functions, such as nested IF statements
  • Learn advanced analytical tools for data consolidation, conditions to exclude data, and PivotCharts
  • Use advanced database functions, such as MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
  • Record macros and relative reference macros for ad-hoc reporting
  • Create a project that applies key concepts from the class

Unit 3 6 Hours

Microsoft Word Level II

  • Manage and work with multiple documents efficiently
  • Track changes and collaborate using comments and revision tools
  • Apply advanced formatting techniques for professional documents
  • Create and manage reference tables, including tables of contents and indexes
  • Design forms and use mail merge to automate personalized communications
  • Build and apply custom style sets and templates for consistent formatting

Unit 4 6 Hours

PowerPoint Level II
  • Create and manage Slide Master layouts to ensure consistent branding across entire presentations
  • Design custom PowerPoint themes, including personalized color palettes, fonts, and reusable backgrounds
  • Animate bullet points, charts, and objects using entrance, emphasis, and exit effects, and explore the Morph transition
  • Integrate video, hyperlinks, and dynamic charts and tables imported from Excel for interactive presentations
  • Customize presentation workflows with hidden slides, custom shows, sections, and the Quick Access Toolbar
  • Collaborate and finalize projects with built-in commenting tools, PDF export options, and optimized printing settings

Unit 5 6 Hours

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.

  • Modify messages and set Global Options
  • Calendar settings
  • Organize and search messages
  • Contacts and groups
  • Manage mailboxes
  • Manage activities
  • Automate message management
  • Share workspaces

Schedule & Enrollment: Microsoft Office Intermediate Bootcamp

  • 29 Hours
  • Price before discounts: $1,245 Full tuition: $949
  • Live Online
  • Expert instructors
  • Small classes

  • Custom Schedule
    Enroll

  • October 16–31 Show package courses
    Enroll

  • November 14–December 19 Show package courses
    Enroll

Show more
A group of adult learners sits in a classroom, smiling and engaged in a government training session.
A government training instructor in a suit gestures while teaching in front of a whiteboard covered with notes and diagrams.
A person in professional attire holds a Graduate School USA folder, symbolizing participation in government training programs.

Related Courses: Compare to Microsoft Office Intermediate Bootcamp

These related courses share skills and topics with Microsoft Office Intermediate Bootcamp. Select up to two and tap Compare selected courses to view a side-by-side comparison.

  • Complete Microsoft Office Bootcamp
    54 hours $1,725

    Learn all the Microsoft Office programs in-depth in this bootcamp. This package includes three levels of Excel, two levels of PowerPoint, two levels of Word, and two levels of Outlook classes at a 15% discount.

  • Microsoft Office Fundamentals Bootcamp
    24 hours $749

    Learn the fundamentals of the essential Microsoft Office programs in this 4-day bootcamp. This package includes our beginner Excel, PowerPoint, Word, and Outlook classes at a 15% discount.

  • Excel Bootcamp
    18 hours $549

    Become proficient in Microsoft Excel and go from beginner to pro with this hands-on bootcamp. Learn functions, Pivot Tables, macros, and time-saving techniques to conquer all the key skills needed to excel in Excel.

  • PowerPoint Bootcamp
    12 hours $399

    Take your PowerPoint skills to the next level with this accelerated course. Learn everything from the basics of creating presentations to more advanced features like custom themes, animations, and managing large presentations.