ADVANCE CERTIFICATE IN MS-OFFICE ( S-ACMSO01 )

Gain an understanding of Microsoft Office, which includes advanced MS Word and MS Excel. In this course, you will learn the skills you will need to use the most popular word processing and spreadsheet software available. Learn to create new documents from scratch using the many formatting tools, or start with a supplied template to make your documents stand out. Simple demonstrations and easy instructor-led tutorials will guide you through the process from start to finish to make your computer life a bit easier and more enjoyable.

FUNDAMENTAL OF COMPUTER

1. Introduction :- What is computer, History of a computer; Shortcut Keys, Full form of Computer

2. Type of Computer :-  Based on Mechanism, Based on Size, Based on Purpose

3.Components of PC : - Computer System, Computer Hardware and Software

4. Input/Output (I/O) Devices: Input Devices, Output Devices

INTRODUCTION OF INTERNET

1. History of the WWW

2.LAN WAN & MAN

3. Creating an Email Account.

4. Browsers and Search Engines.

5. Surfing and Searching

MS OFFICE

1. MS Word :- Create Paragraph, Text Formatting, Change Case, Border, Page Border, Paragraph and Line Spacing, Styles & Editing, Create Table, Chart, Smart Art, Shapes, Hyperlink, Bookmark, Header & Footer, Text Box, Word Art, Object and Text from File, Page Setup, Page, Background, References, Mailings, Comment, Document View, Split Window, Show/Hide, Macro, Protect Document

2. MS Excel :- Introduction of Excel, Insert and Delete (Cells, Rows, Columns and Worksheet), Font, Alignment, Number Formatting, Hide & Unhide (Rows, Columns, and Worksheet), Workbook, Worksheet and File Protect, Customization, Data Fill, Merge Cells, Conditional Formatting, Formatting, Split Window, Freeze Panes

EXCEL FORMULAS:- 40 Count

Math Function (Sum, Round, Int, Mode) 

Stats Function (Count, Average, Max, Min)

Text Function (Upper, Lower, and Proper)

Logical Function (If, Count If, Count Ifs, Sum If, Sum Ifs, Lookup, Vlookup, Hlookup)

Salary Creation, Business Recept slip, and Mark Sheet

Sort, filter, group, and ungroup, remove duplicates.

QUALIFICATION : - 6th CLASS