Microsoft Office Specialist

By bitizens.net Categories: Computing & Informatics

Wishlist

About Course

0540 | MOS

Course Content

Microsoft Windows
Students learning the basics of windows, this includes exploring the windows environment, navigation and settings

Introduction to Computers

00:00
Lesson 2: Computer Components Identification

00:00
Lesson 3: Computer Ports

00:00
Lesson 4: Operating Systems

00:00
Lesson 5: Understanding Applications

00:00
CA-1

File Management
Students learning file creation, different file extensions, file organization using folders

Microsoft Word
Exploring Word, Using Basic Document Skills, Using Formatting, Checking Spelling & Grammar, Managing Lists, Customizing Tables & Charts, Customizing Formatting With Styles And Themes, Modifying Pictures, Creating Customized Graphic Elements, Controlling Text Flow, Using Templates To Automate Document Creation,

Lesson 1: Introduction

00:00
Lesson: Creating a New Document Practical Exercise

00:00
Lesson 3: Paragraph Tools Practical Exercise

00:00
Lesson: 4 The Insert Tab, Practical Exercise

00:00
Lesson: Insert Tab, Practical Exercise

00:00
Lesson 6: Design Tab, Practical Exercise

00:00
Lesson 7: Page Layout Tab, Practical Exercise

00:00
Lesson: Practical Exercise 3

00:00
Lesson 9: Exercise 4

00:00
Lesson 10: Practical Exercise 5

00:00
Lesson 11: Practical Exercise 6

00:00
Lesson 12: Practical Exercise 7

00:00
Lesson 13: Practical Exercise 8

00:00
Lesson 14: Practical Exercise 9

00:00
CA-3
Assignment 17-JULY

00:00
MS Word Assignment

Microsoft Excel
Calculating Data With Advanced Formulas, Organizing Worksheet And Table Data, Presenting Data using Charts, Analyzing Data Using Pivot Tables And Pivot Charts, Inserting Graphic Objects, Customizing And Enhancing Workbooks And The Excel Environment, Streamlining Workflow, Analyzing Data, Working With Multiple Workbooks, Importing And Exporting Data, Using Excel With The Web

Lesson: Introduction

00:00
Lesson 2: Understanding cells

00:00
Modifying column width

00:00
AutoFit column width

00:00
Modify Row Height

00:00
Modify all Rows or Columns

00:00
Inserting, Deleting, Moving, and Hiding Cell

00:00
Deleting a Row or Column

00:00
Moving Row and Column

00:00
Hide and Unhide a Row or Column

00:00
Wrap Text Automatically

00:00
Merge cells in Excel

00:00
Number Formats

00:00
Working with Multiple Worksheets

00:00
Using Find & Replace

00:00
Page Layout and Printing

00:00
Introduction to Formulas

00:00
Order of Operations

00:00
Relative References

00:00
Absolute References

00:00
Terms in Excel

00:00
Arguments

00:00
Formulas and Functions Practical Exercises

00:00
Freezing Rows and Columns

00:00
Single Level Data Sorting

00:00
Multi-Level Data Sorting

00:00
Sorting Dates Data

00:00
Filtering Data

00:00
Groups and Subtotals

00:00
Creating Tables

00:00
Creating a Chart

00:00
Excel Bar Charts

00:00
Conditional Formatting

00:00
Inspecting and Protecting Workbooks

00:00
Pivot Tables

00:00
What-If Analysis with Data Tables in Excel

00:00
Excel CA-P1

Microsoft PowerPoint
Creating A Custom Design Template, Adding Organization Charts And Diagrams, Adding Special Effects, Creating Web Presentations, Collaborating In PowerPoint, Delivering A Presentation, Editing Presentation Masters, Presenting To A Wider Audience

Microsoft Access
Exploring the Microsoft Access Environment, Designing a Database, Building a Database, Managing Data in a Table, Querying a Database, Designing Forms, Generating Reports

Microsoft Publisher
Creating A Basic Publication, Modifying A Publication's Layout And Structure, Editing Content In A Publication, Formatting A Publication, Formatting Pictures In A Publication, Preparing A Publication For Distribution

Web Apps
Google Docs Google Drive

Basic English Language
Nouns, Pronouns, Adjectives, Determiners, Verbs and Tenses, Auxiliary Verbs, Adverbs and Adverb Phrases, Prepositions and Prepositional Phrases, Conjunctions, Sentences, Direct and Indirect Speech, Punctuation

Basic Business Mathematics
Basic Business Maths calculation to help you better manage your day to day activities in Business and other areas of the society.

Student Ratings & Reviews

No Review Yet

Microsoft Office Specialist

About Course

What Will You Learn?

Course Content

Microsoft Windows Students learning the basics of windows, this includes exploring the windows environment, navigation and settings

Introduction to Computers

Lesson 2: Computer Components Identification

Lesson 3: Computer Ports

Lesson 4: Operating Systems

Lesson 5: Understanding Applications

CA-1

File Management Students learning file creation, different file extensions, file organization using folders

Lesson 1: File Management

Lesson 2: File Extensions

CA-2

Lesson 1: Introduction

Lesson: Creating a New Document Practical Exercise

Lesson 3: Paragraph Tools Practical Exercise

Lesson: 4 The Insert Tab, Practical Exercise

Lesson: Insert Tab, Practical Exercise

Lesson 6: Design Tab, Practical Exercise

Lesson 7: Page Layout Tab, Practical Exercise

Lesson: Practical Exercise 3

Lesson 9: Exercise 4

Lesson 10: Practical Exercise 5

Lesson 11: Practical Exercise 6

Lesson 12: Practical Exercise 7

Lesson 13: Practical Exercise 8

Lesson 14: Practical Exercise 9

CA-3

Assignment 17-JULY

MS Word Assignment

Lesson: Introduction

Lesson 2: Understanding cells

Modifying column width

AutoFit column width

Modify Row Height

Modify all Rows or Columns

Inserting, Deleting, Moving, and Hiding Cell

Deleting a Row or Column

Moving Row and Column

Hide and Unhide a Row or Column

Wrap Text Automatically

Merge cells in Excel

Number Formats

Working with Multiple Worksheets

Using Find & Replace

Page Layout and Printing

Introduction to Formulas

Order of Operations

Relative References

Absolute References

Terms in Excel

Arguments

Formulas and Functions Practical Exercises

Freezing Rows and Columns

Single Level Data Sorting

Multi-Level Data Sorting

Sorting Dates Data

Filtering Data

Groups and Subtotals

Creating Tables

Creating a Chart

Excel Bar Charts

Conditional Formatting

Inspecting and Protecting Workbooks

Pivot Tables

What-If Analysis with Data Tables in Excel

Excel CA-P1

Microsoft PowerPoint Creating A Custom Design Template, Adding Organization Charts And Diagrams, Adding Special Effects, Creating Web Presentations, Collaborating In PowerPoint, Delivering A Presentation, Editing Presentation Masters, Presenting To A Wider Audience

Microsoft Access Exploring the Microsoft Access Environment, Designing a Database, Building a Database, Managing Data in a Table, Querying a Database, Designing Forms, Generating Reports

Microsoft Publisher Creating A Basic Publication, Modifying A Publication's Layout And Structure, Editing Content In A Publication, Formatting A Publication, Formatting Pictures In A Publication, Preparing A Publication For Distribution

Web Apps Google Docs Google Drive

Basic English Language Nouns, Pronouns, Adjectives, Determiners, Verbs and Tenses, Auxiliary Verbs, Adverbs and Adverb Phrases, Prepositions and Prepositional Phrases, Conjunctions, Sentences, Direct and Indirect Speech, Punctuation

Lesson: Nouns

Exercise 1

Lesson 2

Basic Business Mathematics Basic Business Maths calculation to help you better manage your day to day activities in Business and other areas of the society.

Student Ratings & Reviews

Your Instructor

Microsoft Windows
Students learning the basics of windows, this includes exploring the windows environment, navigation and settings

File Management
Students learning file creation, different file extensions, file organization using folders

Microsoft PowerPoint
Creating A Custom Design Template, Adding Organization Charts And Diagrams, Adding Special Effects, Creating Web Presentations, Collaborating In PowerPoint, Delivering A Presentation, Editing Presentation Masters, Presenting To A Wider Audience

Microsoft Access
Exploring the Microsoft Access Environment, Designing a Database, Building a Database, Managing Data in a Table, Querying a Database, Designing Forms, Generating Reports

Microsoft Publisher
Creating A Basic Publication, Modifying A Publication's Layout And Structure, Editing Content In A Publication, Formatting A Publication, Formatting Pictures In A Publication, Preparing A Publication For Distribution

Web Apps
Google Docs Google Drive

Basic English Language
Nouns, Pronouns, Adjectives, Determiners, Verbs and Tenses, Auxiliary Verbs, Adverbs and Adverb Phrases, Prepositions and Prepositional Phrases, Conjunctions, Sentences, Direct and Indirect Speech, Punctuation

Basic Business Mathematics
Basic Business Maths calculation to help you better manage your day to day activities in Business and other areas of the society.