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 of our workshops are 6-hours long, except for several specialized workshops.

The workshops we will be conducting in AY2019/20 are:

Additionally, we partner with external organisations to offer some training workshops taught by external trainers:

  • Microsoft Excel VBA by Acadia Training (paid)
  • Data Science by Code for Asia
  • Web Development by Code for Asia

We announce our upcoming workshops via email blasts on NUSSU Events directly to your NUS email. You can also subscribe to our mailing list to be updated about our upcoming workshops.

Workshop registration

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 under the “Events” tab.

Once you have RSVPed on the particular NUSync event, 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: At 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 or contact us.

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)

There will be one Microsoft Excel workshop in Semester 1 AY2019/20. The workshop will be held on:

  • Date: Saturday, 14 September 2019
  • Time: 10:00 – 16:00 (inclusive of 1 hour break)
  • Venue: Seminar Room 3 (COM1 02-12), School of Computing

Note: Please bring your own laptop with Microsoft Excel installed. We will be using the latest version of Microsoft Office 365.

Adobe Photoshop

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

There will be one Adobe Photoshop workshop in Semester 1 AY2019/20. The workshop will be held on:

  • Date: Saturday, 12 October 2019
  • Time: 10:00 – 16:00 (inclusive of 1 hour break)
  • Venue: To be confirmed

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

There will be one Adobe Illustrator workshop in Semester 1 AY2019/20. The workshop will be held on:

  • Date: Saturday, 26 October 2019
  • Time: 10:00 – 16:00 (inclusive of 1 hour break)
  • Venue: To be confirmed

Microsoft Excel VBA

Macros allow users to record a set of actions in Microsoft Excel and repeating them dynamically on any cell or sheet. But have you ever wondered what does on behind recording a macro in Microsoft Excel?

Upon opening up your macro, you’ll find yourself exposed to the world of Visual Basics for Applications (VBA). VBA is the main programming language used in various Microsoft Office applications such as Word and Excel. It allows users to create and program custom scripts that can be executed through the click of a button or even during the opening of a spreadsheet. Actions that could have never been carried out through basic software functions.

As such, many businesses make use of this powerful tool to create custom applications such as automating the generation of reports, creating custom forms and compiling copious amounts of data.

A glimpse of the topics that will covered include:

  • Defining Variables
  • Creating Forms
  • Message Boxes/Alerts
  • Activecell usage
  • Conditional Statements

The workshop will be held at:

  • Date: Tuesday, 25 February 2020
  • Time: 09:45 – 17:00
  • Venue: To be confirmed