Mastering Microsoft Office



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

TOP-RATED COURSE + UNIQUE APPROACH

0 +

STUDENTS HAVE TAKEN OUR COURSES

LIFETIME ACCESS (INCLUDING UPDATES)

CERTIFICATE OF COMPLETION

Bootcamp Curriculum

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

  • Elevate your skills with Advanced Excel, Word, and PowerPoint techniques.
  • Master Outlook for seamless communication, and dive into the world of Database Management with Microsoft Access.
  • Collaborate like a pro with Teams and SharePoint in Office 365, and turn raw data into actionable insights using Power BI.
  • Enroll now, and seize the chance to become an Office expert.

Consulting / Development Package:

$14,190

$7,095

Live Classes Package:

$9,990

$4,995

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:

$14,190

$7,095

Live Classes Package:

$9,990

$4,995

  • 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

The instructor quickly introduces the basics and then dives right into app development, which is great for those who learn by doing.
Natasha Godwin
Thank you John! It's a great course. One hour is short, but I learnt everything I need to know to start coding HTML5.
Yvonne Wu The Independent
I never knew it would be this easy. I've never coded for iOS before but John make it so easy to understand, this course is clear and precise.
Jared Smith Visual Artist
Far Best Instructor on Udemy when Learning iOS. John Bura takes the approach for each video in a way that I love!
James Tuttle
Just an amazing amount of content, very easy to follow along and combine previous lessons with current ones.
Mike FordeGame Dev.
Looks to be a good high-level grounding into the basics of machine learning and data science. Easy to understand.
Richard L BurnettEmergency Management
I have a few Mammoth Courses, but this is the best one so far. John Bura is funny, he explains everything well, very understandable even for beginners. I fully recommend this course for newbies.
Gabriele GilesApp Developer
The course moved at a pace that I appreciated and the sample projects covered, were of such a nature that it covered anything I would encounter while working with the engine myself. All in all this was exactly what I wanted.
Raymond BeetsCommercial Programmer
These tutorials have helped me create course material, which in turn has helped all levels of students; to get the most from UE4.
Jason MatthewsGame Development College Instructor
Yes. It has helped me understand the basics whereas other tutorials seem to think I already knew a bit about coding.
Kane Patterson
I don't know much about coding, making games, or even computers, but this guy sure does make it simple.
Joshua Martinez
I touched ruby in a bootcamp last summer, so expected to know the basics. I have learned a whole lot even in the beginning. It is well explained and great for beginners as well as intermediary devs.
Joshua MartinezVincent MD