5387 Courses in Cardiff delivered Online

Overview After their homes, school is the place where children spend most of their time. Thus, it is vital to create a safety net for children in schools and educate the professionals in the education sector on child safeguarding. This is where our Child Protection in Education Training comes in. This course is designed to educate you on the key aspects of child safeguarding. Through the informative modules, you will learn the child protection and safeguarding framework. The modules will educate you on the process of responding and reporting safeguarding concerns. On top of that, you will learn the skills and expertise required to manage, safeguarding issues in the education sector. You will understand how to handle reports against the staff and take action accordingly. By the end of the course you will have adequate knowledge to develop and implement child safeguarding plans.  This course is the ultimate guide for creating a safe zone for children in educational institutions. Enrol now and develop a better place for the children to flourish. Course Preview Learning Outcomes Familiarise yourself with the basics of child protection and safegurding Know the proper process to respond to child abuse Understand how to share information regarding child safety concerns Learn about the child safeguarding concerns and management procedures in the education sector Develop the skills to deal with allegations against the staff Gain in-depth knowledge of developing safeguarding action plans Why Take This Course From John Academy? 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 Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Child protection and safeguarding Managing and reporting safeguarding concerns Allegation Management Action Plan Development Who Should Take this Child Protection in Education Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Child Protection in Education Training course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Child Protection in Education Training course will equip you with effective skills and abilities and help you explore career paths such as  Child Safeguarding Officer School Administrator Teacher Teaching Assistant Welfare Officer Module 01: Child Protection and Safeguarding Basics Child Protection and Safeguarding Basics 00:16:00 Module 02: Child Protection System In the UK Child Protection System In the UK 00:20:00 Module 03: How to Respond to Child Abuses How to Respond to Child Abuses 00:13:00 Module 04: The Importance of Sharing Information about Any Safeguarding Concerns The Importance of Sharing Information about Any Safeguarding Concerns 00:15:00 Module 05: Reporting Abuse Reporting Abuse 00:11:00 Module 06: Child Maltreatment Child Maltreatment 00:18:00 Module 07: Child Protection in Education System Good Practice Guidelines Child Protection in Education System Good Practice Guidelines 00:21:00 Module 08: How to Deal with Allegations Against Staff How to Deal with Allegations Against Staff 00:17:00 Module 09: Child Protection in Sport & Active Leisure Good Safeguarding and Practice Guideline Child Protection in Sport & Active Leisure Good Safeguarding and Practice Guideline 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Register on the Planning & Control Using Microsoft Project 2013, 2016 & 2019 today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Planning & Control Using Microsoft Project 2013, 2016 & 2019 is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Planning & Control Using Microsoft Project 2013, 2016 & 2019 Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The 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 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. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Planning & Control Using Microsoft Project 2013, 2016 & 2019, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Section 01: Introduction Introduction, Course Agenda and Understanding the Student 00:05:00 Introduction 00:10:00 Section 02: Creating a Project Schedule Creating a Project Plan 00:20:00 Section 03: Navigation and Setting the Options Navigation and Setting the Options 00:20:00 Workshop 1 - Navigation and Setting Your Project Options 00:22:00 Section 04: Creating Projects and Templates Creating Projects and Templates 00:10:00 Workshop 2 - Creating Project and Templates66 00:08:00 Section 05: Defining Calendars Defining Calendars 00:18:00 Workshop 3 - Maintaining the Calendars 00:08:00 Section 06: Adding Tasks Adding Tasks 00:23:00 Workshop 4 - Adding Tasks 00:02:00 Section 07: Organizing Tasks Using Outlining Organising Tasks Using Outlining 00:08:00 Workshop 5 - Entering Summary Tasks 00:03:00 Section 08: Formatting the Display Formatting the Display 00:27:00 Workshop 6 - Formatting the Bar Chart 00:05:00 Adding Task Dependencies 00:15:00 Workshop 7- Adding the Relationships 00:03:00 Section 09: Network Diagram View Network Diagram View 00:13:00 Workshop 8 - Network Diagram and Schedule Calculations 00:04:00 Section 10: Constraints Constraints 00:13:00 Workshop 9 - Constraints 00:03:00 Section 11: Filters Filters 00:17:00 Workshop 10 - Filters 00:05:00 Section 12: Tables and Grouping Tasks Tables and Grouping Tasks 00:19:00 Workshop 11 - Reorganizing the Schedule 00:04:00 Section 13: Views and Details Views & Details 00:19:00 Workshop 12- Organizing Your Data Using Views and Tables 00:06:00 Section 14: Printing and Reports Printing and Reports 00:17:00 Workshop 13 - Printing 00:03:00 Section 15: Tracking Progress Tracking Progress 00:24:00 Workshop 14 - Updating the Schedule and Baseline Comparison 00:10:00 Section 16: Creating Resources and Costs Creating Resources and Costs 00:21:00 Workshop 15 - Defining Resources 00:02:00 Section 17: Assigning Resources and Costs to Tasks Assigning Resources and Costs to Tasks 00:24:00 Workshop 16 - Assigning Resources to Tasks 00:10:00 Section 18: Resource Optimization Resource Optimizing 00:11:00 Workshop 17 - Resource Graphs and Tables 00:04:00 Section 19: Updating Projects with Resources Updating Projects with Resources 00:28:00 Workshop 18 - Updating a Resourced Schedule 00:11: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.

Follow your dreams by enrolling on the Domestic Violence and Domestic Abuse course today and develop the experience, skills and knowledge you need to enhance your professional development. Domestic Violence and Domestic Abuse will help you arm yourself with the qualities you need to work towards your dream job. Study the Domestic Violence and Domestic Abuse training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Domestic Violence and Domestic Abuse course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Domestic Violence and Domestic Abuse course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Domestic Violence and Domestic Abuse course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Domestic Violence and Domestic Abuse course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Domestic Violence and Domestic Abuse course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Domestic Violence and Domestic Abuse course. The Domestic Violence and Domestic Abuse course is designed by industry experts and is tailored to help you learn new skills with ease.  The Domestic Violence and Domestic Abuse is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Domestic Violence and Domestic Abuse when it suits you. Access the Domestic Violence and Domestic Abuse course modules from any internet-enabled device, including computers, tablets, and smartphones. The Domestic Violence and Domestic Abuse course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Domestic Violence and Domestic Abuse now and start learning instantly! What You Get Out Of Studying Domestic Violence and Domestic Abuse With Janets: Receive a digital Certificate upon successful completion of the Domestic Violence and Domestic Abuse course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Domestic Violence and Domestic Abuse training course is delivered through Janets' online learning platform. Access the Domestic Violence and Domestic Abuse content from any internet-enabled device whenever or wherever you want to. The Domestic Violence and Domestic Abuse course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Domestic Violence and Domestic Abuse course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Domestic Violence and Domestic Abuse course. After successfully passing the Domestic Violence and Domestic Abuse course exam, you will be able to apply for a CPD-accredited certificate as proof of your Domestic Violence and Domestic Abuse qualification. Certification All students who successfully complete the Domestic Violence and Domestic Abuse course can instantly download their digital certificate. You can also purchase a hard copy of the Domestic Violence and Domestic Abuse course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Domestic Violence and Domestic Abuse is ideal for those who already work in this sector or are an aspiring professional. This Domestic Violence and Domestic Abuse course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Domestic Violence and Domestic Abuse is open to all students and has no formal entry requirements. To study the Domestic Violence and Domestic Abuse course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Domestic Violence and Domestic Abuse is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Domestic Violence and Domestic Abuse and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Module 1: Introduction to Domestic Violence & Abuse Introduction to Domestic Violence & Abuse 00:27:00 Module 2: The Components of Domestic Violence The Components of Domestic Violence 00:24:00 Module 3: The Impact of Domestic Violence on Victims The Impact of Domestic Violence on Victims 00:31:00 Module 4: The Impact of Domestic Violence and Abuse on Children The Impact of Domestic Violence and Abuse on Children 00:47:00 Module 5: Assessing the Risks of Domestic Violence and Abuses on Children Assessing the Risks of Domestic Violence and Abuses on Children 00:14:00 Module 6: Supporting the Victim and Reporting Incidents Supporting the Victim and Reporting Incidents 00:30:00 Module 7: Record Keeping Record Keeping 00:24:00 Module 8: Domestic Violence and Abuse Legislation in the UK Domestic Violence and Abuse Legislation in the UK 00:15:00 Mock Exam Mock Exam - Domestic Violence and Domestic Abuse 00:20:00 Final Exam Final Exam - Domestic Violence and Domestic Abuse 00:20: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.

Follow your dreams by enrolling on the Anti Money Laundering and Risk Management course today and develop the experience, skills and knowledge you need to enhance your professional development. Anti Money Laundering and Risk Management will help you arm yourself with the qualities you need to work towards your dream job. Study the Anti Money Laundering and Risk Management training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Anti Money Laundering and Risk Management course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Anti Money Laundering and Risk Management course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Anti Money Laundering and Risk Management course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Anti Money Laundering and Risk Management course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Anti Money Laundering and Risk Management course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Anti Money Laundering and Risk Management course. The Anti Money Laundering and Risk Management course is designed by industry experts and is tailored to help you learn new skills with ease.  The Anti Money Laundering and Risk Management is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Anti Money Laundering and Risk Management when it suits you. Access the Anti Money Laundering and Risk Management course modules from any internet-enabled device, including computers, tablets, and smartphones. The Anti Money Laundering and Risk Management course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Anti Money Laundering and Risk Management now and start learning instantly! What You Get Out Of Studying Anti Money Laundering and Risk Management With Janets Free PDF certificate upon successful completion of the Anti Money Laundering and Risk Management Full one-year access to Anti Money Laundering and Risk Management Course materials Instant assessment results with the Anti Money Laundering and Risk Management No hidden fees with the Anti Money Laundering and Risk Management Full tutor support available from Monday to Friday with the Anti Money Laundering and Risk Management Study the Anti Money Laundering and Risk Management at your own pace Benefit from instant feedback through mock exams and multiple-choice assessments Gain a complete understanding of Anti Money Laundering and Risk Management Accessible, informative modules taught by expert instructors Get 24/7 help or advice from our email and live chat teams with the Anti Money Laundering and Risk Management Study the Anti Money Laundering and Risk Management in your own time through your computer, tablet or mobile device Improve your chance of gaining professional skills and better earning potential by completing the Anti Money Laundering and Risk Management Description The Anti Money Laundering and Risk Management training course is delivered through Janets' online learning platform. Access the Anti Money Laundering and Risk Management content from any internet-enabled device whenever or wherever you want to. The Anti Money Laundering and Risk Management course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Anti Money Laundering and Risk Management course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Anti Money Laundering and Risk Management course. After successfully passing the Anti Money Laundering and Risk Management course exam, you will be able to apply for a CPD-accredited certificate as proof of your Anti Money Laundering and Risk Management qualification. Certification All students who successfully complete the Anti Money Laundering and Risk Management course can instantly download their digital certificate. You can also purchase a hard copy of the Anti Money Laundering and Risk Management course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Anti Money Laundering and Risk Management is ideal for those who already work in this sector or are an aspiring professional. This Anti Money Laundering and Risk Management course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Anti Money Laundering and Risk Management is open to all students and has no formal entry requirements. To study the Anti Money Laundering and Risk Management course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Module 01: Introduction to Money Laundering Introduction to Money Laundering 00:15:00 Module 02: Proceeds of Crime Act 2002 Proceeds of Crime Act 2002 00:17:00 Module 03: Development of Anti-Money Laundering Regulation Development of Anti-Money Laundering Regulations 00:30:00 Module 04: Responsibility of the Money Laundering Reporting Officer Responsibility of the Money Laundering Reporting Officer 00:18:00 Module 05: Risk-based Approach Risk-based Approach 00:20:00 Module 06: Customer Due Diligence Customer Due Diligence 00:21:00 Module 07: Record Keeping Record Keeping 00:14:00 Module 08: Suspicious Conduct and Transactions Suspicious Conduct and Transactions 00:19:00 Module 09: Awareness and Training Awareness and Training 00:17:00 Mock Exam Mock Exam - Anti Money Laundering and Risk Management 00:20:00 Final Exam Final Exam - Anti Money Laundering and Risk Management 00:20: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.

Microsoft Office is a leading family of software, with over 1 billion users worldwide. Employers often expect their employees to have at least fundamental knowledge of its essential functions and features.  The Microsoft Office 2010 Essentials course is designed to help you master Microsoft Office and equip you with the practical skills to manage everyday administrative tasks with ease. Whether you have little or no experience, this training program will take you from beginner to expert in no time.  In this masterclass, you will familiarise with the essential features of Word, Excel, PowerPoint, Outlook and Access. You will learn how to create engaging presentations, automate tasks, create documents and much more. On course completion, you will have the practical skills to utilise Microsoft Office programs for ultimate career progression.  Learning Outcomes of The Microsoft Office 2010 Essentials:  Familiarise with Microsoft Office 2010's key functions and features Get expert training on Excel, Word, PowerPoint, Outlook and Access Go from beginner to expert in just a few hours & add new skills to your CV Learn how to automate tasks in Microsoft Excel using macros Utilise Microsoft PowerPoint to deliver killer work presentations and slides Understand how to format and align text Improve your proficiency in everyday administrative tasks Know how to create queries and reports in Access Why choose this course Earn an e-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 Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The 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 Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Microsoft Word Module One - Getting Started 00:15:00 Module Two - Opening and Closing Word 00:30:00 Module Three - Working with Documents 00:20:00 Module Four - Your First Document 00:25:00 Module Five - Basic Editing Tasks 00:20:00 Module Six - Basic Formatting Tasks 00:25:00 Module Seven - Advanced Formatting Tasks 00:20:00 Module Eight - Formatting Paragraphs 00:30:00 Module Nine - Working with Styles 00:25:00 Module Ten - Formatting the Page 00:25:00 Module Eleven - Adding the Finishing Touches 00:25:00 Module Twelve - Wrapping Up 00:10:00 Activities - Microsoft Word 2010 for Beginners 00:00:00 Microsoft Excel Module One - Getting Started 00:15:00 Module Two - Opening and Closing Excel 00:20:00 Module Three - Your First Worksheet 00:20:00 Module Four - Working with Excel Files 00:20:00 Module Five - Viewing Excel Data 00:20:00 Module Six - Printing Excel Data 00:20:00 Module Seven - Building Formulas 00:30:00 Module Eight - Using Excel Functions 00:25:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 00:25:00 Module Eleven - Advanced Formatting Tools 00:25:00 Module Twelve - Wrapping Up 00:30:00 Microsoft PowerPoint Module One - Getting Started 00:10:00 Module Two - Opening and Closing PowerPoint 00:30:00 Module Three - Working with Presentations 00:25:00 Module Four - Your First Presentation 00:30:00 Module Five - Working with Text 00:20:00 Module Six - Formatting Text 00:20:00 Module Seven - Formatting Paragraphs 00:30:00 Module Eight - Advanced Formatting Tasks 00:20:00 Module Nine - Customizing Slide Elements 00:30:00 Module Ten - Setting Up Your Slide Show 00:20:00 Module Eleven - Showtime 00:25:00 Module Twelve - Wrapping Up 00:20:00 Activities-Microsoft PowerPoint 2010 for Beginners 00:00:00 Microsoft Access Module One - Getting Started 00:15:00 Module Two - Getting Started With Access 00:30:00 Module Three - Using the Access Interface 00:30:00 Module Four - Working with Database Objects 00:35:00 Module Five - Creating Tables 00:30:00 Module Six - Working with Tables 00:35:00 Module Seven - Creating Forms 00:25:00 Module Eight - Working with Forms 00:40:00 Module Nine - Creating Reports 00:40:00 Module Ten - Creating Queries 00:35:00 Module Eleven - Managing Your Database 00:20:00 Module Twelve - Wrapping Up 00:10:00 Activities - Microsoft Access 2010 for Beginners 00:00:00 Microsoft Outlook Module One - Getting Started 00:20:00 Module Two - Opening and Closing Outlook 00:25:00 Module Three - Working with E-mail 00:20:00 Module Four - Creating a New E-mail 00:25:00 Module Five - Managing E-mail 00:30:00 Module Six - Managing Junk Mail 00:30:00 Module Seven - Outlook's Organization Tools 00:30:00 Module Eight - Searching for Items 00:20:00 Module Nine - An Introduction to the Calendar 00:35:00 Module Ten - An Introduction to Tasks 00:25:00 Module Eleven - An Introduction to Contacts 00:30:00 Module Twelve - Wrapping Up 00:45:00 Activities-Microsoft Outlook 2010 for Beginners 00:00: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.

Microsoft Office is an office suite that can be used for business as well as for personal use. Although Microsoft Office is already rich with features and essential for productivity, with each new release, it continues to improve and enhance the office package. It's a wise investment for both your professional and personal life if you learn how to use Microsoft Office. Our Microsoft Office 2013 Complete Course course will help you hone your skills in Microsoft Office and take them to an advanced level.  This Microsoft Office 2013 Complete Course course involves advanced lessons on Word, Excel, PowerPoint, Access and Outlook. Throughout this course, learners will go through the practical skills, knowledge, and information needed to make full use of Microsoft Office apps. They'll explore all the key areas related to these applications and their proper utilisation.  Now is your chance to show potential employers that you are confident and comfortable with using Microsoft Office applications. Enrol now and explore the more complex features and tools of Microsoft Office.  Learning Outcomes:  Gain sufficient knowledge of the advanced features of Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, and Microsoft Outlook Understand how to produce standard documents using Microsoft Word Familiarise with the key skills to master Microsoft Excel worksheets Get a solid understanding of advanced accounting calculations Develop your creative PowerPoint presentation skills Familiarise with advanced editing and formatting tasks in Microsoft Word Understand how to perform advanced email tasks and learn how to manage Outlook data Learn how to create forms and reports using Microsoft Access Familiarise with PowerPoint's research tools and learn how to use these tools for preparing a presentation Learn how to create pivot tables and pivot charts and understand grouping and outlining data Why choose this course Earn an e-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 Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The 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 Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Microsoft Word Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with the Word Window 01:00:00 Module Three - Advanced Editing and Formatting Tasks 01:00:00 Module Four - Working with Illustrations 01:00:00 Module Five - Formatting Pictures 01:00:00 Module Six - Adding SmartArt 01:00:00 Module Seven - Adding Tables 01:00:00 Module Eight - Inserting Special Objects 01:00:00 Module Nine - Working with Document References 01:00:00 Module Ten - Reviewing Your Document 01:00:00 Module Eleven - Using Comments and Tracking 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Word Advanced Level 00:00:00 Microsoft Excel Advanced Level Module One - Getting Started 01:00:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel - Advanced Level 00:00:00 Microsoft PowerPoint Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with Shapes 01:00:00 Module Three - Working with Text Boxes 01:00:00 Module Four - Adding SmartArt 01:00:00 Module Five - Advanced Drawing Tasks 01:00:00 Module Six - Adding Tables 01:00:00 Module Seven - Inserting Audio and Video 01:00:00 Module Eight - PowerPoint's Research Tools 01:00:00 Module Nine - Preparing for Your Presentation 01:00:00 Module Ten - Using Slide Masters 01:00:00 Module Eleven - Advanced Presentation Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft PowerPoint Advanced Level 00:00:00 Microsoft Access Advanced Level Module One - Getting Started 00:30:00 Module Two - Using App Views 01:00:00 Module Three - Customizing Apps, Part One 01:00:00 Module Four - Customizing Apps, Part Two 01:00:00 Module Five - Working with More Record Tasks 01:00:00 Module Six - Using Advanced Field Tasks 01:00:00 Module Seven - Working in Table Design View 01:00:00 Module Eight - Working with the Expression Builder 01:00:00 Module Nine - Working with External Data 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Creating Forms and Reports 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access Advanced Level 00:00:00 Microsoft Outlook Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with Messages 01:00:00 Module Three - Customizing Your Profile 01:00:00 Module Four - Advanced Email Tasks 01:00:00 Module Five - Managing Junk Mail 01:00:00 Module Six - Advanced Calendar Tasks 01:00:00 Module Seven - Doing More With Tasks 01:00:00 Module Eight - Using Notes 01:00:00 Module Nine - Viewing RSS Feeds 01:00:00 Module Ten - Printing 01:00:00 Module Eleven - Managing Outlook Data 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities- Microsoft Outlook Advanced Level 00:00: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.

Follow your dreams by enrolling on the Anti Money Laundering (AML) Awareness and AML Regulations course today and develop the experience, skills and knowledge you need to enhance your expert development. Anti Money Laundering (AML) Awareness and AML Regulations will help you arm yourself with the qualities you need to work towards your dream job. Study the Anti Money Laundering (AML) Awareness and AML Regulations training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Anti Money Laundering (AML) Awareness and AML Regulations course will allow you to enhance your CV, impress potential employers, and stand out from the crowd. This Anti Money Laundering (AML) Awareness and AML Regulations course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Anti Money Laundering (AML) Awareness and AML Regulations course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Anti Money Laundering (AML) Awareness and AML Regulations course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Anti Money Laundering (AML) Awareness and AML Regulations course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Anti Money Laundering (AML) Awareness and AML Regulations course. The Anti Money Laundering (AML) Awareness and AML Regulations course is designed by industry experts and is tailored to help you learn new skills with ease. The Anti Money Laundering (AML) Awareness and AML Regulations is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Anti Money Laundering (AML) Awareness and AML Regulations when it suits you. Access the Anti Money Laundering (AML) Awareness and AML Regulations course modules from any internet-enabled device, including computers, tablets, and smartphones. The Anti Money Laundering (AML) Awareness and AML Regulations course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Anti Money Laundering (AML) Awareness and AML Regulations now and start learning instantly! What You Get Out Of Studying Anti Money Laundering (AML) Awareness and AML Regulations With Janets Free PDF certificate upon successful completion of the Anti Money Laundering (AML) Awareness and AML Regulations Full one-year access to Anti Money Laundering (AML) Awareness and AML Regulations Course materials Instant assessment results with the Anti Money Laundering (AML) Awareness and AML Regulations Full tutor support available from Monday to Friday with the Anti Money Laundering (AML) Awareness and AML Regulations Study the Anti Money Laundering (AML) Awareness and AML Regulations at your own pace Benefit from instant feedback through mock exams and multiple-choice assessments Gain a complete understanding of Anti Money Laundering (AML) Awareness and AML Regulations Accessible, informative modules taught by expert instructors Get 24/7 help or advice from our email and live chat teams with the Anti Money Laundering (AML) Awareness and AML Regulations Study the Anti Money Laundering (AML) Awareness and AML Regulations in your own time through your computer, tablet or mobile device Improve your chance of gaining expert skills and better earning potential by completing the Anti Money Laundering (AML) Awareness and AML Regulations Description  The Anti Money Laundering (AML) Awareness and AML Regulations training course is delivered through Janets' online learning platform. Access the Anti Money Laundering (AML) Awareness and AML Regulations content from any internet-enabled device whenever or wherever you want to. The Anti Money Laundering (AML) Awareness and AML Regulations course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £69. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets 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. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who Is This Course For: The Anti Money Laundering (AML) Awareness and AML Regulations is ideal for those who already work in this sector or are an aspiring expert. This Anti Money Laundering (AML) Awareness and AML Regulations course is designed to enhance your expertise and boost your CV. Learn key skills and gain a expert lesson to prove your newly-acquired knowledge. Requirements: The Anti Money Laundering (AML) Awareness and AML Regulations is open to all students and has no formal entry requirements. To study the Anti Money Laundering (AML) Awareness and AML Regulations course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Anti Money Laundering (AML) Awareness and AML Regulations is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Anti Money Laundering (AML) Awareness and AML Regulations and gain an industry-acknowledged lesson that will help you excel in finding your ideal job. Course Content Module 01: Introduction to Money Laundering Introduction to Money Laundering 00:15:00 Module 02: Proceeds of Crime Act 2002 Proceeds of Crime Act 2002 00:17:00 Module 03: Development of Anti-Money Laundering Regulation Development of Anti-Money Laundering Regulations 00:30:00 Module 04: Responsibility of the Money Laundering Reporting Officer Responsibility of the Money Laundering Reporting Officer 00:18:00 Module 05: Risk-based Approach Risk-based Approach 00:20:00 Module 06: Customer Due Diligence Customer Due Diligence 00:21:00 Module 07: Record Keeping Record Keeping 00:14:00 Module 08: Suspicious Conduct and Transactions Suspicious Conduct and Transactions 00:19:00 Module 09: Awareness and Training Awareness and Training 00:17:00 Mock Exam Mock Exam - Anti Money Laundering (AML) Awareness and AML Regulations 00:20:00 Final Exam Final Exam - Anti Money Laundering (AML) Awareness and AML Regulations 00:20:00 Assignment Assignment - Anti Money Laundering (AML) Awareness And AML Regulations 6 days, 3 hours Order Your Certificate Order your Certificate QLS 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.

Register on the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The 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 Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content 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 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.

Overview For those planning for a thriving career in finance, solid skills in depreciation accounting is vital. If you are seeking success in accounting, our Depreciation Accounting Course can be your solution. This course is designed to take your skills to the next level. The course will provide you with the fundamentals of depreciation accounting. From the easy-to-follow modules, you will learn about depreciation models and the strategies to utilise them. In addition, the course will enhance your understanding of reporting and compliance. The course will also cover lessons on depreciation tax shields and depreciation accounting trends and future developments. After the completion of the course, you will receive an accredited certificate of achievement. This certificate will add value to your resume and help you climb the career ladder; enrol now! Course Preview Learning Outcomes Understand the definition and terms of depreciation accounting Learn about depreciation models and how to use them Build your expertise in depreciation reporting and compliance Grasp essential information about depreciation tax shield Get introduced to the trends and future developments of depreciation accounting Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Depreciation Accounting Who Should Take This Depreciation Accounting Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Depreciation Accounting Course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Depreciation Accounting Course will equip you with effective skills and abilities and help you explore career paths such as  Accountants Financial Analyst Financial Consultant Tax Accountant Module 1: Introduction to Depreciation Accounting Introduction to Depreciation Accounting 00:20:00 Module 2: Accounting for Depreciation Accounting for Depreciation 00:22:00 Module 3: Deep Dive into the Depreciation Model Deep Dive into the Depreciation Model 00:14:00 Module 4: Case Studies and Real-World Applications Case Studies and Real-World Applications 00:11:00 Module 5: Depreciation Reporting and Compliance Depreciation Reporting and Compliance 00:13:00 Module 6: Emerging Trends and Future Developments Emerging Trends and Future Developments 00:18:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview Competitive pay, job security, flexible work hours and many other facts make medical transcription a great career opportunity. So if you are looking for a job or want to change your current one, you can give medical transcription a shot. Our Medical Transcription Course will help secure the basic skills you need for this career. The course will provide you with a detailed understanding of medical transcription. From the modules, you grasp adequate knowledge to understand medical reports. The course will assist you in building a solid understanding of the words used in the medical setting. You will be able to learn the essentials of protecting the data of the patients. This course will provide you with a CPD-accredited certificate along with valuable skill sets. This certificate will enhance your CV and help you build a career in the medical industry. Course Preview Learning Outcomes Familiarise yourself with the essentials of medical transcription Develop the ability to understand medical reports Enhance your knowledge and understanding of medical language Understand the process of formatting Learn the process of data protection in medical settings Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Medical Transcription Medical Language Data Protection Who Should Take This Medical Transcription Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Medical Transcription Course Certification After completing and passing the Medical Transcription Course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Medical Transcription Course will equip you with effective skills and abilities and help you explore career paths such as  Medical Transcriptionist Medical Administrator Receptionist Module 01: Introduction To Medical Transcription Introduction to Medical Transcription 00:13:00 Module 02: The What, How, Who And Why Of Medical Transcription The What, How, Who and Why of Medical Transcription 00:18:00 Module 03: Understanding Medical Reports Understanding Medical Reports 00:26:00 Module 04: Medical Language Boot Camp Medical Language Boot Camp 00:13:00 Module 05: Formatting: The Basics Formatting The Basics 00:15:00 Module 06: Data Protection Data Protection 00:18:00 Assignment Assignment - Medical Transcription 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00