Introduction to Microsoft Excel and useful shortcuts
Fundamentals of formulae including freeze panes, how to use the $ sign, & ampersand, drag function, setting names and paste special function.
Date and time formulae.
Text formulae and functions including concatenate, splitting content from cells, flash fill, group and ungroup.
Math and trig formulae including SUM and subtotal, rounding and absolute formula.
Checking for errors.
Importing text delimited files.
What you should bring on the day of the course:
Bring your own laptop and make sure that Microsoft Excel is installed prior to the sessions and as for the version any would do, but ideally version 2016 or Microsoft 365 version 2009.
If there are participants that have MAC operating systems, some shortcuts might be different, so ideally during the session Windows operating system is used.
Suitable for people working in Hospitality who are directly involved in the preparation, production, and handling of food.More Information
The Course is designed for shore-based personnel working in the Malta Port Authority, within the Ship Agency Services sector, or as Freight Forwarding Agents, Terminal Operators and other maritime related service providers.More Information
On completion of this course the trainee should be able to recognize all dangers associated to mooring operation in marine terminal; moreover a candidate will be able to identify crucial principals that he shall follow in order to keep his position safe whilst rendering the maximum possible efficiency to a vessel being moored. Upon successful completion of the training, trainees shall be expected to have gained additional knowledge about the work being carried out be those onboard the vessel.More Information
IMO OPRC – Basic Awareness and Handling of Small Spills This course is intended to provide a general introduction and awareness to all those involved in marine, port and offshore operations that may lead to a release of pollutants.More Information
Various amount of formulae will be covered and at the end of the session participants would be confident on using them in their day to day tasks. The course includes an explanation on how to delve into advanced formulae and how to nest them together. After this session, users will feel more confident to deal with large numbers of data. The session is a practical workshop where participants practice the different functions being taught.More Information