17128 Other courses delivered Online

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

Duration 2 Days 12 CPD hours This course is intended for This certification is for anyone who interfaces with stakeholders or works as a Product Owner in a Scrum Team. Scrum Product Owner Certified (SPOC?) certification exam is designed to confirm applicants practical and working knowledge of Scrum that equips them to handle the business aspects and stakeholders in a Scrum environment. Successful candidates will be awarded the Scrum Product Owner Certified (SPOC?)certification by SCRUMstudy after passing the included certification exam. The certification exam voucher is included in this course so you can take the exam at your convenience. Agile & Scrum Overview What is Agile? Why use Agile? The Agile Manifesto Principles of the Agile Manifesto Agile Methods Other Agile Methods Scrum Overview Scrum Summary Scrum Roles Scrum Roles The Product Owner The Scrum Team The Scrum Master Advantages of Cross-functional Teams Planning in Scrum Scrum Flow Requirements in Scrum Prioritizing the Product Backlog Adaptive Project Management Scrum Planning User Stories The Concept of Persona Acceptance Criteria Generic Done Criteria Criteria for a Good User Story Estimation Importance of Value Risk Burndown Graphics Scrum Board Sprint Planning Sprints (from Product Owner?s point of view) Sprint Planning Meeting Planning Game Task Estimation The Sprint Backlog Implementation of Scrum Daily Stand-up Meeting Sprint Review Meeting Sprint Retrospective Meeting Product Backlog Grooming Scrum for Large Projects Scrum for Large Projects The Chief Product Owner Distributed teams in Scrum Transition to Scrum Mapping Traditional Roles to Scrum Maintaining Stakeholder Involvement Note SCRUMstudy has authored the SBOK? Guide as a comprehensive guide to deliver successful projects using Scrum. SCRUMstudy works through its large global partner network of Authorized Training Providers (A.T.P.s) to deliver trainings and certifications. New Horizons is a proud Authorized Training Provider of SCRUMstudy.

NodeJS allows you to build complex and powerful applications quickly and easily, writing JavaScript code. It also allows you to use JavaScript for web applications with flexibility for a wide range of different purposes. Learn about MongoDB as a database and how to build it as well as Express as a framework to build web apps on top of Node.js.

ChatGPT for Marketing and Productivity with AI Tools Course Overview: This course provides an in-depth exploration of ChatGPT and other AI tools in the context of marketing and productivity. Designed for individuals keen on integrating AI into their business strategies, it covers essential techniques and applications to enhance marketing efforts and streamline work processes. Learners will gain insights into leveraging AI for targeted campaigns, content creation, and automation, while also learning how to increase personal and team productivity using AI tools. By the end of the course, learners will have a clear understanding of how to apply AI-driven solutions to achieve measurable results in marketing and productivity. Course Description: In this course, learners will explore the dynamic field of AI-powered marketing and productivity tools. Key topics include the AI Marketing Playbook, which introduces learners to the fundamentals of using AI in marketing, followed by strategies for utilising ChatGPT and other AI tools for content creation, social media campaigns, and customer engagement. Additionally, learners will discover various AI tools designed to optimise productivity, including project management, data analysis, and communication tools. This course provides a comprehensive approach, equipping learners with the knowledge to harness AI’s capabilities in improving both marketing efforts and workplace efficiency. ChatGPT for Marketing and Productivity with AI Tools Curriculum: Module 01: The AI Marketing Playbook Module 02: How to Use ChatGPT and AI for Marketing Module 03: Productivity with AI Tools (See full curriculum) Who is this course for? Individuals seeking to enhance their marketing efforts with AI. Professionals aiming to boost their productivity using AI-driven tools. Beginners with an interest in AI technologies and marketing. Business owners looking to streamline marketing and productivity. Career Path: Digital Marketing Specialist Marketing Automation Expert AI Solutions Specialist Productivity Consultant Marketing Manager

2 QLS Endorsed Courses | CPD Certified | Free PDF & QLS Hardcopy Certificates | 180 CPD Points | Lifetime Access

Most people think working in the legal sector requires you are a lawyer, a top-level solicitor or a paralegal. But in reality, it not true at all! To become a legal secretary, all you need relevant knowledge and information about legal phases to assist attorneys managing their caseload and achieve goals. Through this Legal Secretary Certified Training Course, you will be trained you to become a legal assistant or administrator within a solicitor or barrister office. This course also includes the basic concepts of the legal system along with courts, crime, controversy, law and crime, state courts, and legal terminology. By taking this course, you'll not only qualified as a legal secretary but also can work as a secretary or administrator in any other field. Course Highlights The price is for the whole course including final exam - no hidden fees FREE accredited certificate upon successful completion Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat Legal Secretary Certified Training Course has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Legal Secretary Certified Training Course is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £30,000. The sky really is the limit. Course Curriculum Legal Secretary Introduction Legal Secretary Introduction 00:06:00 Courts, Crime, and Controversy The Courts and the Criminal Justice System 00:16:00 Actors in the Courthouse 00:10:00 Criminal vs Civil Court Cases 00:16:00 Law on the Books and in Action 00:06:00 Law and Crime The Basis of American Law 00:16:00 Sources of American Law 00:14:00 Civil Disputes and Criminal Law 00:17:00 State Courts State Courts 00:12:00 Arrest to Arraignment Crime and Arrest 00:13:00 Bail 00:10:00 Preliminary Hearing, Grand Jury, and Arraignment 00:06:00 Trials and Juries History of Trials by Jury 00:12:00 Overview of Basic Evidence 00:06:00 Steps In The Trial Process 00:12:00 Appellate Courts Nature of the Appellate Process 00:10:00 Legal Terminology Legal Terminology 00:16:00 Mock Exam Final Exam

Level 3 QLS Endorsed | 120 CPD Points| +Gifts: QLS Certificate + PDF Certificate | Lifetime Access| 24/7 Learner Support

It is estimated that more than 1.2 million people in the UK are living with a learning disability. Healthcare and social care workers must have an adequate understanding of the needs of people with learning disabilities. It is also essential that they listen to the needs, hopes and aspirations of those living with learning disabilities, their careers, friends, and families. An improved knowledge, together with current guidance and best practice recommendations help to improve the care provided to people who have learning disabilities.

A 1 hour guide to building a Circle of Support around a disabled adult

Overview of Copywriting Masterclass Words are powerful. In today’s online world, good writing can help a business grow fast. The UK copywriting industry has grown by 21% in the last three years. This shows how important skilled copywriters have become. Businesses need clear and strong writing to stand out, and that’s where our Copywriting Masterclass comes in. This course gives you the skills to write copy that gets attention and helps people take action. You will learn how to write headlines that make people want to read more. You’ll also follow a proven nine-step copywriting process that top copywriters use. The Copywriting Masterclass also shares simple formulas that have worked for years. You’ll understand how to use words to connect with your audience and gently guide them to act—whether it’s buying something, signing up, or clicking a link. Whether you are writing for websites, emails, or social media, the Copywriting Masterclass teaches you how to write with purpose. You’ll get tips on writing clearly, using the right tone, and making every word count. Many learners who completed the Copywriting Masterclass are now working with top brands or earning well as freelancers. If you want to improve your writing and start creating results with your words, this course is the right choice for you. By completing this Copywriting Masterclass Course, you will be able to: Understand the key rules of writing copy that works. Use copywriting skills in ads, websites, emails, and more. Write strong headlines that grab attention right away. Use smart marketing tricks to write better sales copy. Follow a step-by-step copywriting method used by experts. Write content that’s clear, catchy, and made to convert. Who is this course for? Marketing professionals who want to write better copy that sells. Small business owners who prefer writing their own content. Content creators who want to turn readers into buyers. Anyone thinking about starting a career in copywriting. Entrepreneurs who need to explain their ideas clearly and get results. Process of Evaluation After studying the Copywriting Masterclass Course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Copywriting Masterclass Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Requirements You don’t need any educational qualification or experience to enrol in the Copywriting Masterclass course. Career Path After completing this Copywriting Masterclass course, you can work in roles like: Copywriter – £25,000 to £45,000 per year Content Marketing Specialist – £28,000 to £50,000 per year Digital Marketing Executive – £23,000 to £38,000 per year SEO Content Writer – £22,000 to £40,000 per year Freelance Copywriter – £30,000 to £65,000 per year Course Curriculum Section 1: Introduction Unit 1: Welcome to the Copywriting Course 00:05:00 Unit 2: Course Overview 00:04:00 Section 2: Introduction to Copywriting Unit 1: What is Copywriting 00:05:00 Unit 2: Elements of Great Copy 00:11:00 Unit 3: Traditional vs Modern Copywriting 00:04:00 Unit 4: Career Options for Copywriters 00:12:00 Unit 5: Job Description and Responsibilities of a Copywriter 00:06:00 Unit 6: Copywriting vs Content Writing: The Difference 00:04:00 Section 3: Core Concepts of Copywriting Unit 1: What is a Short Form Copy 00:03:00 Unit 2: What is a Long Form Copy 00:02:00 Unit 3: Types of Tones Used for Writing Copy 00:06:00 Unit 4: Which Types of Tone You Should Use 00:07:00 Unit 5: Identifying the Target Audience 00:06:00 Unit 6: Qualities That Will Make You a Successful Copywriter 00:06:00 Section 4: Marketing Tactics to Write Copy That Sells Unit 1: The Secret to Understand Buyer’s Mindset 00:04:00 Unit 2: Never Make Your Copy Look Like an Ad 00:06:00 Unit 3: 2 Second Hack to Become a Successful Copywriter 00:05:00 Unit 4: Features vs Benefits 00:04:00 Unit 5: The Shocking Truth about Buyers & Customers 00:04:00 Unit 6: So What Test 00:05:00 Unit 7: FOMO: How to Use This Most Powerful Marketing Tool 00:08:00 Unit 8: What’s in It for Me 00:04:00 Unit 9: The Secret to Sell Instantly 00:05:00 Unit 10: Leveraging the Power of Emotions 00:04:00 Section 5: The Copywriting Process: 9 Steps to Make It Easier For You Unit 1: Steps in the Copywriting Process 00:08:00 Unit 2: Understand the Product 00:06:00 Unit 3: Performing Competitor Analysis 00:12:00 Unit 4: Create a Buyer Persona / Customer Avatar 00:06:00 Unit 5: Writing the copy 00:01:00 Unit 6: Editing the Copy 00:02:00 Unit 7: Adding Design Elements + Media 00:07:00 Unit 8: Publish the Copy + Promotion 00:02:00 Unit 9: Checking the Conversion from Copy – Measuring Results 00:03:00 Section 6: Copywriting Formulas Unit 1: AIDA: The 4 Step Formula 00:05:00 Unit 2: Storytelling: Best Tool for Converting Readers into Buyers 00:05:00 Unit 3: 3 STEP Formula: PAS 00:06:00 Section 7: Headlines Unit 1: Section Introduction 00:01:00 Unit 2: Intro to Headlines 00:07:00 Unit 3: Importance of Headlines 00:03:00 Unit 4: Formula to Write Amazing Headlines (Everytime) 00:09:00 Unit 5: How to Use This Formula (With Examples) 00:02:00 Unit 6: Free Tool to Create Attractive Headlines 00:03:00 Unit 7: Practice Exercise 00:01:00 Section 8: 6 Hacks to Write Headlines That Readers Cannot Resist Unit 1: Section Intro 00:02:00 Unit 2: Headline Hack # 1 00:01:00 Unit 3: Headline Hack # 2 00:02:00 Unit 4: Headline Hack # 3 00:02:00 Unit 5: Headline Hack # 4 00:04:00 Unit 6: Headline Hack # 5 00:02:00 Unit 7: Headline Hack # 6 00:03:00 Unit 8: Quick Recap 00:01:00 Section 9: Creating the Copy Unit 1: Creating Call to Actions (CTA) That Reader’s Cannot Resist 00:04:00 Unit 2: Focus on the Customer 00:06:00 Unit 3: How to Write a Conversational Copy 00:03:00 Section 10: Hacks & Tips Unit 1: Collect Winning Pieces 00:04:00 Unit 2: 3 Extremely Powerful Words That You Must Use in a Copy 00:02:00 Unit 3: Using Customer’s Words 00:05:00 Section 11: Practice Exercises Unit 1: Recreate Ads 00:01:00 Unit 2: Record Your Copy 00:02:00 Section 12: Conclusion Unit 1: Conclusion 00:01:00