Complete Microsoft Office Bootcamp
IDCCM

Hands-on Training from Experts Live Online

Master essential Microsoft Office tools as you build proficiency in Excel, PowerPoint, Word, and Outlook. You’ll work on hands-on projects to analyze data, create polished presentations, format documents, and manage communications efficiently. This course is ideal for professionals looking to enhance productivity and technical skills.

View Schedule & Enroll

This course includes

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

Master the full Microsoft Office suite with this bootcamp, which includes three levels of Excel, two levels of PowerPoint, two levels of Word, and two levels of Outlook—all at a 15% discount. This program builds your expertise in each application, taking you from core fundamentals to advanced features.

  • Design Engaging Presentations: Create polished PowerPoint presentations with professional slide layouts, images, and diagrams. Level I covers essentials like SmartArt, tables, and charts, while Level II focuses on custom themes, animations, video integration, and managing large projects for seamless collaboration.
  • Optimize Communication with Outlook: Improve productivity by streamlining email and calendar management. In Level I, you’ll learn to automate tasks, manage contacts, and schedule effectively. Level II explores advanced tools, including account setup, spam filtering, and enhanced contact management for a fully customized Outlook experience.
  • Create Professional Documents: Produce well-structured, professional-quality documents in Microsoft Word. Level I teaches navigation, text formatting, table creation, and inserting citations or references. Level II goes deeper with tracking changes, advanced formatting, mail merge, and building custom templates.
  • Analyze & Automate with Excel: Strengthen your Excel skills from basic functions to advanced automation. Level I introduces functions, charts, and visualizations, while Level II covers data validation and PivotTables. Level III advances to complex analysis tools, date calculations, and macros for workflow automation.
Read more

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

PowerPoint Level I

This beginner-friendly PowerPoint course covers the core skills needed to create engaging and professional presentations.

  • Build new presentations from templates and customize layouts, themes, and content structure
  • Add and edit text, bullets, and numbered lists using Outline View and various formatting tools
  • Insert and enhance photos, SmartArt, and shapes with effects, cropping, and alignment options
  • Create and format tables, add connector lines, and import charts from Excel to display data
  • Apply transitions, manage presenter notes, and use presentation tools for live or virtual delivery
  • Save, print, and export presentations to PDF, with options tailored for professional use

Unit 2 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 3 6 Hours

Microsoft Outlook Level I

This one-day class concentrates on how to use Outlook quickly and effectively for daily work tasks or to become an Official Microsoft Certified Outlook Specialist. By the end of this class, you will be able to reduce hours of repetitive work by setting up rules and search folders to automate email, manage your calendar and to-do lists, manage huge amounts of email with ease, manage complex scheduling, organize all your contacts, and track your correspondence.

  • Outlook settings
  • Working with messages
  • Calendar management
  • Notes, tasks, and journals
  • Contacts and groups

Unit 4 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

Unit 5 6 Hours

Microsoft Word Level I
  • Navigating through documents
  • How to format documents
  • Working with text and paragraphs
  • Tables in Word
  • Lists
  • Endnotes, footnotes, and citations
  • Adding images to Word documents

Unit 6 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 7 6 Hours

Excel Level I: Fundamentals

In this beginner Excel course, you will learn the essentials of Microsoft Excel, including calculators, basic functions, graphs, formatting, and printing.

  • Become familiar with the interface and data entry
  • Learn essential formulas and functions
  • Format and print your work
  • Create charts, including line, column, and pie charts
  • Learn tips and tricks for easy workbook management
  • Review key concepts in a final project

Unit 8 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 9 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

Schedule & Enrollment: Complete Microsoft Office Bootcamp

  • 54 Hours
  • Price before discounts: $2,241 Full tuition: $1,725
  • Live Online
  • Expert instructors
  • Small classes

  • Custom Schedule
    Enroll

  • October 15–31 Show package courses
    Enroll

  • November 13–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 Complete Microsoft Office Bootcamp

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

  • Word Bootcamp
    12 hours $498

    Master essential Microsoft Word skills in this hands-on course covering formatting, styles, tables, mail merge, and document layout tools. You’ll work on real-world exercises to streamline workflows and create polished, professional documents with confidence.

  • 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.

  • Outlook Bootcamp
    12 hours $498

    Learn basic through advanced Outlook skills, including contact and group creation, calendar management, working with mailboxes and activities, and using automations.