Module – 1
Manual Accounting
- Commonly Accepted 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 PivotTable for Tabulating & Managing Data
- Translating Data Analysis into Meaningful Charts & Graphs
- Sheet Protection
- Printing Techniques
Functional Communication
- Understand the Importance of Effective Communication
- Verbal Communication – Smart Talk
- Communicate effectively Over Telephone
- Write Right – Thumb Rules
- Office & Business Correspondence
