534
Page views
0
Files
0
Videos
0
R.Links

Icon
Syllabus

UNIT
1
MS Word and MS Power Point

Word: Create, Modify and Save Word Document, Manipulate Tabs and Margins, Insert Comments, Bookmarks, Create and Edit Styles. Merge Documents, Create and Modify Tables, Sort Records, Using Pictures and Charts, Mail Merge, Generate Labels. PowerPoint: Creating Presentations, Hyperlink, Apply Design Template, Slide Transitions, Custom Animation, Speaker Notes, Print Handouts, Screen Navigation Tools.

UNIT
2
MS Excel

Excel: Create, Modify and Save a Spreadsheet, Using Templates, Using Multiple Workbooks, Formatting Numbers, Report Manager, Computations in Cells, Summary Functions, Conditional Formats, Appearance/ Format of Text and Numbers in Cells, Sorts, Data Filters , Create Graphs and Charts ,Modify Charts.

UNIT
3
Excel for Managers

Max functions- SUM, COUNT, IF, AVERAGE-MAX ,MIN-SIDDEV,VAR-ABS,EXP,INT-LOG 10 AND LOG-ROUND ,SQRT-calculate simple and compound interest- use auto sum-perform sort and filter-alphabets, numeric- conditional formatting using logical( IF /AND/OR/NOT)-execute financial functions( PMP/FV, NPER/RATE)-pivot tables- group pivot table items, multilevel pivot table frequency distribution, pivot chart- basic concepts related with user defined macros by automating recording a macro.

UNIT
4
MS Access

Access: Create Database, Table Relationship, Primary Key, Modify Field Properties, Find and Sort Records, Data Types, Create and Modify Forms, Enter Records Using Form, Delete Records From Table, Control Toolbox , Calculated Control, Apply and Remove Filters, Create Calculated Field , Create Report, Format Properties , Query.

UNIT
5
Tally

Creating Company, Group Ledger, Voucher, Journal, Contra, Sales, Purchases, Credit Note, Debit Note, Receipt, Payment, Report Generation.

Reference Book:

 OFFICE 2000 Complete – BPB  Windows 98 Complete – BPB  Windows 98 6 in one by Jane Calabria and Dorothy Burke – PHI  Using Microsoft Office 2000 by Ed, Bott – PHI  Enterprise Resource planning (ERP): Text and case studies by Murthy, C S V, HPH  Teach yourself SAP in 24 hours by George Anderson; Danielle Larocca - Pearson Education  Photoshop 7 Basic Skills 1 for Windows by Element K Press

Text Book:

 OFFICE 2000 Complete – BPB

 

Print    Download