Agenda

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).

Services

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.

Trainers

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.