4526 Courses

Windows Server 2016 - Level 1 Hands-on Training Course Overview Are you looking to begin your Microsoft Server 2016 career or want to develop more advanced skills in Microsoft Server 2016? Then this Windows Server 2016 - Level 1 Hands-on Training course will set you up with a solid foundation to become a confident Windows Server 2016 administrator and help you to develop your expertise in Microsoft Server 2016. This Windows Server 2016 - Level 1 Hands-on Training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Windows Server 2016 - Level 1 Hands-on Training course will set you up with a solid foundation to become a confident Windows Server 2016 administrator and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a Windows Server 2016 administrator. The Windows Server 2016 - Level 1 Hands-on Training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a Windows Server 2016 administrator. This comprehensive Windows Server 2016 - Level 1 Hands-on Training course is the perfect way to kickstart your career in the field of Microsoft Server 2016. This Windows Server 2016 - Level 1 Hands-on Training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a Windows Server 2016 administrator or want to learn more skills on Microsoft Server 2016 but unsure of where to start, then this Windows Server 2016 - Level 1 Hands-on Training course will set you up with a solid foundation to become a confident Windows Server 2016 administrator and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This Windows Server 2016 - Level 1 Hands-on Training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive Windows Server 2016 - Level 1 Hands-on Training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Server 2016. Entry Requirement There are no academic entry requirements for this Windows Server 2016 - Level 1 Hands-on Training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method This windows server 2016 - level 1 hands-on training online course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Course Curriculum Course Overview Course Overview Video Building Your Virtual Lab Environment Video - Downloading ISO and OVA Fles for VirtualBox Video and Lab - Create Virtual Install of Server 2016 Full GUI Using VirtualBox Video and Lab - Create Virtual Install of Server 2016 Core Using VirtualBox Video and Lab - Create Virtual Install of Windows 10 Pro Using VirtualBox Video - Take a Snapshot of Your Current Configuration Building a Microsoft Server 2016 Domain Video and Lab - Preparing Your Network for Active Directory Video and Lab - Prepare Server 2016 for Promotion to a Domain Controller Video and Lab - Promote Server 2016 to a Domain Controller Video and Lab - Join Server 2016 Core to Windows 2016 Domain Video and Lab - Promote Server Core to a Domain Controller Video and Lab - Add a Windows 10 Workstation to a Microsoft Domain Video - Create a Server 2016 Replica Domain Controller Domain Naming System (DNS) Video - Installing the DNS Role Using Server Manager Video - Create a secondary or backup DNS server using Server Core Video - Create a DNS reverse lookup zone in Server 2016 Video - Create a new DNS host record Video - Create a new MX record in DNS Dynamic Host Configuration Protocol (DHCP) Video and lab - Install and configure DHCP Using PowerShell Video - Authorize a Windows 2016 DHCP Server Video - Server and Scope options in Windows server 2016 Video - How to Edit the Default Gateway Settings in DHCP Video - How to Edit DNS Server List in DHCP Video - Use Filters in DHCP to Deny Clients DHCP Services Video - Use DHCP User Classes to Assign Alternate Scope Options Video - Edit a DHCP Scope Video - How to backup and restore the DHCP database video - Create predefined options in DHCP Speed Learning Active Directory Administration Video - Create a user in Active Directory Video - Create an administrator user in Server 2016 Video - Create a distribution group in Active Directory Video - Create and use a security group Video - Create an Organizational Unit Video - Unlock a User Account Video - Move an object to a New Organizational Unit in Active Directory Video - Change the domain administrator password Video - Fix Access Denied when deleting Active Directory objects Speed Learning Group Policy Video - Prevent automatic logoff due to inactivity Video - Create and link a Group Policy Object to an OU Video - Edit group policy objects to affect a user Video - Edit a group policy object to affect a computer Video - Backup and restore Group Policy objects Video - Force Screensaver and Timeouts Using Group Policy Video - Change Users Desktop Background Using Group Policy Speed Learning Server 2016 Administration Video - Overview of The New Start Menu for Server 2016 Video - Working with Task View in Server 2016 Video - Enable Remote Desktop Using PowerShell 623 Video - Rearm The 180-Day Evaluation Period for Wndows Server Video - Rearm The 30-Day Evaluation Period for Windows 10 Video - Create a Heads-up Display Using BgInfo Video - Change the date, time and numbers format in Server 2016. Video - Rename Windows Server 2016 Using PowerShell Manage Files and Shares Video and Lab - Setup Work Folders in a Windows Domain Video and Lab - Configure a Distributed File System Using Windows Server Video - Create a Shared Folder on a Windows Server Video - Create a Shared Folder Using Server Manager Speed Learning Managing Printers Video - Add a network printer in Windows server 2016 Video - Install and use the Print Management Role in Windows Server 2016 Video - Deploy printers using Group Policy in Windows Server 2016 Speed Learning Server 2016 Firewall Video - Turn the Firewall on or off in Windows 2016 Server Video - Allow an inbound port through a Windows Firewall Video - Enable PING for Server 2016 and Windows 10 Video - Using Netsh to Manage the Windows Firewall Video - Using Powershell to Gather Firewall Information Disk Management Video and Lab - Adding Additional Hard Disks Using VirtualBox Video - Shrink or Extend a Volume in Windows Server Video - Format a Volume With Refs in Windows Server Video - Format a volume with FAT32 in Windows Server Troubleshooting Video - NSLookup Video and Lab - Troubleshooting Internet Connectivity Overview of Windows Sysinternal Tools Video - Overview of Sysinternal's Process Explorer Order Your Certificate Now Order Your Certificate Now Feedback Feedback Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Mental Health and Learning Disability Nurse Course Overview Are you looking to begin your mental health and learning disability nursing career or want to develop more advanced skills in mental health and learning disability nursing? Then this mental health and learning disability nurse course online course will set you up with a solid foundation to become a confident mental health and learning disability nurse and help you to develop your expertise in mental health and learning disability nursing. This mental health and learning disability nurse course online course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this mental health and learning disability nurse course online course will set you up with a solid foundation to become a confident mental health and learning disability nurse and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a mental health and learning disability nurse. The mental health and learning disability nurse course online course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a mental health and learning disability nurse. This comprehensive mental health and learning disability nurse course online course is the perfect way to kickstart your career in the field of mental health and learning disability nursing. This mental health and learning disability nurse course online course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a mental health and learning disability nurse or want to learn more skills on mental health and learning disability nursing but unsure of where to start, then this mental health and learning disability nurse course online course will set you up with a solid foundation to become a confident mental health and learning disability nurse and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This mental health and learning disability nurse course online course is crafted by industry experts, to enable you to learn quickly and efficiently and at your own pace and convenience. Who should take this course? This comprehensive mental health and learning disability nurse course online course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of mental health and learning disability nursing. Entry Requirements There are no academic entry requirements for this mental health and learning disability nurse course online course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Method of Assessment On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Career path This mental health and learning disability nurse course online course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Introduction to Mental Health Nursing Module 01: Introduction to Mental Health Nursing Evolution of Mental Health Services Module 02: Evolution of Mental Health Services Mental Health Well Being in the UK Module 03: Mental Health Well Being in the UK Assessment Mock 1 Assessment Mock 1 - Mental Health Nursing Course UK Mental Health Legislation Module 04: UK Mental Health Legislation Common Mental Health Problems in the UK Module 05: Common Mental Health Problems in the UK Models of Care Delivery in Mental Health Nursing Module 06: Models of Care Delivery in Mental Health Nursing Assessment Mock 2 Assessment Mock 2 - Mental Health Nursing Course Types of Therapy and Treatment Approaches Module 07: Types of Therapy and Treatment Approaches Therapeutic Relationship Facets of Mental Health Nursing Module 08: Therapeutic Relationship Facets of Mental Health Nursing The 10 Essential Shared Capabilities Module 09: The 10 Essential Shared Capabilities Assessment Mock 3 Assessment Mock 3 - Mental Health Nursing Course Child Adolescent Mental Health Module 10: Child Adolescent Mental Health Managing Workplace-Related Stress Module 11: Managing Workplace-Related Stress Mental Health Nursing as a Career Choice Module 12: Mental Health Nursing as a Career Choice The Mental Health Nursing Core Competence and Career Framework Module 13: The Mental Health Nursing Core Competence and Career Framework Assessment Mock 4 Assessment Mock 4 - Mental Health Nursing Course Learning Disability and Mental Health Module 02: Learning Disability and Mental Health Causes of Learning Disability Module 03: Causes of Learning Disability Legal Framework on Learning Disability Module 04: Legal Framework on Learning Disability Challenging Behaviour of Adults with Learning Disabilities Module 05: Challenging Behaviour of Adults with Learning Disabilities Assessment Mock 5 Assessment Mock 1 - Learning Disability Nurse Online Training Course Protecting People with Learning Disabilities Module 06: Protecting People with Learning Disabilities Assessment and Diagnosis of Learning Disability Module 07: Assessment and Diagnosis of Learning Disability Learning Disability Nursing Module 08: Learning Disability Nursing Different Approaches to therapy Module 09: Different Approaches to therapy Physical Health Issues with Down's Syndrome Module 10: Physical Health Issues with Down's Syndrome Assessment Mock 6 Assessment Mock 2 - Learning Disability Nurse Online Training Course Mental Health Issues and Epilepsy Module 11: Mental Health Issues and Epilepsy Access to Health Care Module 12: Access to Health Care Role of the Learning Disability Nurse Module 13: Role of the Learning Disability Nurse Professional and Legal Issues Module 14: Professional and Legal Issues The Future of Learning Disability Nursing Module 15: The Future of Learning Disability Nursing Assessment Mock 7 Assessment Mock 3 - Learning Disability Nurse Online Training Course Conclusion Conclusion Final Assessment Final Assessment Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Register on the Global Project Management 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 Global Project Management 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 Out Of Studying Global Project Management With Janets 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) Description 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 Method of Assessment To successfully complete the Global Project 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 Global Project Management course. After successfully passing the Global Project Management course exam, you will be able to apply for a CPD-accredited certificate as proof of your Global Project Management qualification. Certification All students who successfully complete the Global Project Management course can instantly download their digital certificate. You can also purchase a hard copy of the Global Project Management course certificate, which will be delivered by post for £9.99. Who Is This Course For The Global Project Management is ideal for those who already work in this sector or are an aspiring professional. This Global Project 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 Global Project Management is open to all students and has no formal entry requirements. To study the Global Project 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. Career Path The Global Project Management 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 Global Project Management and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Module 01: Introduction to Project Management Introduction to Project Management 00:24:00 Module 02: PMBOK and PMI PMBOK and PMI 00:16:00 Module 03: Global Project Management Global Project Management 00:41:00 Module 04: Project Life Cycle Project Life Cycle 00:31:00 Module 05: Time Management Time Management 00:42:00 Module 06: Quality Management Quality Management 00:23:00 Module 07: Effective Planning & Scheduling Effective Planning and Scheduling 00:48:00 Module 08: Human Resource Management Introduction to Human Resources 00:19:00 Module 09: Performance Management Performance Management 00:20:00 Module 10: Talent Management Talent Management 00:20:00 Module 11: Organising Meeting and Conferences Organising Meeting and Conferences 00:30:00 Module 12: Managing Resources Managing Resources 00:20:00 Module 13: Change Management Change Management 00:25:00 Module 14: Business Resilience and Crisis Management Business Resilience and Crisis Management 00:19:00 Module 15: Conflict Management Conflict Management 00:16:00 Module 16: Stress Management Stress Management 00:18:00 Module 17: Communication Skills Communication Skills 00:27:00 Module 18: Procurement & Purchasing Management Procurement _ Purchasing Management 00:23:00 Module 19: Risk Management Risk Management 00:26:00 Mock Exam Mock Exam- Global Project Management 00:20:00 Final Exam Final Exam- Global Project 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.

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Register on the SQL NoSQL Big Data and Hadoop 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 SQL NoSQL Big Data and Hadoop 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 SQL NoSQL Big Data and Hadoop 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 SQL NoSQL Big Data and Hadoop, 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 00:07:00 Building a Data-driven Organization - Introduction 00:04:00 Data Engineering 00:06:00 Learning Environment & Course Material 00:04:00 Movielens Dataset 00:03:00 Section 02: Relational Database Systems Introduction to Relational Databases 00:09:00 SQL 00:05:00 Movielens Relational Model 00:15:00 Movielens Relational Model: Normalization vs Denormalization 00:16:00 MySQL 00:05:00 Movielens in MySQL: Database import 00:06:00 OLTP in RDBMS: CRUD Applications 00:17:00 Indexes 00:16:00 Data Warehousing 00:15:00 Analytical Processing 00:17:00 Transaction Logs 00:06:00 Relational Databases - Wrap Up 00:03:00 Section 03: Database Classification Distributed Databases 00:07:00 CAP Theorem 00:10:00 BASE 00:07:00 Other Classifications 00:07:00 Section 04: Key-Value Store Introduction to KV Stores 00:02:00 Redis 00:04:00 Install Redis 00:07:00 Time Complexity of Algorithm 00:05:00 Data Structures in Redis : Key & String 00:20:00 Data Structures in Redis II : Hash & List 00:18:00 Data structures in Redis III : Set & Sorted Set 00:21:00 Data structures in Redis IV : Geo & HyperLogLog 00:11:00 Data structures in Redis V : Pubsub & Transaction 00:08:00 Modelling Movielens in Redis 00:11:00 Redis Example in Application 00:29:00 KV Stores: Wrap Up 00:02:00 Section 05: Document-Oriented Databases Introduction to Document-Oriented Databases 00:05:00 MongoDB 00:04:00 MongoDB Installation 00:02:00 Movielens in MongoDB 00:13:00 Movielens in MongoDB: Normalization vs Denormalization 00:11:00 Movielens in MongoDB: Implementation 00:10:00 CRUD Operations in MongoDB 00:13:00 Indexes 00:16:00 MongoDB Aggregation Query - MapReduce function 00:09:00 MongoDB Aggregation Query - Aggregation Framework 00:16:00 Demo: MySQL vs MongoDB. Modeling with Spark 00:02:00 Document Stores: Wrap Up 00:03:00 Section 06: Search Engines Introduction to Search Engine Stores 00:05:00 Elasticsearch 00:09:00 Basic Terms Concepts and Description 00:13:00 Movielens in Elastisearch 00:12:00 CRUD in Elasticsearch 00:15:00 Search Queries in Elasticsearch 00:23:00 Aggregation Queries in Elasticsearch 00:23:00 The Elastic Stack (ELK) 00:12:00 Use case: UFO Sighting in ElasticSearch 00:29:00 Search Engines: Wrap Up 00:04:00 Section 07: Wide Column Store Introduction to Columnar databases 00:06:00 HBase 00:07:00 HBase Architecture 00:09:00 HBase Installation 00:09:00 Apache Zookeeper 00:06:00 Movielens Data in HBase 00:17:00 Performing CRUD in HBase 00:24:00 SQL on HBase - Apache Phoenix 00:14:00 SQL on HBase - Apache Phoenix - Movielens 00:10:00 Demo : GeoLife GPS Trajectories 00:02:00 Wide Column Store: Wrap Up 00:04:00 Section 08: Time Series Databases Introduction to Time Series 00:09:00 InfluxDB 00:03:00 InfluxDB Installation 00:07:00 InfluxDB Data Model 00:07:00 Data manipulation in InfluxDB 00:17:00 TICK Stack I 00:12:00 TICK Stack II 00:23:00 Time Series Databases: Wrap Up 00:04:00 Section 09: Graph Databases Introduction to Graph Databases 00:05:00 Modelling in Graph 00:14:00 Modelling Movielens as a Graph 00:10:00 Neo4J 00:04:00 Neo4J installation 00:08:00 Cypher 00:12:00 Cypher II 00:19:00 Movielens in Neo4J: Data Import 00:17:00 Movielens in Neo4J: Spring Application 00:12:00 Data Analysis in Graph Databases 00:05:00 Examples of Graph Algorithms in Neo4J 00:18:00 Graph Databases: Wrap Up 00:07:00 Section 10: Hadoop Platform Introduction to Big Data With Apache Hadoop 00:06:00 Big Data Storage in Hadoop (HDFS) 00:16:00 Big Data Processing : YARN 00:11:00 Installation 00:13:00 Data Processing in Hadoop (MapReduce) 00:14:00 Examples in MapReduce 00:25:00 Data Processing in Hadoop (Pig) 00:12:00 Examples in Pig 00:21:00 Data Processing in Hadoop (Spark) 00:23:00 Examples in Spark 00:23:00 Data Analytics with Apache Spark 00:09:00 Data Compression 00:06:00 Data serialization and storage formats 00:20:00 Hadoop: Wrap Up 00:07:00 Section 11: Big Data SQL Engines Introduction Big Data SQL Engines 00:03:00 Apache Hive 00:10:00 Apache Hive : Demonstration 00:20:00 MPP SQL-on-Hadoop: Introduction 00:03:00 Impala 00:06:00 Impala : Demonstration 00:18:00 PrestoDB 00:13:00 PrestoDB : Demonstration 00:14:00 SQL-on-Hadoop: Wrap Up 00:02:00 Section 12: Distributed Commit Log Data Architectures 00:05:00 Introduction to Distributed Commit Logs 00:07:00 Apache Kafka 00:03:00 Confluent Platform Installation 00:10:00 Data Modeling in Kafka I 00:13:00 Data Modeling in Kafka II 00:15:00 Data Generation for Testing 00:09:00 Use case: Toll fee Collection 00:04:00 Stream processing 00:11:00 Stream Processing II with Stream + Connect APIs 00:19:00 Example: Kafka Streams 00:15:00 KSQL : Streaming Processing in SQL 00:04:00 KSQL: Example 00:14:00 Demonstration: NYC Taxi and Fares 00:01:00 Streaming: Wrap Up 00:02:00 Section 13: Summary Database Polyglot 00:04:00 Extending your knowledge 00:08:00 Data Visualization 00:11:00 Building a Data-driven Organization - Conclusion 00:07:00 Conclusion 00:03:00 Resources Resources - SQL NoSQL Big Data And Hadoop 00:00:00

Register on the The Ultimate SEO Link Building Mega Course 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 The Ultimate SEO Link Building Mega Course 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 The Ultimate SEO Link Building Mega Course 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 The Ultimate SEO Link Building Mega Course 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: Basics SEO Introduction 00:01:00 What Are Backlinks 00:04:00 Less More 00:05:00 Structural Overview 00:05:00 Content & Quality 00:03:00 Quality via Relevance 00:04:00 Anchor Diversity 00:07:00 Vicinity 00:07:00 SEO Beyond Link Building 00:03:00 Module 02: Types of Link You Can Build The 20 Types of Backlinks 00:11:00 Article Links 00:04:00 Optimize an Article 00:20:00 Optimize Readability 00:08:00 Manually Hyperlinking Anchor Text 00:02:00 Spintax & Link Tiers 00:05:00 Blog Commenting Links 00:06:00 Directory Links 00:07:00 Document Sharing Links 00:09:00 Exploit Links 00:05:00 Forum Links 00:06:00 Guest Book Links 00:04:00 Article Guest Posts 00:03:00 Image Comment Links 00:04:00 Indexer Links 00:04:00 Micro Blogging Links 00:04:00 Pingback Links 00:03:00 Referrer Links 00:05:00 RSS Feed Links 00:05:00 Social Bookmark Links 00:06:00 Social Network Links 00:06:00 Trackback Links 00:01:00 URL Shortener Links 00:05:00 Video Links 00:12:00 Web 2.0 Links 00:05:00 Wiki Links 00:05:00 Module 03: Keyword Research Difference between Short and Long Tail Keywords 00:06:00 Keyword Planner 00:05:00 Keyword Planner Sorting 00:10:00 Free Keyword Search Volume Tool 00:01:00 What Are Local Keywords 00:02:00 Research vs Buyer Keywords 00:06:00 Google Auto Complete Search Engine 00:02:00 Long Tail Pro Keyword Research 00:10:00 KW Finder Keyword Research 00:05:00 How to Deliver Keyword Research as a Freelancer 00:10:00 Module 04: On Page SEO Optimization Optimize an Article 00:20:00 Optimize Readability 00:08:00 WordPress Permalink Settings 00:01:00 WordPress Yoast SEO Optimization Setup 00:03:00 Fastest Cache Settings (Exampled in WordPress) 00:05:00 Yoast Real-Time Analysis for Any Site 00:02:00 All in One SEO Plugin 00:03:00 WordPress Cache Speed Test 00:01:00 Real-Time Ranking Case Study 00:08:00 Module 05: Local SEO Local SEO vs Other SEOs 00:08:00 The 4 Pillars of Google Maps Ranking 00:05:00 Sign In to Google+ 00:01:00 Keyword Planner & Sorting Breakdown 00:15:00 Google My Business Registration & Optimization 00:12:00 Descriptions Have Been Phased Out Currently 00:01:00 Google Review Management & Marketing 00:19:00 Google Review Management & Marketing 00:19:00 Additional Business Sites for Reviews 00:12:00 Google My Business 00:06:00 Citation SEO 00:09:00 What Are Citations 00:08:00 An Example Citation Setup 00:03:00 WhiteSpark for Citation Analysis 00:03:00 Outsource Local Citations 00:05:00 The Difference in Citation Websites 00:05:00 Module 06: Image SEO Traditional SEO vs Image SEO 00:05:00 What is EXIF Data and How to Remove It 00:08:00 Image File Size Optimization 00:11:00 JPG vs PNG 00:02:00 GIF Images 00:02:00 Captions for Conversion Optimization 00:06:00 Name and ALT SEO 00:05:00 Create a Sitemap for Images 00:04:00 The Goal of Image SEO 00:04:00 Google Image Off-Page SEO 00:07:00 Module 07: Edu and GOV Link Building Strategy What are EDU Links? 00:06:00 Google Aggregate Ranking Algorithm 00:11:00 Posting Comments on EDU & GOV Blogs 00:10:00 Creating Profiles at EDU & GOV Websites 00:05:00 Scholarship Backlinks from EDU & GOV Websites 00:07:00 Resources for EDU & GOV Websites 00:04:00 Resources II 00:01:00 Student Groups 00:06:00 Module 08: Video SEO (Google) 2 Types of Video SEO 00:08:00 When to Host on YouTube and Why 00:07:00 Self Hosting Video Solution 00:05:00 Video SEO for Google 00:07:00 Keyword Planner for Organic & Video Rankings 00:02:00 Self Hosting means Self Promoting 00:03:00 Module 09: Video SEO (YouTube) YouTube Black vs White 00:05:00 YouTube Auto Suggest for Keyword Research 00:08:00 YouTube Analytics 00:03:00 YouTube Video SEO Optimizations 00:05:00 Find YouTube Tags 00:04:00 VidIQ Extension 00:07:00 Video Sitemap SEO 00:07:00 YouTube Video Layout Blueprint 00:11:00 YouTube Comments 00:02:00 The Secret of Subscribers in SEO 00:03:00 Create a Playlist for Hard SEO Terms 00:05:00 Tubular and Other Tool Comparisons 00:04:00 YTCockpit for Keyword Research & Tracking 00:03:00 YouTube AdSense & Other Monetizations 00:10:00 Module 10: Expired Domain Link Building How to Write the 30X Redirects 00:06:00 Types of 30X Redirects 00:03:00 How to Write the 30X Redirects 00:06:00 Redirection of SEO Timeline 00:02:00 Why You Can Lose Redirect SEO Link Juice 00:05:00 How Long Should I Keep These Redirects 00:02:00 Redirects with Google Penalties 00:04:00 Your First Redirect is Called Canonicalization 00:03:00 Why Secure Your Site 00:02:00 How Much SEO Juice is Passed in Google 00:04:00 How Much SEO Juice is Passed in Google II 00:02:00 3 Methods to Use Expired Domains 00:09:00 DomCop Overview 00:16:00 FreshDrop Overview 00:17:00 Module 11: Software Overview Link Building Tiers 00:08:00 Tier 1 Links & Software Suggestion 00:04:00 Tier 2 Links & Software Suggestion 00:06:00 Tier 3 Links & Software Suggestion 00:09:00 Module 12: Screaming Frog SEO Software Walkthrough Starting Your SEO Audit 00:48:00 SEO Audit Software Walkthrough 01:02:00

Register on the R Programming for Data Science 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 R Programming for Data Science 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 R Programming for Data Science 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 R Programming for Data Science, 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 Unit 01: Data Science Overview Introduction to Data Science 00:01:00 Data Science: Career of the Future 00:04:00 What is Data Science? 00:02:00 Data Science as a Process 00:02:00 Data Science Toolbox 00:03:00 Data Science Process Explained 00:05:00 What's Next? 00:01:00 Unit 02: R and RStudio Engine and coding environment 00:03:00 Installing R and RStudio 00:04:00 RStudio: A quick tour 00:04:00 Unit 03: Introduction to Basics Arithmetic with R 00:03:00 Variable assignment 00:04:00 Basic data types in R 00:03:00 Unit 04: Vectors Creating a vector 00:05:00 Naming a vector 00:04:00 Arithmetic calculations on vectors 00:07:00 Vector selection 00:06:00 Selection by comparison 00:04:00 Unit 05: Matrices What's a Matrix? 00:02:00 Analyzing Matrices 00:03:00 Naming a Matrix 00:05:00 Adding columns and rows to a matrix 00:06:00 Selection of matrix elements 00:03:00 Arithmetic with matrices 00:07:00 Additional Materials 00:00:00 Unit 06: Factors What's a Factor? 00:02:00 Categorical Variables and Factor Levels 00:04:00 Summarizing a Factor 00:01:00 Ordered Factors 00:05:00 Unit 07: Data Frames What's a Data Frame? 00:03:00 Creating Data Frames 00:20:00 Selection of Data Frame elements 00:03:00 Conditional selection 00:03:00 Sorting a Data Frame 00:03:00 Additional Materials 00:00:00 Unit 08: Lists Why would you need lists? 00:01:00 Creating a List 00:06:00 Selecting elements from a list 00:03:00 Adding more data to the list 00:02:00 Additional Materials 00:00:00 Unit 09: Relational Operators Equality 00:03:00 Greater and Less Than 00:03:00 Compare Vectors 00:03:00 Compare Matrices 00:02:00 Additional Materials 00:00:00 Unit 10: Logical Operators AND, OR, NOT Operators 00:04:00 Logical operators with vectors and matrices 00:04:00 Reverse the result: (!) 00:01:00 Relational and Logical Operators together 00:06:00 Additional Materials 00:00:00 Unit 11: Conditional Statements The IF statement 00:04:00 IFELSE 00:03:00 The ELSEIF statement 00:05:00 Full Exercise 00:03:00 Additional Materials 00:00:00 Unit 12: Loops Write a While loop 00:04:00 Looping with more conditions 00:04:00 Break: stop the While Loop 00:04:00 What's a For loop? 00:02:00 Loop over a vector 00:02:00 Loop over a list 00:03:00 Loop over a matrix 00:04:00 For loop with conditionals 00:01:00 Using Next and Break with For loop 00:03:00 Additional Materials 00:00:00 Unit 13: Functions What is a Function? 00:02:00 Arguments matching 00:03:00 Required and Optional Arguments 00:03:00 Nested functions 00:02:00 Writing own functions 00:03:00 Functions with no arguments 00:02:00 Defining default arguments in functions 00:04:00 Function scoping 00:02:00 Control flow in functions 00:03:00 Additional Materials 00:00:00 Unit 14: R Packages Installing R Packages 00:01:00 Loading R Packages 00:04:00 Different ways to load a package 00:02:00 Additional Materials 00:00:00 Unit 15: The Apply Family - lapply What is lapply and when is used? 00:04:00 Use lapply with user-defined functions 00:03:00 lapply and anonymous functions 00:01:00 Use lapply with additional arguments 00:04:00 Additional Materials 00:00:00 Unit 16: The apply Family - sapply & vapply What is sapply? 00:02:00 How to use sapply 00:02:00 sapply with your own function 00:02:00 sapply with a function returning a vector 00:02:00 When can't sapply simplify? 00:02:00 What is vapply and why is it used? 00:04:00 Additional Materials 00:00:00 Unit 17: Useful Functions Mathematical functions 00:05:00 Data Utilities 00:08:00 Additional Materials 00:00:00 Unit 18: Regular Expressions grepl & grep 00:04:00 Metacharacters 00:05:00 sub & gsub 00:02:00 More metacharacters 00:04:00 Additional Materials 00:00:00 Unit 19: Dates and Times Today and Now 00:02:00 Create and format dates 00:06:00 Create and format times 00:03:00 Calculations with Dates 00:03:00 Calculations with Times 00:07:00 Additional Materials 00:00:00 Unit 20: Getting and Cleaning Data Get and set current directory 00:04:00 Get data from the web 00:04:00 Loading flat files 00:03:00 Loading Excel files 00:05:00 Additional Materials 00:00:00 Unit 21: Plotting Data in R Base plotting system 00:03:00 Base plots: Histograms 00:03:00 Base plots: Scatterplots 00:05:00 Base plots: Regression Line 00:03:00 Base plots: Boxplot 00:03:00 Unit 22: Data Manipulation with dplyr Introduction to dplyr package 00:04:00 Using the pipe operator (%>%) 00:02:00 Columns component: select() 00:05:00 Columns component: rename() and rename_with() 00:02:00 Columns component: mutate() 00:02:00 Columns component: relocate() 00:02:00 Rows component: filter() 00:01:00 Rows component: slice() 00:04:00 Rows component: arrange() 00:01:00 Rows component: rowwise() 00:02:00 Grouping of rows: summarise() 00:03:00 Grouping of rows: across() 00:02:00 COVID-19 Analysis Task 00:08:00 Additional Materials 00:00:00

Register on the Adobe Photoshop, Illustrator and Graphic Design Bundle Course 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 certificate as proof of your course completion. The Adobe Photoshop, Illustrator and Graphic Design Bundle Course 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, tablets, 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 Adobe Photoshop, Illustrator and Graphic Design Bundle Course course Receive a digital 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 aspiring professionals. 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 Adobe Photoshop, Illustrator and Graphic Design Bundle Course course, all you 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 Adobe Photoshop Getting Started Introduction 00:15:00 The Photoshop CS3 Screen 00:15:00 File Management Basics 00:30:00 Modifying Your Photoshop Layout 00:30:00 Getting Help 00:30:00 Exploring Photoshop Introduction to the Photoshop Toolbox 01:00:00 Using Tool Presets 00:15:00 Introduction to the Photoshop Palettes 00:30:00 Getting Started 00:15:00 Printing your Image 00:15:00 Images and Color Understanding Digital Images 00:30:00 Image Size and Resolution 01:00:00 Working with Your Canvas 00:30:00 Working with Color 01:00:00 Working with Color Tools 00:30:00 Image Basics Making Selections 01:00:00 Manipulating Selections 01:00:00 Editing with Selections 00:15:00 Adjusting Your Image 00:30:00 Basic Editing Tools 00:15:00 Adobe Illustrator Illustrator Course Outline 00:02:00 The Power of Adobe illustrator 00:01:00 Achieve the best learning experience 00:02:00 Illustrator Fundamentals & Basics Illustrator Documents 00:04:00 Ilustrator workspaces & Properties Panel 00:13:00 Artboards 00:13:00 Illustrator Navigation & zooming 00:09:00 Illustrator Prefrences & Settings 00:12:00 Illustrator Basic geometric shapes 00:16:00 Illustrator Transformation & Rotation (resized) 00:12:00 Illustrator Pathfinder & shape builder tool 00:11:00 Illustrator Selection tools & methods 00:09:00 Grouping elements in illustrator 00:06:00 illustrator Layers & Arranging elements 00:08:00 Illustrator Align & distribute panel 00:04:00 Illustrator Gudies, Grids & Rulers 00:11:00 Excercise (layers, selection, pathfinder, guides, coloring, Artboards) 00:17:00 Colors, Appearance & Graphic Styles in Illustrator Illustrator Stroke Panel 00:09:00 Illsutrator color panels ( color, swatches, themes, guide) 00:19:00 Illustrator Gradiant colors panel 00:13:00 Illustrator Appearane & Graphic style panels 00:09:00 Illustrator effects 00:14:00 Exercise (Appearance, Graphic Style, Gradients, strokes) 00:09:00 Drawing Tools & Techniques Illustrator pencil tool 00:07:00 Illustrator Brush tool 00:04:00 Drawing modes & blob brush tool 00:17:00 Illustrator Pen Tools 00:14:00 Illustrator curvature tool 00:06:00 Pen Tools & curvature tool exercise 00:18:00 Illustrator drawing modifying tools 00:14:00 illustrator Transform & Liquify tools 00:10:00 illustrator puppet warp tool 00:04:00 illustrator envelope distort1 00:07:00 Drawing Symmetric Shapes 00:09:00 Drawing Concentric Symmetrical design 00:11:00 Illustrator Clipping Masks 00:11:00 Illustrator Opacity Masks 00:08:00 illustrator live paint bucket tool 00:09:00 Recolor Artwork 00:09:00 Exercise Complex Drawing 00:09:00 Illustrator Complex Drawing techniques explained 00:15:00 Illustrator Brushes Illustrator Art Brushes 00:14:00 Illustrator Scatter Brush 00:10:00 illustrator Bristle Brush1 00:08:00 Illustrator Calligraphic brush 00:10:00 Illustrator Pattern brush 00:08:00 Illustrator Images brushes 00:09:00 Exercise (Brushes) 00:03:00 Design With images in illustrator handling images in illustrator1 00:16:00 images modifications before tracing 00:06:00 Tracing images in illustrator 00:13:00 Enhancing traced Vectors & coloring hints 00:07:00 Exercise (Images) 00:03:00 Typography in Illustrator Illustrator Typography Anatomy & Character control 00:15:00 illustrator Paragraphes control 00:12:00 Illustrator Chracter & paragraph styles panels 00:11:00 Illustrator Fonts (Filtering, Variable, glyphs, stylistic sets, open type panel, svg) 00:16:00 illustrator Touch type tool 00:02:00 Illustrator type on a path tools 00:07:00 Clipping Typography Masks 00:04:00 Illustrator Typography Art directions & trending visual effects 00:15:00 illustrator type envlope distort 00:04:00 illustrator text wrap- 00:02:00 Exercise (Typography Composition) 00:03:00 Illustrator Advanced Techniques & Tricks Illustrator blend tool 00:10:00 illustrator perspective drawing 00:12:00 67 Illustrator Symbols- 00:12:00 Creating Patterns in Illustrator 00:09:00 illustrator Graphs 00:15:00 illustrator gradiant mesh 00:08:00 Exporting & Finalizing Artwork in illustrator exporting illustrator files & save for web 00:07:00 Preparing & exporting illustrator file for printing 00:07:00 Illustrator Asset Export panel 00:02:00 Creative cloud & libraries 00:07:00 Illustrator export for screens, save for web & Archiving files 00:09:00 Graphic Design Section 01 Week 1: Lesson 1 00:56:00 Week 1: Lesson 2 01:00:00 Week 2: Lesson 1 01:03:00 Week 2 : Lesson 2 01:03:00 Week 3: Lesson 1 01:01:00 Week 3: Lesson 2 01:00:00 Week 4: Lesson 1 00:51:00 Week 4: Lesson 2 01:01:00 Section 02: Week 1: Lesson 1 00:50:00 Week 1: Lesson 2 01:00:00 Week 2: Lesson 1 00:56:00 Week 2: Lesson 2 00:59:00 Week 3: Lesson 1 01:00:00 Week 3: Lesson 2 01:05:00 Week 4: Lesson 1 00:51:00 Week 4: Lesson 2 01:01:00 Section 03: Week 1: Lesson 1 00:44:00 Week 1: Lesson 2 00:58:00 Week 2: Lesson 1 00:54:00 Week 2: Lesson 2 00:47:00 Week 3: Lesson1 00:51:00 Week 3: Lesson 2 00:00:00 Week 4: Lesson 1 00:06:00 Week 4: Lesson 2 01:03:00 Resources Resources - Adobe Photoshop, Illustrator and Graphic Design Bundle Course 00:00:00 Assignment Assignment - Adobe Photoshop Illustrator and Graphic Design Bundle Course 00:00:00

Level 5 Project Management for School Administrator is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Level 5 Project Management for School Administrator and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 8 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language numeracy and IT Desire for entrepreneurship over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

Step into innovation and technology with our groundbreaking course, 'Arduino Interfacing with Sensors in Your Smartphone.' Embark on a journey where creativity meets functionality as you harness the power of Arduino to connect sensors to your smartphone seamlessly. From the thrill of setting up your hardware and software to crafting custom Android apps without coding, this course promises to unlock endless possibilities in mobile technology. Discover the essential components needed to kickstart your Arduino adventure, from hardware requirements to navigating the intricacies of MIT App Inventor. Dive deep into the realms of mobile app development as you explore the Designer and Blocks Editor, laying the foundation for your foray into creating intuitive mobile apps. With our guidance, even those with zero coding experience can craft innovative applications that effortlessly bridge the gap between Arduino and smartphones. Unlock the potential of sensors as you delve into the world of proximity, accelerometer, gyroscope, and magnetometer sensors. Learn how to read analogue sensor data with Arduino and translate it into interactive mobile experiences. Whether you're a budding technologist, a hobbyist seeking to expand your skills, or an entrepreneur with a vision for innovative mobile solutions, this course equips you with the tools and knowledge to turn your ideas into reality. Learning Outcomes: Understand the hardware and software requirements for interfacing Arduino with smartphones. Master MIT App Inventor to design and develop custom Android apps for Arduino projects. Explore various sensors, including proximity, accelerometer, gyroscope, and magnetometer. Learn to create mobile apps without coding, integrating Arduino seamlessly. Gain proficiency in reading analogue sensor data and controlling Arduino remotely via smartphones. Highlights of the Arduino Interfacing with Sensors in Your Smartphone : Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Arduino Interfacing with Sensors in Your Smartphone Course for? Tech enthusiasts eager to explore Arduino and smartphone integration. Hobbyists looking to expand their knowledge in mobile app development. Entrepreneurs seeking to develop innovative mobile solutions. Students interested in learning about sensor interfacing and mobile technology. Engineers and developers aiming to enhance their skills in IoT and mobile connectivity. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Requirements The Arduino Interfacing with Sensors in Your Smartphone is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16. Career Path Mobile App Developer: £25,000 - £70,000 per annum IoT Engineer: £30,000 - £65,000 per annum Software Engineer: £25,000 - £70,000 per annum Electronics Engineer: £25,000 - £55,000 per annum Embedded Systems Developer: £30,000 - £70,000 per annum Technology Consultant: £35,000 - £80,000 per annum Course Curriculum Introduction and Getting Started Introduction 00:03:00 Hardware and Software Requirements Hardware and Software Requirements 00:02:00 Download and Install MIT App Inventor 00:10:00 Download and Install Arduino Pro IDE 00:09:00 Setting Up App Inventor What is App Inventor 00:02:00 Designer and Blocks Editor MIT App Inventor User Interface Explained 00:04:00 First Mobile App to Control Arduino Make your first Mobile App - Blink LED 00:15:00 Code your Arduino - Blink LED 00:05:00 Proximity Sensor Proximity Sensor Mobile App 00:14:00 Light Sensor Mobile App and Arduino Code 00:13:00 Practical Testing 00:03:00 Accelerometer Sensor Accelerometer Sensor Mobile App 00:14:00 Coding Accelerometer Sensor 00:05:00 Gyroscope Sensor Gyroscope Sensor Mobile App and Arduino Code 00:06:00 Magnetometer Sensor Magnetometer Sensor Mobile App and Arduino Code 00:05:00 Make Android App With Zero Experience MIT App Inventor Introduction uuuu 00:03:00 What can you do and system requirements 00:03:00 What is app inventor in More Details 00:02:00 Java Vs App Inventor 00:03:00 Why using App Inventor 00:01:00 App Architecture 00:05:00 Let's Start Making Apps 00:05:00 First App Add Items and Start Programming with Blocks 00:10:00 First App Testing and Running the App using Emulator 00:13:00 Resources you need to visit to Create Better Apps 00:02:00 How to Create a website for your app for free and take credit for it 00:05:00 Android Apps for Arduino with MIT App Inventor without Coding Introduction 00:03:00 App Inventor Overview 00:04:00 An App Challenge 00:01:00 System Requirements 00:01:00 AppInventor Vs Java and C 00:03:00 Why App Inventor Works 00:02:00 App Architecture 00:05:00 Download and Install App Inventor on Your Device 00:09:00 AppInventor UserInterface With Example 00:14:00 Arduino Coding for Led On Off Practical Example 00:09:00 Making an Android App for Led On Off Practical Example 00:12:00 Testing On Off App with Arduino 00:07:00 Make a Login Protected Led Control App 00:14:00 Slider Application to Control Led Brightness 00:15:00 Slider Practical 00:09:00 Practical Connect Bluetooth Module 00:05:00 RGB Led Controller Android Application 00:14:00 RGB LED Arduino Coding 00:12:00 Sensor Readings Arduino Coding 00:09:00 Sensor Readings Android Application 00:17:00 LCD Text Arduino Coding 00:09:00 LCD Text Android Application 00:06:00 Remote Controlled Robot Android Application 00:09:00 Remote Controlled Robot Arduino Coding 00:15:00 Make Money with MIT App Inventor Apps 00:05:00 Reading Analog Sensor with Arduino Introduction 00:02:00 How to read analogue sensors using Arduino 00:02:00 Software Requirements 00:04:00 Wiring Analog Sensors to Arduino 00:09:00 Writing code to collect reading from analogue sensors 00:07:00 Practical Analogue Sensor Testing 00:03:00 Analyse and convert Sensor Reading 00:03:00 Manipulating Sensors Reading 00:06:00 ADC in Arduino Explained 00:14:00