Microsoft Office

Duration 3 Months

Course Fee ₹1,200

Eligibility Matric

Category Computer Courses

Basic Information

Microsoft Word: 1 Months

Microsoft Excel: 1 Months

Microsoft PowerPoint: 1 Months

Course Description

Microsoft Office Complete Course | All in one MS Office

Microsoft Office is a suite of productivity software, including applications for word processing, spreadsheets, and presentations. While the term "Microsoft Office" historically referred to a single purchase, it now primarily exists as part of the subscription-based Microsoft 365, which offers cloud-based features, online storage, and continuous updates. Key applications in the suite include Word, Excel, and PowerPoint

Course Syllabus

Module 1: Microsoft Word

1. Introduction to Microsoft Word Interface 2. Font Options in Microsoft Word - 01 3. Font Options in Microsoft Word - 02 4. Paragraph Formatting in Microsoft Word 5. Heading Styles in Microsoft Word 6. Editing Options in Home Tab 7. Clipboard & Format Painter Options in Microsoft Word 8. Page Insert Options in Microsoft Word 9. Inserting Tables in Microsoft Word 10. Insert Pictures in Microsoft Word 11. Shapes, Icons & 3d Models in Microsoft Word 12. SmartArt Options in Microsoft Word 13. Inserting Charts in Microsoft Word 14. Text Box & Drop Cap Options in Microsoft Word 15. Hyperlink in Microsoft Word 16. Header, Footer & Page Number Options in Microsoft Word 17. Equations & Symbols in Microsoft Word 18. Water Mark, Page Color & Page Border Options in Microsoft Word 19. Page Setup Options in Microsoft Word - 01 20. Page Setup Options in Microsoft Word - 02 21. Table of Contents & Table of Figures in Microsoft Word 22. Endnote & Footnote Options in Microsoft Word 23. Mailings Tab Options in Microsoft Word 24. Review Tab Options in Microsoft Word 25. View Tab Options in Microsoft Word 26. File Tab Options in Microsoft Word

Module 2: Microsoft Excel

Introduction to Microsoft Excel Interface 05:09 Basic Math Functions 06:46 AutoSum Functions 05:27 Sum IF Function & Remove Duplicates Option 09:17 Sum IF & Sum IFs, Count IF & Count IFs Functions 10:41 Sub Total Function 05:57 Arrays & Sum Product Functions 04:49 Other Math Functions 07:58 Cell or Range Name 02:25 Absolute & Relative References 04:40 Formatting Techniques in Excel 12:08 Excel Data Types 04:12 Roaming in Excel 05:43 Go to & Replace Options 05:27 Auto Fill Options 04:13 Flash Fill Option 05:50 Copy, Paste & Paste Special Options 07:07 Conditional Formatting 06:10 Sort & Filter 10:40 Excel Operators 08:53 Equations Solving in Excel 04:53 Errors in Excel Sheet 03:42 Logical Function IF 10:24 Logical Function IF Error 03:02 Logical Function (IF, Nested IF, OR) 11:09 Logical Function AND 10:12 VLOOKUP Function 03:51 VLOOKUP with Data Validation 05:19 VLOOKUP Function with Wildcard 05:26 VLOOKUP Function with Helper Column 04:08 Nested VLOOKUP 05:45 HLOOKUP Function 05:33 Quick Audit Using Charts 03:07 Sheet Formulas Auditing Tools 07:28 Selecting the Chart 05:53 Charts in Excel 08:21 Tables in Excel 04:29 Pivot Table & Chart 08:35 Sparklines & Slicer Filter Options 05:47 Inserting Comments 02:52 Inserting Hyperlink 05:27 Info Functions 02:53 Text Functions 04:28 Date, Time & Reference Functions 07:33 Printing & Viewing the Excel Sheet 09:54 Text to Columns Tool 03:54 Data Consolidation 09:15 Scenario Manager Option 10:15 Goal Seek Option 04:15 Data Table Option 04:38 Queries in Excel | Importing External Data 09:38 Dashboards 12:23 Form Controls 12:41 Recording & Using Macros 03:46 Creating & Using Macro Button 04:41 Visual Basic for Application (VBA) | Macro Coding

Module 3: Microsoft PowerPoint

1. Introduction to Microsoft PowerPoint Interface 2. Font & Slide Options in Microsoft PowerPoint 3. Paragraph Formatting in Microsoft PowerPoint 4. Drawing Tools in Microsoft PowerPoint 5. Editing Options in Home Tab 6. Inserting Tables in Microsoft PowerPoint - 01 7. Inserting Tables in Microsoft PowerPoint - 02 8. Inserting Pictures in Microsoft PowerPoint 9. Screenshot Option in Microsoft PowerPoint 10. Inserting Photo Albums in Microsoft PowerPoint 11. Inserting Icons in Microsoft PowerPoint 12. Inserting 3D Models in Microsoft PowerPoint 13. Inserting Smart Arts in Microsoft PowerPoint 14. Inserting Charts in Microsoft PowerPoint 15. Some Other Inserting Options in Microsoft PowerPoint 16. Inserting Videos in Microsoft PowerPoint 17. Audio & Screen Recording in Microsoft PowerPoint 18. Design Tab Options in Microsoft PowerPoint 19. Transitions Tab Options in Microsoft PowerPoint Animations Tab Options in Microsoft PowerPoint Slide Show Tab Options in Microsoft PowerPoint Review Tab Options in Microsoft PowerPoint View Tab Options in Microsoft PowerPoint 'Tell me what you want t do' bar in Microsoft PowerPoint Quick Access Toolbar & File Tab Options in Microsoft PowerPoint Built-in Presentation Templates in Microsoft PowerPoint

Microsoft Office

Basic Information

Course Description

Course Syllabus

Module 1: Microsoft Word

Module 2: Microsoft Excel

Module 3: Microsoft PowerPoint

Course Categories

Related Courses

Microsoft Office

Microsoft Office

Basic Information

Course Description

Course Syllabus

Module 1: Microsoft Word

Module 2: Microsoft Excel

Module 3: Microsoft PowerPoint

Course Categories

Related Courses

Tally Prime

Advance Diploma in Computer Application

Internet

Subscribe to Our Newsletter