Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel for Accounting and Bookkeeping
Rating: 4.4 out of 5(96 ratings)
1,285 students

Excel for Accounting and Bookkeeping

Be Your Own Accountant By Developing Your Own Accounting Template
Created byNiran Marshall Perera
Last updated 1/2018
English

What you'll learn

  • How to develop a Life Time Accounting Template
  • Basic Accounting Principles
  • Useful Excel Tricks Related to Accounting

Course content

1 section • 30 lectures • 2h 57m total length

  • Introduction1:39
  • Process of the Course0:49
  • Elements of Accounting2:57
  • Ledger Accounts Introduction1:07
  • Double entry theory description1:53
  • Ledger Accounts Template Development9:33
  • Transaction Recording Example1:25

    Record a cash capital investment of 1,000 using double-entry in ledger accounts; debit cash (asset) and credit capital, with the description showing the counter account.

  • Recording Transactions To Our Template35:09
  • Ledger Accounts Formatting4:49
  • Normal Account Balances1:26
  • Ledger Account Balancing Introduction2:20
  • Ledger Account Balancing Template18:37
  • Trial Balance Introduction1:00
  • Trial Balance Template16:11
  • Income Statement Introduction3:34

    Explore how the income statement lists sales, subtracts cost of sales and expenses, adds other income, and shows net profit or loss after tax for a period.

  • Income Statement Template12:39
  • Statement of Financial Position Introduction3:46
  • Statement of Financial Position Template8:54
  • Trial Balance Link with Income Statement and Statement of Financial Position12:25
  • Alternative Income Statement Introduction1:01
  • Alternative Income Statement Template6:55

    Create an alternative income statement in Excel, recording revenue and gains, subtracting expenses and losses to reveal profit or loss, with conditional formatting and a financial position statement.

  • Alternative Statementof Financial Position Introduction1:20
  • Alternative Statementof Financial Position Template4:37
  • How to Link Trial Balance With Alternative Financial Statements9:28
  • Charts Introduction1:00
  • Revenues Chart4:28
  • Expenses Chart3:27

    Develop an expense chart in Excel using a 3d pie chart, move it to a new worksheet, and refine data labels to show percentages, including the advertising cost of 5000.

  • Assets Chart2:34
  • Liabilities Chart1:58
  • The End + Accounting Template0:42

Requirements

  • Ability to understand simple English language.
  • Desire to develop an Accounting Template on Your own and become your own Accountant
  • Desire to learn basics of Accounting Principles and Basic Excel Tricks

Description

This course is designed to teach anyone who enroll to develop an Accounting Template on their own. Course will Start with the discussion of, Basic Accounting Principles So the follower of the Course will have Basic idea about the Accounting Concepts which will be useful in the creation of the Accounting Template.

Then Instructor will explain step by step how to develop an Accounting Template Starting from drawing Ledger Accounts to setting up Outputs such as Income Statement and Statement of Financial position.

Most attractive feature of the target Accounting Template is that it is a life time template without any maintenance and upgrade cost you can use over and over without any additional cost, so why pay more for Accounting software’s when you can develop your own Accounting Template which you customize based on your preferences and needs.

Template is set in Such a way once you input transactions in Ledger Accounts and Link with Trial Balance Template will generate Income Statement and Statement of Financial Position and Linked Charts, in next accounting period all you have to worry about new transactions which need new accounts but with the knowledge of Basic Accounting principle user will able to link new accounts.

This course will be a Three in one Package since user will have a self-developed Accounting Template and will have a knowledge about Basic Accounting Principles and Excel tricks related Accounting Template.

So enroll and develop your own Accounting Template and be your Own Accountant…..

Good Luck…

Who this course is for:

  • No specific target student anyone can enroll and learn how to make an Accounting Template your own and be your Own Accountant

Report abuse