On Saturday 12th May 2018 at Intan 104 Building STT Migas Balikpapan, SPE STT MIGAS Balikpapan SC held training class about excel macro for internal board and staff, since this subject is rarely heard in campus or any lecture, so we invited mas Delint Ira S.Adi to become our speaker and share his knowledge, he taught us about the coding and the usage of Visual Basic in Microsoft Excel, the participants looked enthusiast hearing explanations and there were a lot of questions and discussions between participants and the speaker.
The training class was started at 14.00 and finish at 16.00. The event started by the opening from PIC and then went to the speaker to share his knowledge, continued with a short introduction and participants downloaded the data that had been provided by mas Delin before, afterward he explained about the subject before we practice in using it. The explanation was very useful to help the participants to understand what we were about to learn.
Later, mas Delin gave direction to open the file that he told us tho download before, in that file there were three sheets that contain different thing and he taught us to solve all of that with coding, first sheet is the simplest one which is to make cells or range to have a color, using coding we were able to do that. Then, the second sheet is to make a chart. Although we already know how to make a chart, we never learn about chart making with coding in visual basic, which contains complex and long command, that made some participants perplexed to finish this task, however with the help and the guidance from mas Delin all participants successfully finished this task, and the last sheet was not as complex as the second one, in this sheet we learnt about goal seek and the command in visual basic to use it.
After the training finished, there were still some questions asked and some discussion went on between participants and speaker.
The participants of this training are 17 participants from Internal boards and staffs of SPE STT Migas Balikpapan SC. Hopefully, from this training, they can get the knowledge and applicate it. For last, we hope that participants can share their knowledge that they have gotten from this event with their friends and the others.