Computer Application

Computer Application:-

Course objective:-

To equip student with basic of MS EXCEL application, required for planning & monitoring and

basics of MS Power Point functions required for making presentation.

Course Duration:-  90 Hours

MS EXCEL:-

Course Duration:- 46 Hours

Excel Quick Overview : Use of Excel, its boundaries & features. Data Formatting & Custom

settings : Number, Text, Date, Currency, Custom settings. Data formatting & cleaning. Conditional

Formatting : Once defined, it will automatically change color of values e.g. up or down, high or

low, pass or fail, profit or loss etc. Filters & Data Sorting : Drill down your data to your desired

level. Formula Writing & Fixing Errors: Logical, Day and Time, Mathematical etc Sum, Average,

Count, Minimum, Maximum, Round etc. If-Then-Else & Nested If commands : Produce different

set of results based on slabs, conditions. Vlookup / Hlookup : You have large amount of data

placed at different locations & you want to merge it based on common values & it’s relevance.

Graphs & Charts : In this workshop you will learn how to create, modify & update graphs / charts

like Column, Line, Pie, Bar, Area, Scatter, 3D etc. Grouping - Ungrouping : Sometime data needs

to be grouped for summarized results & crisp view. Grouping & ungrouping feature will help you

do so.

MS Power Point:-

Course Duration:- 44 Hours

Power Point Overview : Overview of MS word in terms of Screen layout, Menus, The Ribbon,

Quick Access Toolbar etc. Creating a Presentation : You can start a new presentation from a

blank slide, a template, existing presentations, or a Word outline. Formatting Presentation :

Working on fonts, styles, effects, Word art, Alignment, Text direction etc. Simple Presentation :

Creating general presentation by using templates etc. These presentations are system built and easy

to use and create. Adding Graphics : Adding pictures, Clip Art, Shapes, Smart Art, Photo album

etc. These graphics can be animated. Adding Tables : Creating tables, modifying structure,

Inserting Table from Word or Excel to prevent the rework. Tables can be modified and used in a

colorful manner. Adding Animation : Slide effects, Slide Transitions, Slide Animations,

Animation Preview, Setting up slide show. Adding Charts : Creating chart, editing chart, Chart

tools etc. Copying charts from Word and Excel etc. Adding Notes : As a speaker you can add

notes to presentation so you could refer to those notes while presentation. Printing Tips : Creating

speaker notes, Handouts etc. Tips on printing slides and handouts. Slide Sorter : Sort slides based

on the requirement.