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 new platform for NUS students. You can access the NUS Student Union’s portal there and look for our events.

Once you have registered via NUSync, do remember to make the $5 refundable deposit payment. Payment is open from Monday to Wednesday on the week of the respective workshops at our computer centre in YIH. Payment for each workshop must be done separately, each during the week of the workshop itself.

If you have any questions, check out our Workshops FAQ or feel free to ask us at nussu.commit@gmail.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, 4th February 2017 on Training Room, Central Library Level 6. There will be 2 separate sessions held on that day, from 1015-1400 and from 1500-1845.

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, 4th February 2017 and Saturday, 25th March 2015, 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.

Our Illustrator Workshop will be held on Wednesday, 22 February 2017, 1000-1600.

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 Tuesday, 22 February 2017 and Saturday, 11 March 2017, 1015-1600 on Training Room, Central Library level 6.

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.
This semester (AY16/17 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

The workshop will be held on Saturday, 18th February 2017 and Tuesday, 22th February 2017, 1000-1700 on LT32. $20 payment will be collected on our centre (YIH Level 3, near the entrance) 1000-2100 Mon – Thursday. Come down and register now!

(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)