There is a general tendency to underestimate hard skills in the industry that’s been dominated by soft skills. However, in today’s ever more competitive environment. Having hard skills gives you additional leverage in the most unexpected places and industries, the hospitality industry is no exception.
Well, before diving into the discussion, I would like to point out the difference between coding and programming:
- Coding is the translation of natural language into machine commands.
- Programming – to create a product, you need to take several additional steps aside from coding. They include planning, design, testing, deployment, and even maintenance. Altogether, the whole process can be called programming.
I would argue that any industry may benefit from coding and basic programming skills. However, in this article, we are going to focus on the hospitality industry. I felt compelled that the industry dominated by soft skills should also try to diverge from orthodox views and look a little bit into hard skills. Therefore, all the examples and scenarios are provided from the hospitality industry.
At the beginning of my studies at the university. I was already suspicious that many things that are done on the managerial level could be increased in efficiency. Since many reports are repetitive and could stay the same in structure for several years, I was wondering if there is a way to automate them using any kind of software. Upon further research, I found out that the financial industry automates its reports through Excel VBA, a programming language native to excel and simple in design and structure. Without any hesitation, I took the online course at the University of Colorado to learn and apply Excel VBA. I saw it as an additional tool to help in my future career in the hospitality industry.
The courses were hard and required some skills related to abstraction and logic, however, since I graduated technically focused high school, it was manageable. Upon completing several projects as well as finishing automating some of my coursework from university just for fun, I felt confident that I can start applying my skills in a potential workplace.
There are two main different applications of Excel VBA:
- Automating repetitive reports
- Creating small programs that may help with doing advanced analytics such as web-scraping or trends detection.
All of the code is scalable, meaning that if the code was created once it can be used by all the other associates in the department or company.
There are many tedious reports that can be automated in different departments of the hotel industry starting with Finance, and Sales and ending with F&B and Front Office. In some departments more so than the others. For example, more administrative tasks will more likely require excel. In the departments such as F&B and Front Office, the administrative tasks are mainly done by managers and supervisors while in Sales and Finance you may have them at the entry-level position.
In my particular department, I wrote a piece of code to automate the Guest Satisfaction Survey(aka GSS) that previously used to be done manually by one of the supervisors on a daily basis. This allowed to relieve the burden and improve productivity within the department and get some recognition from managers. However, there was some resistance due to the lack of trust and understanding but they were eventually overcome. Moreover, …….