Topic outline

  • Basic Budgeting on Excel

    Basic Budgeting on Excel

    Budget might be defined as an estimate of income and expenditure for a set period of time. If you need financial security and sustainability for health of your financial position, the importance of budget cannot be overemphasized as a budget forces you to map out your goals, save your money, keep track of your progress, and make your dreams a reality. At the personal level, most important benefit that you can receive from a budget is that it helps you make sure you don’t spend the money that you haven’t earned yet so you won’t have any liability that you cannot afford.
    No matter in a business or only at a personal level, budgeting allows to create a spending plan for money on hand and you will always have enough money for the things you need. Thanks to the technology, there are many tools available to create and sustainably use There are smart phone applications as well as computed based software. One of the available options is Excel budget templates for individuals and business where you can easily develop your budget, formulate the cells and keep track of your budget over time.

    COURSE INFORMATON

    Course Code - Title

    TEL210- Basic Budgeting on Excel

    Prerequisites

    No

    Language of Instruction

    English

    Language of Subtitles

    Turkish, Spanish, Bask, Greek, Dutch, Italian

    Who this course is for:

    Technological Literate

    Course Type

    Optional

    Course Coordinator

    AU

    Instructor

    Ummugulsum ZOR

    Email

    gulsumalici@gmail.com

    Description

    In this lesson, you will learn how to develop a budget by using Microsoft Excel and how to use it as a control tool

    Course Content

    1) Introduction and syllabus
    2) Income, Cost and Expense Forecasting
    3)Formulation for control
    4) Variance analysis
     5) Creating and reading budget graphs