USING EXCEL FOR BUDGETING AND SIMPLE DATA ANALYTICS

  • USING EXCEL FOR BUDGETING AND SIMPLE DATA ANALYTICS

    About the Course

    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

    1. Using Relative vs Absolute Referencing in Excel
    2. Using Scenario Manager and Goal Seek to assess investment plans
    3. Linking Excel to external data such as stock prices/interest rates
    4. Introduction to slicers to filter and view data
    5. Cleaning and manipulating text and data in Excel
    6. Preparing interactive dashboards and charts

  • Target Participants

    The course is suitable for individuals or Sole Proprietors with basic knowledge of Excel and wish to upskill their knowledge in this area.

  • Certification

    Certificate in Participation

  • Admission Requirements

    Lower Secondary & above with basic knowledge in Microsoft Excel

  • Course schedule (conducting days & time)

    03 August 2018

    9.00am – 5.00pm

     

  • What You'll Study

    USING EXCEL FOR BUDGETING AND SIMPLE DATA ANALYTICS
  • Course Fees and Funding

    Fee Type Fee Payable (incl GST)
    Full Fee $214.00
    SC aged 50 & above: Fee Payable after NSA Grant $114.00
    Course is SkillsFuture credit eligible for self-funded individuals

  • Contact for course enquiries

    Ms TEO SHALYNN, shalynn_teo@nyp.edu.sg, Tel No:6550-1094

  • Remarks

    NYP reserves the right to reschedule/cancel any prog and amend the fees/info without prior notice.