Lessons

Excel Advanced

  What you'll learn Rapidly increase the speed and efficiency of your work with the shortcuts, tips, tools & techniques used. Master the key functions in Excel, applying them together and in isolation in a range of commercial contexts. Utilize Goal Seek, Data Tables and Scenario modelling techniques to answer Management's most important questions. Harness the power of Pivot Tables to organize, summarize, slice, dice & dissect data...fast! Format your work to look professional and presentable, gaining trust and usability. Lookup data with INDEX & MATCH, and learn Excel's new XLOOKUP function. Unlock the power of SUMIFS & SUMPRODUCT in your summaries, and master IF, AND & OR to reduce risk in your work. Course objectives Gain broad, advanced, commercially-orientated knowledge of Excel suited to Accounting & Finance, Analyst, Consultant and Strategy positions, as well as other roles with a commercial focus. Be able to apply in multiple ways the most useful and relevant Excel functions to your analysis and spreadsheets. Learn how to construct formula containing multiple functions. Utilize a range of inbuilt Excel tools in your data analysis and work. Be able to format your work to look professional and presentable. Extend your knowledge of Excel functionality relevant to analysis. Increase the speed with which you work in Excel and produce analysis.   WHAT’S IN THE COURSE? This course is split into 4 main sections: Excel Essentials – shortcuts, tips, tools and techniques that will rapidly speed up your work so that you’re operating as fast and efficiently as you can be. Exploring the Ribbon - what’s in there, what’s important, what’s secondary Customizing the Quick Access Toolbar to speed up your work Top keyboard shortcuts for fast navigation and undertaking regular actions A look at a very powerful add-in (NB: this add-in is available on Windows only, not Mac) Other tips and techniques to work as efficiently as you can  Functions, Formulae & Calculations – a comprehensive look at the theory, advice and demos of the most important and relevant functions, top tips for formula construction & auditing, and the creation and use of Named Ranges. Overview of the Function Library Most useful functions and their application: INDEX, MATCH, INDEX & MATCH vs VLOOKUP, XLOOKUP, SUMIFS, SUMPRODUCT, COUNTIFS, MAX & MIN, RANK, IF, AND, OR, TRUE & FALSE Formula construction – top tips for building formula involving multiple functions Formula auditing tools – navigating your calculations and finding errors Range names – how to create, use and edit to make your work more transparent  Data & Analysis Tools – Excel’s most useful tools – Pivot Tables, Goal Seek and Data Tables – as well as techniques for introducing scenarios into your spreadsheets and modelling. Pivot Tables - how to create, use and customize What-If tools – Goal Seek to find inputs What-If tools – Data Tables to sensitize inputs Techniques for creating scenarios and flexing inputs   Formatting & Views – ways to make your work presentable, presentational and professional, to increase trust in it and improve its usability. Importance of formatting your spreadsheets Cell styles - their use and customizing Conditional formatting of outputs Presenting the data you want through Sorting & Filtering Improving the look of work through Freeze Panes, Grouping & Hiding Data Validation to make your spreadsheet more robust & usable   *The Program can be adapted to the needs of your company  

GDPR (General Data Protection Regulation)

THE ROLE AND DUTIES OF THE DATA PROTECTION OFFICER (DPO) Introduction to the basic provisions of the GDPR Explanation of the importance of personal data for the importance it attaches to the EU. Important Terms: concepts in the protection of personal data in the context of the workplace The importance of the customer's consent to the processing of their personal data. When is it needed? When can processing take place without consent? What are the conditions? Rights of Citizens in relation to their Personal Data The GDPR now allows citizens to have access to their personal data as well as the right to modify / delete it. Information on what employees and company executives who manage personal data need to know about the proper management of this type of request from customers and/or other persons. Penalties for breach of GDPR: Penalties and penalty criteria update/explanation) Principle of Proportionality: Explanation of the principle of proportionality in relation to the management of personal data and the formation of correct procedures and practices within their company) Transfers of Personal Data outside the EU (Explanation of procedures and practice with scenarios) Key Documents: Explanation of key documents / records required by GDPR. Practical help and examples for completing them. Technology and GDPR: Importance of technology in implementing GDPR. Explain basic IT concepts and applications. Good practices of electronic management of personal data and protection against leaks and impositions by external factors (external hacks). Practical applications in the workplace: Examining various scenarios so that the participants understand the practical application of the Regulation in the workplace and to be able to apply the theory of the previous modules in practice.   *The Program can be adapted to the needs of your company    

Trade Based Money Laundering in Transaction Monitoring & Maritime Sanctions

      Description Transaction Monitoring is a Regulatory requirement and aims the countering of ML, TF, Fraud, Tax evasion and any illicit activity that would be permitted otherwise. The objective of the webinar is to provide a thorough view and approach to the risks involved, either towards above threats or even sanctions including Maritime Sanctions. The topic is very broad but quite easy to understand and it includes day to day operations, experiences etc. The course will provide knowledge and techniques how to screen and monitor transactions in order to mitigate risks involved both for ourselves but also for the organization we work for. The topics prepared for you for this course are as follows:  Regulatory Framework & Relevant Risks Internal Procedures on Due diligence KYC,KYT,KYB,KYC of counterparty & UBO Sanctions due diligence including Maritime Sanctions TBML - Advanced Trade-Based Money Laundering Techniques Advanced Tradecraft TB typologies and methods What one would expect from this exciting and unique webinar check on the following sample: Money launderers engaged in TBML are constantly pushing the envelope in their quest to outwit compliance officers. With the Suez Canal/Panama Canal/Black Sea transport issues affecting global commerce, laundrymen tactically employing TBML schemes have the commercial world, which is preoccupied with these obstacles, at a serious disadvantage. Money launderers are certainly exploiting the chaos, which we know because of the paucity of reports of compliance departments and law enforcement agencies interdicting TBML operations. For example, a number of enterprising laundrymen have created shell companies purporting to be engaged in insurance coverage, to shield the transfer of dirty money, disguised as insurance payments for losses, whether from wartime damage, delay and spoilage issues, and a number of other types of insurable events that arise constantly in times of danger and exposure to risk. They may have already set up front shipping companies for that purpose. Money launderers in the TBML field are, as we consider it, brainstorming over new ways to take full advantage of the confusion over trade route risks. They are actively engaged proactively, seeking out new methods, which they use, and then lose, effectively defeating unimaginative compliance officers who don't embrace the possibility that what they are seeing are not necessarily legitimate payments for trade, but creative criminal variations on a number of themes, forever changing form and format.Take another look at that transaction; analyze it, dissect it, and you may find it is more than it appears to be. Be as creative as your worthy laundrymen opponents, and you can stop them. Definite interest to: Bank employees dealing with payments, trading transactions, trade finance Lawyers and accountants dealing with customer due diligence and behaviour MSBs dealing with customer services Shipping companies dealing with movement of cargo and ships Maritime suppliers of goods and services *The Program can be adapted to the needs of your company  

PROPERTY PURCHASES – ENHANCED DUE DILIGENCE ON FOREIGN INVESTORS

ΠΛΗΡΟΦΟΡΙΕΣ ΣΕΜΙΝΑΡΙΟΥ Εκπαιδευτής: Αβραάμ Δημητρίου (CAMS,AFC,AML,CFT, Cyber Security) Διάρκεια: 12 ώρες  Χώρος διεξαγωγής: Εξ αποστάσεως (ONLINE) Έναρξη: 08/04-11/04/2024 Δίδακτρα: €310 Δίδακτρα για Δικαιούχους εταιρικής επιχορήγησης: €70 Κόστος για ανέργους : ΔΩΡΕΑΝ The need arises due to the strict regulatory environment due to the trend for foreign investments in Cyprus and the recent fail-out of Cyprus papers, demanding more knowledge, more training on KYC, SOF, SOW  source of funds, source of wealth.  This need also arises due to the extremely sensitive environment with the increased sanctions implemented both to SDNs but also anything related with the Russian government and  Duma. This program is perhaps one of the most useful but also unique of its kind since it includes both knowledge and practical experience with what to look for in such a case. Μετά την ολοκλήρωση του προγράμματος οι καταρτιζόμενοι θα είναι σε θέση να: Σε επίπεδο γνώσεων To understand the need for EDD To acknowledge the fraudulent intentions in the investment in properties To recognize suspicious investments Σε επίπεδο δεξιοτήτων Be in a position to know how to handle such cases Be in a position to exercise EDD on foreign investors Be in a position to analyze financial positions of foreign investors Σε επίπεδο στάσεων To have the critical thinking how to proceed with the case To have the ability to prepare a recommendation for approval or rejection To be able to proceed with reporting when and if deemed necessary Σε ποιους απευθύνεται:  Members of staff that deal with payments, exercise due diligence on foreign investors compliance staff or staff in the Recovery Units that are engaged in the EDD of foreign investors Recovery Unit staff that are engaged in the sales of properties Front line staff that deal with customer needs in property sales or purchase   ΕΚΠΑΙΔΕΥΤΗΣ ΠΡΟΓΡΑΜΜΑΤΟΣ       Πρόγραμμα:    ΠΡΟΓΡΑΜΜΑ Size: 41.81 KB Format: DOCX Preview Οδηγίες Εγγραφής στο σύστημα ERMIS: {{#with category}} {{title}} {{/with}} {{#if categories}} {{#each categories}} {{title}} {{/each}} {{/if}} {{#with category}} {{#if parent_id}} Back {{/if}} {{/with}} {{#if category}} {{#if category.type}} {{/if}} {{#if category.linkdownload_cat}} {{/if}} {{/if}} {{#if files}} {{#each files}}{{#if ext}} {{#if custom_icon}} {{else}} {{ext}} {{/if}} {{title}} {{#if description}} {{{description}}} {{/if}} {{#if versionNumber}} Version : {{versionNumber}}  {{/if}} {{#if size}} Size : {{bytesToSize size}} {{/if}} Hits : {{hits}} Date added : {{created_time}} Download {{#if openpdflink}} Open {{else}} {{#if viewerlink}} Preview {{/if}} {{/if}} {{/if}}{{/each}} {{/if}} ΕΡΜΗΣ ΕΡΜΗΣ pdf ΔΙΑΔΙΚΑΣΙΑ ΠΑΡΟΥΣΙΟΛΟΓΙΟΥ Size: 916.87 KB Hits : 2142 Date added: 2023-01-18 Download Preview pdf ΔΙΑΔΙΚΑΣΙΑ ΕΡΓΟΔΟΤΗ ΓΙΑ ΣΥΜΜΕΤΟΧΗ ΣΕ ΠΟΛΥΕΠΙΧΕΙΡΗΣΙΑΚΑ ΠΡΟΓΡΑΜΜΑΤΑ Size: 1.19 MB Hits : 1853 Date added: 2023-01-18 Download Preview docx 5) ΒΗΜΑΤΑ ΓΙΑ ΑΠΟΚΤΗΣΗ ΡΟΛΟΥ ΕΡΓΟΔΟΤΗ Size: 16.90 KB Hits : 1134 Date added: 2023-10-30 Download Preview docx 2) ΕΓΓΡΑΦΗ ΦΠ-ΕΡΓΟΔΟΤΟΥΜΕΝΟΙ Size: 19.05 KB Hits : 1188 Date added: 2023-10-30 Download Preview docx 4) ΕΓΓΡΑΦΗ ΝΠ-ΕΡΓΟΔΟΤΗΣ Size: 1.21 MB Hits : 1177 Date added: 2023-10-30 Download Preview  

ΣΤΡΑΤΙΩΤΙΚΗ ΣΧΟΛΗ ΕΥΕΛΠΙΔΩΝ

Τα μαθήματα θα διεξάγονται ζωντανά διαδικτυακά για όλες τις πόλεις. Με βάση την εμπειρία που κατέχουμε στα 25 χρόνια λειτουργίας μας και την διοργάνωση μαθημάτων για παρόμοιας φύσης εξετάσεις που κατά καιρούς προκηρύχτηκαν από διάφορους οργανισμούς, δημόσιους και ιδιωτικούς, καθώς και η συσσωρευμένη εμπειρία από τις εκδόσεις των βιβλίων μας που έχουν θεματολογία με σχετική συνάφεια με το αντικείμενο, θα διοργανώσουμε διαλέξεις προετοιμασίας για τις εξετάσεις ως ακολούθως:   Πρόγραμμα μαθημάτων 2024:     Κόστος προετοιμασίας: €300 Τα μαθήματα θα ολοκληρώνονται μέσα από 18 ώρες διδασκαλίας  το κάθε ένα.    Η αποπληρωμή θα γίνει ως ακολούθως:  1η δόση μέχρι 31/01/2024 150 ευρώ 2η δόση 29/02/2024: 150 ευρώ    Tρόποι πληρωμής: REVOLUT: 99516071 BANK OF CYPRUS: NEORAMA EDUCATION LTD -  017711025529 / IBAN: CY77002001770000001102552900     Εγγραφές: Για κράτηση θέσης παρακαλώ στείλτε μήνυμα στο 99516071 με τα στοιχεία σας (ΕΥΕΛΠΙΔΩΝ - ΟΝΟΜΑΤΕΠΩΝΥΜΟ)