Mastering Microsoft Office

Harness power and versatility for professional excellence in our top corporate bootcamp.


0 +




Bootcamp Curriculum

Unlock the full potential of Microsoft Office in this exhilarating 8-session bootcamp. 

Consulting / Development Package:



Live Classes Package:



Note: All weeks would include a 15-minute Q&A session at the end, to address any questions or clarifications. In addition, each week would provide supplemental learning materials, such as cheat sheets, reference guides, and additional practice exercises.

Bootcamp Details

Consulting / Development Package:



Live Classes Package:



  • 8 sessions of interactive instruction (2 hours per session) delving into Microsoft Office’s advanced capabilities.
  • Lifetime access to live class recordings.
  • Lifetime access to Drupal masterclass.
  • Permanent entry to our reservoir of Microsoft Office guides and resources.
  • Opportunity to connect with fellow Microsoft Office learners.
  • Access to the Microsoft Office Mastery community for peer support.
  • Instructor-led guidance via the Microsoft Office Mastery community.
  • Limitless email and chat support related to Microsoft Office.
Session 1: Advanced Microsoft Excel I

Session 1 (2 hours)

  • Introduction to advanced Excel functions
  • Overview of complex formulas
  • Learning how to work with Array Formulas
  • Understanding and using nested functions

Homework Assignment: Utilize array formulas and nested functions to automate an inventory tracking sheet.

Session 2: Advanced Microsoft Excel II

Session 2 (2 hours)

  • Advanced data validation and conditional formatting
  • Creating advanced charts and Graphs
  • Introduction to Power Query
  • Introduction to Power Pivot and Data Models

Homework Assignment: Develop a sales analysis report using advanced charts and Power Pivot.

Session 3: Advanced Microsoft Word

Session 3 (2 hours)

  • Mastering Styles and Themes for efficient formatting
  • Utilizing advanced features for long documents (Table of Contents, Index, Cross-references, Citations)
  • Advanced Mail Merge techniques
  • Collaborative work in Word

Homework Assignment: Create a complex business report utilizing the advanced features studied.

Session 4: Microsoft PowerPoint Mastery

Session 4 (2 hours)

  • Advanced design principles for effective presentations
  • Mastering Animation and Transitions
  • Incorporating media files effectively
  • Tips for delivering effective presentations using Presenter View

Homework Assignment: Develop a business presentation using advanced design and animation principles.

Session 5: Advanced Microsoft Outlook

Session 5 (2 hours)

  • Mastering Email Management: rules, folders, conditional formatting
  • Using advanced Calendar features
  • Task and Notes Management
  • Outlook add-ins and customization

Homework Assignment: Organize an example inbox utilizing advanced email management techniques.

Session 6: Microsoft Access - Database Management

Session 6 (2 hours)

  • Database Design Principles
  • Advanced Query techniques
  • Form and Report design
  • Data Import and Export

Homework Assignment: Create a functional database based on a case scenario, implement queries and design a report.

Session 7: Microsoft Office 365 - Teams and SharePoint

Session 7 (2 hours)

  • Mastering collaboration with Teams: advanced features
  • SharePoint: advanced document management and collaboration
  • Creating workflows in SharePoint
  • Introduction to Power Automate

Homework Assignment: Develop a project collaboration setup using Teams and SharePoint.

Session 8: Office 365 - Power BI

Session 8 (2 hours)

  • Data visualization principles
  • Creating interactive dashboards
  • Publishing and sharing dashboards
  • Security features in Power BI

Homework Assignment: Create an interactive dashboard for a provided set of data, and share it securely with a specified audience.

Consulting / Development Package

  • Access to forthcoming Microsoft Office Live Classes (8 sessions/2 hours per session).
  • Assistance in developing a custom Microsoft Office project, including potential software development.
  • 10 hours of personalized video/phone consultation or software development time with our experts.

Any Questions?

Our team is always happy to help with any inquiry. We will get back to you within 2 business days. 

What Mammoth Students are Saying