| Topics for practical |
1. Introduction to Spreadsheet:
Data entry using spreadsheet:
Text, Number, Formula, Function, Auto fill, Auto Correct and Data Validation
Using Total and Subtotal:
+, sum() , Quick sum, subtotal(), sumif(), conditional sums, sorting of data |
2. Advance functions:
Lookup(), HLOOKUP(), VLOOKUP(), date functions, numeric functions, string functions, Index(), Match()
Financial Functions |
3. Using paste special:
To demonstrate different types of paste options available in paste special. |
4. Analysing Data:
Data tables
Scenarios
Goal Seek |
5. Pivot Table:
Creating a Pivot Table
Layout of the PivotTable |
6. Auditing Tools:
Auditing Toolbar
Documenting a Sheet
Migrating Data from Other Software
Common Audit Techniques |
7. Application of spreadsheet:
Creating Balance Sheet and Balance Sheet Summary
Creating Income Statement and Income Statement Summary
Creating Cash Flow Statement and Cash Flow Statement Summary |
8. General Ledger:
Creating a General Ledger |
9. Loan Amortization:
Create a Loan Amortization table using the PMT function |
10. Automate common tasks using Macros:
Using Global Macros (download and use Currency conversion, Number to Word conversion etc)
Creating own Macros (Income tax & GST Macros) |