LearnWave
Learn it. Master it.
All books

Class 12

Accountancy: Computerised Accounting System

26 lessons in 4 chapters, explained in plain words.

Overview of Computerised Accounting System

  1. What a computerised accounting system is
  2. Features of CAS and grouping of accounts
  3. Codes for accounts
  4. Designing a coding structure
  5. Using CAS: security, advantages and limits
  6. The accounting information system

Spreadsheet

  1. Workbooks, worksheets and cells
  2. Values, formulas and what-if
  3. Functions, named ranges and IF
  4. Date, maths, text and logical functions
  5. Lookup functions
  6. Financial functions
  7. Entering and checking data
  8. Formatting and printing
  9. Data tables and pivot tables
  10. Error values and how to fix them

Use of Spreadsheet in Business Applications

  1. Payroll: earnings and deductions
  2. Building the payroll sheet
  3. Asset accounting and straight line depreciation
  4. Written down value and the fixed-asset schedule
  5. Loan repayment with PMT

Graphs and Charts for Business Data

  1. Graphs, charts and the first chart
  2. Parts of a chart
  3. Formatting a chart
  4. Pie, 3-D, radar and doughnut charts
  5. Why charts help, and the steps in full