4298 Analyst courses delivered Online

Excel Vlookup, Xlookup, Match and Index Course Overview: This comprehensive course covers essential Excel functions such as VLOOKUP, XLOOKUP, MATCH, and INDEX, which are integral for efficient data management and analysis. Learners will gain a clear understanding of how to use these functions to simplify complex data tasks, enhance productivity, and improve decision-making. Throughout the course, students will master how to search, match, and retrieve data from large datasets, preparing them for real-world scenarios in finance, marketing, HR, and more. The course is designed to equip learners with the necessary skills to perform advanced Excel functions with confidence, contributing to their professional growth and data analysis expertise. Course Description: In this course, learners will explore the powerful functions of Excel, including VLOOKUP, XLOOKUP, MATCH, and INDEX, enabling them to perform efficient data searches, cross-referencing, and information retrieval. The course includes step-by-step lessons on how to apply these functions to real-world datasets, making it highly relevant for anyone working with large volumes of data. Learners will become proficient in building dynamic spreadsheets that streamline decision-making processes and improve data accuracy. Additionally, this course emphasises problem-solving techniques, empowering individuals to handle complex data-related tasks with ease. By the end of the course, learners will have a strong command of these Excel functions, boosting their data management and analytical capabilities. Excel Vlookup, Xlookup, Match and Index Curriculum: Module 01: Excel VLOOKUP Module 02: Excel XLOOKUP Module 03: Excel MATCH Module 04: Excel INDEX Module 05: Advanced VLOOKUP Techniques Module 06: Combining VLOOKUP, MATCH, and INDEX Module 07: Practical Applications of XLOOKUP (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel skills for data analysis. Professionals aiming to improve their data management capabilities. Beginners with an interest in learning advanced Excel functions. Anyone looking to improve their problem-solving abilities in data-heavy tasks. Career Path: Data Analyst Financial Analyst Marketing Analyst HR Specialist Business Intelligence Specialist Excel Expert for Administrative or Management Roles

Duration 3 Days 18 CPD hours This course is intended for The CompTIA Cloud Essentials+ Specialty certification is relevant to IT specialists, IT technical services specialists, IT relationship managers, IT architects, consultants, business and IT management, business process owners, and analysts. Overview Upon successful completion of this course, students will be able to: Learn the fundamental concepts of cloud computing. Learn the business aspects and impact of cloud computing. Differentiate the types of cloud solutions and the adoption measures needed for each. Identify the technical challenges and the mitigation measures involved in cloud computing. Identify the steps to successfully adopt cloud services. Identify the basic concepts of ITIL and describe how the ITIL framework is useful in the implementation of cloud computing in an organization. Identify the possible risks involved in cloud computing and the risk mitigation measures, and you will also identify the potential cost considerations for the implementation of cloud and its strategic benefits. Students will weigh the pros and cons of cloud computing to make effective decisions and meet IT challenges. 1 - Understanding Cloud Computing Concepts Topic A: Understand Basic Cloud Concepts and Terms Topic B: Identify Cloud Network and Cloud Storage Technologies Topic C: Recognize Cloud Design Aspects 2 - Applying Cloud Business Principles Topic A: Relate Cloud Concepts to Business Principles Topic B: Establish Cloud Vendor Relations Topic C: Distinguish the Financial Aspects of Engaging a Cloud Service Provider Topic D: Report Financial Expenditures 3 - Advising a Cloud Design and Migration Topic A: Relate Cloud Concepts to Cloud Design and Migration Topic B: Use Cloud Assessments Topic C: Manage Cloud Design Topic D: Compare Cloud Migration Approaches Topic E: Identify Benefits and Solutions of Cloud Services 4 - Operating in the Cloud Topic A: Relate Cloud Concepts to Technical Operations Topic B: Identify the Technical Aspects of Cloud Operations Topic C: Understand DevOps in the Cloud Topic D: Explain Cloud Security Concerns, Measures, and Concepts 5 - Managing Cloud Governance Topic A: Relate Cloud Concepts to Governance Topic B: Apply Risk Management Concepts Topic C: Understand Compliance and the Cloud Topic D: Manage Policies and Procedures for Cloud Services 6 - Appendix A: Mapping Course Content to the CompTIA Cloud Essentials+ (Exam CLO-002) 7 - Appendix B: CompTIA Cloud Essentials+ (Exam CLO-002) Acronyms 8 - Glossary 9 - Index Additional course details: Nexus Humans CompTIA Cloud Essentials Plus Certification (Exam CLO-002) 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 CompTIA Cloud Essentials Plus Certification (Exam CLO-002) 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.

A crash course in understanding a company’s report and accounts, this programme is ideal for anyone wanting to get more comfortable with the art of dissecting balance sheets and accounts more generally.

Mergers and Acquisitions - Virtual Learning Why Attend This practical course covers the key steps in the Mergers and Acquisitions(M&A) process, from the initial step of valuing the shares in a company through to closing the deal. Whether or not participants practice M&A, this course will provide them an insider's look into what is an undeniable major force in today's corporate arena. This course will give participants an A-Z understanding of the M&A process and the ability to evaluate whether a merger or acquisition fits with their organization's strategy. As a result they will identify the most lucrative M&A opportunities, select the best partners and get the maximum reward from the deal. Course Methodology In this interactive training course participants will frequently work in pairs as well as in larger groups to complete exercises, and regional and international case studies. Course Objectives By the end of the course, participants will be able to: Identify attractive Mergers and Acquisitions (M&A) opportunities Formulate the initial steps and the preliminary agreements for a merger or acquisition Carry out a full due diligence into the state of affairs of a target company Understand the Share Purchase Agreement (SPA) and the Asset Purchase Agreement (APA) Take an active role in the exchange and completion stages of a merger or acquisition Be an effective part of the post-merger integration to ensure the smooth running of the new organization Target Audience This course is suitable for anyone involved in the identification, planning and execution of a Mergers and Acquisitions opportunity. This includes, CEOs, managing directors, general managers, financial directors, accountants, board members, commercial directors, business development directors, strategy planners and analysts, and in-house council. Target Competencies Identifying M&A opportunities Due Diligence Organizing Acquisitions Structuring Negotiations Post-acquisition Integration Post-acquisition Audit Note The Dubai Government Legal Affairs Department has introduced a Continuing Legal Professional Development (CLPD) programme to legal consultants authorised to practise through a licensed firm in the Emirate of Dubai. We are proud to announce that the Dubai Government Legal Affairs Department has accredited EMG Associates as a CLPD provider. In addition, all our legal programmes have been approved. This PLUS Specialty Training Legal course qualifies for 4 elective CLPD points. Fundamentals of Mergers and Acquisitions ( M&A) Distinction between Mergers and Acquisitions Types of Mergers & Acquisitions Horizontal Vertical conglomerate Knowledge of areas of law required in M& A The Preliminary documents required in M&A Heads of terms- legally binding? Confidentiality - do they need to be in writing? Lockout/exclusivity agreements- requirements for enforceability How to structure the Acquisition Share sale Advantages and disadvantages from the buyer's perspective Advantages and disadvantages from the seller's perspective Business sale Advantages and disadvantages from the buyer's perspective Advantages and disadvantages from the seller's perspective Hive down A combination of assert sale and share sale Looking at different valuation techniques Real Estate Value Relief from Royalty Discounted Cash Flow Market Multiples Dividend Yield Net Assets The Due Diligence Process What is it? Why do it? Scope of due diligence Legal Financial  Commercial Operational The Purchase Agreements Share Sale Purchase Agreement v Asset Purchase Agreement v Business Purchase Agreements Provisions in a Share Purchase Agreement Importance of warranties and indemnities in purchase agreements Negotiating warranties from a Share Purchase Agreement Contractual protection for the seller  Disclosure letter Intellectual property What happens to IP in M&A  Stages of the IP during the M&A process Dispute Resolution in M&A Litigation Arbitration Mediation The Exchange and completion stages of M&A Seller's document Buyer's document The auction process The relevant stages Advantages and disadvantages from the buyer's and the seller's perspective

Boost your insurance career with payroll, Excel, accounting, data entry, and Tableau-led data analytics skills. Navigating the corporate side of UK insurance requires more than just policy talk. This mini bundle neatly ties together the essentials—think payroll, accounting, data entry, Excel, and Tableau. Whether you’re brushing up your spreadsheets or deciphering financials, you’ll gain the structured knowledge to operate with precision. From managing numbers to visualising them, this collection delivers the core knowledge behind successful insurance operations. It’s designed for those who want to make insurance sound less... dull. (It’s not. There are spreadsheets. They're thrilling.) All courses are online, self-paced, and geared to help you move confidently through the essentials of corporate insurance functions. Learning Outcomes: Understand payroll functions within a corporate insurance context. Explore accounting processes used across insurance firms. Input, organise and manage insurance data accurately. Use Excel for reporting and insurance data management tasks. Visualise data clearly using Tableau’s dashboard features. Identify ways to optimise internal insurance operations with data. Who Is This Course For: Staff in insurance admin or back-office support roles. Payroll clerks needing sector-specific understanding. Accounting assistants in the insurance sector. Excel users looking to manage data more efficiently. Those moving into data-based insurance roles. Data entry professionals in insurance firms. Business support staff in insurance environments. Team leaders needing digital insurance fluency. Career Path (UK Average Salaries): Insurance Administrator – £24,000 per year Payroll Officer – £28,000 per year Data Entry Clerk – £21,500 per year Accounts Assistant – £26,000 per year Excel Data Analyst – £30,000 per year Tableau Reporting Analyst – £35,000 per year

Learn charity-focused accounting, finance, and problem-solving to strengthen your management and analysis skills online. Charity finance is a delicate balance of stewardship, accuracy, and calm problem-solving under pressure. This mini bundle brings together essential topics—accounting, financial analysis, business analysis, business management, and structured problem solving—all focused on the not-for-profit context. Whether you're overseeing budgets or handling funding reports, this bundle supports your role with clarity and purpose. It's ideal for those involved in running, supporting, or reporting within charitable organisations. From planning costs to responding to financial puzzles with a level head, this is where spreadsheet meets strategy—without any need for complicated jargon or beige PowerPoint slides. Learning Outcomes: Understand accounting principles for charity-related finance roles. Analyse financial data to support planning and decision-making. Evaluate charity business activities through structured analysis. Interpret financial reports in a management-led context. Identify and respond to financial and operational issues. Apply structured approaches to charity-focused problem solving. Who Is This Course For: Charity finance officers handling budgeting and expenditure. Admin staff supporting financial reporting within charities. Charity managers overseeing funding and financial planning. Support workers assisting with operational decision-making. Grant officers reviewing costs and funding allocations. Entry-level accountants within charitable organisations. Trustees or board members reviewing charity performance. Fund programme staff handling budgeting-related queries. Career Path (UK Average Salaries): Charity Accountant – £36,000 per year Financial Analyst (Charity) – £37,000 per year Business Analyst (Non-profit) – £38,000 per year Budget Officer – £32,000 per year Operations Coordinator (Charity) – £30,500 per year Programme Finance Officer – £34,000 per year

Learn with Case Study - Market Research Course Overview: This course, "Learn with Case Study - Market Research," provides an in-depth understanding of the principles and techniques used in market research. It is designed to equip learners with the knowledge necessary to assess market trends, consumer behaviour, and competitive landscapes effectively. Through the use of real-world case studies, participants will gain valuable insights into the application of market research methodologies in various industries. By the end of the course, learners will be able to conduct research, analyse data, and make informed decisions that drive business strategies and growth. This course is ideal for those seeking to enhance their market research skills and apply them to professional practice. Course Description: In this course, learners will explore the core concepts of market research, including data collection, analysis techniques, and the interpretation of findings. The course integrates case studies to demonstrate how these methods are applied in real-life scenarios across different sectors. Key topics covered include survey design, focus groups, consumer behaviour analysis, and competitor research. Learners will develop the ability to evaluate and synthesise market data to inform strategic business decisions. The course encourages critical thinking, data interpretation, and strategic application, ensuring that learners can effectively utilise market research to support business objectives. By the end of the course, participants will have the skills to execute comprehensive market research projects. Learn with Case Study - Market Research Curriculum: Module 01: Introduction to Market Research Module 02: Data Collection Techniques Module 03: Case Study: Market Research in Action Module 04: Data Analysis and Interpretation Module 05: Consumer Behaviour and Market Segmentation Module 06: Reporting and Presenting Research Findings (See full curriculum) Who is this course for? Individuals seeking to improve their market research skills. Professionals aiming to enhance their strategic decision-making abilities. Beginners with an interest in understanding market dynamics. Those working in marketing, sales, or business strategy roles. Career Path: Market Research Analyst Marketing Manager Business Development Specialist Consumer Insights Analyst Data Analyst

Overview This comprehensive course on IT For Recruiters will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This IT For Recruiters comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this IT For Recruiters. It is available to all students, of all academic backgrounds. Requirements Our IT For Recruiters is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 8 sections • 60 lectures • 05:10:00 total length •Introduction: 00:02:00 •What is hardware and software: 00:04:00 •Server: 00:08:00 •Project Life cycle: 00:06:00 •Software Development Life Cycle: 00:08:00 •Methodologies: 00:09:00 •CMS: 00:04:00 •API: 00:04:00 •CI/CD: 00:04:00 •Stacks: 00:03:00 •Native and Hybrid Native Apps: 00:02:00 •CTO: 00:13:00 •IT Architect: 00:08:00 •Product Owner: 00:12:00 •Project Manager: 00:13:00 •Product Manager: 00:06:00 •PO vs PM vs Product Manager: 00:07:00 •PO vs Product Manager: 00:04:00 •Business Analyst: 00:09:00 •Business Intelligence Specialist: 00:06:00 •Data Engineer: 00:05:00 •Data Scientist: 00:07:00 •Data Engineer vs Data Scientist: 00:07:00 •Agile Coach: 00:14:00 •Scrum Master: 00:08:00 •Agile Coach vs Scrum Master: 00:01:00 •Frontend Developer: 00:06:00 •Backend Developer: 00:06:00 •Fullstack Developer: 00:04:00 •Frontend vs Backend vs Fullstack Developer: 00:02:00 •iOS Developer: 00:03:00 •Android Developer: 00:04:00 •UX Designer: 00:10:00 •UI Designer: 00:08:00 •UX vs UI Designer: 00:04:00 •QA Engineer_Tester: 00:09:00 •SysAdmin: 00:07:00 •DevOps: 00:05:00 •SEO: 00:10:00 •Programming languages and frameworks. Intro: 00:01:00 •Programming languages and frameworks: 00:08:00 •Java: 00:03:00 •JavaScript: 00:02:00 •Python: 00:01:00 •C: 00:02:00 •C++: 00:03:00 •C#: 00:02:00 •HTML: 00:02:00 •PHP: 00:02:00 •SWIFT: 00:02:00 •Objective-C: 00:01:00 •Ruby: 00:02:00 •SQL: 00:02:00 •Go (Golang): 00:01:00 •Database: 00:05:00 •Types of Databases: 00:07:00 •The day of an IT Recruiter: 00:05:00 •Key principles: 00:03:00 •Sourcing Tipps: 00:03:00 •Good Bye Video: 00:01:00

Real Estate: Real Estate Agent, Property Management, Property Development & Marketing 5-in-1 Package Are you looking to excel in the real estate industry? Our all-inclusive 5-in-1 Real Estate bundle course covers everything you need to succeed: Real Estate Agent training, Property Management skills, Property Development insights, and effective Marketing strategies. According to Reed a Real Estate Agent can earn from £45,000 to £55,000 in a year depending on qualification, experience, location and other factors. Transform your career with our expert-led real estate course. Whether you are just starting out or looking to enhance your skills, this course is designed to provide you with the knowledge and tools you need to thrive in the real estate market. Enrol now and take the first step towards a successful career in real estate! Key Features: This Real Estate: Real Estate Agent, Property Management, Property Development & Marketing course comes with: CPD Certified Developed by Specialist Lifetime Access Enrol this 5-in-1 Package This Real Estate: Real Estate Agent, Property Management, Property Development & Marketing course TODAY and Excel in this field. Course Curriculum Real Estate: Real Estate Agent, Property Management, Property Development & Marketing course: Section 1: Foundations of Real Estate 1.1 Real Estate Agent Overview 1.2 Various Real Estate Agent Specializations 1.3 Regulatory Framework for Real Estate Agents Section 2: Starting & Building Your Career as an Agent 2.1 Initiating Your Professional Journey 2.2 Property Listing: Identifying Sellers 2.3 Property Valuation Procedures 2.4 Negotiation Techniques for Real Estate Agents 2.5 Property Sales: Attracting Buyers 2.6 Property Leasing 2.7 Technological Tools for Real Estate Professionals Section 3: Property Management Essentials 3.1 Basics of Property Management 3.2 Legal Considerations in Property Management Section 4: Introduction to Property Development 4.1 Introduction to Property Development 4.2 Diverse Property Types 4.3 Property Research Fundamentals 4.4 Compliance with Building Regulations 4.5 The Planning Phase in Property Development 4.6 Project Management in Property Development Section 5: Financing & Marketing in Real Estate 5.1 Varied Financing Options 5.2 Property Marketing Techniques Learning Outcomes After completing this Real Estate: Real Estate Agent, Property Management, Property Development & Marketing course, you will be able to: Identify diverse roles within the real estate agent profession. Apply techniques for property listing and valuation processes. Understand the legal aspects of property management and ownership. Analyse various property development types and regulatory frameworks. Evaluate different financing options relevant to real estate transactions. Implement marketing strategies specific to the property market. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Real Estate Agent, Property Management, Property Development & Marketing course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Real Estate Agent, Property Management, Property Development & Marketing. Moreover, this course is ideal for: Aspiring real estate agents seeking foundational knowledge. Individuals interested in property management basics. Those exploring property development as a potential career. Individuals keen on understanding real estate financing options and also property development & marketing. Professionals looking to enhance their real estate marketing skills. Requirements There are no requirements needed to enrol into this Real Estate Agent, Property Management, Property Development & Marketingcourse. We welcome individuals from all backgrounds and levels of experience to enrol into this Real Estate: Real Estate Agent, Property Management, Property Development & Marketing course. Career path After finishing this Real Estate Agent, Property Management, Property Development & Marketing course you will have multiple job opportunities waiting for you. Some of the Job sectors of Real Estate Agent, Property Management, Property Development & Marketing are: Property Valuer Letting Agent Property Developer Real Estate Analyst Property Manager Marketing Executive in Real Estate Sector Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

Overview This comprehensive course on Business Analystics for Beginners Using SASS will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Analystics for Beginners Using SASS comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Business Analystics for Beginners Using SASS. It is available to all students, of all academic backgrounds. Requirements Our Business Analystics for Beginners Using SASS is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 73 lectures • 08:10:00 total length •SAS Introduction: 00:07:00 •Introduction to SAS Program: 00:05:00 •Read SAS Dataset: 00:09:00 •Practice Read Dataset: 00:08:00 •Practical Example on Read Dataset: 00:02:00 •Introduction to SAS Dataset: 00:12:00 •SAS Dataset Practical Example: 00:07:00 •SAS Dataset Practical Program: 00:06:00 •DateValue: 00:03:00 •SAS Formats Part 1: 00:13:00 •SAS Formats Part 2: 00:09:00 •Reading Excel Worksheets: 00:05:00 •Reading Excel Worksheet Example: 00:11:00 •Date Format Example: 00:06:00 •Raw Data File Standard Part 1: 00:09:00 •Raw Data File Standard Part 2: 00:08:00 •Raw Data File Standard Example: 00:06:00 •Raw Data File Non Standard: 00:07:00 •Raw Data File Non Standard Example: 00:06:00 •Length Statement: 00:02:00 •Compilation Execution: 00:04:00 •Heading: 00:01:00 •Dataerrors: 00:05:00 •Data Errorsz Example: 00:03:00 •Validate Data Procfreq: 00:05:00 •Validate Data Procpront: 00:07:00 •Validate Data Peocmeans: 00:05:00 •Dat Constant: 00:07:00 •Assignment Statement: 00:09:00 •If Then Statement: 00:09:00 •If Then Do End Statement: 00:09:00 •Diff Where and If Statement: 00:02:00 •Keep Drop: 00:08:00 •Keep Drop Example: 00:04:00 •Append: 00:09:00 •Append Examples part 1: 00:09:00 •Append Examples part 2: 00:07:00 •Concatenate: 00:12:00 •Merge: 00:06:00 •Merge One to One: 00:07:00 •Merge One to Many: 00:04:00 •Merge Non Match: 00:04:00 •Global Statements: 00:09:00 •Global Statements Examples Part 1: 00:08:00 •Global Statements Examples Part 2: 00:06:00 •Title n Foot Note: 00:05:00 •Title n Foot Note Example: 00:08:00 •By Statement: 00:08:00 •Multiple Where Stament: 00:03:00 •ODS: 00:07:00 •ODS Example: 00:04:00 •Sas Date Function: 00:10:00 •Sas Date Function Example: 00:08:00 •Sas Functions Part 1: 00:10:00 •Sas Functions Part 2: 00:08:00 •Sas Functions: 00:07:00 •Sas Functions Example Part 1: 00:07:00 •Sas Functions Example Part 2: 00:09:00 •Multiple SAS Datasets Part 1: 00:05:00 •Multiple SAS Datasets Part 2: 00:02:00 •Multiple SAS Datasets Example: 00:09:00 •Select Group: 00:09:00 •Select Group Example: 00:08:00 •Do Loop Part 1: 00:07:00 •Do Loop Part 2: 00:06:00 •Do Loop Example: 00:07:00 •Array Part 1: 00:05:00 •Array Part 2: 00:08:00 •Array DoLoop: 00:06:00 •ArrayTemp: 00:05:00 •Array Example: 00:10:00 •Sas Statement Part 1: 00:04:00 •Sas Statement Part 2: 00:05:00