Microsoft Office Management Training Course

Learn Microsoft Office Applications Word, Excel, PowerPoint, and Access step by step

What you'll learn

A good knowledge on Microsoft Office Applications - Word, Excel, PowerPoint, and Access

Learn the uses of tools under different menus of different office applications

Good operational knowledge on Word, Excel, PowerPoint, and Access

Full expertise on Microsoft Office Applications - Word, Excel, PowerPoint, and Access

Requirements

Basic Knowledge of PC, and Laptop

Eager to learn new things

Tech shavvy

Patience to learn

Description

Microsoft Office is one of the most widely used productivity suites in the world. It includes several essential applications such as Word, Excel, PowerPoint, and Access, among others. Due to the widespread use of Microsoft Office, it is essential for professionals to learn how to manage and utilize it effectively.A Microsoft Office management course is a training program designed to teach individuals how to use the software suite efficiently. The course covers a range of topics, from basic skills to advanced techniques, and it can be tailored to fit the needs of different learners. Here are some of the key areas that may be covered in a Microsoft Office management course:Windows: At this part you will get the basic operations, manipulations, and handling process of windows in your desktop and laptop.Microsoft Word: Microsoft Word is one of the most commonly used applications in the Microsoft Office suite. A Microsoft Office management course will teach you how to create and edit documents, use templates, format text, and work with images.Microsoft Excel: Microsoft Excel is another widely used application in the suite. In a Microsoft Office management course, you will learn how to create and format spreadsheets, use formulas and functions, and analyze data.Microsoft PowerPoint: Microsoft PowerPoint is used for creating presentations. A Microsoft Office management course will teach you how to create and edit presentations, add animations and transitions, and use multimedia.Microsoft Access: Microsoft Access is a relational database management system (RDBMS) that is part of the Microsoft Office suite of applications. It provides a user-friendly interface that allows users to create, manage and manipulate databases. After completion of this training, users can create tables to store data, forms to enter data, queries to search and retrieve data, and reports analyzing and present data.Overall, a Microsoft Office management course is essential for anyone who wants to learn how to use Microsoft Office effectively. By completing the course, you will gain a deeper understanding of the software suite and be able to use it to increase your productivity and efficiency in your professional and personal life.After completion of this course, you will1. Achieve a Course Completion Certificate2. Get a competitive advantage on job market3. Be able to handle Microsoft Applications efficiently and effectively4. Get full knowledge on Microsoft Applications to handle your desktop and laptopMicrosoft Windows Course Outline01. Introduction to Windows Desktop02. How to manipulate desktop Windows03. Introduction to Windows applications and the desktop04. Process to check basic information of PC05. Use of Windows File Explorer06. How to manipulate folder on Windows07. Process to remove pen drive safely from PC08. File manipulation process in windows09. How to compress and decompress file on WindowsMicrosoft Word course outline01. Introduction to Microsoft Word 02. Starting Microsoft Word with blank document03. Starting Microsoft Word document with a template04. Manipulating text in Microsoft Word 2016 document05. Text formatting process in Microsoft Word 06. Paragraph formatting process in Microsoft Word 07. How to use Styles in Microsoft Word 08. Find and Replace function in Microsoft Word 09. How Insert menu functions in Microsoft Word 10. Design Theme in Microsoft Word 11. Create and Design Table in Microsoft Word 12. Functions of view menu in Microsoft Word 13. Mail Merge Process in Microsoft Word Microsoft Excel course outline01. Getting Started with Microsoft Excel application02. How to use Cut, Copy, Paste, and Format Painter in Excel03. Function of Font Tools under Home Menu04. Function of Alignment Tools under Home Menu05. Function of Number Tools under Home Menu06. Use of Style Tools under Home Menu07. Function of Cells tool under home menu08. How to use Editing Tools under Home Menu09. Process to Work with Multiple worksheet10. How to use tables under insert menu11. Usage of illustrator tool under the insert menu12. Process to use Charts & Sparkline's  tool under insert menu13. Use of Pivot Table and Slicer in Microsoft Excel14. Function of text tool under insert menu15. How to use text & symbol tool under insert menu16. Functions of different tools under Draw menu17. How to set Page Layout in Microsoft Excel18. How to use different functions in Microsoft Excel19. How to Check and fix Function Errors in Microsoft Excel20. Use of Formula Auditing tools under Formula Menu in Excel21. Use of IF function in Microsoft Excel22. How to import data, sorting, filtering and remove data duplication in MS Excel23. How to use Data Validation tool in Excel24. Text to Column Process in Microsoft Excel25. What IF Analysis - Goal Seek for decision-making in Microsoft Excel26. What IF Analysis - Data Table for decision-making in Microsoft Excel27. What IF Analysis - Scenario Manager for Scenario Analysis in Microsoft Excel28. Data Forecasting Manually and Automatically in Microsoft Excel29. How to activate solver in Microsoft Excel for Data Analysis 30. Use of Spelling checker tool under Review Menu in Microsoft Excel31. How to use Thesaurus and Translate Tool in Excel32. How to use comments and Protection in Excel33. Workbook Different Views in Microsoft Excel34. How to use Show and Zoom Tools in Microsoft Excel35. How to use Window Tools under view menu in Excel36. How to activate Macro Tool in Microsoft Excel37. Tell me what to do Tool in Microsoft ExcelMicrosoft PowerPoint course outline01. Getting Started with Microsoft PowerPoint02. Introduce to the interface of Microsoft PowerPoint03. Start Microsoft PowerPoint with blank document and pre-built template04. Use of Clipboard function under home menu in Microsoft PowerPoint05. Use of File Menu Function in Microsoft PowerPoint06. Tool of Font in formatting in MS PowerPoint07. Use of Paragraph tools in formatting in Microsoft PowerPoint08. Use of Drawing tools in Microsoft PowerPoint09. How to insert slides, table and pictures from insert menu in MS PowerPoint10. Use of illustrations tool under insert menu in Microsoft PowerPoint11. Use of Text tools under insert menu in Microsoft PowerPoint12. Usage of Design menu tools to design slides in Microsoft PowerPoint13. How to add transition in slides in Microsoft PowerPoint14. How to add animations in the slides in PowerPoint15. How to add Slide Show in Microsoft PowerPoint16. Use of tools available under review menu in Microsoft PowerPoint17. How to use view menu tools in Microsoft PowerPoint18. Tell me what you want to do tool in Microsoft PowerPointMicrosoft Access course outline01. Microsoft Access Database Concept Part - 102. Microsoft Access Database Concept Part - 203. Getting Started with Microsoft Access04. Use of different tools under file menu in Microsoft Access05. How to create database from template in Access06. How to update field properties in Access table07. How to set validation rule and list in the table fields of Microsoft Access08. How to do formatting work in Microsoft Access09. Manipulating tables and records in Access10. How to set up primary keys and indexes in table11. How to do filtering and sorting in Microsoft Access12. How to create relationship between tables in Microsoft Access13. How to create a Form and input data in table14. How to design a Form in Microsoft Access15. Process to create Query in Microsoft Access on specific requirements16. Process to create Report in Microsoft AccessI wish you all the best!

Overview

Section 1: Microsoft Windows Basic Training

Lecture 1 Introduction to Windows Desktop

Lecture 2 How to manipulate desktop Windows

Lecture 3 Introduction to Windows applications and the desktop

Lecture 4 Process to check basic information of PC

Lecture 5 Use of Windows File Explorer

Lecture 6 How to manipulate folder on Windows

Lecture 7 Process to remove pen drive safely from PC

Lecture 8 File manipulation process in windows

Lecture 9 How to compress and decompress file on Windows

Section 2: Microsoft Word Training

Lecture 10 Introduction to Microsoft Word Application

Lecture 11 Getting Started with Microsoft Word with blank document

Lecture 12 Start Microsoft Word document with a template

Lecture 13 How to manipulate text in Microsoft Word document

Lecture 14 Process to format text in Microsoft Word

Lecture 15 How to format paragraph in Microsoft Word

Lecture 16 How to use different Styles in Microsoft Word

Lecture 17 How to use Find and Replace tool in Microsoft Word

Lecture 18 How to use Insert menu tools in Microsoft Word

Lecture 19 How to Design Theme in Microsoft Word

Lecture 20 Process to Create and Design Table in Microsoft Word

Lecture 21 How to use view menu in Microsoft Word

Lecture 22 Process to do Mail Merge in Microsoft Word

Section 3: Microsoft Excel Training

Lecture 23 Getting Started with Microsoft Excel Application

Lecture 24 How to use Cut, Copy, Paste, and Format Painter in Excel

Lecture 25 Function of Font Tools under Home Menu

Lecture 26 Function of Alignment Tools under Home Menu

Lecture 27 Function of Number Tools under Home Menu

Lecture 28 Use of Style Tools under Home Menu

Lecture 29 Function of Cells tool under home menu

Lecture 30 How to use Editing Tools under Home Menu

Lecture 31 Process to Work with Multiple worksheet

Lecture 32 How to use tables under insert menu

Lecture 33 Usage of illustrator tool under the insert menu

Lecture 34 Process to use Charts & Sparkline's tool under insert menu

Lecture 35 Use of Pivot Table and Slicer in Microsoft Excel

Lecture 36 Function of text tool under insert menu

Lecture 37 Function of text & symbol tool under insert menu

Lecture 38 Functions of different tools under Draw menu

Lecture 39 How to set Page Layout in Microsoft Excel

Lecture 40 How to use different functions in Microsoft Excel

Lecture 41 How to Check and fix Function Errors in Microsoft Excel

Lecture 42 Use of Formula Auditing tools under Formula Menu in Excel

Lecture 43 Use of IF function in Microsoft Excel

Lecture 44 How to import data, sorting, filtering and remove data duplication in MS Excel

Lecture 45 How to use Data Validation tool in Microsoft Excel

Lecture 46 Text to Columns Process in Microsoft Excel

Lecture 47 What IF Analysis - Goal Seek for decision making in Microsoft Excel

Lecture 48 What IF Analysis - Data Table for decision making in Microsoft Excel

Lecture 49 What IF Analysis - Scenario Manager for Scenario Analysis in Microsoft Excel

Lecture 50 Data Forecasting Manually and Automatically in Microsoft Excel

Lecture 51 How to activate solver in Microsoft Excel for Data Analysis

Lecture 52 Use of Spelling checker tool under Review Menu in Excel

Lecture 53 How to use Thesaurus and Translate Tool in Excel

Lecture 54 How to use comments and Protection in Microsoft Excel

Lecture 55 Workbook Different Views in Microsoft Excel

Lecture 56 How to use Show and Zoom Tools in Microsoft Excel

Lecture 57 How to use Window Tools under view menu in Microsoft Excel

Lecture 58 How to activate Macro Tool in Microsoft Excel

Lecture 59 Tell me what to do Tool in Microsoft Excel

Section 4: Microsoft PowerPoint Training

Lecture 60 Getting started with Microsoft PowerPoint

Lecture 61 Introduce to the interface of Microsoft PowerPoint

Lecture 62 Start Microsoft PowerPoint with blank document and pre-built template

Lecture 63 Use of Clipboard function under home menu in Microsoft PowerPoint

Lecture 64 Use of File Menu Function in Microsoft PowerPoint

Lecture 65 Use of Font tools in formatting in MS PowerPoint

Lecture 66 Use of Paragraph tools in formatting in Microsoft PowerPoint

Lecture 67 Use of Drawing tools in Microsoft PowerPoint

Lecture 68 How to insert slides, table and pictures from insert menu in MS PowerPoint

Lecture 69 Use of illustrations tool under insert menu in Microsoft PowerPoint

Lecture 70 Use of Text tools under insert menu in Microsoft PowerPoint

Lecture 71 Usage of Design menu tools to design slides in Microsoft PowerPoint

Lecture 72 How to add transition in slides in PowerPoint

Lecture 73 How to add animations in the slides of Microsoft PowerPoint

Lecture 74 How to do Slide Show in Microsoft PowerPoint

Lecture 75 Use of tools available under review menu in Microsoft PowerPoint

Lecture 76 Tell me what you want to do tool in Microsoft PowerPoint

Section 5: Microsoft Access Training

Lecture 77 Microsoft Access Database Concept Part - 1

Lecture 78 Microsoft Access Database Concept Part - 2

Lecture 79 Getting started with MS Access

Lecture 80 Use of different tools under file menu in Microsoft Access

Lecture 81 How to create database from template in Microsoft Access

Lecture 82 How to update field properties in Access table

Lecture 83 How to set validation rule and list in the field of Microsoft Access

Lecture 84 How to do formatting work in Access

Lecture 85 Manipulating tables and records in Microsoft Access

Lecture 86 How to set up primary keys and indexes in table

Lecture 87 How to do filtering and sorting in Access

Lecture 88 Process to create relationship between tables in Microsoft Access

Lecture 89 How to create a form to input data in table in Microsoft Access

Lecture 90 Process to design a form in Microsoft Access

Lecture 91 How to create query in Microsoft Access on specific requirements

Lecture 92 How to create Report in Microsoft Access

Job Holders,Business Owners,Students,Trainers,Corporate personnel