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.
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.
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.
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.
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