47680 Learning courses

Are you looking to enhance your Child Care skills? If yes, then you have come to the right place. Our comprehensive course on Child Care will assist you in producing the best possible outcome by mastering the Child Care skills. The Child Care course is for those who want to be successful. In the Child Care course, you will learn the essential knowledge needed to become well versed in Child Care. Our Child Care course starts with the basics of Child Care and gradually progresses towards advanced topics. Therefore, each lesson of this Child Care course is intuitive and easy to understand. Why would you choose the Child Care course from Compliance Central: Lifetime access to Child Care course materials Full tutor support is available from Monday to Friday with the Child Care course Learn Child Care skills at your own pace from the comfort of your home Gain a complete understanding of Child Care course Accessible, informative Child Care learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Child Care course Study Child Care in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Child Care Course Curriculum Breakdown of the Child Care Course Module 01: Understanding Child Development Module 02: Caring for Children Module 03: Healthy Food, Healthy living Module 04: Keeping Children Healthy & Safe Module 05: Child Protection Module 06: Play, Imagination and Creativity Module 07: Early Years Provision Module 08: Children with Special Needs CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Child Care course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Child Care. It is also great for professionals who are already working in Child Care and want to get promoted at work. Requirements To enrol in this Child Care course, all you need is a basic understanding of the English Language and an internet connection. Career path The Child Care course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Child Care. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Customer relationship management helps in customer retention. It is essential in every business for increased profits. Set your business for higher productivity and efficiency with the Customer Relationship Management course. Effective CRM implementation can improve customer relationships, attract new prospective customers, and win back former customers. This Customer Relationship Management Course will teach you about CRM fundamentals and equip you with the skills to build strong customer relationships. It will teach you how to create a CRM strategy for your business. You'll pick up valuable information on data analysis in CRM and how to deepen your customer relationships. The training will also enhance your ability to handle customer complaints and familiarise you with the emerging trends of CRM.  Learning Objectives Learn the CRM fundamentals Know about data analysis in CRM Enrich your knowledge of CRM database management Know how to deepen customer relationships Learn to handle customer complaints Who is this Course for? This Customer Relationship Management Course is ideal for aspiring professionals who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of CRM or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course. However, an eye for detail and a creative mind is essential. Entry Requirement Anyone interested in learning more about this subject should take this Customer Relationship Management course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successful completion of the Customer Relationship Management Course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: CRM Analyst CRM Consultant CRM Developer CRM Executive CRM Manager CRM Specialist Course Curriculum Module 01: Introduction to Customer Relationship Management (CRM) Introduction to Customer Relationship Management (CRM) 00:22:00 Module 02: CRM Fundamentals CRM Fundamentals 00:24:00 Module 03: CRM Strategies CRM Strategies 00:33:00 Module 04: Data Analysis in CRM Data Analysis in CRM 00:28:00 Module 05: CRM Databases CRM Databases 00:21:00 Module 06: Deepening Customer Relationship Deepening Customer Relationship 00:23:00 Module 07: Handling Customer Complaints Handling Customer Complaints 00:22:00 Module 08: Future of CRM Future of CRM 00:25:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Powerful Functions in Microsoft Excel course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Powerful Functions in Microsoft Excel course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Powerful Functions in Microsoft Excel and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Powerful Functions in Microsoft Excel course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Powerful Functions in Microsoft Excel course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Powerful Functions in Microsoft Excel will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Powerful Functions in Microsoft Excel Introduction 00:03:00 Basic Functions 00:12:00 Date Functions 00:09:00 Random Numbers 00:09:00 IFS so many IFS 00:11:00 Text Functions 00:13:00 Logical Functions 00:09:00 Creating a Drop-Down List 00:05:00 VLOOKUP and XLOOKUP 00:09:00 Pivot Tables 00:08:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

The life of every animal is priceless. Enhance your ability to deliver a better quality of life for animals by taking this Zoology course. This Zoology course will teach you about the mating process of animals. It will educate you on animal behaviour and diversity of life and genetics and breeding. In addition, the course will give you deep insights into vertebrates and invertebrates zoology. You'll also learn about the different types of animal diseases and explore how to create excellent recovery plans. This training is the most effective approach to kickstart your career in the relevant field. Enrol now and learn the skills required to monitor wildlife health! Please note that this course only gives you the theoretical knowledge to succeed in this industry. Our Zoology Course doesn't entitle you to practise as a professional in this specific sector. Learning Objectives Understand the animal mating process Enrich your knowledge of animal behaviour and diversity of life Get broad ideas on genetics and breeding Know about vertebrate and invertebrate zoology Familiarise yourself with the various animal diseases Gain an excellent understanding of animal health care Who is this Course for? This Zoology course is ideal for aspiring professionals who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of zoology or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course. However, an eye for detail and a creative mind is essential. Entry Requirement Anyone interested in learning more about this subject should take this Zoology course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successful completion of the Zoology course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Zookeeper Toxicologist Zoologist Teacher Veterinary Nurse Animal nutritionist Farm Manager Stable Worker Course Curriculum Module 01: Zoology Zoology 00:12:00 Module 02: Animal Behaviours And Diversity of Life Animal Behaviours and Diversity of Life 00:21:00 Module 03: Genetics and Breeding Genetics and Breeding 00:14:00 Module 04: Vertebrate Zoology Vertebrate Zoology 00:17:00 Module 05: Invertebrate Zoology Invertebrate Zoology 00:24:00 Module 06: Animal Diseases Animal Diseases 00:24:00 Module 07: Animal Health Care Animal Health Care 00:19:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Learn how to conduct a successful accident investigation by taking this Accident Investigation Course . Through this course, you'll learn the steps involved in the accident investigation process to prevent such incidents from occurring. This Accident Investigation Course will provide you with a thorough understanding of the accident investigation procedure. Throughout the course, you'll learn the process of documenting an accident scene and conducting interviews. Next, it will take you through investigation and cause analysis, developing solutions and reporting documentation. By the end of the course, you'll have a broader knowledge of how to identify the accident causes and write excellent reports. As a result, you can take an approach to prevent the occurrence of future accidents. Enrol now! Learning Objectives Understand the accident investigation procedures Learn how to document an accident scene Be able to conduct effective interviews Get to know about investigation and cause analysis Know the process of developing solutions to prevent the incidents from occurring Who is this Course for? This Accident Investigation Course is ideal for aspiring professionals who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of accident investigation or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course. However, an eye for detail and a creative mind is essential. Entry Requirement Anyone interested in learning more about this subject should take this Accident Investigation Course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path On successful completion of the Accident Investigation Course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Accident Investigator Aircraft Accident Investigator Forensic Collision Investigator Road Traffic Accident Investigator Course Curriculum Module 01: Understanding the Investigation Understanding the Investigation 00:14:00 Module 02: Why Investigate? Why Investigate? 00:19:00 Module 03: Accident Investigation Procedure Accident Investigation Procedure 00:16:00 Module 04: Documenting The Accident Scene Accident Investigation Procedure 00:16:00 Module 05: Conducting Effective Interviews Conducting Effective Interviews 00:15:00 Module 06: Investigation and Cause Analysis Investigation and Cause Analysis 00:21:00 Module 07: Developing Solutions Developing Solutions 00:19:00 Module 08: Report Documentation and Communication Report Documentation and Communication 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Dive into the fascinating world of particle physics through the Particle Physics Level 2 course. This course is designed to show you the ins and outs of particle physics. It will elevate your knowledge on the subject and help you pursue a rewarding career in the relevant sector. The Particle Physics Level 2 course will provide you with deep insights into particle physics. From the easily digestible modules, you will grasp the core principles of particle physics. This informative course will equip you with the key knowledge of elementary particles. In addition, you will get the opportunity to understand the fundamentals of particle acceleration. The course will also provide you with detailed lessons on radiation detectors. The comprehensive course will also assist you in learning the fundamentals of nuclear physics. After completing this Particle Physics Level 2 course, you will receive a certificate. This certificate will add significant value to your resume. Enrol in the course today and open new doors of opportunities. Learning Objectives Understand the fundamentals of particle physics Familiarise yourself with elementary particles Enrich your understanding of nuclear physics Grasp the principles of particle accelerators Build a clear understanding of radiation detectors Who is this Course for? This Particle Physics Level 2 course is ideal for aspiring particle physicists who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of the principles of particle physics or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course; however, an eye for detail and a creative mind is essential. Entry Requirement This course is available to all learners of all academic backgrounds. A good understanding of the English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successful completion of the Particle Physics Level 2 course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Particle Physicist Academic researcher Higher education lecturer Nanotechnologist Radiation protection practitioner Research scientist (physical sciences) Secondary school teacher Technical author Course Curriculum Module 01: Introduction to Particle Physics Introduction to Particle Physics 00:22:00 Module 02: Elementary Particles Elementary Particles 00:20:00 Module 03: The Nucleus The Nucleus 00:23:00 Module 04: Nuclear Physics Nuclear Physics 00:18:00 Module 05: Particle Accelerators Particle Accelerators 00:23:00 Module 06: Radiation detectors Radiation Detectors 00:37:00 Module 07: The Standard Model The Standard Model 00:15:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Mindfulness Practice will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Mindfulness Practice will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Mindfulness Practice and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Mindfulness Practice is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Mindfulness Practice. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Mindfulness Practice will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Fundamentals of Mindfulness Introduction to Mindfulness 00:04:00 Mindfulness Meditation 00:10:00 Section 02: Mindfulness in Various Conditions and Situations Mindfulness in Stress, Anxiety and Depression 00:07:00 Mindfulness for Bad Habits and Procrastination 00:05:00 Mindfulness for Pain Management 00:04:00 Mindfulness for Better Sleep 00:04:00 Mindfulness When at Work 00:03:00 Mindfulness for Kids 00:02:00 Mindfulness for Elderly 00:03:00 Mindfulness for Groups 00:03:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Hold the attention and suspense of the reader with Thriller Writing Thriller can be both enjoyable yet challenging tasks. A thriller writer needs to know a lot of things including the knowledge of science, reader's interest, the understanding of writing patterns, and more. The Creative Writing Course - Thriller course is prepared to fulfil the thirst of the thriller writer. The course teaches you the writing pattern or formats of a thriller and helps you to create a story and protagonist that will hold the suspense of the readers. You will learn how to write a thriller easily, then submit it to the publisher, and finally the procedures of publication. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Creative Writing Course - Thriller is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Creative Writing Course - Thriller. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Creative Writing Course - Thriller will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Writing The Thriller Introduction to Writing the Thriller 00:30:00 The Thriller: Form and Function 00:30:00 Writing the Thriller: Lesson One 00:30:00 Writing the Thriller: Lesson Two 00:30:00 Exercise 1 - Building Your Thriller 00:30:00 Writing the Thriller: Lesson Three 00:30:00 Exercise 2 - Building Your Thriller 00:30:00 Writing the Thriller: Lesson Four 00:30:00 Exercise 3 - Building Your Thriller 00:30:00 Writing the Thriller: Lesson Five 00:30:00 Exercise 4 - Building Your Thriller 00:30:00 Writing the Thriller: Lesson Six 00:30:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Basic Insomnia Solution course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Basic Insomnia Solution course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Basic Insomnia Solution and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Basic Insomnia Solution course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Basic Insomnia Solution course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Basic Insomnia Solution will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Introduction & First Concepts Introduction 00:01:00 The Science behind Insomnia 00:09:00 Section 02: Understanding Insomnia The Brain of an Insomniac 00:10:00 Sleep Starvation 00:09:00 Section 03: Beating Insomnia The Insomnia Cure 00:10:00 Lifestyle Modification for Insomniacs 00:05:00 Switching Off 00:07:00 Section 04: Final Ideas & Tips Final Thought and Tips 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

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