15060 Courses

Learning Outcomes Learn how to input the opening balances Know how to post customer invoices to the sales ledger Learn how to post credit notes to the sales ledger Know how to record the receipts of the customers Understand wages journal posting Learn how to create month-end reports Description You should keep in mind that as long as you want to know how to manage the essential bookkeeping tasks you'll be fine, but taking this Xero Accounting and Bookkeeping course will take your skills to a whole new level. Study this online course either part-time or full time, whichever suits you the best. The comprehensive course aimed at explaining to you every feature of the most preferred online accounting software worldwide, Xero in an easy-to-understand method. In the course, you'll initially learn how to set up a Xero system from the start to the end and grasp how to enter opening balances, post customer invoices, reconcile the bank and the credit card, prepare a VAT return, the manage of payroll function, credit notes and much more. To sum up, this extensive course will be ideal for you to become an efficient bookkeeper. Through the excellently explained modules, you will learn what accounting is and how it works. Furthermore, you will get to understand the fundamental accounting concepts, and their rules and equations. While progressing with the study of accounting you will get to learn about more advanced topics such as - four statements, depreciation policy, fixed operational asset, inventory accounting, revenue accounting and their control process. These skills in accounting will enhance your ability to work and advance your career in the accounting sector. In addition, you will get a CPD- certificate of achievement right after completing this course. Which will add extra value to your resume and grab the attention of employers. So, hurry up and start your learning journey. Certificate of Achievement 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.  Method of Assessment After completing this course, you will be provided with some assessment questions. To pass that assessment, you need to score at least 60%. Our experts will check your assessment and give you feedback accordingly. Career path After completing this course, you will be able to pursue your career in the following sectors: Accountant Financial Accounting Manager Bookkeeper Accounting Clerk Finance Administrator Course Content Introduction Introduction 00:02:00 Getting Started Introduction - Getting Started 00:01:00 Signing up to Xero 00:04:00 Quick Tour of Xero 00:12:00 Initial Xero Settings 00:13:00 Chart of Accounts 00:14:00 Adding a Bank Account 00:08:00 Demo Company 00:04:00 Tracking Categories 00:07:00 Contacts 00:12:00 Invoices and Sales Introduction - Invoices and Sales 00:01:00 Sales Screens 00:04:00 Invoice Settings 00:13:00 Creating an Invoice 00:17:00 Repeating Invoices 00:07:00 Credit Notes 00:10:00 Quotes Settings 00:03:00 Creating Quotes 00:07:00 Other Invoicing Tasks 00:03:00 Sending Statements 00:03:00 Sales Reporting 00:05:00 Bills and Purchases Introduction - Bills and Purchases 00:01:00 Purchases Screens 00:04:00 Bill Settings 00:02:00 Creating a Bill 00:13:00 Repeating Bills 00:05:00 Credit Notes 00:10:00 Purchase Order Settings 00:02:00 Purchase Orders 00:08:00 Batch Payments 00:12:00 Other Billing Tasks 00:02:00 Sending Remittances 00:03:00 Purchases Reporting 00:05:00 Bank Accounts Introduction - Bank Accounts 00:01:00 Bank Accounts Screens 00:07:00 Automatic Matching 00:04:00 Reconciling Invoices 00:06:00 Reconciling Bills 00:03:00 Reconciling Spend Money 00:05:00 Reconciling Receive Money 00:04:00 Find and Match 00:04:00 Bank Rules 00:09:00 Cash Coding 00:03:00 Remove and Redo vs Unreconcile 00:04:00 Uploading Bank Transactions 00:07:00 Automatic Bank Feeds 00:06:00 Products and Services Introduction - Products and Services 00:01:00 Products and Services Screen 00:02:00 Adding Services 00:03:00 Adding Untracked Products 00:03:00 Adding Tracked Products 00:07:00 Fixed Assets Introduction - Fixed Assets 00:01:00 Fixed Assets Settings 00:05:00 Adding Assets from Bank Transactions 00:06:00 Adding Assets from Spend Money 00:05:00 Adding Assets from Bills 00:02:00 Depreciation 00:04:00 Payroll Introduction - Payroll 00:01:00 Payroll Settings 00:15:00 Adding Employees 00:18:00 Paying Employees 00:10:00 Payroll Filing 00:04:00 VAT Returns Introduction - VAT Returns 00:01:00 VAT Settings 00:02:00 VAT Returns - Manual Filing 00:06:00 VAT Returns - Digital Filing 00:02:00 Assignment Assignment - Xero Accounting and Bookkeeping Online 00:00:00 Recommended Materials Workbook - Xero Accounting and Bookkeeping Online 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.

Learning Outcomes Understand the core principles of the Thai massage therapy Get a step-by-step guideline on how to perform Thai massage Develop the skills to perform Lomi Lomi massage Familiarise yourself with the essentials of Shiatsu techniques Enhance your knowledge and understanding of the massage sequence Description As a massage therapist, you can earn up to £58,000 per year in the UK. However, to reach that level you must have excellent massage skills. The Thai Massage Therapy course is the ideal place to develop your skills and expertise in Thai massage. This course is designed to provide you with quality training and help you boost your career. In this complete training, you will get introduced to the ins and outs of Thai massage therapy. The course will provide detailed lessons on the process of performing Thai massage. Furthermore, you will be able to develop the core skills required for Lomi Lomi massage. In addition, the course will educate you on the techniques of Shiatsu. You will also get the opportunity to develop a clear understanding of the massage sequence. This course will elevate your knowledge of Thai massage and uplift your resume with a CPD -accredited certificate of achievement. This certificate will increase your employability in the massage industry. Join now! Certificate of Achievement 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.  Method of Assessment At the end of the course, there will be an online MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, you will get the results immediately. Career path This course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Massage Therapist Spa Owner Course Content Thai Massage Introduction Introduction 00:01:00 Therapeutic Environment 00:03:00 Choosing Your Futon 00:02:00 Clothing 00:03:00 Hygiene 00:01:00 Thai Massage Techniques Step By Step Thai Massage-The Beginning Sequence 00:03:00 Leg Sequence 00:14:00 Side Transition 00:01:00 Side Sequence-01 00:08:00 Side Sequence-02 00:09:00 Arm Sequence 00:04:00 Arm Sequence Reversed 00:04:00 Seated Transition 00:01:00 Seated Transition Reversed 00:01:00 Seated Sequence 00:08:00 Lying Prone Sequence 00:12:00 Introduction to Lomi Lomi Massage Introduction 00:03:00 Forearm technique-vital elements to your massage! 00:13:00 The Table-The 4 most Important things about your Table 00:07:00 Creams or oils 00:04:00 The set-up. Do Not do what I did 00:05:00 One factor that makes a HUGE Difference! 00:03:00 It's all in the Timing! 00:04:00 Contraindications to massage, intake forms and more 00:01:00 Why I Don't include these things in my massages 00:04:00 Do no harm 00:01:00 The Perfect Person to Practice your massage on 00:01:00 Why most therapists don't last and what you SHOULD do instead 00:07:00 Practice Makes Perfect 00:02:00 Putting it all together 00:02:00 Lomi Lomi Massage Techniques A close look at using your forearms 00:02:00 The back 00:24:00 Another look at the back sequence 00:14:00 The back of the legs 00:09:00 The back of the legs opposite side 00:09:00 The front of the legs 00:03:00 The front of the legs opposite side 00:03:00 The arms 00:07:00 The arms opposite side 00:07:00 The neck and head 00:06:00 Shiatsu Techniques It's time to learn the techniques 00:01:00 Proper technique is vital 00:04:00 How to apply pressure 00:01:00 Palming techniques 00:02:00 Rocking technique 00:02:00 Using your thumbs 00:01:00 Using your feet 00:07:00 Using your elbows 00:03:00 Stretching 00:02:00 Massage Sequence Prone Let's get started 00:01:00 The back 00:24:00 The buttocks, legs and feet 00:13:00 Massage Sequence Supine Let's get started face up now 00:01:00 The legs 00:12:00 The chest 00:01:00 The arms and hands 00:06:00 The neck and head 00:06:00 Practice Time The whole back of body sequence to music 00:37:00 Now the front 00:24:00 Advanced Techniques Adding advanced techniques 00:18:00 Knees 00:01:00 Stretching techniques 00:04:00 Using your feet 00:07:00 Congratulations 01:01: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.

Youth Work: Youth WorkCourse Online This Youth Work: Youth Work Course comprises a series of easy-to-understand, in-depth modules that will provide you with a thorough understanding of the subject. Industry experts craft this course to enable you to learn quickly and efficiently and at your own pace and convenience. The Youth Work: Youth Work Course begins with the fundamentals and covers all you need to know about organizing youth work and youth engagement events. With the Youth Work Certificate, you will learn about a variety of techniques and concepts that have impacted current youth work practices and the role, skills, and duties of a Youth Worker. This comprehensive Youth Work: Youth Work Course is designed to improve your employability and provide you with all the skills you will need to succeed. Enrol today in our Youth Work Certificate course and start learning! Special Offers of this Youth Work: Youth Work Course This Youth Work: Youth Work Course includes a FREE PDF Certificate. Lifetime access to this Youth Work: Youth Work Course Instant access to this Youth Work: Youth Work Course Get FREE Tutor Support from Monday to Friday in this Youth Work: Youth Work Course Main Course: Level 2 Youth Work Certificate Course Free courses included with Youth Work: Youth Work Course Course 01: Drug and Alcohol Awareness Training Course 02: Mental Health Support Worker Course 03: Level 5 Diploma in Family Support Worker [ Note: Free PDF certificate as soon as completing the Youth Work: Youth Work Course] Youth Work: Youth WorkCourse Online Industry Experts Designed this Youth Work: Youth Work Course into 11 detailed modules. Course curriculum of Level 2 Youth Work Certificate Course Module 01: Overview to Youth Work Module 02: Youth Workers: Who Are They? Module 03: Role and Approaches of Youth Worker Module 04: Ethical Conduct and Principles in Youth Work Module 05: Career as a Youth Worker (Social Work) Module 06: Social Influences on Youth Worker Module 07: The National Youth Agency (NYA) Module 08: The EU on Youth Work Module 09: Mental Health of Youth Worker Module 10: Dealing with Stress Module 11: Youth Justice and Social Work Assessment Method of Youth Work: Youth Work Certificate After completing each module of Youth Work: Youth Work Certificate course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Youth Work: Youth Work Certificate After completing the MCQ/Assignment assessment for this Youth Work: Youth Work Certificate course, you will be entitled to a Certificate of Completion from Training Tale which is completely free to download. Who is this course for? Youth Work: Youth WorkCourse Online This Youth Work: Youth Work Course is perfect for anybody who wants to work in social care with young adults. It involves the following responsibilities: Youth Worker SEND Youth Support Worker Youth Support & Development Worker Youth Mentor Youth Employment Coach Requirements Youth Work: Youth WorkCourse Online Students who intend to enrol in this Youth Work: Youth Work Course must meet the following requirements: Youth Work: Good command of the English language Youth Work: Must be vivacious and self-driven. Youth Work: Basic computer knowledge Youth Work: A minimum of 16 years of age is required. Career path Youth Work: Youth WorkCourse Online Enrol in the Youth Work: Youth Work Course today to learn the skills and knowledge required to work with young people and organize youth activities. Certificates Certificate of completion Digital certificate - Included

Sports First Aid Training Online You will have both practical and theoretical skills at the end of the Sports First Aid: Sports First Aid Course, as well as the ability to take command in a first-aid emergency. You will also have the confidence and knowledge to perform CPR. This Sports First Aid: Sports First Aid Course is incredible of great value and allows you to study at your own pace. Enrol in this Sports First Aid: Sports First Aid Course today and gain the experience, skills, and knowledge you need to advance your professional development. Discover the ultimate Sports First Aid: Sports First Aid course, your gateway to safety on the field. Sports First Aid: Sports First Aid is designed for athletes, coaches, and enthusiasts alike. Learn crucial life-saving skills, injury management, and prevention. Equip yourself with Sports First Aid: Sports First Aid today and ensure a secure sports environment. Why Choose This Sports First Aid: Sports First Aid Course from Us Sports First Aid: Sports First Aid Course developed by industry experts. Free PDF certificate as soon as completing the Sports First Aid: Sports First Aid course. Special Offers of this Sports First Aid: Sports First Aid Course This Sports First Aid: Sports First Aid Course includes a FREE PDF Certificate. Lifetime access to this Sports First Aid: Sports First Aid Course Instant access to this Sports First Aid: Sports First Aid Course Get FREE Tutor Support from Monday to Friday in this Sports First Aid: Sports First Aid Course Other 4 Complimentary Courses that come with our Sports First Aid Bundle Course* Course 01: Paediatric First Aid Course 02: Level 2 Youth Work Certificate Course Course 03: Level 2 Health & Social Care Course 04: Childcare and Nutrition [ Note: Free PDF certificate as soon as completing the Sports First Aid Training Course] Sports First Aid Training Industry Experts Designed this Sports First Aid: Sports First Aid Course into 08 detailed modules. Detailed Course Curriculum Of Sports First Aid Training Module 01: An Overview of Sports First Aid Module 02: Preliminary Analysis Module 03: Importance of Life-Saving Priorities Module 04: First Aid for Frequent Injuries Module 05: First Aid for Severe Injuries Module 06: Injuries Caused by the Environment Module 07: Understanding Medical Emergencies Module 08: Points to Remember Assessment Method of Sports First Aid Training After completing each module of the Sports First Aid: Sports First Aid Training Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Sports First Aid Training After completing the MCQ/Assignment assessment for this Sports First Aid: Sports First Aid Training course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Sports First Aid Training This Sports First Aid Training course is ideal for- Sports Coach Athlete PE Teacher Personal Trainer Gym staff Requirements Sports First Aid Training Students who intend to enrol in this Sports First Aid: Sports First Aid Course must meet the following requirements: Sports First Aid: Good command of the English language Sports First Aid: Must be vivacious and self-driven. Sports First Aid: Basic computer knowledge Sports First Aid: A minimum of 16 years of age is required. Career path Sports First Aid Training This specialized Sports First Aid Training course aims to advance your career goals. Therefore, complete this course and develop your abilities to explore prospects in relevant fields.

Forensic Science: Forensic Science Online Have you ever wondered how forensic investigators manage to solve crimes? Are you willing to uncover the mysteries of criminal behaviour? If so, check out our comprehensive Forensic Science Course as soon as possible! Forensic science includes criminal investigations and the recoverable materials. This forensic science course also includes discussions on fingerprinting, DNA proofing, and the analysis of bodily fluids. In addition, Forensic Science explains forensic toxicology and illicit drugs. Forensic science lessons will cover the UK accreditation procedure in addition to facts about fire. Enrol our forensic science course to provide you the skills and knowledge you need to succeed in this Forensic Science industry! Forensic Science Course Learning Outcomes By the end of the Forensic Science: Forensic Science course, learners will be able to gain in-depth knowledge on: The Forensic Science course will give a brief Introduction to forensic science, crime scene and Recoverable materials. Forensic Science explains fingerprints and examination of body fluids. DNA profiling, Forensic toxicology and drugs of abuse are part of Forensic Science. Fire related information is described in Forensic Science. Forensic science in court. The accreditation of forensic science in the UK. Special Offers of this Forensic Science Course This Forensic Science Course includes a FREE PDF Certificate. Lifetime access to this Forensic Science Course Instant access to this Forensic Science: Forensic Science Course Get FREE Tutor Support from Monday to Friday in this Forensic Science: Forensic Science Course Other courses are included with Forensic Science Course Course 01: Forensic Nursing Course 02: Adult Nursing Training Course 03: Level 2 Safeguarding Children Training Course [ Note: Free PDF certificate as soon as completing the Forensic Science: Forensic Science course ] >> Forensic Science: Forensic Science << Detailed course curriculum Of Forensic Science Industry Experts Designed this Forensic Science course into 10 detailed modules. Industry Experts Designed this Forensic Nursing course into 17 detailed modules. Module 01: Introduction to Forensic Science Module 02: The Crime Scene Module 03: Recoverable Materials Module 04: Fingerprints Module 05: The Examination of Body Fluids Module 06: DNA Profiling Module 07: Forensic Toxicology and Drugs of Abuse Module 08: Fires Module 09: Forensic Science in Court Module 10: The Accreditation of Forensic Science in the UK Assessment Method of Forensic Science After completing each module of the Forensic Science: Forensic Science Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Forensic Science After completing the MCQ/Assignment assessment for this Forensic Science: Forensic Science course, you will be entitled to a Certificate of Completion from Training Tale which is completely free to download. Who is this course for? >> Forensic Science: Forensic Science << The forensic science course should be taken by anyone interested in a career in forensic science degrees. Requirements >> Forensic Science: Forensic Science << Students who intend to enrol in this Forensic Science: Forensic Science course must meet the following requirements: Forensic Science: Good command of the English language Forensic Science: Must be vivacious and self-driven Forensic Science: Basic computer knowledge Forensic Science: A minimum of 16 years of age is required Career path >> Forensic Science: Forensic Science << Upon completing our forensic science course, you can pursue various careers, such as, Forensic Scientist Crime Scene Investigator

Course Overview Microsoft Excel has brought a revolutionary change in the field of data management. It is one of the key skills that every employer looks for in a potential employee. The 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is designed to equip you with adequate expertise in Excel. This course is a golden opportunity to add a highly beneficial skill to your resume and impress your employers. In this 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course, you will receive a wide range of valuable tips to elevate your MS Excel skills. The course will show you the process of adding a link in the formula bar and adding multiple columns and rows within a blink. You will become skilled in quick calculations in the status bar. From the informative modules, you will identify the shortcut keys and learn to navigate between worksheets. The lessons will introduce you to the method of ZIP code format. You will understand how to move cell directions and convert numbers to text.  This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is packed with valuable information about MS Excel. So enroll in the course and become a proficient MS Excel user. Learning Outcomes Learn how to navigate between worksheets using shortcut keys Understand the process of creating a custom autofill list and importing data from webpages Build the skills to hide workbook elements Enrich your understanding of advanced transpose Grasp the techniques of moving cell directions and deleting data Know how to convert text to numbers Who is this course for? This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is for those who want to improve their Excel skills. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path  The 50 MS Excel Tips to Upgrade your Excel Skill to next Level course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Administrative Assistant Data Analyst Accountants Financial Analyst Retail Store Manager Project Manager Business Analyst Unit 01: Introduction Welcome 00:02:00 Unit 02: Excel Productivity Tips -Part 1 Camera Tool 00:05:00 Add Line Break in Formula Bar 00:03:00 Advanced Copy-Paste using Office Clipboard 00:03:00 Navigation between Worksheets using Shortcut Keys 00:01:00 Flash Fill 00:02:00 Add Multiple Rows and Columns Quickly 00:02:00 Delete Blank Rows 00:03:00 Multi Level Row and Column Sorting 00:04:00 Add Sparklines 00:03:00 Paste Special - Transpose 00:03:00 Unit 03: Excel Productivity Tips - Part 2 Snap to Grid 00:03:00 Create Custom Auto fill List 00:06:00 Absolute Cell Reference 00:03:00 Import Data from Web page 00:04:00 Move Cell Direction 00:03:00 Delete Data using Mouse 00:02:00 Status Bar Quick Calculations 00:03:00 Link Text Boxes to Cell 00:04:00 Phone Number and ZIP Code Format 00:04:00 Speaking Cell 00:05:00 Unit 04: Excel Productivity Tips - Part 3 Invisible Text 00:03:00 Worksheet Grouping 00:04:00 Advanced Transpose 00:04:00 XLStart Folder 00:03:00 Use Slicers 00:05:00 Convert Text to Numbers 00:03:00 Hiding Workbook Elements 00:02:00 Useful Shortcut Keys 00:03:00 Sort data from Left to Right 00:03:00 Advanced Filter (Complex) 00:11:00 Unit 05: Excel Productivity Tips - Part 4 Email as PDF 00:02:00 Synchronous Scrolling 00:03:00 Quick Analysis of data within Excel 00:02:00 Fill blank cells with Value 00:03:00 Hidden Chart Source Data 00:03:00 Two more Shortcuts 00:03:00 Add Blank Rows 00:03:00 Custom views in Excel 00:06:00 EMBED Feature 00:04:00 Adding Country code in Mobile Numbers 00:04:00 Unit 05: Excel Productivity Tips - Part 5 Plot an Average Line to a Chart 00:04:00 3D Referencing 00:04:00 Extract Unique Values 00:03:00 Excel Array Formula 00:04:00 Forecast Sheet 00:04:00 Add Spin Controls in Excel 00:05:00 Move Data using Mouse 00:01:00 Add new entry in Auto Correct to use across Office Applications 00:05:00 Find Differences between Two Lists 00:02:00 Find formulas Quickly 00:02:00 Unit: 06 Wrap Up Thank You 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Electrical Engineering - Electrical Machines Complete Training Overview Are you looking to begin your electrical machines career or want to develop more advanced skills in electrical machines? Then this electrical engineering - electrical machines complete online training course will set you up with a solid foundation to become a confident electrical engineer and help you to develop your expertise in electrical machines. This electrical engineering - electrical machines complete online 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 electrical engineering - electrical machines complete online training course will set you up with a solid foundation to become a confident electrical engineer and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a electrical engineer. The electrical engineering - electrical machines complete online 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 electrical engineer. This comprehensive electrical engineering - electrical machines complete online training course is the perfect way to kickstart your career in the field of electrical machines. This electrical engineering - electrical machines complete online 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 electrical engineer or want to learn more skills on electrical machines but unsure of where to start, then this electrical engineering - electrical machines complete online training course will set you up with a solid foundation to become a confident electrical engineer 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 electrical engineering - electrical machines complete online 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 electrical engineering - electrical machines complete online 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 electrical machines. Entry Requirements There are no academic entry requirements for this electrical engineering - electrical machines complete online 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. Career path This electrical engineering - electrical machines complete online training 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 Course Content Introduction to Electric Machines Types of Electric Machines and Principle of Electricity Generation DC Machines Importance and Construction of DC Machines Armature Winding and EMF Equation Solved Example 1 Solved Example 2 Solved Example 3 Solved Example 4 Shunt and Series DC Machines Solved Example 1 on Separately Excited DC Machine Solved Example 2 on Separately Excited DC Machine Solved Example 3 on Shunt Generator Solved Example 4 on Shunt Generator Solved Example 5 on Series DC Generator Types and Applications of Compound DC Motors Torque-Speed Characteristics and Speed Control of Separately Excited DC Motor Torque-Speed Characteristics of Series DC Motor Solved Example 1 on Speed Control Solved Example 2 on Speed Control Starting of DC Machine Armature Reaction in DC Machines Losses in DC Machines Construction of Transformer Magnetic Circuit Inside Transformer Windings of Transformer Why are Windings Made of Copper Why are Windings Made of Copper Insulating Material and Transformer Oil Conservator of Transformer Breather of Transformer Bushings of Transformer Tap Changer of Transformer Cooling Tubes of Transformer Buchholz Relay of Transformer Explosion Vent Methods of Cooling Types of Transformers Power Transformer and Distribution Transformer Single Phase Core Type Transformer Single Phase Shell Type Transformer Three Phase Core Type Transformer Three Phase Shell Type Transformer Comparison between Shell and Core CSA Comparison between Shell and Core Type Notes Video Explaining The Components in 3D and Real Life Fundamentals of Magnetic Circuits for Electrical Engineering Magnetic Circuit and Important Definitions Linear and Non Linear Materials Flux Linkage and Reluctance Analogy between Electric and Magnetic Circuits Fringing Effect Example 1 Magnetic Circuits Example 2 Example 3 Application on Magnetic Circuit - Transformers Theoretical Part on Transformers Introduction to Transformers Construction of Transformer Theory of Operation Ideal Transformer Non Ideal Transformer Effect of Loading on Transformer Transformer Regulation Transformer Losses Transformer Efficiency Transformer Rating Question 1 Question 2 Question 3 Example 1 Voltage Relation of Transformer Transformer Exact Equivalent Circuit Concept of Refereeing Approximate Equivalent Circuit Synchronous Machines Construction and Principle of Operation of Synchronous Generator rinciple of Operation of Synchronous Motor Equivalent Circuit and Phasor Diagram of Non Salient Synchronous Machine Solved Example 1 on Non Salient Machine Solved Example 2 on Non Salient Machine Solved Example 3 on Non Salient Machine Solved Example 4 on Non Salient Machine lved Example 5 on Non Salient Machine Solved Example 6 on Non Salient Machine Equivalent Circuit and Phasor Diagram of Salient Synchronous Machine Solved Example 1 on Salient Machine Solved Example 2 on Salient Machine Solved Example 3 on Salient Machine Parallel Operation of Two Generators Synchronization of Machine with Grid Induction Machines Construction and Theory of Operation of Induction Machines Equivalent Circuit and Power Flow in Induction Motor Torque-Speed Characteristics of Induction Motor Solved Example 1 on Induction Motor Solved Example 2 on Induction Motor Solved Example 3 on Induction Motor Solved Example 4 on Induction Motor Solved Example 5 on Induction Motor Methods of Speed Control of Induction Motor Methods of Starting of Induction Motor Solved Example on Motor Starter Self Excited Induction Generator 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. 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.  

Course Overview If you want to take exotic pictures of your surroundings at night, night photography is the perfect skill for you. Learn night photography from the Night Photography: Capture Stunning Photos at Night course with us and take stunning pictures at night. From the Night Photography: Capture Stunning Photos at Night course, you will learn night photography camera basics, field basics, image editing, camera setup, advanced techniques and many other topics that will help you enhance your photography skill. This course will help you to watch the same surroundings from a different perspective. This course is ideal for photographers, photo editors, videographers, designers, illustrators or anyone who wants to capture the beauty of the night with a camera. Learning Outcomes Learn about camera anatomy and camera basics Understand the difference between night photography and other types of photography Be able to edit and correct photo Learn advanced techniques of editing Who is this course for? This online course is for anyone who wants to learn more about photography and capture beautiful night scenery on camera. This course will help learners from any level to learn night photography. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere, anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Night Photography: Capture Stunning Photos at Night is a useful qualification to possess and would be beneficial for any related profession or industry such as: Photography Photo Editing Videography Designing Illustrating Unit 1: Introduction to Night Photography Module 1: Introduction to the Course 00:02:00 Module 2: What is Night Photography 00:01:00 Unit 2: Photography Equipment Module 1: Introduction 00:01:00 Module 2: Camera 00:02:00 Module 3: Sensor Size 00:03:00 Module 4: Lenses 00:03:00 Module 5: Prime VS Zoom 00:02:00 Module 6: Tripods 00:02:00 Module 7: Filters 00:02:00 Module 8: Accessories 00:05:00 Unit 3: Basics Module 1: Introduction 00:01:00 Module 2: What is ISO 00:01:00 Module 3: ISO Practical 00:02:00 Module 4: What is Aperture 00:02:00 Module 5: What is Shutter Speed 00:03:00 Module 6: Shutter Speed Practical 00:04:00 Module 7: Exposure Triangle 00:03:00 Unit 4: Advanced Basics Module 1: Introduction 00:01:00 Module 2: Histogram 00:03:00 Module 3: RAW vs JPEG 00:03:00 Module 4: What is RAW 00:02:00 Module 5: Dynamic Range 00:03:00 Module 6: Kelvin Temp 00:03:00 Unit 5: How to Plan Module 1: Introduction 00:02:00 Module 2: Light Pollution 00:03:00 Module 3: Weather App 00:03:00 Module 4: PhotoPills 00:06:00 Module 5: Feature of PhotoPills 00:07:00 Module 6: PRO Tip for Night Sky Planning 00:03:00 Unit 6: Capturing Night Photos Module 1: How to Focus 00:07:00 Module 2: Base Settings 00:02:00 Module 3: Practical Base Setting 00:02:00 Module 4: Underexposed 00:02:00 Module 5: Overexposed Part 1 00:02:00 Module 6: Overexposed Part 2 00:03:00 Module 7: Pro Tip to Find Composition Fast 00:02:00 Unit 7: Composition Module 1: Introduction 00:02:00 Module 2: Foreground 00:03:00 Module 3: Scale 00:03:00 Module 4: Reflection 00:03:00 Module 5: Low Light Cityscape Photography 00:04:00 Module 6: Creating Simple Light Trails 00:03:00 Unit 8: Advanced Capturing Module 1: Light Pollution Filter 00:02:00 Module 2: Exposure Blending 00:03:00 Module 3: Artificial Light 00:03:00 Module 4: Focus Stacking 00:04:00 Module 5: Time Lapse 00:05:00 Module 6: Star Trails 00:03:00 Unit 9: Editing Module 1: Introduction 00:02:00 Module 2: Basic Overview 00:19:00 Module 3: Global VS Local Adjustment 00:09:00 Module 4: Editing Night Photography Images 00:22:00 Module 5: Proper Artificial Light 00:15:00 Module 6: Blending Multiple Exposure 00:13:00 Module 7: Focus Stack- Photoshop 00:07:00 Module 8: Focus Stack- Helicon 00:06:00 Module 9: Time Lapse 00:06:00 Module 10: Star Trails 00:11:00 Module 11: Adobe Lightroom Pro Tips 00:14:00 Resources Resources - Night Photography: Capture Stunning Photos at Night 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Nowadays, SQL Developers are in-demand and becoming a SQL developer can be a rewarding and fulfilling profession. This SQL Masterclass: SQL for Data Analytic is intended for absolute beginners that concentrate on giving the appropriate knowledge of Microsoft SQL Server and help to acquire the skills and abilities to become an SQL Server developer as well as offer many job opportunities in the competitive job market. In this course, you will learn how to create databases, tables, design databases and tables. You will also learn to create flat file database, confidently use SSMS Tool as well as write basic T-SQL Queries. In addition to that, learn to create constraints and views in the most dynamic way possible. Enrol right now and start exploring SQL, the most popular relational database management system. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. SQL for Data Analytic - Beginner Level Module: 01 Introduction FREE 00:16:00 Tools for Creating Views 00:11:00 Examples 00:21:00 Updating Data Using a View 00:13:00 Columns and Indexed Views 00:18:00 Module: 02 Introduction Stored Procedures 00:18:00 Creating Stored Procedures 00:19:00 Returning Data 00:14:00 Module: 03 Testing and Debugging 00:17:00 Execute with Result Sets 00:11:00 Creating Triggers 00:26:00 Module: 04 Overview and Scalar Functions 00:20:00 Inline Table Valued Functions 00:11:00 Multi Statement 00:16:00 Views and Stored Procedures 00:18:00 Module: 05 Transaction Concepts 00:30:00 Applications and Transactions 00:13:00 Creating Explicit Transactions 00:29:00 Structured Error Handling 00:25:00 Module: 06 Introduction to SQL CLR 00:08:00 Writing SQL CLR Code 00:24:00 Using SQL CLR Code 00:22:00 SQL CLR Code 00:13:00 SQL CLR Security 00:20:00 SQL for Data Analytic - Intermediate Level Module: 07 Topic A Aggregates FREE 00:27:00 Topic B User Defined Types 00:17:00 Topic C Table and Functions 00:10:00 Topic D Managing Code Modules 00:08:00 Module: 08 Topic A Introduction Data Tools 00:19:00 Topic B Connected Database Development 00:20:00 Topic C Updating a Connected Database 00:16:00 Module: 09 Topic A Creating New Objects with TSQL 00:12:00 Topic B Comparing Database Schemas 00:10:00 Topic C Offline Database Development 00:13:00 Topic D Database Project Settings 00:18:00 Module: 10 Topic A Using APPLY 00:15:00 Topic B MERGE Statement 00:23:00 Topic C Creating Recursive Queries 00:08:00 Topic D Grouping Sets 00:12:00 Module: 11 Topic A ROLLUP and CUBE Operators 00:12:00 Topic B Creating Pivot Queries 00:14:00 Topic C Executing Dynamic SQL 00:28:00 Module: 12 Topic A Complex Query Execution 00:26:00 Topic B Using Execution Plans 00:16:00 Topic C Execution Plan Operators 00:12:00 Topic D Common Join Operators 00:16:00 Module: 13 Topic A Hierarchy ID Data Type 00:12:00 Topic B Exploring a Hierarchy 00:09:00 Topic C Sparse Columns 00:16:00 Topic D Column Sets 00:12:00 Module: 14 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 15 Topic A Introduction to Spatial Data 00:13:00 Topic B Spatial Data in SQL Server 00:23:00 Topic C Manipulating Spatial Shapes 00:10:00 Topic D Interactions Between Objects 00:09:00 SQL for Data Analytic - Advanced Level Module: 16 Topic A Partitioning FREE 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 17 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 18 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 19 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00

Description: Microsoft Office is a group of different applications with different specific main functions that offer flexible and powerful tasks management. These applications can help you to organise, manage, and present information. Since the products of Microsoft Office are considered as the gold standard for businesses across the globe, knowing the functions of applications is a benefit for you. Through this course, you will learn all the essential skills, knowledge, and information about Microsoft Office 2007. You will know how to make use of all the programs and features of Microsoft Office. Who is the course for? New staff or workers who want to learn about the Microsoft Office 2007 Programs People who have an interest in all the features of the Microsoft Office 2007 Applications Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Office 2007 Essentials course is a useful qualification to possess and would be beneficial for any type of professions or career from any type of industry you are in, such as: Administrative Assistant Businessman Executive Assistant Office Administrator Office Manager Personal Assistant Secretary Senior Manager Staff. Microsoft Word 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Word 01:00:00 Module Three - Working with Documents 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Advanced Formatting Tasks 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Adding the Finishing Touches 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Word 2007 for Beginners 00:00:00 Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 for Beginners 00:00:00 Microsoft PowerPoint 2007 For Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing PowerPoint 01:00:00 Module Three - Working with Presentations 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Formatting Text 01:00:00 Module Six - Formatting Paragraphs 01:00:00 Module Seven - Working with Text 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Customizing Slide Elements 01:00:00 Module Ten - Setting up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft PowerPoint 2007 for Beginners 00:00:00 Microsoft Access 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening Access 01:00:00 Module Three - Using the Access Interface 01:00:00 Module Four - Working with Database Objects 01:00:00 Module Five - Creating Tables 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Creating Forms 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Creating Reports 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Managing Your Database 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activites- Microsoft Access 2007 for Beginners 00:00:00 Microsoft Outlook 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Outlook 01:00:00 Module Three - Working with E-mail 01:00:00 Module Four - Creating a New E-mail 01:00:00 Module Five - Managing E-mail 01:00:00 Module Six - Managing Junk Mail 01:00:00 Module Seven - Outlook's Organization Tools 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contacts 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Outlook 2007 for Beginners 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00