Duration-04 Months

Certificate In MS-Office

Fundamental of Computer

Computer & its feature, task of computer, peripherals devices, computer generation(description) memory & it measurement, commuter architecture ,binary & decimal conversion.

Networking

Networking, types of networking, topology, protocol, ISO-OSI model

Operating system

CUI(character User Interface)-Disk Operating System. GUI(graphic User Interface)-window7,window 8,window 10.

Window

Work with taskbar, task manager, work control panel, operating system accessories-notepad, WordPad ,paint.

Office automation (MS Office):2019,2021 and other upgraded version

Ms Word

Create a new document, open, save and print a document, Edit and format text, change the page layout, background and borders, format document, work with text object, work with References Insert headers and footers, Insert and edit tables, Insert clip art and pictures to document, Perform a mail merge, share and review shared document files. Project Work : Resume creation, form creation, and other professional document.

Ms – Excel

Introduction of excel workbook, shortcut key and various selection techniques, customizing Excel, Freezing panes. Using Basic Function: sum(), Average(), Max(), Min(), Count(). Mathematical function: Sumif(), Countif(), sumifs(). Other function: today(), now(), day(), date(), Upper(), Lower(), etc Formatting and proofing: Formating cell, Alignment, Border its, using conditional formatting. Managing worksheets: Data sorting & data Filtration, Excel sheet protection.

Advance Excel

Data Analysis, Goal seek, Data table (PMT Function), Logical function, data Validation, Lookup function, Pivort chart in excel chart various chart: Bar chart, pivot chart, pie chart, Line chart etc. Database function : Dsum(), Dcount(), Dmax(), Dmin() etc. Work with VBA Application(Project),Form Designing in VBA.

Power Point

Create presetation, work with colour & Theme in powerpoint, Insert clipart, Image, shapes to slide. Add sound & video, to a slide presentation, work with Animation in presentation, Final Preparation present a presentation.

Internet and Web design

Introduction of Browser, Domain name system. Work with Email : Email A/c creation & Email composing and file attachment. Online form felling and file attachment, online shopping. File upload and downloading.