Microsoft Office Intermediate Bootcamp (Self-Paced)

Self-paced online training with expert support 5 modules

Enhance your Microsoft Office skills in this immersive self-paced course, mastering Excel, PowerPoint, Word, and Outlook to streamline your workflow and increase productivity.

$949 30 clock hours Live Support Start anytime

This course includes

  • 30 hours of project-based training from experts
  • 41 training videos
  • Access to Microsoft Office
  • Learn from a Microsoft Certified Trainer
  • Retake for free within 1 year
  • Access to class recordings (30 days)
  • Verified digital certificate of completion

In this self-paced course, you’ll master intermediate and advanced functions of Microsoft Office programs, including Excel, PowerPoint, Word, and Outlook. This comprehensive training package covers essential skills and time-saving techniques, with a focus on improving productivity and streamlining your workflow. You’ll dive into advanced Excel functions like Pivot Tables, VLOOKUP, and macros, while also learning how to automate tasks and summarize data effectively.

You’ll also enhance your PowerPoint skills by creating reusable templates, importing Excel charts, and designing multimedia-rich presentations. In Word, you’ll learn to automate tasks like mail merge, create custom styles and templates, and write macros to boost efficiency. Finally, you’ll gain advanced Outlook skills, including configuring mail accounts, performing complex searches, managing spam, and optimizing calendar and contact management. By the end, you’ll have the skills to use Microsoft Office more effectively and efficiently in your daily work.

Read more

Join a larger program to learn more and save:

Courses & Videos in This Package

Download Syllabus PDF

Unit 1 6 Hours

Excel Level II: Intermediate Course Online (Self-Paced)

  • Learn to split and join text, apply data validation, and create named ranges
  • Use database functions such as VLOOKUP and HLOOKUP
  • Write logical formulas using AND, OR, and IF functions
  • Create Pivot Tables to efficiently summarize and analyze large datasets
  • Apply statistical functions such as RANK, COUNTIFS, and SUMIFS
  • Build advanced combo charts by combining multiple chart types
  • Reinforce key concepts through a guided final project

Video Training Preview
Lesson 5: Workbook Management
Lesson 1: Worksheet Management
Lesson 2: Working with Text
Lesson 3: Cell Ranges
Lesson 4: Database Functions
Lesson 5: Pivot Tables
Lesson 6: Logical Functions
Lesson 7: Statistical Functions
Lesson 8: Advanced Charts

Unit 2 6 Hours

Excel Level III: Advanced Course Online (Self-Paced)
  • Cell management including cell locking, auditing,  and hot keys
  • Special formatting for calculating dates
  • Use advanced functions and advanced analytical tools 
  • Record macros and relative reference macros for ad hoc reporting
Video Training Preview
Lesson 1: Cell Management
Lesson 2: Special Formatting
Lesson 3: Advanced Functions
Lesson 4: What If Analysis
Lesson 5: Advanced Analytical Tools
Lesson 6: Advanced Database Functions
Lesson 7: Introduction to Macros
Lesson 8: Dynamic Arrays

Unit 3 6 Hours

Microsoft Word Level II (Self-Paced)
  • Efficiently manage and work with multiple documents
  • Track changes and collaborate using comments and revision tools
  • Apply advanced formatting techniques for polished, professional documents
  • Create and manage reference tables, including tables of contents and indexes
  • Design forms and utilize mail merge to automate personalized communications
  • Develop and apply custom style sets and templates for consistent formatting

Unit 4 6 Hours

PowerPoint Level II (Self-Paced)

This self-paced course covers core PowerPoint skills to create engaging, professional presentations. Learn how to design slides, work with images, charts, and transitions, and develop visually compelling presentations you can confidently present.

  • Create presentations from templates and customize layouts, themes, and content structure
  • Edit text, bullets, and numbered lists with Outline View and advanced formatting tools
  • Insert and enhance images, SmartArt, and shapes using effects, cropping, and alignment options
  • Format tables, add connector lines, and import Excel charts to display data
  • Apply transitions, manage presenter notes, and use tools for live or virtual presentations
  • Save, print, and export presentations to PDF with professional-use options

Unit 5 6 Hours

Microsoft Outlook Level II (Self-Paced)
  • Edit messages and configure global settings
  • Customize calendar settings
  • Organize and search for messages
  • Manage contacts and groups
  • Handle mailboxes efficiently
  • Manage tasks and activities
  • Automate message management
  • Share workspaces and collaborate effectively

Related Courses: Compare to Microsoft Office Intermediate Bootcamp (Self-Paced)

These related courses share skills and topics with Microsoft Office Intermediate Bootcamp (Self-Paced). 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 Online (Self-Paced)
    18 hours $549

    Become proficient in Microsoft Excel and go from beginner to pro with our hands-on Excel Bootcamp. Learn functions, formulas, 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 our accelerated course. Learn everything from the basics of creating presentations to more advanced features like custom themes, animations, and managing large presentations.

Yelp Facebook LinkedIn YouTube Twitter Instagram