MS EXCEL LAB.I. Spread Sheet Package: Data Entry in cells, Entry of numbers, text and formulae. Moving data in worksheet, Navigation in the worksheet using Interface (Tool Bars, Menus) - Editing Basics. Working with Work books Calculations (Formulae) and worksheets - Using auto fill Efficient data display with data formatting (Number, data Formatting etc.) Worksheet Printing (with Headers and Footers). Adding formatting text data with auto format. Creating embedded chart using chart wizard, sizing and moving parts - Using different types of charts and creating separate charts. Formatting charts, Printing Charts.
MS POWER POINT Presentation Software Slides preparation by wizards. Using animation and effects. Adding audio to the presentation. Slide show.
FOXPRO & MS ACCESS: 1. Exploring FOXPRO Menu system 2. Creating a Database file, Entering Records in a database file (APPEND) Using List Commands, Closing a database file. 3. Viewing and Editing Data, Usage of DISPLAY, LOCATE, BROWSE, EDIT, REPLACE, DELETE, RECALL, PACK, ZAP commands 4. SORTING & INDEXING: What is sorting? Sorting on Multiple fields, Disadvantages of Sorting. What is Indexing, Creating Index, and Reindexing using FIND, SEEK Commands. 5. PRINTING REPORTS & LABELS : Features of FOXPRO Reports Creating a Report format Saving, Generating and Previewing a Report Designing Mailing Address labels, Displaying and Printing Lables.
|