Excel Workshop

The increased importance of data analytics and efficiency gains in the context of professional settings create the need to effectively deploy Microsoft Excel, particularly in relation to data management and analysis, which can assist professionals in capitalising on the information they use on a day-to-day basis.

The present workshop aims to improve participants’ competencies in using Excel by presenting various Excel practices and demonstrating useful Excel functionalities, while concurrently providing participants with the opportunity to apply multiple techniques through exercises. Participants will be able to familiarise themselves with both basic and advanced functions of Excel, as well as effectively design charts and graphs. 

Following completion of the workshop, participants will be able to:

• Describe the basic functionalities of Excel
• Express best practices for using Excel
• Apply formulas and functions to solve complex problems in Excel
• Organise, analyse and manage data more efficiently
• Develop scenario analyses and sensitivity analyses using Excel
• Participate more actively in the identification of effective alternative techniques in Excel to achieve business targets.

The seminar is targeted at professionals involved in various business sectors who wish to improve their knowledge and skills in Excel. Participants’ roles may be widely diverse, including administrative officers, analysts, engineers and entrepreneurs.

In order to participate in the workshop, participants are required to possess basic knowledge of computer use, as well as have prior experience in using Excel at a basic level, such as creating and editing Excel sheets and applying basic Excel functions.

Specialised technical knowledge or experience in any industry of the economy is NOT required.

All participants should be currently employed.

*The number of participants is restricted to 16.

1. Course Introduction (15 min)

2. Effective navigation (45 min)

• Navigation techniques
• Keyboard shortcuts for navigation
• Useful settings

3. Excel leading practices (30 min)

4. Working with excel data (2 hr & 15 min)

• Data types
• Copying and moving data
• Data formatting
• Excel tables

5. Formulas and functions (1hr & 45 min)

• Formula structures
• Cell referencing
• Calculation options
• Mathematical functions
• Counting functions

6. Questions (30 min)

• Q&A session

-- Day 2 --

7. Formulas and functions (continued) (2hr)

• Text functions
• Date functions
• Logical functions
• Lookup functions

8. Troubleshooting errors (20 min)

• Presentation of troubleshooting tools
  

9. Scenario and sensitivity analysis (40 min)

• Scenario and sensitivity analysis functionalities

10. Data management and visualisation (2hr & 10 min)

• Text-to-column
  
• Data validation
• Pivot tables
• Graphs and charts design

11. Course summary and questions (30 min).

Our services include:

• Handouts, including the hard copy presentation, examples, case studies, exercises, and additional notes, if applicable.
• Stationery, such as pads, pens, and files.
• Drinks (coffee, tea, etc.) and a buffet lunch.
• A fully equipped training room with WiFi access.
• Certificate of completion.

If you wish to register for the seminar, please complete the registration form.

Once your registration is submitted, you will receive an email stating the participation fee, including any discounts, if applicable. Kindly note that the payment should be settled at least two days prior to the seminar’s date for your registration to be confirmed.

The programme has been approved by the HRDA. Enterprises participating with their employees who satisfy HRDA’s criteria, are entitled to subsidy. Please note that there are limited seats available, therefore enroll in this seminar as soon as possible.

If you do not receive our confirmation e-mail regarding your registration, your participation cannot be guaranteed.

Cost

€415 Net investment after subsidy from the HRDA of €233,33: €181,67 for all eligible participants*

€415 + VAT (19%) for all participants who are non-eligible for the HRDA subsidy.

*Last Date for 10% Early Bird Discount: 19/11/2024

Note

We do not provide a soft copy of the presentation for face-to-face seminars. However, if you would like to request one, please contact us. We may be able to provide it, subject to approval. In this case, the cost of the soft copy will be €50 for participants who have already attended the relevant training, or €100 for those who have not.
 

HRDA Note

For HRDA approved trainings, all individuals who wish to attend our training courses should not only fill out our registration form, but also complete the registration process through the ERMIS platform in order to be approved by the HRDA. Please reach out to the HRDA Ermis officers on 22 390 300 for more details regarding this process. Kindly also note that each participant regardless if they are claiming the HRDA subsidy or not, will need to complete their registration through ERMIS as a physical person and choose our training in order to be able to attend (either as an employee whose company is claiming the subsidy or as an individual not claiming the subsidy).

According to HRDA regulations, you will not qualify for the HRDA subsidy if you have attended this seminar within the last two years, as there have been no substantial changes to the content.

Discounts available

• For more than two (3+) participants from the same company a 10% discount is available on the total cost, before the VAT and HRDA subsidy. This discount only applies for participants who enroll in the same seminar, on the same day. This discount can only be combined with the early bird discount and the HRDA subsidy, when applicable.
• For individuals/legal entities who/which register in more than two (3+) seminars during the same semester (January-June & July-December), a 10% discount is available on the total cost, before the VAT and HRDA subsidy. This discount only applies for individuals/legal entities who/which enroll in more than two (3+) seminars during the same semester, on the same day. This discount can only be combined with the early bird discount and the HRDA subsidy, when applicable.
• There is a 10% discount for alumni members. This discount should be applied before the VAT and HRDA subsidy and can only be combined with the early bird discount and the HRDA subsidy, when applicable. For more information on our alumni scheme, click here.
• There is a 10% early bird discount on selected seminars for participants who enroll in a training course until a specific date which is stated above. This discount should be applied before the VAT and HRDA subsidy and can only be combined with the HRDA subsidy, when applicable.
• HRDA subsidy for all HRDA approved seminars.
• Please note that while participants may qualify for multiple discounts, a maximum of two discounts, up to a total of 20%, can be applied per registration.

Contact

For any queries, please contact Vasiliki Sioziou on +357 22 207 460 or at academy@kpmg.com.cy

CPD

This seminar may contribute to Continuing Professional Development requirements. At the end of the seminar participants will be given a certificate of attendance confirming the total number of training hours (11,4 CPD).

Prodromos Papanikolaou
Senior Manager, Deal Advisory, KPMG in Cyprus

Prodromos is a Senior Manager in the Deals Advisory department of KPMG in Cyprus and has over nine years of experience in the field of Deal Advisory Services. He has been involved in the preparation of financial models, valuations, mergers and acquisitions, privatisations, financing and restructuring projects for many public and private companies from different sectors including financial services, infrastructure, energy, education, agriculture, retail and tourism. Through this wide hands-on experience, he has gained unique in-depth knowledge of the business dynamics in practical situations.

Prodromos has a BSc in Finance from the University of Cyprus. He is, also, a CFA charter holder and a member of the CFA Society Cyprus. He has presented various seminars on valuation and the use of MS Excel. 

Michalis Stylianides
Senior Manager, Deals Advisory, KPMG in Cyprus

Michalis is a Senior Manager in the Deals Advisory department at KPMG in Cyprus. He holds a BSc in Finance, Accounting and Management and an MSc in Risk Management, both from the University of Nottingham.

Michalis has been involved, among others, in valuations, mergers and acquisitions, privatisations, financing and restructuring projects. His clients include public and private companies from various sectors, such as financial services, retail, tourism and real estate. Through his hands-on experience, Michalis has gained in-depth understanding of the current business environment both at local and international level.

He is a member of the Institute of Risk Management (IRMCert) and a member of the Institute of Chartered Accountants in England and Wales (ICAEW). He has delivered various seminars on valuation, financial modelling and use of MS Excel for both KPMG staff and clients.