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

44119 Courses

Solid Waste Management Training

By Xpert Learning

About Course Elevate Your Career in Solid Waste Management with this Solid Waste Management Training online program. Solid Waste Management Training is a comprehensive course that provides an introduction to the principles and practices of solid waste management. The course covers the entire waste management cycle, from waste generation and collection to treatment and disposal. Topics include: The different types of solid waste, such as municipal solid waste, industrial waste, hazardous waste, and construction and demolition waste. The environmental and health impacts of poor waste management, such as air pollution, water pollution, and disease. Sustainable approaches to waste management, such as waste minimization, recycling, and composting. The latest technologies and innovations in waste management, such as waste-to-energy conversion and anaerobic digestion. Why take this course? This course is designed for students who are interested in a career in environmental engineering or waste management. It is also a valuable resource for professionals who work in these fields. The course will provide you with the knowledge and skills you need to understand the waste management process and to develop and implement effective waste management solutions. Specifically, this course will help you to: Understand the different types of solid waste and their environmental impacts. Develop strategies for reducing waste generation and increasing waste diversion. Evaluate different waste treatment and disposal options. Stay up-to-date on the latest technologies and innovations in waste management. If you are interested in a career in environmental engineering or waste management, or if you are simply looking to learn more about how to manage our waste more effectively, then this course is for you. Additional benefits You will gain a deeper understanding of the environmental and health impacts of waste. You will learn about the different technologies and innovations that are being used to manage waste more sustainably. You will develop the skills and knowledge you need to work in the waste management industry. You will be able to contribute to the development of more sustainable waste management solutions. What Will You Learn? Understand the principles and practices of solid waste management Develop the skills you need to work in the waste management industry Apply your knowledge to solve real-world waste management problems Enhance your career in environmental engineering Start a new career in the waste management field Course Content Introduction to Solid Waste Management Introduction to Solid Waste Management Waste Generation and Composition Waste Generation and Composition Waste Collection and Transportation Waste Collection and Transportation Waste Treatment Technologies Waste Treatment Technologies Landfill Design and Operation Landfill Design and Operation Hazardous and Special Waste Management Hazardous and Special Waste Management Sustainable Waste Management Practices Sustainable Waste Management Practices Policy, Regulations, and Future Trends Policy, Regulations, and Future Trends Conclusion Conclusion A course by Xpert Learning RequirementsBasic Understanding of Chemistry and Biology. Audience Students who are interested in a career in environmental engineering or waste management. This course will provide them with the knowledge and skills they need to understand the waste management process and to develop and implement effective waste management solutions. Professionals who work in the waste management industry. This course will help them to stay up-to-date on the latest developments in waste management and to improve their skills and knowledge. Anyone who is interested in learning more about solid waste management. This course provides a comprehensive overview of the subject and is suitable for anyone who wants to learn more about how to manage our waste more effectively. Environmental engineers Waste management professionals Municipal officials Business owners Environmental advocates Students Anyone who is concerned about the environment Audience Students who are interested in a career in environmental engineering or waste management. This course will provide them with the knowledge and skills they need to understand the waste management process and to develop and implement effective waste management solutions. Professionals who work in the waste management industry. This course will help them to stay up-to-date on the latest developments in waste management and to improve their skills and knowledge. Anyone who is interested in learning more about solid waste management. This course provides a comprehensive overview of the subject and is suitable for anyone who wants to learn more about how to manage our waste more effectively. Environmental engineers Waste management professionals Municipal officials Business owners Environmental advocates Students Anyone who is concerned about the environment

Solid Waste Management Training
Delivered Online On Demand2 hours 40 minutes
£9.99

Risk and Treatment of Bipolar Disorder

4.7(160)

By Janets

Bipolar disorder involves several risk factors and requires proper knowledge to understand it. This course has been designed to educate you about this disorder. It also includes the way treatment and medication should be done. Start learning Risk and Treatment of Bipolar Disorder that will give you enough knowledge and skills to build your dream career. About this course This Risk and Treatment of Bipolar Disorder helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Risk and Treatment of Bipolar Disorder is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who Is This Course For:​ This Risk and Treatment of Bipolar Disorder is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Risk and Treatment of Bipolar Disorder related skills to aid his/her career path. No formal entry prerequisites are required Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 1: Introduction to Bipolar Disorder Module 2: Mental Disease Module 3: Bipolar Risk and Understanding Module 4: Bipolar Disorder Treatment and Medication Course Content Bipolar Disorder: Risk and Treatment Module 1: Introduction to Bipolar Disorder 00:12:00 Module 2: Mental Disease 00:15:00 Module 3: Bipolar Risk and Understanding 00:07:00 Module 4: Bipolar Disorder Treatment and Medication 00:22:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Risk and Treatment of Bipolar Disorder
Delivered Online On Demand56 minutes
£5.99

Biotechnology for Health: Industries & Business

4.7(160)

By Janets

Biotechnology is a broader concept that includes several fields. This course will take you to the historical aspect and how it contributes to the healthcare industry. It also shares knowledge of commercial biotechnology. Start learning Biotechnology for Health: Industries & Business that will give you enough knowledge and skills to build your dream career. About this course This Biotechnology for Health: Industries & Business helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Biotechnology for Health: Industries & Business is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who Is This Course For:​ This Biotechnology for Health: Industries & Business is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Biotechnology for Health: Industries & Business related skills to aid his/her career path. No formal entry prerequisites are required Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 1: Biotechnology in Historical Perspective Module 2: Biotechnology in the Healthcare Industry Module 3: Biotechnology for Industry Module 4: Commercial Biotechnology Course Content Biotechnology: Health and Business Module 1: Biotechnology in Historical Perspective 00:21:00 Module 2: Biotechnology in the Healthcare Industry 00:07:00 Module 3: Biotechnology for Industry 00:09:00 Module 4: Commercial Biotechnology 00:08:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Biotechnology for Health: Industries & Business
Delivered Online On Demand45 minutes
£5.99

Concierge Service Basics Course

4.7(160)

By Janets

Content Management System is now the most popular computer software that is used to create and modify digital contents. This course has been illustrated to educate you on how it functions. It discusses the fundamental aspects of CMS. Hit the course to enter into the digital world. Start learning Concierge Service Basics Course that will give you enough knowledge and skills to build your dream career. About this course This Concierge Service Basics Course helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Concierge Service Basics Course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who Is This Course For:​ This Concierge Service Basics Course is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Concierge Service Basics Course related skills to aid his/her career path. No formal entry prerequisites are required Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 01: Getting to Know the Service Module 02: Concierge Service Types. Module 03: Required Skills for Any Concierge. Module 04: Concierge Service Business Principles Course Content Concierge Basics Module 01: Getting to Know the Service 00:08:00 Module 02: Concierge Service Types. 00:11:00 Module 03: Required Skills for Any Concierge. 00:14:00 Module 04: Concierge Service Business Principles 00:13:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Concierge Service Basics Course
Delivered Online On Demand46 minutes
£5.99

Editing on CapCut - A Crash Course

By IOMH - Institute of Mental Health

Overview of Teaching Assistant Level 3 Video content is booming. With easy access to smartphones, everyone can be a videographer today. However, editing videos that captivate audiences requires skills. This Editing on CapCut – A Crash Course teaches you professional editing techniques using CapCut to create stunning videos for social media and online platforms. Learn industry best practices from an experienced instructor. Unleash your creativity and find opportunities as a video creator, editor or influencer. Export high-quality videos after Editing. Employ advanced techniques to edit videos creatively. This Editing on CapCut - A Crash Course will help you to learn: Edit videos using CapCut software tools. Arrange clips and add visual effects in videos. Sync motions to audio using keyframes in CapCut. Generate automatic captions for videos. Insert music and sound effects into videos skillfully. Export high-quality videos after Editing. Employ advanced techniques to edit videos creatively. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Editing on CapCut – A Crash Course. Enrol today and complete the course to achieve a certificate that can change your career forever. 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 Certificate of Completion – Digital / PDF Certificate After completing the Editing on CapCut – A Crash Course course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Aspiring video editors and content creators. Social media influencers and marketers want to create engaging videos. Small business owners looking to promote their brand through videos. Students interested in video production and Editing. Requirements There is no prerequisite to enrol in this course. You don’t need any educational qualification or experience to enrol in the Editing on CapCut – A Crash Course 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 Video Editor - £18K to £35K per year Social Media Manager - £21K to £45K per year Digital Marketer - £19K to £50K per year Content Creator - £15K to £40K per year Videographer - £20K to £50K per year

Editing on CapCut - A Crash Course
Delivered Online On Demand33 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

Creative Writing Training

By NextGen Learning

Are you struggling to write creatively? Do you need help generating ideas and require the skill to write creatively? If you are having these issues, you are in the right place to enhance your writing skills and boost your mind with the necessary skills and knowledge of writing creatively. This Creative Writing course will provide you with all the necessary information and knowledge about creative writing. It will help you get the advantage in every sphere of your life if you are passionate about writing. Our course is designed to teach you the knowledge of writing stories, novels, non-fiction, poetry and other writings. In addition, you will get to expand your expertise in creating fictional characters, writing for children, and writing creative dialogue. The course will also help you acquire knowledge about thinking critically to write creatively and get a competitive advantage in business using the skill and knowledge gained from this course. Through this course, you can learn to evaluate, edit and, lastly, publish your valuable writing. So, what are you waiting for? Get enrolled on this course and start your journey of becoming a creative writer today. Learning Outcomes: Basic knowledge of creative writing. Getting ideas about developing your creative writing skill. Novel Writing knowledge. Non-fiction writing knowledge. Understanding writing stories of horror, thriller, and murder. Knowledge writing for children. Proficiency in poetry writing. Enhanced knowledge of business writing. Knowledge about evaluating, editing and publishing. What will make you stand out? On completion of this online course, you will gain: CPD QS Accredited After successfully completing the Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. The online test with immediate results You can study and complete the course at your own pace. Study for the course using any internet-connected device, such as a computer, tablet, or mobile device. The substantial Creative Writing is designed to help you demonstrate the preliminary to in-depth level of learning regarding this topic. Moreover, you will be provided with the most knowledgeable and informative modules for your lifetime by enrolling in this course just once. Furthermore, as you proceed through the modules of this course, you will discover the fundamentals of Creative Writing and explore the key topics, Therefore, reinforce your knowledge and furnish your skills by enrolling in our course. Take one step closer to achieving your goal. Show off your new skills with a certificate of completion Once you complete the Creative Writing course, you will be eligible to request a digital certificate for free. For Printed Transcript & Hardcopy Certificate- 4.99 GBP (Inside the UK Postal Fee) 8.99 GBP (International Delivery Fee) CPD 10 CPD hours / points Accredited by CPD Quality Standards Module 01: Introduction to Creative Writing 06:32 1: Introduction to Creative Writing Preview 06:32 Module 02: The Development of Creative Writing 08:50 2: The Development of Creative Writing 08:50 Module 03: Novel Writing 08:39 3: Novel Writing 08:39 Module 04: Writing Non-Fiction 07:44 4: Writing Non-Fiction 07:44 Module 05: Creating Fictional Characters 15:05 5: Creating Fictional Characters 15:05 Module 06: Writing Realistic Dialogue 07:02 6: Writing Realistic Dialogue 07:02 Module 07: Writing Horrors, Thriller and Murder Stories 10:46 7: Writing Horrors, Thriller and Murder Stories 10:46 Module 08: Writing for Children 07:43 8: Writing for Children 07:43 Module 09: Writing Poetry 10:49 9: Writing Poetry 10:49 Module 10: Proposal Writing 15:00 10: Proposal Writing 15:00 Module 11: Critical Thinking 07:36 11: Critical Thinking 07:36 Module 12: Business Writing 11:08 12: Business Writing 11:08 Module 13: Other Writings 14:36 13: Other Writings 14:36 Module 14: Editing, Evaluating and Getting Published 13:28 14: Editing, Evaluating and Getting Published 13:28 Who is this course for? Anyone who wants to master creative writing skills and is interested in writing creatively is encouraged to take this course. By enrolling in this Creative Writing course, one will acquire the fundamental concepts and develop a thorough comprehension of the subject. Requirements Without any formal requirements, you can delightfully enrol in this course. Career path Copywriter - £20-35k/year Content Editor - £22-40k/year Screenwriter - £25-60k/year Creative Writing Instructor - £18-30k/year Novelist - Variable income Literary Agent - £22-50k/year

Creative Writing Training
Delivered Online On Demand24 hours
£12

Employment Law Training

By NextGen Learning

Did you know that over 60% of workplace disputes in the UK arise from a need for more understanding of employment law? Don't let your organisation fall victim to costly legal battles. Our "Employment Law Training" course is your gateway to mastering the intricacies of employment legislation, mitigating risks, and fostering a harmonious workplace. You'll gain a profound understanding of the subject with ten in-depth chapters covering everything from the Basics of Employment Law to Workplace Monitoring and Data Protection. Master the legal recruitment process, craft foolproof employment contracts, and create employee handbooks that ensure compliance. Explore topics like discrimination, health & safety, and dismissal procedures with expert guidance. Take advantage of this opportunity to empower your team with the knowledge they need to thrive in a legally compliant workplace. Enroll now and embrace the world of Employment Law today! Learning Outcomes: Upon completing the Employment Law course, learners will: Employment Law Foundation: Develop a strong understanding of UK Employment Law principles and legislation. Recruitment Proficiency: Master the legal recruitment process, a critical aspect of Employment Law. Contract Expertise: Create effective employment contracts and employee handbooks in line with Employment Law standards. Conflict Resolution: Handle disciplinary procedures, grievances, and dismissal in compliance with Employment Law regulations. Compliance Assurance: Ensure workplace compliance with anti-discrimination laws, health and safety regulations, and data protection, all integral to Employment Law. Risk Mitigation: Learn to effectively identify and mitigate legal risks in the workplace, a key component of Employment Law expertise. What will make you stand out? On completion of this Employment Law online course, you will gain: CPD QS Accredited Proficiency Lifetime access to the whole collection of learning materials. The online test with immediate results You can study and complete the Employment Law course at your own pace. Study for the Employment Law course using any internet-connected device, such as a computer, tablet, or mobile device. "Employment Law Training" offers an invaluable opportunity to delve deep into the intricate world of employment law in the United Kingdom. With a focus on practicality and legal compliance, this comprehensive course empowers you with the knowledge and expertise needed to navigate the complex nuances of the employment landscape effectively. This Employment Law course covers a wide array of essential modules, including recruitment procedures, the art of crafting airtight employment contracts, and the development of employee handbooks that align seamlessly with legal standards. Delve into conflict resolution techniques, encompassing disciplinary processes and dismissal protocols, all within the bounds of UK employment law. Additionally, it explores vital topics such as combating workplace discrimination, upholding stringent health and safety regulations, and ensuring data protection compliance. CPD 10 CPD hours / points Accredited by CPD Quality Standards Chapter 01: Basics of Employment Law 16:17 1: Basics of Employment Law Chapter Preview 16:17 Chapter 02: Legal Recruitment Process 26:44 2: Legal Recruitment Process 26:44 Chapter 03: Employment Contracts 14:06 3: Employment Contracts 14:06 Chapter 04: Employee Handbook 13:03 4: Employee Handbook 13:03 Chapter 05: Disciplinary Procedure 13:55 5: Disciplinary Procedure 13:55 Chapter 06: National Minimum Wage _ National Living Wage 21:57 6: National Minimum Wage _ National Living Wage 21:57 Chapter 07: Parental Rights, Sick Pay and Pension Scheme 31:13 7: Parental Rights, Sick Pay and Pension Scheme 31:13 Chapter 08: Discrimination in the Workplace 27:43 8: Discrimination in the Workplace 27:43 Chapter 09: Health & Safety at Work 10:21 9: Health & Safety at Work 10:21 Chapter 10: Dismissal, Grievances and Employment Tribunals 20:51 10: Dismissal, Grievances and Employment Tribunals 20:51 Chapter 11: Workplace Monitoring and Data Protection 06:59 11: Workplace Monitoring and Data Protection 06:59 Assignment - Employment Law UK 03:00 12: Assignment On Employment Law UK 03:00 PDF Who is this course for? This Employment Law course is perfect for: HR Professionals Managers & Supervisors Business Owners Legal Consultants Compliance Officers Career Advancers Requirements Without any formal requirements, you can delightfully enrol in this Employment Law course. Career path The aim of this exclusive Employment Law course is to help you toward your dream career. So, complete this Employment Law course and enhance your skills to explore opportunities in relevant areas: Solicitor: £27,000 - £38,000 per annum HR Advisor: £25,000 - £29,500 per annum Employment Law Consultant: £40,000 - £45,000 per annum Compliance Officer: £30,000 - £50,000 per year Certificates CPD Quality Standard Certificate Digital certificate - £4.99 Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Employment Law Training
Delivered Online On Demand34 hours
£12

Getting Started with Programming, OO and Basic Java for Non-Developers (TT2000)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This basic course is intended for anyone who is new to software development and wants, or needs, to gain an understanding of the fundamentals of coding and basics of Java and object-oriented programming concepts. Attendees might include: Technically-minded attendees who want or who want to begin the process of becoming an OO application developer Technical team members from non-development roles, re-skilling to move into software and application development roles within an organization Recent college graduates looking to apply their college experience to programming skills in a professional environment, or perhaps needing to learn the best practices and standards for programming within their new organization Technical managers tasked with overseeing programming teams, or development projects, where basic coding knowledge and exposure will be useful in project oversight or communications needs Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in basic coding with Java, coupling the most current, effective techniques with the soundest industry practices. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will learn: The steps involved in the creation and deployment of a computer program What OO programming is and what the advantages of OO are in today's world To work with objects, classes, and OO implementations The basic concepts of OO such as encapsulation, inheritance, polymorphism, and abstraction The basic constructs that all programming languages share The basic Java constructs supporting processing as well as the OO orientation How to use Java exception handling About and how to use classes, inheritance and polymorphism About use collections, generics, autoboxing, and enumerations How to take advantage of the Java tooling that is available with the programming environment being used in the class Getting Started with Programming, OO and Java Basics for Non-Developers is a skills-focused, hands-on coding course that teaches students the fundamentals of programming object oriented (OO) applications with Java to a basic level, using sound coding skills and best practices for OO development. This course is presented in a way that enables interested students to embrace the fundamentals of coding as well as an introduction to Java, in a gentle paced environment that focuses on coding basics.Students are introduced to the application development cycle, structure of programs, and specific language syntax. The course introduces important algorithmic constructs, string and character manipulation, dynamic memory allocation, standard I/O, and fundamental object-oriented programming concepts. The course explains the use of inheritance and polymorphism early on so the students can practice extensively in the hands-on labs. Structured programming techniques and error handling are emphasized. The course includes the processing of command line arguments and environment variables, so students will be able to write flexible, user-friendly programs. Students will leave this course armed with the required skills to begin their journey as a Java programmer using modern coding skills and technologies. Introduction to Computer Programming Introduction to Programming Programming Tools Programming Fundamentals Thinking About Objects Program Basics Programming Constructs Java: A First Look The Java Platform Using the JDK The Eclipse Paradigm Writing a Simple Class OO Concepts Object-Oriented Programming Inheritance, Abstraction, and Polymorphism Getting Started with Java Adding Methods to the Class Language Statements Using Strings Specializing in a Subclass Essential Java Programming Fields and Variables Using Arrays Java Packages and Visibility Advanced Java Programming Inheritance and Polymorphism Interfaces and Abstract Classes Exceptions Java Developer's Toolbox Utility Classes Enumerations and Static Imports Formatting Strings Collections and Generics Introduction to Generics Collections

Getting Started with Programming, OO and Basic Java for Non-Developers (TT2000)
Delivered OnlineFlexible Dates
Price on Enquiry

TP2897 Advanced Jira Workshop Training

By Nexus Human

Duration 1 Days 6 CPD hours In this hands on workshop for Agile Scrum Masters, Release Train Engineers and anyone serving as Jira Administrators, Jira experts will lead you through advanced configuration and customization settings in Jira, from installation through to customized screens, workflows, filters and reports. Jira Administration Adding and managing Users Administering and managing Groups Global Jira Settings Jira layout and interface customization User authentication and security Jira Customization Customization of screens and fields Customization of workflows Project and Board Administration Configuring and managing Projects Configuring and managing Boards Creating and managing Filters JQL Jira Integration Integrating Jira with Atlassian Tools Retrospectives and Documentation in Confluence Code management with Bitbucket Integration management with Bamboo Building a Dashboard with gadgets Jira Plug-ins and Marketplace

TP2897 Advanced Jira Workshop Training
Delivered OnlineFlexible Dates
Price on Enquiry