118 Courses in Nottingham delivered Online

Duration 5 Days 30 CPD hours This course is intended for This class is ideal for experienced Salesforce Administrators, business analysts, and implementation specialists looking to gain a greater technical understanding of Salesforce CPQ Administration. It's also designed for experienced administrators, solution architects, implementation consultants, and developers looking to understand the full capabilities of Salesforce CPQ in order to formulate solutions for their business. This class is also a great foundation builder for anyone looking to earn the Salesforce CPQ Specialist credential. Overview When you complete this course, you'll be able to: Set Up Products, Bundles, and Product Rules Build Price Rules to Automatically Populate Field Values While Quoting or Configuring a Bundle Set Up Appropriate System Discounts and Pricing Methods Configure Dynamic Output Document Generation Manage Subscription Products (Including the Processes for Renewing and/or Amending Them) Formulate Sound Solutions to Common CPQ Business Requirements Make Significant Progress in Preparing for the Salesforce Certified CPQ Specialist Exam Discover how to configure an end-to-end Salesforce CPQ solution with out-of-the-box functionality. In this 5-day class, our CPQ experts will give you an in-depth look at Salesforce CPQ and its applications. You?ll learn how to set up and manage products, configure discount and pricing methods, create and manage subscriptions, and formulate solutions to meet common CPQ business requirements so you can successfully implement a Salesforce CPQ solution for your company. Course Introduction Review Course Objectives Set Learner Expectations Review Housekeeping Rules Explore Additional Course Resources Review Exam Quick Facts Introduction to CPQ Understand the Business Case for CPQ Watch an End-to-End Solution Demo Build a Quote Object Model Foundations Get Familiar with Products, Price Books, and Price Book Entries Review Product Fields Integral to Basic Salesforce CPQ Functionality Product Selection Modify Out-of-the-Box Button Behavior for Product Selection Review Guided Selling Bundle Configuration Define and Build Product Bundles Enforce Business Logic with Product Features Option Selection Guidelines Enforce Business Logic with Option Constraints Product Rules Define Product Rules Enforce Business Logic with Product Rules (Including Validation Rules, Alert Rules, Selection Rules, and Dynamic Bundles) Build Product Rules Using Supporting Objects (Including Error Conditions, Product Actions, Summary Variables, Configuration Rules, and Configuration Attributes) Pricing Methods Discover Pricing Waterfall Default Flows Review List Pricing, Cost Plus Markup, and Block Pricing Use Contracted Pricing for Negotiated Prices Subscription Pricing Configure Subscription and Proration Pricing Methods Understand How Subscription Pricing Methods Affect List and Regular Price Discounting Compare Discounting Strategies Build a Discount Schedule Price Rules Set Values for Quote and Quote Line Fields Declaratively Review CPQ Advanced Quote Calculator Calculation Events and Conditions Understand Price Action Sources (Including Static Values, Summary Variables, Formulas, and Lookup Tables) Create Lookup Queries to Outsource Evaluation to a Lookup Object Advanced Approvals Compare and Contrast the Advanced Approval Package Versus Native Approvals Define Approvers, Approval Chains, Approval Variables, and Approval Rules to Meet Specific Business Requirements Quote Templates Generate Dynamic Output Documents Create Conditional Template Content Localization and Multicurrency Make Accommodations for Localization Define Localization and How It Works in CPQ Orders Review Business Purposes of an Order Define the Data Model for Orders Define Data Requirements to Generate Orders Contracts, Renewals, and Amendments Generate New Contracts to Manage Active Subscriptions Related to an Account Review Amendment and Renewal Processes Review Renewal Pricing Methods Capstone Class Project: Troubleshoot Common Scenarios in Salesforce CPQ Design a Solution

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Duration 3 Days 18 CPD hours This course is intended for This course is designed for project leaders, scrum masters, coaches, product owners, and team members who intend on taking the PMI-ACP© exam. This course provides participants with a foundation of the PMI-ACP© exam. Participants will be introduced to PMI Agile concepts and practices with banks of sample questions. PMI-ACP© Exam Preperation PMI-ACP© Exam Particulars Overview PMI-ACP© Exam Particulars PMI-ACP© Candidate Requirements PMI-ACP© Candidate Fees PMI-ACP© Exam Application Process Core Agile Concepts Core Agile Concepts Overview Traditional Project Management Methodologies Drawbacks of Waterfall Methodologies Agile Approach Empirical Process Control Agile and Traditional Project Management Choice of Methodologies/Frameworks The Agile Manifesto The Agile Manifesto Overview Manifesto Contributors Manifesto Values Manifesto Principles Common Agile Methodology Elements Common Agile Methodology Elements Overview Project (Product; Release) Initiation Agile Planning Iteration Planning and Executing Project Initiation Project Initiation Overview Determine Project Justifications and Metrics Provide Value-Driven Delivery Write Project Vision Statement Create Project Charter Identify Stakeholders and Leader/Coach Form Project Team Agile Teams and Team Space Agile Teams and Team Space Overview Scrum Master/Coach Product Owner/Customer Team Members/Developers (XP) Trackers and Testers Other Roles Team Space Physical Space Recommendations Agile Planning Agile Planning Overview Develop Epics and Stories Create Stories Non-Customer Facing Stories Personas and Extreme Personas Story Maps Estimating Stories Prioritizing Stories Create Product Backlog Create Product Roadmap Conduct Release Planning Create Parking Lot Iterations/Sprints Iterations/Sprints Overview Velocity Determination Iteration Planning Meeting Iteration Planning Guidelines Development Testing Daily Standup Meetings Progress Tracking Velocity Tracking Interpersonal Aspects of Agile Interpersonal Aspects of Agile Overview Methodologies and Uncertainty Coach/Scrum Master Team Motivation Soft Skills Emotional Intelligence Collaboration Negotiations Active listening Conflict Resolution Speed Leas? Model of Group Conflict Conducting Retrospectives Mindsets of Agile Coaches Leadership Stages Key Coaching Responsibilities Agile Methodologies Agile Methodologies Overview XP and Scrum Terms XP Terms and Concepts XP Primary Practices XP Corollary Practices Scrum Lean Software Development Seven Principles of Lean Seven Types of Muda Responsibilities Core Beliefs of Lean-Agile Software Development Other Principles of Lean-Agile Software Development Value Stream Mapping Lean-Agile Software Development Portfolio Management Additional course details: Nexus Humans PMI Agile Certified Practitioner (PMI-ACP) Exam Preparation 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 PMI Agile Certified Practitioner (PMI-ACP) Exam Preparation 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.

Duration 3 Days 18 CPD hours This course is intended for This certification is appropriate for anyone interested in becoming familiar with the concepts and practices of Agile Project Delivery, and who wants to have a working knowledge of the various Agile methodologies. Overview Objectives are: To provide an understanding of Agile philosophy and practices To provide a working knowledge of various Agile methodologies To provide students with the ability to compare and choose which methodology is appropriate in a given situation To prepare participants to pass the SAMC™ exam Course outcomes: Participants will be familiar with the concepts and practices of Agile project delivery. Participants will be equipped with detailed knowledge and understanding of available Agile methodologies. Participants will be able to compare and choose the methodologies or parts of methodologies that are most relevant to their current and future situations. Participants will be armed with the proper tools to take the lead in Agile projects and to address and resolve Agile issues in their organizations. Participants will be SAMC certified. Agile relies on adaptive planning and iterative development and delivery. It focuses primarily on the value of people in getting the job done effectively.Successful candidates will be awarded the SCRUMstudy Agile Master Certified (SAMC?) 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. IntroductionAgile Overview Agile Defined Why Use Agile? Adaptive Project Management The Agile Manifesto Principles of the Agile Manifesto Declaration of Interdependence Difference between Waterfall and Agile Domains of Agile Practices Value-Driven Delivery Stakeholder Engagement Team Performance Practices Adaptive Planning Problem Detection and Resolution Continuous Improvement Agile Tools and Artifacts Lean Kanban Software Development Introduction Core Values Practices Understanding Lean Software Development Understanding Kanban Software Development Scrum Overview of Scrum Brief History of Scrum Why Use Scrum? Scalability of Scrum Scrum Principles Scrum Aspects Scrum Processes Scrum and Kanban Extreme Programming (XP) Introduction Core Values? Roles Practices XP Artifacts XP Events XP Release Adopting XP Test-Driven Development (TDD) Introduction The Process Dynamic Systems Development Methods (DSDM) Introduction Core Values Roles Practices Crystal Introduction Core Values Roles Practices The Process Feature Driven Development (FDD) Introduction Core Values Roles Practices The Process Comparison of Agile MethodsBest Fit Analysis ToolBlitz PlanningNote 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. Additional course details: Nexus Humans SCRUMstudy Agile Master Certified (SAMC) 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 SCRUMstudy Agile Master Certified (SAMC) 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.

**Don't Spend More; Spend Smarter** Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Save Up To £4,169 and get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Corporate Social Responsibility (CSR) will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate skills for your next promotion, this bundle will help you keep ahead of the pack. The Corporate Social Responsibility (CSR) incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Further, this Corporate Social Responsibility (CSR) 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 chosen field while also outlining essential career insights in this job sector. Consequently, you'll sharpen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the bundle, you can equip yourself with the essentials to keep you afloat in the competition. Along with this Corporate Social Responsibility (CSR) course, you will get 10 premium courses, an originalHardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Bundle Consists of the following Premium courses: Course 01: Corporate Social Responsibility (CSR) Course 02: Commercial Law 2021 Course 03: Business Law Course 04: Leadership & Management Diploma Course 05: Stakeholder Management Course 06: Performance Management Course 07: Environmental Health Course 08: Process Improvement: Reduce Waste Course 09: Carbon Literacy Knowledge | Course Course 10: Quality Assurance Course 11: Working Effectively Across Cultures As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the Corporate Social Responsibility (CSR) to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning: Pay once and get lifetime access to 11 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills 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 £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But with this special offer, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. Curriculum of Bundle Course 01: Corporate Social Responsibility (CSR) Introduction to Corporate Social Responsibility Stakeholders & the Social Contract A Sustainable Perspective Implementing CSR Performance Evaluation and Performance Reporting Course 02: Commercial Law 2021 Introduction of Commercial law Business Organisations International Trade: the Theory, the Institutions, and the Law Sales of Goods Law Consumer Law and Protection E-Commerce Law Competition Law Course 03: Business Law Understanding Business Law European Community Law The Court System Civil and Alternative Dispute Resolution Contract & Business Law Employment Law Agency Law Consumer Law and Protection Law of Tort Business Organisations Company Law Business Property Competition Law Course 04: Personal Leadership and Influencing Skills Getting Started The Evolution of Leadership Situational Leadership A Personal Inventory Modelling the Way Inspiring a Shared Vision Challenging the Process Enabling Others to Act Encouraging the Heart Basic Influencing Skills Setting Goals Course 05: Stakeholder Management Introducing Stakeholder Management Stakeholder Theories Stakeholder Mapping Building Strong Business Relationships With Stakeholders Stakeholder Engagement Stakeholder Engagement Through Effective Communication Monitoring and Evaluating the Engagement Managing Stakeholder Conflict Course 06: Performance Management Introduction Performance Key Performance Indicators Reporting Rewarding Conclusion Course 07: Environmental Health Intro to Environmental Health Waste, Pollution and Pollutants Environment, Pollution, Climate Change and Health Recovering Resources and Managing Waste Food Waste Plastic Air Pollution Water Environmental Sustainability Course 08: Process Improvement: Reduce Waste Introduction Fundamentals of Waste The 8 Wastes VA vs. NVA Process Mapping Tools Case Study Close Out Course 09: Carbon Literacy Knowledge | Course Introduction to Carbon Literacy The Carbon Cycle Global Warming and Climate Change Solutions for Global Warming Steps to Take for a Cleaner Tomorrow Course 10: Quality Assurance Introduction (Various Types of Testing) Functional Testing Rally Tool (Part - I) Rally Tool (Part - II) Documentation Waterfall Methodology Agile Methodology Introduction QA Revision Introduction to QTP Introduction to Loadrunner Course 11: Working Effectively Across Cultures Introduction Cultural identity OBSERVE Learn APPLY More practical TIPS Wrap up CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our course is fully compatible with PC's, Mac's, laptops, tablets 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 Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Corporate Social Responsibility (CSR)) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Do crippling anxieties prevent you from enjoying social situations? Does the fear of judgment keep you from connecting with others? Social anxiety can be isolating, but there is hope. This Social Anxiety Therapy course offers a roadmap to overcoming social anxiety and reclaiming your social life. Social Anxiety Therapy offers a transformative path to freedom from the debilitating grip of social anxiety. In the UK, approximately 1 in 8 individuals suffer from this condition, impacting their personal and professional lives. This comprehensive Social Anxiety Therapy course unlocks a powerful toolkit, equipping you with mindfulness techniques, cognitive strategies, and a profound understanding of the self. Embark on a transformative journey, where you'll learn to embrace acceptance, challenge limiting thoughts, and cultivate a newfound resilience in social situations. Unlock your true potential and reclaim the joy of genuine connections. Social Anxiety Therapy empowers you to transcend fear, embrace vulnerability, and live life to its fullest. This Social Anxiety Therapy course covers the following topics: Identify core social anxiety concepts like Acceptance and Commitment Therapy (ACT). Recognise and challenge unhelpful safety behaviours that maintain anxiety. Develop mindfulness skills to manage difficult emotions and body sensations. Identify and challenge unhelpful thought patterns that fuel anxiety. Explore techniques to create psychological distance from negative thoughts. Understand how to build a more fulfilling and values-driven life. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Social Anxiety Therapy course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Social Anxiety Therapy is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Social Anxiety Therapy course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Social Anxiety Therapy Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Section 01 Introduction 00:03:00 What is ACT 00:06:00 Defining Social Anxiety 00:03:00 Diagnosis of Social Anxiety 00:04:00 Situations That Trigger Social Anxiety 00:01:00 Section 02 Four Component of Safety Behavior 00:02:00 Types of Safety Behaviors 00:05:00 Knowing What Really Matters 00:10:00 Section 03 Mindfulness 00:03:00 Anapana Meditation 00:05:00 Acceptance of Bodily Sensations 00:04:00 Vipassana Meditation 00:08:00 Being with Anxiety 00:03:00 Section 04 Introduction 00:01:00 Types of Anxiety Thought 00:07:00 The Thought That 00:02:00 Labelling Effect 00:01:00 Ditching the Meaning 00:02:00 Waterfall Metaphor 00:01:00 Bringing It All Together 00:02:00 Wrap up 00:01:00 Section 05 Bonus Cognitive Defusion 00:11:00 Self as Context 00:14:00

Unlock a brighter, worry-free future with our transformative course, 'Overcome Overthinking and Worrying.' Dive into a journey of self-discovery and empowerment as you learn to break free from the chains of anxiety and excessive thinking. With eight comprehensive sections and expert guidance, this course equips you with the tools to conquer your mind and regain control over your life. Say goodbye to relentless worry and embrace a path to a more peaceful and fulfilling existence. Learning Outcomes Develop a deep understanding of thought patterns and their impact on your well-being. Master the art of thought journaling to gain insight into your inner world. Identify and challenge limited thinking patterns that hold you back. Learn effective relaxation exercises to manage stress and anxiety. Cultivate mindfulness and diffusion techniques for a calmer, more present mindset. Why buy this Overcome Overthinking and Worrying course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Overcome Overthinking and Worrying there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Overcome Overthinking and Worrying course for? Individuals seeking relief from chronic overthinking and anxiety. Professionals looking to enhance their mental resilience and productivity. Students aiming to improve their focus and concentration. Anyone interested in personal growth and inner transformation. Those committed to living a more balanced, worry-free life. Prerequisites This Overcome Overthinking and Worrying does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Overcome Overthinking and Worrying 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. Career path Life Coach: £25,000 - £60,000 per annum Counsellor: £22,000 - £50,000 per annum Mental Health Support Worker: £18,000 - £30,000 per annum HR Specialist: £25,000 - £55,000 per annum Meditation Instructor: £20,000 - £45,000 per annum Wellness Consultant: £22,000 - £50,000 per annum Course Curriculum Section 01: Introduction to the Course Introduction to the Course 00:03:00 Section 02: Introduction to Thought Journaling Uncovering Automatic Thoughts 00:04:00 Understanding Feedback Loops 00:04:00 The Nature of Automatic Thoughts 00:01:00 Characteristics of Automatic Thoughts Part 01 00:08:00 Characteristics of Automatic Thoughts Part 02 00:08:00 Thought Journal 00:02:00 Section 03: Introduction to Limited Thinking Patterns Filtering 00:02:00 Polarised Thinking 00:02:00 Overgeneralise Thinking 00:02:00 Mind Reading 00:02:00 Catastrophising 00:01:00 Magnifying 00:02:00 Personalisation 00:01:00 Shoulds 00:02:00 Composing Balanced Alternative Thoughts 00:08:00 Using Thought Journal for Limited Thinking Patterns 00:02:00 Section 04: Introduction to Hot Thoughts Eight Steps for Changing Hot Thoughts 00:07:00 Section 05: Introduction to Relaxation Exercises Abdominal Breathing 00:15:00 Progressive Muscle Relaxation 00:11:00 Relaxation without Tension 00:01:00 Cue Controlled Relaxation 00:07:00 Visualisation 00:04:00 Section 06: Introduction to Controlling Worry Worry System 00:02:00 Relaxation 00:02:00 Risk Assessment 00:07:00 Worry Exposure 00:03:00 Worry Behaviour Prevention 00:02:00 Section 07: Introduction to Mindfulness and Diffusion The Thought Mechanism 00:02:00 Labelling Effect 00:01:00 The Meaning of Thoughts 00:02:00 Waterfall Metaphor 00:01:00 Mindfulness 00:03:00 Dealing with Anxiety 00:03:00 Section 08: Knowing What Really Matters Knowing What Really Matters 00:10:00 Section 09: Conclusion Conclusion 00:02:00

This Microsoft Power BI course will help you become a Power BI expert. It'll enhance your skills by offering you comprehensive knowledge on Power BI Desktop and Power BI Online, and unleash the capabilities of Power BI to perform a comprehensive analysis of data from multiple sources and present the data using the perfect visualization.

Overview This Microsoft Excel Course for Everyone - Complete Excel Course is your passport to spreadsheet mastery.Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!Enrol right away to see how your confidence and chances rise! Don't wait! 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 Microsoft Excel Course for Everyone - Complete Excel Course. It is available to all students, of all academic backgrounds. Requirements Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs. Particularly designed to be easily accessed with an internet connection on tablets and smartphones. No strict deadlines; learn whenever it's convenient for you. Individuals with basic English proficiency. Career Path After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as : Data Analyst: £25,000 - £50,000 per year Financial Analyst: £30,000 - £60,000 per year Operations Manager: £35,000 - £70,000 per year Accountant: £25,000 - £50,000 per year Business Intelligence Analyst: £35,000 - £65,000 per year These salary ranges can vary based on factors such as experience, location, and the specific industry of the business. Course Curriculum 15 sections • 80 lectures • 06:51:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:04:00 •Getting started on Windows, macOS, Android, and IOS: 00:01:00 •How to ask great questions: 00:02:00 •FAQ's: 00:01:00 •Starting Excel: 00:04:00 •Introduction: 00:02:00 •Worksheet basics: 00:22:00 •Entering values and formulas: 00:12:00 •Data formats: 00:10:00 •Data handling basics - cut copy and paste: 00:07:00 •Save and print in excel: 00:10:00 •Excel Ranges: 00:05:00 •Introduction: 00:01:00 •Basic formula operations: 00:06:00 •Mathematical functions level 1: 00:20:00 •Mathematical functions level 2: 00:12:00 •Text functions level 1: 00:09:00 •Text functions level 2: 00:13:00 •Logical functions: 00:11:00 •Date time functions: 00:06:00 •V Lookup formula: 00:12:00 •HLookup formula: 00:04:00 •HLookup + Match formula: 00:09:00 •Match + Index formula: 00:05:00 •Introduction: 00:02:00 •XLookup: 00:08:00 •Handling #NA and Approximates match in XLookup: 00:11:00 •Wildcard matching in XLookup: 00:06:00 •Introduction: 00:02:00 •Split text into columns: 00:07:00 •Flash Fill: 00:07:00 •Remove Duplicates: 00:08:00 •Data Validation: 00:07:00 •Get- import Data from Text: 00:06:00 •Get - import Data from CSV: 00:03:00 •Introduction: 00:01:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Number: 00:05:00 •Formatting Date: 00:03:00 •Formatting tables: 00:05:00 •Introduction: 00:01:00 •Creating Pivot Table: 00:07:00 •Value field settings: 00:04:00 •Number format: 00:02:00 •Pivot Table Design: 00:03:00 •Excel Exercise: 00:01:00 •Solution for Excel Exercise: 00:02:00 •Introduction: 00:01:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Easy way to create charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line charts: 00:02:00 •Area charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Format AreaPlot or XY chart: 00:08:00 •Scatter or bubble charts: 00:02:00 •Introduction: 00:01:00 •Frequency Distribution and Histograms: 00:04:00 •Waterfall charts: 00:02:00 •Hierarchy charts: sunburst and tree map: 00:03:00 •Combination charts: 00:02:00 •Sparklines: 00:05:00 •Pivot charts: 00:02:00 •Maps chart: 00:04:00 •3D Maps chart: 00:03:00 •Introduction: 00:01:00 •Stock charts: 00:02:00 •Radar charts: 00:02:00 •Surface charts: 00:02:00 •Heat maps: 00:04:00 •Named ranges: 00:05:00 •Indirect Name range Function: 00:06:00 •Import Data table from PDF file - Excel 2021: 00:04:00 •Import Data from Website - Excel 2019 above: 00:09:00 •Project: Sales forecast tracker: 00:07:00 •Product Sale Tax invoice: Tax Calculations: 00:05:00

In this course, you will learn adaptive project management methodologies that empower teams to deliver high value results in faster time. You will learn the principles of agile and explore the scrum framework in this comprehensive course. This Course At A Glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand what agile & scrum is. Understand the fundamental aspects of agile & scrum. Get a better understanding of agile history. Develop the skills required to design an agile & scrum framework for software development. Learn and understand about the agile manifesto Learn to communicate effectively in an agile project Learn to implement the agile methodology in all the areas of assignments. Get acquainted with the scrum methodology best practices. Agile & Scrum Course Overview This online agile & scrum course is perfect for anyone willing to obtain a better understanding of the agile & scrum framework for software development or aspire to become a confident project manager. This online course will help you understand the basic concepts and significant aspects of Agile project management. This online agile & scrum course will also help you understand the brief history of agile, its manifesto, requirements in agile and much more. After taking this flexible online course, you will also understand what scrum is and the benefits of using the scram framework for project management. By the end of this course, you will get a comprehensive understanding of agile & scrum and learn to design a practical agile & scrum framework for software development. Who should take this course? This comprehensive agile & scrum course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of agile management and Scrum management. Entry Requirements There are no academic entry requirements for this agile & scrum course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This agile & scrum course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Course Curriculum What is Agile? Waterfall vs Agile Brief History of Agile The Agile Manifesto Requirements in Agile Requirements in Agile What is Scrum? Scrum 101 Assessment Assessment - Agile & Scrum Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org