17097 Other courses in Carrickfergus delivered Online

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Developing Teamwork is all about building stronger relationships within your team by getting to know each other better and creating the foundations for an exceptionally high performing group of people. This course explains in detail what team working is and covers some of the basic principles for putting together a group of people who will work well together. It then goes on to cover conflict within teams, explaining some of the reasons conflict occurs and some strategies for managing it. It finishes off by exploring some of the different styles of management behaviour and how to develop a resilient team.

Compliance involves the efforts and programs of an organization to ensure that the business complies with government and industry regulations. If your organization is subject to a compliance scheme, it means your business is bound, by contract or law, to follow rules set by external bodies. Description This course provides an introduction to the principles of compliance and how they apply to FCA-regulated businesses and organizations. Training Duration This course may take up to 2 hours to be completed. However, actual study time differs as each learner uses their own training pace. Training Method The course is offered fully online using a self-paced approach. The learning units consist of reading material. Learners may start, stop and resume their training at any time. At the end of each session, participants take a Quiz to complete their learning unit and earn a Certificate of Completion upon completion of all units. Accreditation and CPD Recognition This programme has been developed by the London Governance and Compliance Academy (LGCA), a UK-recognised training institution. The syllabus is verified by external subject matter experts and can be accredited by regulators and other bodies for 1 CPD Unit that approve education in financial regulation, such as the FCA. The course may be also approved for CPD Units by institutions which approve general financial training, such as the CISI. Eligibility criteria and CPD Units are verified directly by your association, regulator or other bodies which you hold membership. Registration and Access To register to this course, click on the Get this course button to pay online and receive your access instantly. If you are purchasing this course on behalf of others, please be advised that you will need to create or use their personal profile before finalising your payment. If you wish to receive an invoice instead of paying online, please contact us at info@lgca.uk. Access to the course is valid for 365 days.

This course provides an introduction to the General Data Protection Regulation (GDPR), which is the European Union's (EU) comprehensive data protection law. The GDPR applies to all organizations that process personal data of individuals located in the EU, regardless of where the organization is located. Description This course is designed to give all employees of a firm an understanding of what GDPR is intended to achieve, how it aims to empower individuals, and how it impacts firms and the roles of their employees. Training Duration This course may take up to 2 hours to be completed. However, actual study time differs as each learner uses their own training pace. Training Method The course is offered fully online using a self-paced approach. The learning units consist of reading material. Learners may start, stop and resume their training at any time. At the end of each session, participants take a Quiz to complete their learning unit and earn a Certificate of Completion upon completion of all units. Accreditation and CPD Recognition This programme has been developed by the London Governance and Compliance Academy (LGCA), a UK-recognised training institution. The syllabus is verified by external subject matter experts and can be accredited by regulators and other bodies for 1 CPD Unit that approve education in data protection and information security. Eligibility criteria and CPD Units are verified directly by your association, regulator or other bodies which you hold membership. Registration and Access To register to this course, click on the Get this course button to pay online and receive your access instantly. If you are purchasing this course on behalf of others, please be advised that you will need to create or use their personal profile before finalising your payment. If you wish to receive an invoice instead of paying online, please contact us at info@lgca.uk. Access to the course is valid for 365 days.

Course Overview SFTR is a major regulatory reporting requirement for anyone transacting repo and other securities financing transactions in the EU, no matter how limited their activity. In order to meet the regulator's demand for complete, accurate and timely data, firms are devoting considerable resources to the speedy remediation of rejected or unreconciled reports. Description This self-paced online course will offer delegates a grasp of what is required by SFTR in the EU and UK but will also provide a practical insight by looking at specific reporting rules and key data fields. Training Objectives By the end of the course, delegates should be able to: • Identify what trading activities are covered by SFTR, who has to report and by when; • Outline the role of trade repositories and recognise the reports sent to and sent out by these entities; • Distinguish the types of record to be sent to trade repositories and know in what order they should be sent; • Select and describe the data fields required for generic SFT structures, whether collateralized at transaction or portfolio level; • Complete a basic calculation of the estimated re-use of collateral. They should also: • Be aware of some of the practical issues that have arisen in reporting; • Know where to look for further guidance. Training Outline • Background which has brought the SFTR • What is Shadow Banking and how is it related to SFTR • Purpose of SFTR and key requirements for reporting parties • What SFTR covers: repos, securities/commodities lending, margin lending • Who is subject to SFTR, including mandatory delegation and branches • The role of trade repositories: who they are; what they do (validation and recon-ciliation); what you send them and what they send back and to others • Types of report (Action Types) and sequencing • Reporting deadlines. • Data sets, matching fields, cardinality rules (mandatory, conditional or optional) and conditionality links between fields • Counterparty data • Loan data: type, UTI, level of reporting, legal data, term, rate • Collateral data: type; level of reporting; classifications • CCP-cleared SFTs and margins • Collateral re-use reports: actual and estimated • Practical examples provided by ESMA Training Duration This course may take up to 3 hours to be completed. However, actual study time differs as each learner uses their own training pace. Participants This course is suitable for any professional involved with SFTR. Delegates would benefit from a familiarity with repos, securities lending and margin lending but this is not essential. The course is offered fully online using a self-paced approach. The learning units are based on reading material. Learners may start, stop and resume their training at any time. Accreditation and CPD Recognition This programme has been developed by the European Institute of Management and Finance (EIMF), a globally-recognised training institution. The syllabus is verified by external subject matter experts and can be accredited by regulators and other bodies for 3 CPD Units that require CPD training in financial regulation. The course may be also approved for CPD Units by institutions which approve general financial training, such as the CISI. Eligibility criteria and CPD Units are verified directly by your association, regulator or other bodies which you hold membership. Registration and Access To register to this course, click on the Get this course button to pay online and receive your access instantly. If you are purchasing this course on behalf of others, please be advised that you will need to create or use their personal profile before finalising your payment. Access to the course is valid for 365 days. If you wish to receive an invoice instead of paying online, please Contact us here. Talk to us for our special Corporate Group rates.

***24 Hour Limited Time Flash Sale*** QLS Endorsed Import/Export and Port Management Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Unlock the world of Import/Export and Port Management with this QLS-endorsed training bundle. Embark on a learning journey across two cornerstone courses - Import/Export and Port Management. Alongside these, complement your theoretical understanding with five CPD QS accredited courses. Expand your expertise in Logistic Management, Supply Chain Management, Airport Management, the role of a Transport Manager, and grasp the ins and outs of Warehouse Management. This all-encompassing course bundle gives you a rigorous understanding of the import/export industry, as well as the management of ports and other logistical hubs. You'll receive hardcopy certificates upon the completion of the QLS-endorsed courses, highlighting your accomplishment. Delve deeper with the CPD QS accredited courses, and broaden your knowledge base. Be it understanding supply chains, mastering logistics, or knowing the vital role a Transport Manager plays, this bundle has it covered. Discover the complexities of Import/Export and Port Management, and gear yourself up with in-depth theoretical knowledge to navigate this fast-paced industry. This bundle comprises the following courses: QLS Endorsed Courses: Course 01: Diploma in Import/Export Processing at QLS Level 4 Course 02: Diploma in Port Management at QLS Level 5 CPD QS Accredited Courses: Course 03: Logistic Management Course 04: Supply Chain Management Course 05: Airport Management Course 06: Transport Manager Course 07: Warehouse Management Diploma Learning Outcomes: By the end of this Import/Export and Port Management bundle course, learners will be able to: Gain an understanding of the principles and processes involved in Import/Export. Acquire knowledge about the functioning and management of ports. Learn the intricacies of Logistics Management and its application. Understand the principles of Supply Chain Management. Learn the workings and responsibilities of a Transport Manager. Gain knowledge about the operations and management of airports. Understand the functions and organisation of a warehouse. Enhance overall knowledge about the transport and logistics industry. The Import/Export and Port Management - Endorsed Training bundle is a comprehensive package offering a profound understanding of key areas within the transport and logistics industry. The two QLS-endorsed courses impart a strong theoretical understanding of the import/export sector, alongside the management and operation of ports. These subjects are central to the world of trade, transport and global commerce. The five CPD QS accredited courses supplement this knowledge by addressing other pivotal elements of the industry such as logistics, supply chains, airport operations, transport management, and warehouse management. This comprehensive training bundle aims to provide a thorough theoretical understanding of these areas, expanding your knowledge and boosting your potential within the transport and logistics sector. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Import/Export and Port Management bundle is perfect for: Individuals interested in gaining knowledge about the import/export sector and port management. Aspiring professionals looking to delve into transport and logistics management. Those seeking to learn about different facets of the transport and logistics industry such as airport and warehouse management. Anyone wishing to gain a theoretical understanding to complement further professional training in this field. Career path Import/Export Specialist: Median Salary - £28,000 per year. Port Manager: Median Salary - £40,000 per year. Logistic Manager: Median Salary - £35,000 per year. Supply Chain Manager: Median Salary - £42,000 per year. Transport Manager: Median Salary - £31,000 per year. Warehouse Manager: Median Salary - £27,000 per year. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people who use PowerPoint for their business communication needs. Overview To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders. This course is intended for those who wish to take advantage of the application for high quality business presentations and reports. Presentations Create Attractive Presentations from Existing PowerPoint Templates Creating Presentations Quickly using Outline to build a Structure Incorporating and reusing slides from other presentations into your own Templates and Customization Using Slide Layouts Using the Slide Master Creating Custom Slide Layout Working with Charts and Tables Create and Modify Tables Create Charts and Graphs Copying Charts into PowerPoint Link Vs Embed Add Visual Elements to a Presentation Create and Modify Shapes Add Images Create SmartArt to Make Easily Modifiable graphics Use SmartArt to Give Dull Text a More Visual Appeal Working with Media and Animation Add Audio to A Presentation Add Video to A Presentation Add and Customize Animations Add and Customize Transitions Preparing to Present Add Notes to A Presentation Presenter View And Slide Show Controls Create A Custom Slide Show Saving and Sharing the Presentation Printing Options and Handouts Additional course details: Nexus Humans Microsoft PowerPoint for the Business User training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft PowerPoint for the Business User course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Facilities management professionals are responsible for services that support business. Their roles can cover management of a wide range of areas including health and safety, risk management, business continuity, procurement, sustainability, space planning, energy, property and asset management. They are typically responsible for activities such as catering, cleaning, building maintenance, environmental services, security and reception. The Level 5 qualifications will provide the skills needed to complete complex tasks and take on responsibility for planning and delivering solutions while developing your specialised knowledge of the profession. It is for you if you are at a middle or senior management level and responsible for more complex functions, or if you are aspiring to these roles and looking to stretch and develop.

This course uses a non-traditional approach that improves all 4 Language Skills using materials from the students' own school courses. The training also focuses on examination techniques.

Sharing a radical change in thinking from Service to Person centred