MS Office Complete Training - Beginner to Expert Level
Course Description
MS Office 2026 and Office 365 additional features has been updated!
Most of us are aware of MS Word, Excel and PowerPoint but are not efficient, as we don’t give so much importance to it and got stuck in workplace because of the lack of knowledge. So become more productive with our online Microsoft Office training course, designed to help you become more efficient in the workplace. Our training classes will teach you everything you need to know about creating worksheets, documents, presentation and more.
This course is intended for individuals and office workers who need to master the features of the most demanding office utility software that is Microsoft Office. In more than 14 hours of video presentations, you'll learn everything you need to know to make your office work more efficiently.
-
Excel Beginner / Intermediate: Create basic spreadsheets and use expense tracking formulas.
-
Excel Advanced: Use complex formulas and data analysis about your company's revenue and expense models.
-
Word: Create documents, embed videos, and set up online collaboration for shared work or school projects.
-
PowerPoint: Create an elegant presentation for your next business meeting with animation, audio / video, and collaboration tools.
-
Access: Learn database management system that combines the relational Access Database Engine with a graphical user interface.
When you complete this course, you will become a work efficiency expert using the tools available in Microsoft Office.
Course Curriculum
- 1 Intro Video
- 2 MS Word
- 3 Powerpoint
- 4 Overview of Microsoft office Products - Made with Climpchamp
- 5 Outlook
- 6 One Note
- 7 Importance and common usage scenarios of Microsoft Office apps
- 8 Excel
- 9 Evolution of Microsoft Office Suite
- 10 Access
- 11 Working with text and graphics
- 12 WordArt
- 13 Using Styles and Themes
- 14 The Start Screen and Introduction to Basic Features
- 15 Review Tools_Spellcheck,Thesaurus,etc
- 16 Printing and Publishing Options
- 17 Opening and Editing Existing Word Documents
- 18 Move and Copy Text,and Find and Replace
- 19 Modyfying Pagelayout
- 20 Managing References and Citations
- 21 Mail Merging and forms
- 1 Introduction to Microsoft Word
- 2 Introduction to Online Videos
- 3 Inserting Equations
- 4 Inserting Audio Files
- 5 Get Help
- 6 Formatting Pictures
- 7 Formatting Characters and Paragraphs
- 8 Customizing Word Settings
- 9 Creating and Formatting Documents
- 10 Create and Edit Tables
- 11 Collaborating and Reviewing Documents
- 12 Writing and Formatting Email
- 13 Tasks and to-do lists
- 14 Setting up your view in Outlook
- 15 Schedule Your Email to send at a later time
- 16 Replying and Forwarding Emails
- 17 Overview of Microsoft Outlook Interface
- 18 Outlook Interface
- 19 Organizing with Folders in Outlook
- 20 Integration with other Office Apps
- 21 Have your Emails read to you
- 22 Dictating Your Email in Outlook
- 23 Deleting,Flagginmg and Sorting Emails
- 24 Customize the look and Feel of Outlook
- 25 Creating Signature and Adding to Emails
- 26 Composing Emails
- 27 Calendar Management (scheduling,appointments,meetings)
- 28 Advanced features(archiving,journaling,etc
- 29 Adding Attachments and Images to your Emails
- 30 Adding a Contact in Outlook
- 32 Adding Multimedia and Visual Effects
- 1 Using Formulas
- 2 Sharing and Collaboration
- 3 Save File
- 4 Pivot Tables and PivotCharts
- 5 Introduction to Microsoft Excel
- 6 Introduction to Basic Features
- 7 Insert & Delete Columns or Rows
- 8 Find& Remove Duplicates
- 9 Filter and Sorting
- 10 Data Validation and Protection
- 11 Data Analysis and Visualization
- 12 Conditional Formatting
- 13 Basic Formatting
- 14 Advanced Charting Techniques
- 15 Introduction to Microsoft Powerpoint
- 16 How to Use Powerpoint Templates to Get Started
- 17 Key Terminologies
- 18 Creating Slides Easily
- 19 Copy and Paste Elements
- 20 Applying Professional Design to slides Quickly
- 21 Use SmartArt Diagrams
- 22 Find Dropdown Menu with Additional Options
- 23 Different Ways to Insert pictures
- 24 Sorting Slides
- 25 Printing or Exporting a Presentation
- 26 Principles of Effective Presentations
- 27 Presenting Slides with Slideslow and Navigating in Slideshow
- 28 Delivering Presentations
- 29 Creating a Chart
- 30 Constructing a Table
- 31 Applying Different Slide Layouts
- 33 Tables,Fields & Records
- 1 Introduction to Microsoft Access
- 2 Advantages of a Databases Over Excel
- 3 Accessing the Start Page
- 4 Access Alternatives.
- 5 Sample Order Data
- 6 Calculated Field & Expression Builder
- 7 Exports tables Forms Queries
- 8 Forms
- 9 Queries
- 10 Relationships
- 11 Reports
- 12 Save Database
- 13 Wrapup
- 14 Collaboration Features
- 15 Integrating Microsoft Office Apps
- 16 Integrating with Cloud Services
- 17 Version Control and Document Management
- 18 Accessibility Features
- 19 Advanced Customization
- 20 Security Best Practices
- 21 Tips and Tricks
- 22 Troubleshooting Most Common Scenarios