Manual Accounting

• Accounting Principles

• Book Keeping

MS Excel

• Introduction to MS-Excel Interface

• Navigating Around in an Excel Spreadsheet

• Working on Simple Calculations

• Functions; Organize & Process Statistical, Mathematical, Financial & Logical Data

• Link Worksheets

Using Data Tab; Organize, Analyze & Present Data for various purposes

• Sorting

• Filtering

• Grouping

• Sub-Totalling

• Consolidate

Perform “what-if” & Data Analysis for Developing Financial, Marketing & Plans

• Scenario

• Goal Seek

• Data Table

Tools & Techniques to Process & Enhance the Usefulness of Data

• Data Validation

• Conditional Formatting

• Using Pivot-Table for Tabulating & Managing Data

• Translating Data Analysis into Meaningful Charts & Graphs

• Sheet Protection

• Printing Techniques