Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Microsoft Excel Level 2

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.

Description

Intermediate to Advanced Level

  • Logical formulae including IF, IFNA or IFERROR, goal seek and scenarios manager.

  • Lookup and reference including VLOOKUP, HLOOKUP and the new function XLOOKUP.

  • Conditional information including COUNTIF, SUMIF and AVERAGEIF.

  • Pivot Tables

  • Other advanced functions such as pivot tables, basic macros, charts, INDEX and MATCH and more.

     

 

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.

Prerequisites

  • Microsoft Excel Basic Level (Microsoft Excel Level 1 is recommended)
  • Basic Understanding / Speaking of the English Language

Similar courses

Train the Trainer (Training Course for Instructors) STCW A-I/6 and A-I/8

More Information
Food Handling Course Category B Licence

Suitable for people working in Hospitality who are directly involved in the preparation, production, and handling of food.

More Information
Marine Induction

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
Mooring Man Induction Course

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

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
VHF Induction

Basic familiarization course on VHF communication training

More Information
Microsoft Excel Level 1

The objective of the session is to start using Microsoft Excel in a more confident way for day-to-day tasks and familiarize yourself with basic formulae. The session is a practical workshop where participants practice the different functions being taught.

More Information

Press enter to see more results