Training Workshops

Aligned with our mission to be the IT training hub in NUS, we are committed to providing highly-demanded training workshops to our NUS community. In every semester, we equip our members with the necessary skills and knowledge needed before embarking with them to spread their knowledge to the NUS community. Most our workshops are 3-hours long, except for several specialized workshops.

For workshop registration, we will be using NUSync, a platform for NUS students. You can access the NUS Student Union’s portal in NUSync and look for our events.

Once you have registered via NUSync, do remember to make the $5 refundable deposit payment. Deposit has to be submitted to NUSSU Secretariat, YIH Monday to Wednesday on the week of the respective workshop on office hours (1000 – 1800, minus the lunch time on 1300 – 1400). Deposit for each workshop must be done separately, each during the week of the workshop itself. The deposit will be returned upon attendance to the workshop.

To go to NUSSU Secretariat: in Yusof Ishak House, from the entrance of the Study Room, go towards Student Lounge. On your left, there will be a lot of stairs. Just keep on climbing until the 5th floor. In the right, there will be a sign saying “NUSSU Secretariat”.

If you have any queries, check out our Workshops FAQ, kindly approach our supervisor at YIH Computer Centre or feel free to contact us at trainingcell@nussucommit.com.

Microsoft Excel

Microsoft Excel has been the all-time favorite software for data handling through the use of its versatile spreadsheet layout. Be it to create simple tables and charts, or to handle massive financial records and experimental results, Microsoft Excel is able to manipulate these data into usable information with ease.

Our workshop will cover these topics which will bring you from the introductory page to the basic functions and manipulations in Microsoft Excel:

  • Navigation and Interface
  • Basic Formulas
  • Cell Formatting
  • Data Processing (Paste Values, Sort, Filter)
  • View (Freeze Panes, Page Break View)
  • Charts and Graphing
  • Protect
  • Pivot Table and Pivot Chart
  • Functions (IF, HLOOKUP, VLOOKUP)

Our Excel Workshop will be held on Saturday, 16 September 2017, 0930–1330 on ThinkLab, Computer Centre Level 3.

Adobe Photoshop CC

The premier and leading graphics-editing software in the world. Used by professional graphic designers to amateur photographers, the Photoshop skill has proven to be vital in differentiating oneself. Be it to create viral, hoax photos or beautifying one’s looks, we are there to provide you with the necessary skills.

  • Navigation and Interface
  • Basic Tools (Text, Brush, Eraser)
  • Selection Tools
  • Introduction to Layers
  • Layer Masking
  • Layer Style
  • Layer Blending Modes
  • Healing Tools, Dodge, Burn, Blur, Sharpen
  • Selective Adjustments
  • Filter, Liquify

Our Photoshop Workshop will be held on Saturday, 14 October 2017, 1000–1600 on ThinkLab, Computer Centre Level 3.

Adobe Illustrator

Another one from the Adobe family, the world’s best digital editing software, Illustrator is the go-to program for professional vector drawing and editing. Create scalable vector artwork with no loss of resolution for use both in print and digital form using Illustrator. In this workshop, we will be teaching the essentials of the software Illustrator and practicing a simulation of the workflow of a graphic designer – from paper to screen.

  • Navigation and Interface
  • Tools Panel
  • Building Shapes
  • Lines, Curve and Sketching
  • Image Tracing
  • Effects

Our Adobe Illustrator Workshop will be held on Saturday, 28 October 2017, 1000–1600 on ThinkLab, Computer Centre Level 3.

Website Design

We live in a world surrounded by websites, be it searching information from Google or updating your Facebook pages. Sometimes, the magic behind the websites are the seemingly unlimited yet intriguing designs & interfaces in front of your computer screens. Surprisingly, most of these designs relies on basic strings and codes which let you program your website interface with high degree of freedom. Therefore, understanding the basic HTML and CSS codes are essential to design your own website.

Our website design will introduce you to HTML and CSS and some basic template editing so that you can start supplying contents to your own personal website. We expect you to be able to read and understand how webpages are displayed in your browser after the workshop, and play around with them. You will also be able to create your own website using a pre-existing template by playing around with its raw HTML code.

Our Website Design Workshop will be held on Semester 2. Subscribe to our mailing list to receive the latest update on our incoming workshop.

Excel VBA

Excel Visual Basic for Applications is a highly-demanded software, long-demanded by the NUS community. Excel VBA is the most overlooked, useful feature in MS Excel. It is a specified required skill by many business firms as well as engineering firms. Programming with VBA allows spreadsheet manipulation that is awkward or impossible with standard spreadsheet techniques.
Next semester (AY17/18 Sem 2), we will be hosting a special 2-day workshop for Excel VBA. External professional trainers from Acadia training company will be conducting the workshop and you will receive a certificate upon completion of the workshop. The workshop will cover these following topics:

Introduction to VBA

  • The Excel Developer Tab
  • Change Macro Security Settings
  • VBA Macro Security Settings
  • The VBA Environment
  • The Visual Basic Editor
  • Saving VBA Codes In Excel
  • The Standard Toolbar

User Forms & Modules

  • Creating And Removing A User Form/Module
    • To Add A User Form / Module
    • To Remove A User Form / Module
  • The View Object Mode And Toolbox
  • Manipulating Objects In A User Form
  • Naming Objects
  • Activating A User Form
  • Writing Simple Codes

Variables & Data Types

  • Visual Basic Data Types
  • Understanding Variables
  • Scope Of Variables

VBA Codes

  • The Msgbox Function
  • Setting Objects Properties
  • Positioning The Excel Activecell Cursor With Codes
  • Retrieving The Content Of An Activecell
  • Populating A Combobox With Default Values
  • If–Then–Else Statement
  • Comparison Operators
  • Select Case Statement
  • The Offset Method
  • Do Until Loop
  • User-Defined Functions & Sub Procedures
    • Arguments
    • Passing Arguments By Value and By Reference
    • Calling VBA Functions & Sub Procedures

Our VBA Codes Workshop will be held on Semester 2. Subscribe to our mailing list to receive the latest update on our incoming workshop.

(If you wish to be updated on our workshops or events, you can subscribe to our mailing list by dropping us an email at nussu.commit@gmail.com)