About Course
Microsoft Office applications are a versatile productivity tool suite that empowers individuals and organizations to create, communicate, collaborate, and organize information effectively. From creating documents and presentations to managing data and communication, Microsoft Office offers comprehensive applications to streamline workflows and boost productivity.
To leverage the full potential of Microsoft Office, individuals should focus on mastering the following key applications and skills:
What will You Learn?
Microsoft Word:
- Introduction Microsoft Word
- Folder Create, Word Document File Create, English Typing, and Bangla Typing
- All Types of Text Formatting (Font Size Style Change, Font Size Change, Font Color, Bold, Italic and Underline)
- Page Layout, Page Size(A4, Legal, Letter)
- Page Watermark, Page Border, Page Color
- Table of Contents Project
- Table Create and Table Project
- Admission Form Project
- Personal CV Project
Microsoft PowerPoint:
- Introduction to Microsoft PowerPoint
- PowerPoint File Creation
- PowerPoint Slide Layout, Different Slide Page Size
- PowerPoint Slide Custom Design
- PowerPoint Presentation Project Creation
- PowerPoint Slide Animations and Transitions Effects
- Auto PowerPoint Presentation Slide Show
Microsoft Excel:
- Introduction Microsoft Excel
- Excel Worksheet File Creations
- Excel Worksheet File A to Z Overview
- Excel Ribbon, Tabs & Groups, Name box, Formula Bar, Rows and Column, Cells, Worksheet, Selection Tool, Moving Tool, Fill Handle Tool, Navigation Bar.
- Basic Excel Cell and Columns and Rows Manage
- Basic Excel Data Navigation and Data Entry
- Excel Number Formatting
- Conditional Formatting
- Data Sort and Filter
- Data Validation and Drop downlist
- Basic Excel Formulas and Functions (SUM, MIN, MAX, AVERAGE, Auto Sum, Logical Function IF, AND, OR, Etc.)
- Excel Relative vs Absolute Cell References
- School Result Sheet Project
- Salary Sheet Project
- Sales Summary Commission Project
- Basic Pie Chart, Line Chart, Column Chart Creation Excel
- How to Print Excel File (Bonus)
Who Is This Course For?
- Students preparing for academic and professional careers
- Professionals seeking to improve their office software skills
- Business owners wanting to improve operational efficiency
Course Outcomes:
Upon completing this course, learners can efficiently use word processing software to create professional documents, analyze and visualize data using spreadsheet applications, Deliver compelling presentations using advanced features, and collaborate effectively with colleagues and peers.
Join us and become proficient in Microsoft Office applications today!
Course Content
Office Applications Online Courses
File-Folder Create and Introduction to Word
08:14Text & Paragraph Formatting
12:31Sentence Case Change, Bullets Points, Text & Paragraph Shading
09:19Text & Paragraph Bordering, Cover Page, Blank Page & Page Break Insert
05:54How to Insert Table in MS Word & Table Design
08:58How to Make Complex Table with Draw Table in MS Word
14:22Attendance Sheet Table Project
10:08How to Insert Image in MS Word
17:59How to Insert Water Mark, Page Color, Page Border & Page Numbering in MS Word
15:47MS Word Admission Form Project
15:56How to Insert Mathmatical Equation in MS Word
11:35Professional CV Project in MS Word Part-1
09:14Professional CV Project In MS Word Part-2
09:10Email Writing & Internet Browsing
12:56Table Of Contents
14:20Introduction to MS PowerPoint and Create Slide
10:22PowerPoint Slide Design and Content Insert into Slide
13:35How to Apply Animation & Transition in MS PowerPoint
10:18Introduction to MS Excel
11:23How to Use Formula & Function in MS Excel
11:41MS Excel School Result Sheet Project
10:24MS Excel Salary Sheet Project
11:34MS Excel Sales Commission Project
00:00MS Excel Count Function & Relative vs Absolute Cell Reference
10:11MS Excel SSC Board Result Sheet Project
19:31MS Excel Cell Formatting Using Format Painter Tool
09:25MS Excel Cell Formatting Using Themes
09:54MS Excel Find Select & Replace , Data Sorting & Filtering
09:28MS Excel Conditional Formatting
09:07How To Insert Pie Chart, Line Chart and Column Chart in MS Excel
08:10Large & Small Function in MS Excel
10:21Concatenate Functions in MS Excel
09:39MS Excel SUMIFS & COUNTIFS Function Apply
00:00MS Excel Vlookup Functions Apply
10:18MS Excel Data Validations & Dropdown List Making
11:44How to Print in MS Excel
08:54