6239 Courses

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

Overview Explore the intricacies of clinical research and understand the administration process with our Clinical Research Administration Training course. This course will help you deepen your knowledge and acquire the ability to seek career prospects in the relevant sectors. The course is packed with high;y valuable information on clinical research. From the informative modules, you will learn the core concepts of clinic trial designing and planning. The course will help you develop the skills for data management and analysis. You will be able to build your expertise in monitoring and auditing. Moreover, you will acquire the skills required for quality control and site management as well. After the course, you will receive a CPDQS-accredated certificate of achievement. This certificate will enhance your employability and help you reach your career goals. Enrol now! Course Preview Learning Outcomes Understand the significance of clinical research in healthcare Learn about the process of clinical trail design and planning Deepen your knowledge of ethics and regulatory compliance Develop the ability for data management and record-keeping Know how to monitor and audit the trials Grasp the process of study site management and quality control 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? Trail planning Data management and analysis Monitoring and auditing Site management Quality control Compliance management Who Should Take This Clinical Research Administration 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 Clinical Research Administration 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 Clinical Research Administration Training course will equip you with effective skills and abilities and help you explore career paths such as  Clinical Research Administrator Clinical Research Associate Clinical Research Coordinator Clinical Data Manager Module 01: Introduction to Clinical Research Administration Introduction to Clinical Research Administration 00:15:00 Module 02: Clinical Trial Design and Planning Clinical Trial Design and Planning 00:11:00 Module 03: Ethics and Regulatory Compliance Ethics and Regulatory Compliance 00:13:00 Module 04: Institutional Review Boards (IRBs) and Ethics Committees Institutional Review Boards (IRBs) and Ethics Committees 00:10:00 Module 05: Data Management and Recordkeeping Data Management and Recordkeeping 00:12:00 Module 06: Safety Reporting and Adverse Events Safety Reporting and Adverse Events 00:10:00 Module 07: Clinical Trial Monitoring and Auditing Clinical Trial Monitoring and Auditing 00:09:00 Module 08: Study Site Management and Quality Control Study Site Management and Quality Control 00:17:00 Module 09: Data Analysis and Reporting Data Analysis and Reporting 00:09:00 Module 10: The Future of Clinical Research The Future of Clinical Research 00:10:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Unlock your career in payroll, finance, and data-driven administration with this comprehensive 20-in-1 Payroll Analyst bundle. Designed to help you stand out in accounting, HR, or financial operations roles, this bundle proves you’re prepared, capable, and hiring-ready. Description Payroll professionals are no longer just data processors—they're problem solvers, analysts, and compliance champions. Employers across sectors—from SMEs to large corporations—seek payroll analysts who are fluent in reporting, legislation, and software tools. That’s exactly the profile this bundle supports. With credentials in VAT, payroll systems, financial analysis, and key legal areas, you’ll show potential employers that you’re not just trainable—you’re already trained. It's a value-packed alternative to expensive accounting courses and a smart route to job-readiness in finance. The best part? It’s self-paced, affordable, and yours for life. Jobs may come and go—but this qualification toolkit stays with you. FAQ What roles can this help me land? Payroll analyst, payroll assistant, finance admin, data reporting officer, accounting support. Is this bundle suited for finance beginners? Yes, it’s built for beginners and career changers looking to enter payroll or finance operations. Will I receive proof of completion? Yes, each course includes a certificate you can use for applications and professional profiles. Is accounting software covered? Yes—key platforms like Xero, Sage, and Excel are included. What makes this a smart investment? 20 courses, one bundle, lifetime access—less than the cost of one-day payroll training. Should I wait before enrolling? Not if you want to be job-ready before the next hiring cycle. The earlier you start, the sooner you stand out.

Stand out in a crowded job market with the 20-in-1 Electrical: Electrician bundle—created for those who want to go beyond wiring and show full-spectrum job readiness. From site protocols to compliance and technical reporting, this training package offers serious value for serious professionals. If you’re aiming for more than just entry-level roles, this is your shortcut to being noticed. Description Being an electrician today means more than just knowing your circuits. Hiring managers, contractors, and facilities teams want professionals who can work safely, communicate clearly, and support regulatory and purchasing operations. This bundle was built to reflect that full picture. With content spanning electrical engineering fundamentals, renewable systems, negotiation, and incident reporting, the bundle supports roles across construction, repair, safety, and energy installation. It’s designed to give you the well-rounded skill set employers now prioritise—without breaking the bank. You get 20 certificates. You save hundreds. You prove your worth. But only if you act before the offer disappears. FAQ What job titles would this bundle support? Electrician, electrical technician, facilities maintenance worker, fire safety assistant, and repair contractor. Do I need to be working in the industry to take this? Not at all. It’s ideal for career changers, trainees, and upskillers alike. Does the bundle include compliance-related courses? Yes. Compliance, safety, PUWER, and RIDDOR are all part of the package. Will I get proof of qualification? Yes. Each course includes certification for your CV or job applications. Is this training recognised by employers? The certifications are widely accepted in the trade and admin-adjacent sectors. Is this a one-time offer? Yes. Once the promotion closes, the bundle will no longer be available at this rate.

Master the essentials and gain the edge employers are actively looking for in today’s competitive plumbing industry. This 20-in-1 course bundle is tailored for those who want to stand out — whether you're starting out, switching careers, or moving up the ladder. Description Hiring managers don’t just want plumbers — they want professionals who can handle safety, site management, compliance, and communication with confidence. This powerful 20-in-1 bundle brings all that and more into one streamlined learning path designed to make you job-ready from every angle. From operations and reporting to procurement and logistics, it’s everything a modern plumber needs to stay ahead of the curve. Why settle for one skill when you can master twenty? Whether you’re aiming for solo contracts or team leadership in a construction firm, this bundle adds credibility to your CV and shows you're ready for real responsibility. Employers notice multi-skilled professionals — don’t be the one left behind while others check all the boxes. FAQ Q: Who should take this bundle? A: Aspiring plumbers, contractor support staff, or anyone targeting facility management and on-site service roles. Q: Will this help me get hired? A: Yes — it’s crafted to build credibility across technical and soft skills valued in hiring decisions. Q: Does this replace formal apprenticeship or licensure? A: No. This bundle enhances employability, but doesn’t substitute regulated qualifications. Q: Can I list these courses individually on my CV? A: Absolutely — and it’ll make your CV stand out with breadth and professionalism. Q: Is it suited for self-employed tradespeople? A: Definitely. It strengthens your toolkit across safety, negotiation, reporting, and more. Q: Is this good value for the price? A: You're getting 20 targeted skills in one investment — that’s unmatched value and flexibility.