MS Office Online Courses & Certifications

Application

Description

Microsoft Word

1. A word processing application that is used for creating, formatting, and editing text documents
2. It includes features like spell check, grammar check, templates, and collaboration tools

Microsoft Excel

1. A spreadsheet application used for data organization, analysis, and visualization
2. It supports formulas, functions, pivot tables, charts, and data manipulation tools

Microsoft PowerPoint

1. A presentation application used for creating and delivering slide shows
2. It allows users to incorporate text, images, videos, and animations into their presentations

Microsoft Outlook

1. Email and calendar application that are used for managing emails, appointments, tasks, and contacts
2. It includes features like email organization, scheduling, and integration with other MS Office applications

Microsoft Access

1. A database management application used for creating and managing databases
2. It supports data entry, queries, forms, and reports, making it ideal for handling large volumes of data

Microsoft OneNote

1. A note-taking application that allows users to organize notes, ideas, and information in digital notebooks 
2. It supports text, images, audio recordings, and drawing tools

Microsoft Publisher

1. This course dives into advanced Excel techniques, including complex formulas, data analysis tools, and macro programming
2. It is a good course for professionals who want to enhance their MS Excel skills

Module

Description

Introduction to MS Word

1. Ribbon, Word interface, and toolbars
2. Creating, saving, and opening documents
3. Using Go To, scroll bars, and a navigation pane
4. Difference between Save and Save As

Basic Text Formatting

1. Fonts and size change, and applying styles
2. Text formatting, line and paragraph spacing
3. Creating as well as formatting bullet points and numbered lists

Advanced Text Formatting

1. Using and customizing built-in styles and themes
2. Adding, editing, and formatting headers and footers
3. Inserting and managing footnotes and endnotes.

Page Layout

1. Setting margins, page orientation, and paper size
2. Inserting page breaks, section breaks and managing them
3. Creating and formatting columns

Working with Tables

1. Table insertion and defining its structure
2. Table style application, merging cells, and adjusting layout
3. Using formulas within the tables

Graphics & Multimedia

1. Adding and formatting images within documents
2. Using SmartArt, shapes, and WordArt for visual impact
3. Inserting and formatting charts

Document Review

1. Tracking changes and using comments
2. Spell check, grammar check, and thesaurus
3. Comparing and combining documents

Mail Merge

1. Setting up a mail merge for letters, labels, and emails
2. Connecting and managing data sources 
3. Creating customised mail merge fields and rules

Templates & Macros

1. Creating and managing document templates
2. Recording as well as running simple macros
3. Introduction to editing macros in VBA

Collaboration & Sharing

1. Protecting documents through passwords
2. Sharing documents through OneDrive, and real-time collaboration
3. Documents printing, PDF creation, and exporting

Module

Description

Introduction to PowerPoint

1. PowerPoint interface and ribbon
2. Creating, saving, and opening presentations
3. Using views: Normal, Slide Sorter, and Reading View

Basic Slide Design

1. Creating and formatting slides
2. Adding text, images, and shapes
3. Using themes and templates for consistent design

Advanced Slide Design

1. Using transitions and animations
2. Customizing slide layouts and design
3. Adding multimedia elements: audio and video

Working with Charts and Graphs

1. Inserting and formatting charts
2. Using SmartArt for visual data representation
3. Creating and customizing tables

Presentation Techniques

1. Tips for effective presentations
2. Using presenter view
3. Creating speaker notes

Collaboration & Sharing

1. Sharing presentations via OneDrive
2. Real-time collaboration
3. Protecting and exporting presentations as PDF

Printing and Delivering Presentations

1. Setting up print options
2. Handouts and notes pages
3. Delivering presentations and using slideshow controls

Module

Description

Introduction to MS Excel

1. Excel interface, ribbon, and toolbars
2. Creating, saving, and opening workbooks
3. Using Go To, scroll bars, and navigation pane
4. How to add strikethrough in Excel?

Basic Spreadsheet Management

1. Entering and editing data
2. Cell formatting
3. Basic MS Excel Formulas
4. Rows and Columns in Excel

Advanced Formulas and Functions

1. Using complex functions (VLOOKUP, IF, etc.)
2. Creating and managing named ranges
3. Using array formulas

Data Analysis

1. Sorting and filtering data
2. Using PivotTables and PivotCharts
3. Data validation and conditional formatting

Charting and Data Visualization

1. Creating and formatting charts
2. Using Sparklines
3. Adding trendlines and data bars

Working with Tables

1. Table creation and formatting
2. Using structured references
3. Table sorting and filtering

Data Import and Export

1. Importing data from various sources
2. Exporting data to different formats
3. Using Power Query for data transformation

Macros and Automation

1. Recording and running macros
2. Editing macros in VBA
3. Automating repetitive tasks

Collaboration and Sharing

1. Protecting workbooks and worksheets
2. Sharing workbooks via OneDrive
3. Real-time collaboration and track changes

Printing and Page Layout

1. Setting up print options
2. Page layout and scaling
3. Creating headers, footers, and print areas

Module

Description

Introduction to Access

1. Access interface, ribbon, and navigation pane
2. Creating, saving, and opening databases
3. Understanding database objects (tables, queries, forms, reports)

Table Design and Management

1. Creating and modifying tables
2. Setting field properties and data types
3. Establishing relationships between tables

Query Design and Management

1. Creating select queries
2. Using criteria and parameters
3. Creating action queries (append, update, delete)

Form Design and Management

1. Creating and customizing forms
2. Using controls (text boxes, combo boxes, etc.)
3. Designing navigation forms

Report Design and Management

1. Creating and formatting reports
2. Grouping and sorting data
3. Using calculated fields and expressions

Data Import and Export

1. Importing data from various sources
2. Exporting data to different formats
3. Linking tables from external databases

Advanced Data Management

1. Using SQL in Access
2. Creating and managing macros
3. Automating tasks with VBA

Database Security and Maintenance

1. Setting up user permissions
2. Encrypting databases
3. Performing database backups and repairs

Collaboration and Sharing

1. Sharing databases on a network
2. Splitting a database for multi-user access
3. Using Access with SharePoint

Module

Description

Introduction to OneNote

1. OneNote interface and navigation
2. Creating and organizing notebooks, sections, and pages
3. Using templates for note-taking

Basic Note-Taking

1. Adding and formatting text
2. Inserting images, audio, and video
3. Creating and managing tables

Advanced Note-Taking

1. Using tags and search features
2. Linking notes and creating cross-references
3. Using drawing tools and converting handwriting to text

Organizing and Managing Notes

1. Creating and managing sections and groups
2. Using OneNote's page templates
3. Organizing notes with tags and labels

Collaboration & Sharing

1. Sharing notebooks via OneDrive
2. Real-time collaboration
3. Integrating OneNote with other MS Office applications

Integrating OneNote with Other Apps

1. Linking OneNote with Outlook for meeting notes
2. Using OneNote with MS Teams
3. Integrating with third-party apps and services

Printing and Exporting Notes

1. Setting up print options
2. Exporting notes to PDF and other formats
3. Creating backups and restoring notes

Advanced Features

1. Using OneNote Web Clipper
2. Embedding files and links
3. Setting up and using OneNote with different devices

Course

Description

Diploma in MS Office by CSC

This course offers comprehensive training on the entire MS Office suite, including Word, Excel, PowerPoint, and Access. Ideal for beginners and those looking to enhance their productivity skills, this program covers the fundamentals and advanced features of each application.

Beginner to Pro in Excel: Financial Modeling and Valuation by Udemy

This course transforms beginners into Excel pros, focusing on financial modelling and valuation. It covers essential Excel functions, advanced formulas, and real-world financial modelling techniques, making it perfect for those seeking in-depth online MS Excel courses.

Work Smarter with Microsoft Word by Coursera

This course teaches you how to maximize your efficiency with Microsoft Word. Learn advanced document formatting, automation tools, and collaboration features to streamline your workflow.

Microsoft 365 Fundamentals Specialization by Coursera

Dive into the essentials of Microsoft 365 with this specialization. Understand cloud services, Office 365 applications, and how to integrate them into your daily tasks for enhanced productivity.

Ultimate Microsoft Office: Excel, Word, PowerPoint & Access by Udemy

This comprehensive course covers all major Microsoft Office applications. From Excel’s data analysis tools to Word’s advanced formatting, and PowerPoint’s presentation skills to Access’s database management, it’s ideal for those seeking a thorough MS Office education.

Problem Solving with Excel by Coursera

Learn to leverage Excel for effective problem-solving. This course covers data analysis, advanced functions, and practical Excel solutions for business challenges, making it a must for those interested in MS Excel courses.

Microsoft Project: All Beginner to Expert (10 Projects) by Udemy

Gain expertise in Microsoft Project through hands-on experience with 10 comprehensive projects. This course takes you from beginner to expert, covering project planning, execution, and management.

The Complete Microsoft Office Course by Prii Institute

This all-encompassing course offers training in Word, Excel, PowerPoint, and Access. Ideal for beginners and those looking to enhance their skills, it provides detailed instructions on each application’s advanced features.

Microsoft Excel Masterclass for Business Managers by LearnX

Designed specifically for business managers, this masterclass covers advanced Excel functions, data analysis, and financial modeling, providing the tools needed for strategic decision-making and operational efficiency in online MS Excel courses.

Microsoft Office 365 Administration by LinkedIn Learning

This course focuses on administering Office 365, covering user management, security settings, and compliance features. It’s ideal for IT professionals managing Office 365 environments.

Microsoft Dynamics 365 CRM & Power Platform Training by Udemy

Learn to use Microsoft Dynamics 365 CRM and the Power Platform for customer relationship management and business automation. This course covers configuration, customization, and integration techniques.

Work Smarter with Microsoft PowerPoint by Coursera

Enhance your presentation skills with advanced PowerPoint techniques. Learn to design compelling slides, use multimedia elements, and deliver impactful presentations.

Microsoft 365 Certified Fundamentals by Microsoft

This certification course provides foundational knowledge of Microsoft 365 services. Understand core services, pricing models, and how to implement and manage them in an organizational context.

Microsoft Advanced Excel by Tasty Tech

This course dives into advanced Excel techniques, including complex formulas, data analysis tools, and macro programming. It is suitable for professionals seeking to enhance their MS Excel skills.