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.

    Trainer Profile:

    Nasrul joined NYP in early 2018 and teaches Business Analytics, Business Software Applications and Design Thinking modules. Prior to joining Nanyang Polytechnic, Nasrul was in the IT and Digital Media Industry since 2001 in multiple roles, from software development, to project management and business development. Major projects Nasrul contributed to while in industry include those with Temasek Holdings, SAP, CA Technologies, Cisco Systems, Hewlett Packard and Nokia.

    Nasrul graduated with a BSc Degree (2nd Upper Honours) in Information Management, Diplomas in IT and Multimedia and is currently pursuing an MSc in Information Systems at Nanyang Technological University. 

  • 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.

  • Admission Requirements

    Lower Secondary & Above with Basic Excel Knowledge

  • Course schedule (conducting days & time)

    27 September 2019

    9am - 5pm

  • What You'll Study

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

    Please refer to course website.

  • 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.