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.

Get Access To Every Vision Training Course

Course Description

Discover comprehensive Microsoft Office training online with ITU’s series, designed for those seeking to enhance their skills in Excel, Access, Word, PowerPoint, and Outlook. This series is your gateway to achieving Microsoft Office Specialist (MOS) certification. It’s perfect for anyone interested in business, HR, sales, office administration, or accounting, offering essential tools for career advancement.

Who Will Benefit From this Microsoft Office Training?

Professionals eager to distinguish themselves in the competitive job market will find value in this online Microsoft Office training. It’s ideal for anyone aiming to validate their proficiency and boost their career potential through Microsoft Office training certifications.

Courses Offered

The series includes 18 detailed courses covering various Office applications. Each course is meticulously crafted to cater to different proficiency levels, from beginner to advanced, ensuring a holistic learning experience. This series covers multiple years of Microsoft Office offering you a progressive leaning path from early Office versions up to Microsoft Office 365.

Harness the Power of Microsoft Office Suite

Our Microsoft Office 365 training center provides in-depth knowledge of each application. You’ll learn to efficiently use Office tools, enhancing your productivity and mastering skills crucial for modern office environments.

Certification and Completion

On completing these Microsoft Office training courses, you’ll be well-prepared for MOS certification, showcasing your expertise to potential employers. A personalized certificate of completion further endorses your newly acquired skills.

Who Would Benefit From Microsoft Office Training?

The Microsoft Office Training Series is beneficial for a wide range of professionals, including:

  1. Business Professionals: Enhance productivity and efficiency in various business applications.
  2. HR Personnel: Gain skills in document management and data organization.
  3. Sales Professionals: Learn to create persuasive presentations and manage customer data effectively.
  4. Office Administrators: Improve office management through advanced Office tools.
  5. Accountants: Utilize Excel for complex financial calculations and data analysis.
  6. Marketing Professionals: Create impactful marketing materials using Office Suite.
  7. Students: Build foundational skills for academic and future career success.
  8. Educators: Develop engaging teaching materials and manage classroom information.
  9. IT Professionals: Understand Office applications for better tech support and user training.
  10. Job Seekers: Enhance resumes with Microsoft Office proficiency.

Frequently Asked Questions About Microsoft Office Training

What does the Online Microsoft Office Training Series include?

The series includes comprehensive training in Microsoft Office Suite applications like Excel, Word, and PowerPoint, preparing for Microsoft Office Specialist certification.

Who should enroll in the Microsoft Office 365 Training?

Ideal for professionals in business, HR, sales, and administration seeking to enhance their skills with Microsoft Office 365 training certification.

Does the Microsoft Office Training Certification provide a certificate?

Yes, participants receive a Microsoft Office Training certification upon completion, demonstrating their proficiency in Office applications.

Can I access Microsoft Office Training Courses online?

Absolutely, all Microsoft Office training courses are available online, offering flexibility for self-paced learning.

Are the Microsoft Office Training Online courses beginner-friendly?

Yes, the training caters to various levels, including beginners, with structured modules for each Microsoft Office application.

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

Vision What's Possible

Vision Your Best Career
365
Price: $139 / YEAR

Gain unlimited access to our comprehensive IT training library featuring top certifications like CompTIA, Cisco, Microsoft, AWS, and more. Explore expert-led courses in cybersecurity, networking, cloud computing, project management, and soft skills development—all designed to help you build real-world, job-ready skills. With the 365 Training Pass, you can start learning today and accelerate your path to a successful IT career.

Sign Up for my 365 access pass today
  • 855-488-5327
  • customerservice@visiontrainingsystems.com

Navigate With Us

Vision What’s Possible
Join today for over 50% off