• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

6124 Courses delivered Online

Level 2 & 3 Financial Investigator: Financial Crimes

By Imperial Academy

Level 3 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 120 CPD Points | Lifetime Access

Level 2 & 3 Financial Investigator: Financial Crimes
Delivered Online On Demand
£100

Road to Passive Income

5.0(1)

By Course Gate

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Road to Passive Income course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Road to Passive Income course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Road to Passive Income and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Road to Passive Income course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Road to Passive Income course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Road to Passive Income will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Introduction Introduction 00:04:00 Section 02: What are Recurring Income Streams? What are Recurring Income Streams? 00:05:00 What Is the Recurring Revenue Model? 00:04:00 What Should You Sell to Make the Recurring Revenue Model Work? 00:05:00 The Importance of Recurring Revenue in a Thriving Business 00:03:00 Reasons Fortune 500 Companies Are Moving to Recurring Revenue Models 00:03:00 How Recurring Revenue Increases Business Value 00:06:00 Section 03: What is Residual Income? What is Residual Income? 00:04:00 What Is Residual Income And Why Do You Want It? 00:03:00 What is Residual Income & Why is it Important for Building Wealth? 00:04:00 Reasons Why Passive Income Is Important 00:04:00 How Does Residual Revenue Work? 00:04:00 Why Residual Income is Important for Financial Independence 00:05:00 Section 04: Types of Recurring Income Types of Recurring Income 00:04:00 Hard contracts 00:05:00 Auto renewal subscriptions 00:04:00 Build a Membership Program for Your Business 00:03:00 Become an Affiliate for Other Companies Products 00:03:00 Combine Online Membership and Physical Product Delivery 00:04:00 Section 05: Types of Residual Income Types of Residual Income 00:05:00 Consider Investing 00:04:00 Write a Book or E-Book 00:04:00 Build an Online Course 00:05:00 Create an App 00:04:00 Launch a Podcast 00:02:00 Section 06: Relationship between Recurring, Residual and Passive Income Relationship between Recurring, Residual and Passive Income 00:04:00 How They're Similar and also Different 00:04:00 What is Passive Income and Its Relationship to Passive and Residual Income? 00:04:00 Examples of Passive Income 00:04:00 The Truth about Active Income vs Passive Income 00:03:00 Active Income Becomes Passive Income 00:03:00 Section 07: Building Wealth Strategies Building Wealth Strategies 00:04:00 Effective Wealth Building Strategies Used by Personal Finance Pros 00:04:00 Develop a Wealthy Mindset 00:03:00 Strategies for Building Wealth 00:05:00 Strategies to Build Wealth Fast (That Your Financial Advisor Won't Tell You) 00:04:00 How to Begin to Build Wealth 00:04:00 Section 08: Conclusion Review 00:03:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Road to Passive Income
Delivered Online On Demand2 hours 30 minutes
£11.99

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

4.5(3)

By Studyhub UK

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thank you Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Delivered Online On Demand6 hours 8 minutes
£10.99

ISO 31000:2018 (RM) Auditor Training Course

By TUVSW Academy

ISO 31000:2018 is an international standard of Risk Management, the existence of it requires competent personnel to interpret its guidelines, address those to integrate Risk Management in an organization’s operations and audit organization to assess the implementation and effectiveness of overall implementation. This course is designed for professionals who are responsible of any aspect of Risk Management as well as for those, specifically, who are pursuing their career in the field of auditing Risk Management. This course enhances the knowledge and skills of delegates to understand the standard and audit it effectively. Course is consisting of study material in form of written details. Attendees of this course will be, on completion, competent to implement Risk Management, Plan, Conduct & Report 1st, 2nd & 3rd party audits. This course also discusses about different risk assessment techniques such as Brainstorming Structured or semi-structured interviews Delphi technique Check-lists Preliminary hazard analysis (PHA) HAZOP Hazard analysis and critical control points (HACCP) Toxicity assessment Structured “What-if” Technique (SWIFT) Scenario analysis Business impact analysis (BIA) Root cause analysis (RCA) Failure modes and effects analysis (FMEA) and failure modes and effects and criticality analysis (FMECA) Fault tree analysis (FTA) Event tree analysis (ETA) Cause-consequence analysis Cause-and-effect analysis Layers of protection analysis (LOPA) Decision tree analysis Human reliability assessment (HRA) Bow tie analysis Reliability centred maintenance Sneak analysis (SA)and sneak circuit analysis (SCI) Markov analysis Monte Carlo simulation Bayesian statistics and Bayes Nets FN curves Risk indices Consequence/ probability matrix Cost/benefit analysis (CBA) Multi-criteria decision analysis (MCDA)   Features of Couse ✔ 100% Online Self-paced: Considering the busy lives, we have designed this course to be attended online without bounding with the schedules. To make it interactive, we have created different communication groups where candidate can discuss the points with other fellows as well as the trainers of course. ✔ Testing the Learning: Each section of course is covered with exercise to check your knowledge in real-time, and overall result is affected by exercises you complete. ✔ Self-Scheduling: This 40 Hours full fledge course is designed to match you schedule. You will get a life time access to this course and complete it on your ease. ✔ Superlative Material: The training is designed, developed and reviewed by competent auditors having an extensive experience of auditing in different regions of world. ✔ Approved Course: The course is approved by one of the well-known personal certifying body “IRCP”.   Who should attend this? This course is recommended to be attended by those who are involved in implementation and/ or auditing of Risk Management System, specifically Risk Managers, Auditors and others willing to add credibility with a widely accepted qualification for auditing. Also, recommended to satisfy the applicable requirement of training and competence, if any. This course can add values to your profile if you are Intending to perform audits of RM. A Risk Management Executive/ Management Representative An Existing Internal Auditor A Ris Management Consultant Responsible for implementing the ISO 31000 standard. Responsibility to evaluate the outcome of internal RM audits and have responsibility/ authority to improve the effectiveness of the RM. Pursuing to make career in RM auditing.   Course Duration: 40 Learning Hours and extended time of exercise & Exam.   Certificate: Those who pass all exercises with 50% at least in each exercise and 70% overall marks will be awarded with successfully completion certificate with approval of Exemplar Global and a Lifetime validity.   Language of Course: English   Pre-Requisites: Knowledge of Risk Management

ISO 31000:2018 (RM) Auditor Training Course
Delivered Online On Demand
£198

Successfully manage customer expectations during each stage of the customer journey

By Beyond Satisfaction - Customer service Training

If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on managing expectations successfully.

Successfully manage customer expectations during each stage of the customer journey
Delivered in person or OnlineFlexible Dates
Price on Enquiry

Business Law - CPD Accredited

5.0(10)

By Apex Learning

***Limited Time Offer*** Give a compliment to your career and take it to the next level. This Business Law will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Business Law will help you keep ahead of the pack. The Business Law incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and knowledge, reaching out to the level of expertise required for your position. Further, this Business Law will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of Business Law, you can equip yourself with the essentials to keep you afloat into the competition. Along with this Business Law course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. Courses are included in this Bundle: Course 01: Business Law Course 02: Commercial Law 2021 Course 03: Compliance & Business Risk Management Course 04: GDPR Data Protection Level 5 Course 05: Level 3 Tax Accounting Course 06: Investment Course 07: Business Analysis Level 3 Course 08: Budgeting and Forecasting Course 09: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 10: Business Writing Course 11: Workplace Confidentiality So, enrol now to advance your career! How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum: Course 1: Business Law Course 2: Commercial Law 2021 01: Introduction of Commercial law 02: Business Organisations 03: International Trade: the Theory, the Institutions, and the Law 04: Sales of Goods Law 05: Consumer Law and Protection 06: E-Commerce Law 07: Competition Law Course 3: Compliance & Business Risk Management 1: Introduction to Compliance 2: Five basic elements of compliance 3: Compliance Management System (CMS) 4: Compliance Audit 5: Compliance and Ethics 6: Risk and Types of Risk 7: Introduction to Risk Management 8: Risk Management Process Course 4: GDPR Data Protection Level 5 01: GDPR Basics 02: GDPR Explained 03: Lawful Basis for Preparation 04: Rights and Breaches 05: Responsibilities and Obligations Course 5: Level 3 Tax Accounting 01: Tax System and Administration in the UK 02: Tax on Individuals 03: National Insurance 04: How to Submit a Self-Assessment Tax Return 05: Fundamentals of Income Tax 06: Payee, Payroll and Wages 07: Value Added Tax 08: Corporation Tax 09: Double Entry Accounting 10: Management Accounting and Financial Analysis 11: Career as a Tax Accountant in the UK Course 6: Investment 01: Introduction to Investment 02: Types and Techniques of Investment 03: Key Concepts in Investment 04: Understanding the Finance 05: Investing in Bond Market Course 7: Business Analysis Level 3 01: Introduction to Business Analysis 02: Business Processes 03: Business Analysis Planning and Monitoring 04: Strategic Analysis and Product Scope 05: Solution Evaluation Course 8: Budgeting and Forecasting Unit-1. Introduction Unit-2. Detail Budget Requirement Unit-3. Process of Making Budget Course 9: Fraud Management & Anti Money Laundering Awareness Complete Diploma 01: Introduction to Money Laundering 02: Proceeds of Crime Act 2002 03: Development of Anti-Money Laundering Regulation 04: Responsibility of the Money Laundering Reporting Office 05: Risk-based Approach Course 10: Business Writing Words to Cut Building Strong Sentences SCQA How to Write Punchy Summaries Words that Work, Feedback that Improves ProofReading Makes Perfect Course 11: Workplace Confidentiality 01: Introduction to workplace confidentiality 02: Business Etiquettes and Types of Confidentiality 03: The Importance of Confidentiality 04: Confidentiality with Co-workers 05: Preventing Confidentiality Breach 06: How Employers Can Protect Confidential Information CPD 120 CPD hours / points Accredited by CPD Quality Standards Certificates Certificate of completion Digital certificate - Included

Business Law - CPD Accredited
Delivered Online On Demand
£53

Microsoft Excel Advanced

By Microsoft Office Training

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

Microsoft Excel Advanced
Delivered OnlineFlexible Dates
£550

AML : Anti Money Laundering

By Training Tale

AML: AML Online Are you interested in learning more about Anti-Money Laundering (AML) Training? With the help of this fantastic Anti-Money Laundering (AML) Training, you can step forward to progress in your career. This Anti-Money Laundering (AML) Training explains introduction to money laundering to full training and awareness. The Proceeds of Crime Act of 2002 and the Development of Anti-Money Laundering (AML) Legislation are also covered in Anti-Money Laundering (AML) Training curriculum. The responsibilities of the officer, risk management, and client handling are also covered in this Anti-Money Laundering (AML) Training. After Anti-Money Laundering (AML) Training, you will examine the record-keeping process and agent management system. Enrol our dedicated Anti-Money Laundering (AML) Training, so that you can immediately increase your knowledge and discover the duties and obligations of an AML (Anti Money Laundering) expert! Special Offers of this AML: AML Course This AML: AML Course includes a FREE PDF Certificate. Lifetime access to this AML: AML Course Instant access to this AML: AML Course Get FREE Tutor Support from Monday to Friday in this AML: AML Course Courses you will GET : Course 01: Anti-Money Laundering (AML) Course 02: Diploma in Forex Trading Course 03: Level 5 Accounting and Finance [ Note: Free PDF certificate will provide as soon as completing the AML: Anti-Money Laundering (AML) Training course ] AML: AML Industry Experts Designed this AML: Anti-Money Laundering (AML) Training course into 8 detailed modules. Assessment Method of AML After completing each module of the AML: Anti-Money Laundering (AML) Training Course, you will find automated MCQ quizzes. Certification of AML After completing the MCQ/Assignment assessment for this AML: Anti-Money Laundering (AML) Training course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? AML : AML This Anti-Money Laundering (AML) Training is recommended for anybody who want to protect their organisation and clients. Requirements AML : AML There are no specific requirements for this AML: Anti-Money Laundering (AML) Training course. Career path AML : AML Taking our Anti-Money Laundering (AML) Training to get employment as an AML officer, compliance officer, risk manager, manager, or director, among other positions. Certificates Certificate of completion Digital certificate - Included

AML : Anti Money Laundering
Delivered Online On Demand3 hours
£12

Oil and Gas Management

By Compliance Central

Oil and Gas Management course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in Oil and Gas Management. Our course starts with the basics of Oil and Gas Management and gradually progresses towards advanced topics. Therefore, each lesson of this Oil and Gas Management is intuitive and easy to understand. So, stand out in the job market by completing the Oil and Gas Management course. Get an accredited certificate and add it to your resume to impress your employers. Along with the Oil and Gas Management course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Curriculum Breakdown of the Course:- Introduction to Oil and Gas Management Energy, Economics and Finance in Oil and Gas Oil and Gas Project Management Managing Oil and Gas Pipelines Project Risk Analysis Managing Communication and Conflict Oil and Gas Health and Safety CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Oil and Gas Management course. Requirements To enrol in this Oil and Gas Management course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Oil and Gas Management. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Oil and Gas Management
Delivered Online On Demand3 hours
£12

Family Law Diploma Training

By Compliance Central

INVEST Your WORTH to Dig SKILLS TREASURE < Take an Offer, Get Started with Worry-free Access & Claim a BIGGER Saving > Family Law course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in Family Law. Our course starts with the basics of Family Law and gradually progresses towards advanced topics. Therefore, each lesson of this Family Law is intuitive and easy to understand. So, stand out in the job market by completing the Family Law course. Get an accredited certificate and add it to your resume to impress your employers. Along with the Family Law course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Course contains advanced and latest curriculum study modules: Module 01: Introduction to Family Law Module 02: Framing Family Law Module 03: Marriage in Family Law Module 04: Civil Partnership and Cohabitation Module 05: Nullity in Marriage Module 06: Divorce and Family Law Module 07: Child Custody Module 08: Property and Finance on Divorce Module 09: Child Support and Family Law Module 10: Adoption Process Module 11: Domestic Violence Module 12: Gender Equality Module 13: Feminist Perspectives CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this course. Requirements To enrol in this course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Family Law, such as- Family Support Worker Family Solicitor Family Safeguarding Local Campaigns Officer Family Engagement Manager

Family Law Diploma Training
Delivered Online On Demand5 hours
£12