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 Hakim, Lecturer 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

    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

  • 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 of Participation

  • Admission Requirements

    Lower Secondary & Above with Basic Excel Knowledge

  • Course schedule (conducting days & time)

    5 October 2022

    9am - 5pm

  • What You'll Study

    USING EXCEL FOR BUDGETING AND SIMPLE DATA ANALYTICS

  • Course Fees and Funding

    Please refer to course brochure.

  • Contact for course enquiries

    Ms TEO SHALYNN, shalynn_teo@nyp.edu.sg, Tel No:65501094

  • Remarks

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

  • Attachments

    Course Brochure
    Company Sponsorship & SME/SP Declaration Forms