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

54049 Courses delivered Online

Advanced Excel Models using Formulas, VBA & Power Query

4.3(43)

By John Academy

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst 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 Thankyou 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 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Excel Models using Formulas, VBA & Power Query
Delivered Online On Demand6 hours 8 minutes
£18

Advanced Business Networking & MLM Course

4.3(43)

By John Academy

Do you have a desire to meet new people and form beneficial business relationships? If yes, then enrol now and benefit from this course. Description: If you are in business you require every one of the customers you can get, am I right? If you want to do your best in your professional career then you have to meet and connect with the right people, am I right? You know very well that networking can enable you to do various things, that is why you're taking a look at this outline. This course will provide you with an overview, of a networking procedure. It will also introduce you to some excellent tips and techniques that will help you gain more clients make more money and progress further in your professional career. Who is this course for? Technical or professional - who do not feel entirely comfortable in networking situations. Network marketers with frequent customer contact who require better aptitudes to use potential business openings without selling. Managers with new duties around customer confronting activities who lack confidence. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: 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. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career path: Advanced Business Networking Course is a useful qualification to possess, and would be beneficial for the following professionals: Secretary. Receptionist. Office Administrator. Personal Assistant. Office supervisor. Team leader. Office Manager. Advanced Business Networking Course Introduction To Business Networking 00:15:00 How To Run A Successful Multilevel Marketing Business 01:00:00 Tips For Network Marketing Success 01:00:00 Benefits Of Outsourcing 01:00:00 Advantages Of Outsourcing Your Prospecting Efforts In MLM 01:00:00 Process Of Online Outsourcing Work 00:30:00 Outsourcing Tips For Network Marketers 01:00:00 Upgrade Your MLM Campaign With Outsourcing 00:30:00 Where Do Marketers Outsource Their Jobs? 01:00:00 Way To Start With Outsourcing A Job 00:30:00 Way To Pay Your Hired Staff When You Outsource 00:30:00 Building A Team Through Outsourcing Business 01:00:00 How To Make The Most Of Your Outsourcing 01:00:00 About Getting Revisions For Your Outsourced Work 00:30:00 What You Must Never Outsource 00:30:00 Important Tips For Outsourcing 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Business Networking & MLM Course
Delivered Online On Demand11 hours 45 minutes
£18

Advanced Keyword Research Course

4.3(43)

By John Academy

Are you a beginner keyword researcher? Do you want to know the secrets of keyword research, SEO, and content marketing? If yes, then enrol now and discover how to get on page one of the search engines including Google, Yahoo, and Bing right now! Description: Keyword research is a standout amongst the most basic segments of any web promoting the effort. Without appropriate keyword research, it will be considerably harder for individuals to discover your website. If your web page doesn't have the correct keyword, nobody will have the capacity to find it. Thus, it is very necessary that you pick the right keywords, and add them to your site in the correct places to guarantee proper search engine optimisation. In this course, will show you precisely how to locate the appropriate keyword for your niche, how to pick the ones you ought to concentrate on more vigorously, and where you ought to include them in your pages keeping in mind the end goal to have an ideal impact for SEO purposes. Who is the course for? Individuals who want to reveal the best keywords in their perspective niche. Individuals who want to find the best way to do keyword research online. Entrepreneurs. Small business. Webmasters. Bloggers who want to enhance their traffic. Freelancers who want to improve the ranking of their client's website. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  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. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Advanced Keyword Research Course would be beneficial for the following professionals: Digital marketer. SEO Specialist Google analyst. SEO expert. Word Press developer. Advanced Keyword Research Course Introduction 00:15:00 Preliminary Keyword Research 01:00:00 Keyword Research Assessment 00:30:00 Keywords in SEO(Search Engine Optimization) 00:30:00 Off-Page SEO(Search Engine Optimization) 00:30:00 Mock Test Mock Exam- Advanced Keyword Research Course 00:20:00 Final Exam Final Exam- Advanced Keyword Research Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Keyword Research Course
Delivered Online On Demand3 hours 25 minutes
£18

Advanced Electrical Safety at Workplace

4.3(43)

By John Academy

Course overview Electrical accidents can cause a lot of harm to your body. So, while working with electrical equipment, you need to be super careful and maintained safety precautions always. Learn how you can maintain safety while working with electrical equipment from this Advanced Electrical Safety at Workplace course. This course will help you to understand electrical hazards and how you can keep yourself safe from those hazards. This interactive course will teach you about electrical safety procedures step by step with easily understandable and bite-sized lessons. You will be familiarised with various electrical hazards, their impact and how to prevent them in this Advanced Electrical Safety at Workplace course. This course will provide you with the skills you need to handle electrical equipment safely. Learning outcomes Learn about the roles and responsibilities of an electrician Understand the safety precautions for electricians Learn the basic principles of the direct and alternating current Be able to calculate voltage and resistance Learn how to work safely with electrical equipment Learn about different electrical accidents and first aid procedures Be able to recognise electrical risks and mitigate them Be able to perform safety inspections and ensure safety before working with electrical equipment Who Is This Course For? Anyone who wants to learn about electrical safety can take this Advanced Electrical Safety at Workplace course. The skills gained from this training will provide excellent opportunities for career advancement.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognised accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Electrical Safety at Workplace course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Electricians Technicians Mechanics Residential Managers Safety Professionals Engineers Housekeepers Maintenance Officers Builders Advanced Electrical Safety at Workplace Module 1: Safety Precautions FREE 00:47:00 Module 2: Direct Current 00:21:00 Module 3: Alternating Current 00:21:00 Module 4: Voltage and Resistance 00:22:00 Module 5: Capacitance and Capacitors 00:20:00 Module 6: Working Safely with Electrical Equipment 00:19:00 Module 7: Electrical Incidents 00:12:00 Module 8: Risk Assessment 00:27:00 Module 9: Reducing and Controlling Risks 00:25:00 Module 10: Combined Inspection and Testing 00:40:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Electrical Safety at Workplace
Delivered Online On Demand4 hours 14 minutes
£18

Advanced Diploma in Interior Design

4.3(43)

By John Academy

Course Overview Amp up your project management skills to meet your project requirements and shape your organisation's success. Project managers are responsible for the successful planning and execution of projects. This Advanced Diploma in Interior Design course is designed to help you learn the proven project management skills and techniques to manage projects from beginning to end. The course will give you clear ideas on project management basics, different project types, and the techniques applied to project activities for successful project completion. During the course, you'll gain insights into project management steps, such as project initiation, execution, monitoring, and closing. On top of that, you'll explore the steps involved in project team building and acquire knowledge of earned value management to measure project performance. Learning Outcomes Discover the crucial steps to project success Familiarise yourself with different types of projects Identify the steps involved in project initiation, execution, monitoring and closing Understand what makes a successful project management team Learn about Earned Value Management (EVM) for project performance measurement Determine what is a change control process in project management Who is the Advanced Diploma in Interior Design Course for? This Advanced Diploma in Interior Design course is perfect for aspiring professionals in the relevant industry, such as people with careers in: Project Manager Project Executive Project Administrator Project Co-ordinator Project Lead It will deepen their knowledge and help them establish the fundamental skills for project management. Why Choose this Diploma in Advanced Diploma in Interior Design Course? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result The UK & internationally recognised accredited qualification Access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities 24/7 student support via email. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the English language, numeracy, and ICT are required to attend this course. Assessment At the end of the course, you will be required to sit for an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. However, you can also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Section 01: Popular Interior Design Styles and How to Use Them The 3 Types of Style That Influence Interior Design Choices 00:01:00 Art Deco Style 00:03:00 Victorian Style 00:03:00 Scandinavian Style 00:02:00 Modern Style 00:02:00 Contemporary Style 00:03:00 Eclectic Style 00:06:00 Italian Style 00:04:00 French Style 00:05:00 Industrial Style 00:04:00 Country Style: Architectural & Interiors 00:04:00 African Style 00:05:00 Conclusion 00:06:00 Section 02: Design Principles and Elements in Interiors Introduction to Design Principles & The Design Recipe 00:03:00 Design Element: Line 00:05:00 Design Element: Shape 00:03:00 Design Element: Form 00:03:00 Design Element: Colour 00:02:00 Design Element: Texture 00:05:00 Design Element: Space 00:03:00 Design Element: Value 00:01:00 Design Principle: Pattern 00:03:00 Design Principle: Contrast 00:03:00 Design Principle: Emphasis/Focal Point 00:05:00 Design Principle: Balance 00:05:00 Design Principle: Scale/Proportion 00:03:00 Design Principle: Rhythm/Movement 00:03:00 Design Principle: Unity/Harmony 00:01:00 Conclusion 00:01:00 Section 03: Introduction to Colour in Interiors The Impact of Fashion and Colour Trends 00:04:00 Colour Terminology 00:04:00 Colour Basics and Neutral Colours 00:05:00 Warm vs. Cool Colours 00:03:00 Colour Schemes 00:11:00 Colour Ratios and Applications 00:05:00 Using Colour To Trick The Eye 00:04:00 Conclusion 00:01:00 Section 04: Introduction to Space Planning In Interiors Understand why space planning is important to successful interiors 00:01:00 Efficient vs. Poorly Planned Spaces 00:04:00 Types of Building and Space Plans 00:06:00 Open and Closed Planned Spaces 00:04:00 Space Planning and The Design Principles 00:09:00 Tips and Tricks to Space Planning 00:02:00 Conclusion 00:01:00 Section 05: Textiles and Fabrics for Interiors Introduction To Textiles & Fabrics 00:01:00 Natural Fibers and Textiles 00:08:00 Synthetic Fibers and Textiles 00:06:00 Fabric Know Hows 00:10:00 End-Use of Textiles and Fabrics 00:04:00 Selecting and Recommending Textiles and Fabrics 00:04:00 Conclusion 00:01:00 Section 06: Styling and Staging Interior Spaces Introduction to Styling and Staging 00:03:00 Styling Coffee Tables 00:12:00 Styling Side Tables 00:07:00 Styling Servers and Consoles 00:05:00 Styling Dining Room Tables 00:04:00 Styling Book Cases and Display Cases 00:12:00 Styling with Scatter Cushions and Throw Pillows 00:11:00 Styling Seating and Sleeping Areas 00:05:00 Styling Walls with Art and Framing 00:11:00 Conclusion 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Diploma in Interior Design
Delivered Online On Demand4 hours 26 minutes
£18

Ambulance Care Assistant Course

4.3(43)

By John Academy

Course overview Gain the skills to provide the best ambulance care with the Ambulance Care Assistant Course. This course will teach you how to perform your primary duties as an ambulance care assistant.  This Ambulance Care Assistant Course delves into the specifics of how an ambulance service works. It will educate you on Pediatrics first aid for common illnesses, injuries and incidents. You will learn the procedure to perform CPR and explore the steps to care for an unconscious person. In addition, you will explore how to handle common hazards and injuries and attain the ability to undertake essential ambulance maintenance. By the end of the course, you will have a solid knowledge of delivering the best care and safer transport to non-emergency patients. Learning outcomes Learn the fundamentals of ambulance care Gain the skills and knowledge in Pediatric first aid Learn how to provide emergency treatment for loss of responsiveness and CPR Deepen your understanding of fire safety Learn about the manual handling hazards and injuries Learn how to perform basic ambulance maintenance Who is this course for This Ambulance Care Assistant Course is ideal for aspiring professionals interested in learning how to deliver the best ambulance care to non-emergency patients. The skills developed in the learning process will provide tremendous opportunities to work as Ambulance Care Assistants. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. The PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The valuable Ambulance Care Assistant Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Ambulance care assistant Call handler/emergency medical dispatcher Emergency Care Assistant Patient Transport Service (PTS) . Paramedic Ambulance Care Assistant Course Module 01: Basics of Ambulance Care 00:18:00 Module 02: Paediatric First Aid 00:17:00 Module: 03: Paediatric First Aid for Common Illnesses, Injuries and Incidents 00:37:00 Module 04: Loss of Responsiveness and CPR 00:19:00 Module 05: Fire Safety 00:34:00 Module 06: Manual Handling Hazards and Injuries 00:35:00 Module 07: Ambulance Maintenance 00:28:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Ambulance Care Assistant Course
Delivered Online On Demand3 hours 8 minutes
£18

Algebra for Beginners

4.3(43)

By John Academy

Description: Algebra is an area of mathematics that uses symbols to represent numbers in formulas and equations. Understanding these symbols and how they work together and provide structure to equations allows mathematicians to more efficiently write formulas and solve math problems.  This Algebra for Beginners is an introduction to the basic principles and skills of algebra. Topics include Variables, Grouping Symbols, Equations, Translating Words Into Symbols, and Translating Sentences Into Equations. With this course you will learn to manipulate and solve basic algebraic expressions, solve rational expressions, changing the subject of formulae and using formulae. You will learn to work with integers, decimals and fractions, how to evaluate powers and roots and how to solve single and multi-variable equations and inequalities. Learn how to apply algebra to a wide range of real-world problems and study critical algebraic concepts like functions, domains and ranges. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Algebra for Beginners is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Algebra for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Lecture 1 Intro video Algebra Introduction final 00:02:00 Fundamental concepts on Algebraic Expressions Lecture 2 Terminology used in Algebra 00:05:00 Lecture 3 Language of Algebra 00:06:00 Lecture 4 Practice Questions 00:06:00 Lecture 5 Finding numerical value of an algebraic expression 00:14:00 Operations on Algebraic Expressions Lecture 6 Revision of Directed number ( integers 00:06:00 Lecture 7 Addition and subtraction of monomial expressions 00:06:00 Lecture 8 Addition of algebraic expressions with many terms 00:10:00 Lecture 9 Subtraction of algebraic expressions 00:10:00 Indices ( Exponents) Lecture 10 The rules of Indices in algebra 00:11:00 Lecture 11 Fractional indices 00:10:00 Lecture 12 Understanding indices (practice questions) 00:07:00 Lecture 13 Problems from IGCSE Last year papers 00:05:00 Multiplication and Division of Algebraic expressions Lecture 14 Multiplication of monomial algebraic expressions 00:05:00 Lecture 15 Multiplication of monomial with binomials and trinomials 00:11:00 Lecture 16 Division of algebraic expression by a monomial 00:07:00 Lecture 17 Division of algebraic expression by another polynomial 00:09:00 Lecture 18 Division of a polynomial by another polynomial with remainder 00:11:00 Brackets in Algebra Lecture 19 Rules of brackets 00:04:00 Lecture 20 Simplification by removing brackets 00:11:00 Linear equations in one variable Lecture 21 Simplification of algebraic fractions 00:07:00 Lecture 22 Rules to solve linear equations in one variable 00:03:00 Lecture 23 Solving linear equations in one variable 00:07:00 Lecture 24 Solving complex linear equations in one variable 00:10:00 Lecture 25 Word problems on linear equations in one variable 00:13:00 Algebraic Identities Lecture 26 Standard Identities (a + b )² and (a - b )² identities 00:11:00 Lecture 27 Standard Identity ( a - b ) ( a + b) = a ² - b ² 00:08:00 Lecture 28 Standard Identities ( a + b + c ) ² = a ² + b ² + c ² + 2 a b + 2 a c +2 b c 00:07:00 Lecture 29 Standard Identities ( a + b ) ³ and ( a - b ) ³ 00:09:00 Lecture 30 Standard Identities a ³ + b ³ and a ³ - b ³ 00:06:00 Lecture 31 Standard Identities a ³ + b ³ + c ³ - 3 a b c 00:10:00 Formula : Change of subject of formula Lecture 32 -Changing the subject of formula 00:08:00 Linear Inequalities Lecture 33 Linear Inequalities 00:12:00 Resolve into factors Lecture 34 Factorization by taking out common factor 00:10:00 Lecture 35 Factorization by grouping the terms 00:09:00 Lecture 36 Factorize using identity a ² - b ² 00:07:00 Lecture 37 Factorize using identity (a + b )² and (a - b )² 00:08:00 Lecture 38 Factorize using identity ( a + b + c ) ² 00:05:00 Lecture 39 Factorization by middle term split 00:12:00 Algebraic Fractions Lecture 40 Simplification of algebraic fractions 00:06:00 Coordinate axis - points and Line graph Lecture 41 All that you need to know about co ordinate axis 00:04:00 Lecture 42 Some important facts needed to draw line graph 00:03:00 Lecture 43 How to draw a line graph on coordinate plane 00:03:00 Lecture 44 Drawing line graphs 00:06:00 System of simultaneous linear equations in two variables Lecture 45 Simultaneous Linear Equations in two variables- intro 00:03:00 Lecture 46 Graphical method of solving linear equations 00:06:00 Lecture 47 Graphical method - more sums 00:10:00 Lecture 48 Method of Elimination by substitution 00:09:00 Lecture 49 Method of Elimination by Equating coefficients 00:11:00 Lecture 50 Method of Elimination by cross multiplication 00:07:00 Lecture 51 Equations reducible to simultaneous linear equations 00:12:00 Lecture 52 Word Problems on Linear equations 00:18:00 Polynomials Lecture 53 Polynomials and Zeros of polynomials 00:10:00 Lecture 54 Remainder Theorem 00:04:00 Lecture 55 Factor Theorem 00:08:00 Lecture 56 Practice problems on Remainder and Factor Theorem 00:09:00 Lecture 57 Factorization using factor Theorem 00:10:00 Quadratic Polynomials Lecture 58 Zeros of polynomials α, β & γ 00:10:00 Lecture 59 Relation between zeros and coefficients of a polynomials 00:13:00 Lecture 60 Writing polynomials if zeros are given 00:06:00 Lecture 61 Practice problems on zeros of polynomials 00:10:00 Lecture 62 Problems solving with α and β (part 1) 00:11:00 Lecture 63 Problems solving with α and β (part 2) 00:10:00 Quadratic Equations Lecture 64 what are Quadratic equations 00:03:00 Lecture 65 Solutions by factorization method 00:12:00 Lecture 66 Solutions by completing square formula 00:06:00 Lecture 67 Deriving Quadratic formula 00:05:00 Lecture 68 Practice problems by Quadratic formula 00:07:00 Lecture 69 Solving complex quadratic equations by Quadratic Formula 00:11:00 Lecture 70 Solutions of reducible to Quadratic Formula 00:09:00 Lecture 71 Skilled problems on Quadratic Equations 00:07:00 Lecture 72 Exponential problems reducible to Quadratic Equations 00:06:00 Lecture 73 Nature of Roots of Quadratic Equations 00:09:00 Lecture 74 Word problems on quadratic Equations Part 1 00:13:00 Lecture 75 Word problems on quadratic Equations Part 2 00:11:00 lecture 76 word problems on Quadratic 00:12:00 Mock Exam Mock Exam - Algebra for Beginners 00:20:00 Final Exam Final Exam - Algebra for Beginners 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Algebra for Beginners
Delivered Online On Demand11 hours 8 minutes
£18

Airport Management Basics

4.3(43)

By John Academy

Course Overview Airport management covers a vast area and a wide range of tasks; therefore, it requires a great deal of experience to become a part of the airport management industry. The Airport Management Basics course is created by industry experts to help you grasp the key skills and knowledge to pursue a career in this sector.  Through this Airport Management Basics course, you will get introduced to the crucial departments of airport management. The course will teach you how to provide quality customer service in airports. This step by step learning program will instruct you on cargo management and airport components. You will acquire the skills and expertise for security management. The modules will also educate you on airline scheduling, aviation noise control, weather control etc. This Airport Management Basics course is loaded with valuable information and insights into airport management. Enroll in the course and prepare yourself for a promising career in the airport management sector. Learning Outcomes Learn the fundamentals of airport management Get quality training on airport customer service Familiarize yourself with airline scheduling Build essential skills for passenger terminal management and cargo management Enrich your knowledge of aviation noise control Become competent in airport security management Who is this course for? The Airport Management Basics is suitable for anyone interested to pursue a career in airport management  Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Airport Management Basics course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Airport manager Airport security director Aviation manager Operations site manager Airport Management Basics Module 01: Introduction to Airport Management 00:16:00 Module 02: Airport Customer Service 00:12:00 Module 03: Passenger Terminal Management 00:16:00 Module 04: Airport Components 00:17:00 Module 05: Airport Peaks and Airline Scheduling 00:18:00 Module 06: Cargo Management 00:19:00 Module 07: Aviation Noise Control 00:11:00 Module 08: Weather Control 00:16:00 Module 09: Sustainable Airport Management 00:17:00 Module 10: Security Management 00:17:00 Module 11: Innovation and Growth 00:16:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Airport Management Basics
Delivered Online On Demand2 hours 55 minutes
£18

Agricultural Science Masterclass

4.3(43)

By John Academy

Course Overview Learn how you can build your career in the agricultural sector from this Agricultural Science Masterclass course. This course will teach you the knowledge you need to keep your plants healthy and boost your agricultural skill. This Agricultural Science Masterclass course will help you to strengthen your basic about agricultural science and learn new skills. You will learn how to take care of plants and animals, control pests and ensure nutrition for your plants. This course will also teach you about soil quality, weed control and home gardening. You will learn how to take care of flowery plants and ornamental plants to beautify your garden or farm. The comprehensive and easily understandable lessons of this agriculture science masterclass will help you to grasp the topics easily. You will be able to memorize the knowledge you learn for a long time with striking techniques. Learning Outcomes Learn the basic fundamentals and principles of agricultural science Familiarize with horticulture and nursery production techniques Be able to understand plant propagation Get to know about soil science and its application Learn how plant nutrition can affect the production of your crop Be able to control plant pests and help your plant to grow Know home gardening tips and techniques Know how to take care of ornamental plants Learn the strategies of growing flowering plants and how to cut flowers Get a clear understanding of aquaculture and permaculture Learn the basic principles of animal farming Be able to take care of animals on your farm properly Who is this course for? This comprehensive Agricultural Science Masterclass is ideal for those who want to learn more about agricultural science and work in the agriculture industry. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Agricultural Science Masterclass is a useful qualification to possess and would be beneficial for any related profession or industry such as: Agricultural Scientists Animal Scientists Soil Scientists Crop Scientists Agricultural And Food Scientists Farmers Green House Managers Horticultural Scientists Plant Pathologists Water Quality Specialists Module 1: Introduction to Agricultural Science Introduction to Agricultural Science 00:20:00 Module 2: Horticulture and The Nursery Production Horticulture and The Nursery Production 00:24:00 Module 3: Plant Propagation Plant Propagation 00:34:00 Module 4: Soil Science Soil Science 00:27:00 Module 5: Plant Nutrition Plant Nutrition 00:27:00 Module 6: Controlling Plant Pests Controlling Plant Pests 00:26:00 Module 7: Weed Control Weed Control 00:32:00 Module 8: Home Gardening Home Gardening 00:19:00 Module 9: Ornamental Plants Ornamental Plants 00:16:00 Module 10: Cut Flowers Cut Flowers 00:20:00 Module 11: Permaculture Permaculture 00:22:00 Module 12: Aquaculture Aquaculture 00:20:00 Module 13: Animal Farming - Raising Beef Cattle Animal Farming - Raising Beef Cattle 00:26:00 Module 14: Animal Farming - Milking of Dairy Cattle Animal Farming - Milking of Dairy Cattle 00:25:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Agricultural Science Masterclass
Delivered Online On Demand5 hours 38 minutes
£18

Advanced Team Building Course

4.3(43)

By John Academy

Are you aspiring to become a team leader? If you want to know how to become an effective leader through conducting team building, then this course will be perfect for you and your team members! Description: You have the potential to become a leader and in this course, you will learn the skills to unleash your potential to become an inspiring team leader. You realise that your employees or team members are the most crucial factor in your business or company. You need to have the right skills to teach them how to develop for the company's success, and this course will train you in that. You will learn that team building is a solid way to help your team become closer which will result in more effective and efficient outputs. In this course, you will be able to hire and recruits employees and have them trained to unleash their creativity. Who is the course for? For employees who are aiming for a promotion, joining a team leader role for the first time or looking forward to becoming a top executive. Or anyone who is interested in becoming a team leader. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  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. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Advanced Team Building Course will be useful and beneficial for the management positions, specifically the following careers: Administrative Services Manager Advertising, Promotions and Marketing Managers Agricultural Managers Architectural and Engineering Managers Compensation and Benefits Managers Computer and Information Systems Manager Construction Managers Financial Managers Food Services Managers Human Resources Managers Industrial Production Managers Management Directors Medical and Health Managers Natural Sciences Managers Top Executives. Team Building Introduction To Team Building 00:30:00 Effective Use Of Online Tools 00:15:00 Celebrate Your Commitment In Style 00:30:00 Empower Your Team To Innovate and Execute 00:30:00 Always Motivate Your Team 00:30:00 Keeping Up To Date On Your Own Training 00:15:00 Always Support And Train Your Team 00:30:00 Benefits Of Building A Good Team 00:15:00 Wrapping Up 00:15:00 Building Effective Teams Defining Teams 00:15:00 Establishing Team Norms 00:15:00 Working as a Team 00:15:00 Your Team Player Type 01:00:00 Building Team Trust 00:15:00 The Stages of Team Development 00:30:00 Communication 00:30:00 Becoming a Good Team Player 00:15:00 Mock Exam Mock Exam-Advanced Team Building Course 00:20:00 Final Exam Final Exam-Advanced Team Building Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Team Building Course
Delivered Online On Demand7 hours 25 minutes
£18