Using Excel for Budgeting and Simple Data Analytics (National Silver Academy Courses)

(SkillsFuture Credit applicable subject to Terms & Conditions) 

  • Course Aims

    The objective of the course is to equip participants with the ability to leverage on Excel to manage company or personal expenses, investment and other financial matters. Participants will also learn how to prepare interactive dashboards with charts and slicers.
  • Course Outline

    • Using Relative vs Absolute Referencing in Excel
    • Using Scenario Manager and Goal Seek to assess investment plans
    • Linking Excel to external data such as stock prices/interest rates
    • Introduction to slicers to filter and view data
    • Cleaning and manipulating text and data in Excel
    • Preparing interactive dashboards and charts
  • Course Fees

    Singapore Citizens 50 years old & above: $114.00 (Incl. Gst)

    Singapore Citizens below 50 years old: $214.00 (Incl.Gst)

    Course is SkillsFuture credit eligible for self-funded individuals

     

  • Entry & Application

    Duration : 7 hrs

    Class Date : 29 Mar 19 (9am – 5pm) 

    Class Size : 15 - 20

    Application Close: 22 Mar 19