Get the Newest CompTIA A+ 2025 Course for Only $12.99

For a limited time, check out some of our most popular courses for free on Udemy.  View Free Courses.

Microsoft Office Training Courses

Course Level: Beginner
Duration: 119 Hrs 22 Min
Total Videos: 651 On-demand Videos

ITU’s Microsoft office training series contains certification courses in Excel, Access, Word, PowerPoint & Outlook and allows you to prepare for your Microsoft Office Specialist(MOS) certification.

Course Description

This Microsoft Office Training Series is designed for professionals who want to elevate their day‑to‑day productivity and earn MOS certification. Whether you’re in business, HR, sales, office administration, accounting, or IT support, this online program helps you build practical, job‑ready skills you can apply immediately in real roles.

Across an expertly structured path, you’ll gain confidence with Excel, Word, PowerPoint, Outlook, and Access through clear, hands‑on lessons. The training emphasizes real‑world use cases, from data analysis and reporting to professional document creation and compelling presentations, so you can deliver measurable results at work.

What you’ll acquire goes beyond theory: you’ll develop core competencies that matter in today’s offices—efficient data handling, accurate formatting, persuasive communications, organized records, and streamlined collaboration. This is the foundation you need to stand out in a competitive job market and demonstrate proficiency across the Office suite.

Key topics you’ll cover include creating and analyzing spreadsheets, building dynamic documents, designing impactful slides, managing emails and calendars, and organizing data in databases. The program offers a progressive learning path from foundational to advanced levels, with practice tasks and practical exercises aligned to modern office workflows.

By completing these courses, you’ll be well‑prepared for MOS certification, showcasing your expertise to potential employers. A personalized certificate of completion reinforces your newly acquired skills and signals readiness for more advanced responsibilities.

Outcomes you’ll achieve include:

  • Proficient data analysis with Excel, including formulas, charts, and data interpretation
  • Professional document creation and formatting in Word
  • Effective presentation design and delivery in PowerPoint
  • Efficient email management and scheduling using Outlook
  • Database basics and data organization with Access

Whether you’re refreshing skills or building a brand‑new Office toolkit, this online learning path adapts to your schedule. Enroll today to advance your capabilities, validate your expertise, and move forward with confidence in your role.

Who Benefits From This Course

Included In This Course

Module 1: Beginner

  •    1.0 Intro
  •    1.1 The Ribbon
  •    1.2 Saving Files
  •    1.3 Entering and Formatting Data
  •    1.4 Printing from Excel & Using Page Layout View
  •    1.5 Formulas Explained
  •    1.6 Working with Formulas and Absolute References
  •    1.7 Specifying and Using Named Range
  •    1.8 Correct a Formula Error
  •    1.9 What is a Function
  •    1.10 Insert Function & Formula Builder
  •    1.11 How to Use a Function- AUTOSUM, COUNT, AVERAGE
  •    1.12 Create and Customize Charts

Module 2: Intermediate

  •    2.0 Recap
  •    2.1 Navigating and editing in two or more worksheets
  •    2.2 View options - Split screen, view multiple windows
  •    2.3 Moving or copying worksheets to another workbook
  •    2.4 Create a link between two worksheets and workbooks
  •    2.5 Creating summary worksheets
  •    2.6 Freezing Cells
  •    2.7 Add a hyperlink to another document
  •    2.8 Filters
  •    2.9 Grouping and ungrouping data
  •    2.10 Creating and customizing all different kinds of charts
  •    2.11 Adding graphics and using page layout to create visually appealing pages
  •    2.12 Using Sparkline formatting
  •    2.13 Converting tabular data to an Excel table
  •    2.14 Using Structured References
  •    2.15 Applying Data Validation to cells
  •    2.16 Comments - Add, review, edit
  •    2.17 Locating errors

Module 3: Advanced

  •    3.1 Recap
  •    3.2 Conditional (IF) functions
  •    3.3 Nested condition formulas
  •    3.4 Date and Time functions
  •    3.5 Logical functions
  •    3.6 Informational functions
  •    3.7 VLOOKUP & HLOOKUP
  •    3.8 Custom drop down lists
  •    3.9 Create outline of data
  •    3.10 Convert text to columns
  •    3.11 Protecting the integrity of the data
  •    3.12 What is it, how we use it and how to create a new rule
  •    3.13 Clear conditional formatting & Themes
  •    3.14 What is a Pivot Table and why do we want one
  •    3.15 Create and modify data in a Pivot Table
  •    3.16 Formatting and deleting a Pivot Table
  •    3.17 Create and modify Pivot Charts
  •    3.18 Customize Pivot Charts
  •    3.19 Pivot Charts and Data Analysis
  •    3.20 What is it and what do we use it for
  •    3.21 Scenarios
  •    3.22 Goal Seek
  •    3.23 Running preinstalled Macros
  •    3.24 Recording and assigning a new Macro
  •    3.25 Save a Workbook to be Macro enabled
  •    3.26 Create a simple Macro with Visual Basics for Applications (VBA)
  •    3.27 Outro

Module 1: Beginner

  •    1.01 Instructor Intro
  •    1.02 Course Intro
  •    1.1 Explaining the Ribbon
  •    1.2 Creating a Document
  •    1.3 Saving Files
  •    1.4 Page Views
  •    1.5 Formatting Text
  •    1.6 Ruler, Margins and Tab Stops
  •    1.7 Moving and Duplicating Text
  •    1.8 Line Spacing and Paragraph Formatting
  •    1.9 Basic Editing
  •    1.10 Insert a Basic Table and Graphics
  •    1.11 Working with Styles

Module 2: Intermediate

  •    2.1 Intermediate Intro
  •    2.2 Collaboration & Co-Authorship
  •    2.3 Tracking and Viewing Changes
  •    2.4 Commenting
  •    2.5 Templates & Layouts
  •    2.6 Layout Functions on the Ribbon
  •    2.7 Customize, Format and Convert Tables and Use as a Page Layout
  •    2.8 Insert and Edit a Cover Page
  •    2.9 Insert and Customize Headers and Footers
  •    2.10 Insert and Customize Endnotes and Footnotes
  •    2.11 Creating Sections in a Long Document
  •    2.12 Using Sections to Format a Document
  •    2.13 Deleting a Section
  •    2.14 Reviewing, Inserting and Updating TOC
  •    2.15 Creating a Data Source and Linking a Mailing List
  •    2.16 Print Settings for Mail Merge

Module 3: Advanced

  •    3.1 Adding the Developer Tab
  •    3.2 Functionality Among Microsoft Office Products
  •    3.3 Using Formulas in Word
  •    3.4 Citing Sources in Word
  •    3.5 Reviewing and Merging Versions of the Same Document
  •    3.6 Creating a Master Document
  •    3.7 Creating Sub Documents and Editing Master and Sub Docs
  •    3.8 Controlling Editable Content
  •    3.9 Form Creation Using the Developer Tab
  •    3.10 Macros

Word 2016 Basic

  •    Introduction To Word Interface Part1
  •    Introduction To Word Interface Part2
  •    Introduction To Word Interface Part3
  •    View
  •    Typing Part1
  •    Typing Part2
  •    Typing Part3
  •    Typing Part4
  •    Resume Part1
  •    Resume Part2
  •    Bullet List

Word 2016 Intermediate

  •    Menus And Keyboard Shortcuts Part1
  •    Menus And Keyboard Shortcuts Part2
  •    Tabs
  •    Tables Part1
  •    Tables Part2
  •    Tables Part3
  •    Styles Part1
  •    Styles Part2
  •    Styles Part3
  •    Page Formatting Part1
  •    Page Formatting Part2
  •    Page Formatting Part3

Word 2016 Advanced

  •    Creating An Outline
  •    Inserting Images Part1
  •    Inserting Images Part2
  •    Tracking Changes
  •    Mail Merge Part1
  •    Mail Merge Part2
  •    Large Documents Part1
  •    Large Documents Part2
  •    Other Word Functions Part1
  •    Other Word Functions Part2
  •    Document Comparison

Basic Microsoft PowerPoint 2016

  •    What Is PowerPoint Part 1
  •    What Is PowerPoint Part 2
  •    New Presentation
  •    Viewing Presentation
  •    Inserting Transitions
  •    More Visual Designs Part 1
  •    More Visual Designs Part 2
  •    More Visual Designs Part 3
  •    More Visual Designs Part 4
  •    Notes

Intermediate Microsoft PowerPoint 2016

  •    Visual Designs With Logos And Animation Part1
  •    Visual Designs With Logos And Animation Part2
  •    Visual Designs With Logos And Animation Part3
  •    Visual Designs With Logos And Animation Part4
  •    Visual Designs With Logos And Animation Part5
  •    Exit Animation Part1
  •    Exit Animation Part2
  •    Exit Animation Part3
  •    Navigation Buttons
  •    Layout Options Part1
  •    Layout Options Part2

Advanced Microsoft PowerPoint 2016

  •    Master Pages Part1
  •    Master Pages Part2
  •    Software Simulation Part1
  •    Software Simulation Part2
  •    Setting Pictures To Music
  •    Advanced Animation Techniques
  •    Triggers
  •    Motion Path Animation
  •    Video In PowerPoint
  •    PowerPoint Review Part1
  •    PowerPoint Review Part2
  •    Additional Options

Outlook 2016 Basic

Outlook 2016 Intermediate

Outlook 2016 Advanced

Excel 2016 Basic

Excel 2016 Intermediate

Excel 2016 Advanced

Access 2016 Basic

Access 2016 Intermediate

Access 2016 Advanced

Module 1: What Is Microsoft 365

Module 2: Word Online

Module 3: Excel Online

Module 4: Powerpoint Online

Module 5: Outlook Online

Module 6: One Note Online

Outlook 2013 Basic

Outlook 2013 Intermediate

Outlook 2013 Advanced

Word 2013 Basic

Word 2013 Intermediate

Word 2013 Advanced

Powerpoint 2013 Basic

Powerpoint 2013 Intermediate

Powerpoint 2013 Advanced

Excel 2013 Basic

Excel 2013 Intermediate

Excel 2013 Advanced

Access 2013 Introduction

Access 2013 Intermediate

Access 2013 Advanced

Excel 2010 Basic

Excel 2010 Intermediate

Excel 2010 Advanced

Outlook 2010 Basic

Outlook 2010 Intermediate

Outlook 2010 Advanced

Powerpoint 2010 Basic

Powerpoint 2010 Intermediate

Powerpoint 2010 Advanced

Word 2010 Basic

Word 2010 Intermediate

Word 2010 Advanced

Access 2010 Basic

Access 2010 Intermediate

Access 2010 Advanced