6013 Power courses delivered On Demand

Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. 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 Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:04:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:04:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:07:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excel's IF() Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 INDEX() Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:14:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Lopps For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Course Highlights: This qualification is equivalent to GCSE grade C or 4 Take the Exam from Home – Guaranteed Fast Track Results Exam Booking within 2 Working Days of Enrolment Remote Exam Online or Paper based both option available Course Duration: 55 hours Unlimited Access to Course Materials Get Free Mock Tests & Free Past Papers Extra 25% Time for people with Learning Difficulties NCFE, Pearson Edexcel & Open Awards all are OFQUAL-regulated and nationally recognised Exam slots are available 24*7 from Monday to Sunday. If you are in a rush and would like to book your exam sooner, then you can book your remote online exam within 3 working days for Open Awards, 2 working days of enrolment for NCFE and within 7 working days for Pearson Edexcel. Please note the exam price advertised on the website for the Open Awards remote invigilation exam is applicable for weekdays (Monday to Friday between 9 am to 5 pm). If you would like to book the Open Awards remote invigilation exam at the weekend then there is an additional £25+Vat applicable. Why is this course right for you? Our expert designed Functional Skills English Level 1 Course has smart learning options that provide the necessary knowledge and skills to excel in Functional Skills English. Whether you want to improve your literacy skills, our course is tailored to meet your specific needs and help you achieve your academic and career goals from the comfort of your home. You also get the opportunity to book Live 1:1 tutor support via Zoom. With interactive lessons, FREE mock test, personalised feedback and remote exams, our English Level 1 Course ensures a comprehensive and engaging learning experience. EXAM Booking & Results Details You can decide the exam date and place according to your convenience. Awarding Body Paper-Based Exam in Centre On-Screen Exam in Centre Remote Online Exam – From Home Results Edexcel Book within 15 days Book within 24 Hours Book within 7 working days Get results in 20 working days NCFE Book within 10 working days Book within 24 Hours Book within 2 working days Get results in only 7 days Open Awards N/A N/A Book within 2 working days Get results in only 16 working days TQUK Book within 7 working days N/A Book within 2 working days Get results in only 6 working days *Offline examinations will be held at our Swindon and London centres. Please contact us for more information. The new assessment and result dates by NCFE is- Delivery mode: Paper-based Assessment date to and from: 17/06/2024 – 19/07/2024 Results release: 26/07/2024 Delivery mode: On-screen and RI Assessment date to and from: 20/05/2024 – 27/06/2024 Results release: 04/07/2024 (Note that this only applies to the mentioned exam type and if you book the exam during the dates mentioned above. Also, this will not affect the schedule of the other exam types and results.) Difference between NCFE and Pearson Edexcel and Open Awards NCFE, Pearson Edexcel and Open Awards are OFQUAL-regulated and nationally recognised; however, the only difference lies in the exam booking and result turn-around time. You can book your remote online exam within 2 working days of enrolment for NCFE, within 7 working days for Pearson Edexcel and within 3 working days for Open Awards. You can get your NCFE results in 7 days, your Edexcel results in 20 working days and your Open Awards results within 16 to 32 working days. All of the awarding bodies are accepted by universities and apprenticeships. This distinction allows learners to choose the awarding body that aligns best with their educational and career goals. Course Curriculum Unit 1: Speaking and Listening The speaking and listening section entails comprehensive learning and activities, including presenting and narrating skills, argument presentation techniques, and more. Unit 2: Reading Learn to read a text with the help of scanning, skimming, and detailed reading, and also, learn how to find organisational features' purpose from the text. Unit 3: Writing The writing part will cover English grammar, including punctuation, spelling, syntax, etc. enabling you to avoid all the writing errors and mistakes. How This Course Will Work? This Level 1 Functional Skills English course will help you build a solid foundation in mathematics. Throughout the course, it will provide you with various learning materials and activities to enhance your understanding of these subjects. Initial Assessment: To identify the current level of a student's abilities and recommend the appropriate course to enrol in upon completion. Diagnostic Assessment: Identifies skill gaps and produces an individual learning plan Learning Resources: Comprehensive video tutorials, practice quizzes & topic-based tests Progress Tracker: To record your progress in the course Free Mock Test: Access our free mock test facility for professional feedback and to prepare for the final exam. Entry Requirement This level 1 English qualification is available to all students of all academic backgrounds; no experience or previous qualifications are required. However, you will require a laptop/desktop computer (ChromeBook are not allowed for the exam) and a good internet connection. Exam Structure The Pearson Edexcel, NCFE and Open Awards Functional Skills Qualification in English at Level 2 consist of 3 exams, these are Reading, Writing and Speaking, Listening and Communicating. Speaking, Listening and Communicating (SLC) Exam Awarding Body Duration Number of Marks Pearson Edexcel / NCFE / Open Awards Up to 25 minutes Pass/Fail SLS Exam Pearson Edexcel / NCFE: Speaking, listening and communicating are assessed through one 5-minute presentation and linked question and answer session in groups of three to five and one 15-minute formal discussion together in groups of three to five learners. This exam will be conducted via Microsoft Teams.  SLS Exam Open Awards: Speaking, listening and communicating are assessed through one 10-minute presentation and linked question and answer session in groups of three to four and one 10-minute formal discussion together in groups of three to five learners. This exam will be conducted via Microsoft Teams.  Reading Exam Awarding Body Duration Number of Marks Pass Mark Pearson Edexcel 75 minutes 35 65% NCFE 60 minutes 30 53% – 57% Open Awards 60 minutes 30 18 out of 30 Reading is assessed through a test consisting of multiple-choice, short open-response and medium open-response questions.  Writing Exam Awarding Body Duration Number of Marks Pass Mark Pearson Edexcel 60 minutes 36 63% NCFE 60 minutes 44 57% – 61% Open Awards 60 minutes 60 36 out of 60. Reading/Writing Exam Pass Mark: Learners are required to achieve an overall percentage of marks mentioned in the above table to pass the English reading exam. However, the awarding process will determine specifically where the pass mark sits for each assessment version. Therefore, the pass mark may vary between assessments.  Recognised Accreditation This Functional Skills English Level 1 has been independently accredited by Pearson Edexcel, NCFE and Open Awards also regulated by Ofqual. The Office of Qualifications and Examinations Regulation (Ofqual) is responsible for regulating qualifications, assessments, and examinations in England. Pearson Edexcel is the most prestigious awarding body, for an academic and vocational qualifications. Pearson Edexcel qualifications are regulated by Ofqual and recognised by universities and employers across the world.  NCFE is a charity and awarding organisation that provides qualifications in England, Wales, and Northern Ireland. It is regulated by Ofqual in England and recognised in Wales and Northern Ireland.  Open Awards is an awarding organisation that offers a wide range of qualifications across various sectors, including education, health and social care, and business. Their qualifications are regulated by Ofqual and are designed to meet the needs of learners and employers. Open Awards also works closely with educational institutions and employers to ensure their qualifications are relevant and up-to-date.   FAQs What are functional skills English level course 1 equivalent to? Level 1 English equals a GCSE Grade 1 to 3 or D-G. This means that achieving a Level 1 qualification in English demonstrates a basic understanding and practical application of the English language, including reading, writing, and communication skills. What is the Advanced course of Functional Skills English Level 1? The advanced course of functional skills English level 1 is the level 2 English course. In the advanced course, you will learn English in depth. Do Universities Accept Functional Skills Level 1? Some universities may approve the functional skills English level 1 as an alternative to GCSEs or other qualifications, it ultimately depends on the specific university and its admissions policies. Therefore, it's best to check with the university's requirements. However, most universities usually require a higher level of English proficiency, like Functional Skills English level 2 GCSE Grade C/4 in English. How long are these Functional Skills Exams? StudyPlex's Pearson Edexcel and NCFE Qualifications in English Level 1 consist of internally marked speaking, listening, and communicating assessments and externally marked reading and writing assessments. The speaking and listening assessments include a 5-minute presentation and a 15-minute formal discussion in groups of three to five learners. The reading assessment lasts 75 minutes and consists of multiple-choice, short open-response, and medium open-response questions. The writing assessment, which includes tasks assessing spelling, punctuation, and grammar, lasts 60 minutes. Is English Functional Skills Level 1 difficult? Functional English skills Level 1 is generally less complicated than GCSE English. The exam focuses on basic language skills and communication, emphasizing practical, real-world applications. The exam is designed to be accessible to many learners, including those who may have struggled with traditional classroom-based learning. However, it still requires a good understanding and proficiency in English, so preparing and practicing in advance is essential. What is the Difference between Functional Skills and GCSE? A Functional skills course develops for the one who wants to learn Math, English, and ICT for individual achievement in the daily workplace. On the other hand, GCSE focuses on theories and tests your academic ability. How will I access the functional skills Maths level 1 course after payment? A confirmation email will be sent to your registered email after payment. Hereafter anytime, you can start your learning journey with StudyPlex. What is an Accredited course? The professional body approves the procedures if any e-learning platform claims its courses are accredited. What is the benefit of doing an accredited course? You will only realize the benefit of having an accredited certificate once you face the corporate world. As employees, job places, and more value the accredited certificate, you must own this certificate by doing the course with us. What are the system requirements for remote exam? For Pearson Edexcel and NCFE: To sit your assessment, you’ll need: A laptop/desktop with webcam and microphone; you can’t sit the assessment on a tablet or smartphone a good Wi-Fi connection – recommended minimum 1Mbit/s Upload, minimum 10Mbit/s Download. You MUST use google chrome browser for the exam, as this is recommended by the awarding body. A smartphone or tablet (Apple iOS 8.0 / Android 4.1 or higher) - this will be used to record you taking the assessment. A suitable environment - quiet room with no distractions The link for the assessment sent to your email; remember to check your spam/junk folder. You must activate Airplane mode on your smartphone however you need to be connected to Wi-Fi, so turn on Airplane mode then reactivate your Wi-Fi. Please familiarise yourself with the potential violations as these can potentially lead to the assessment being voided. Ensure ALL equipment is plugged in (including phone for the recording of sessions). Loss of power at any point could lead to the assessment being voided. You must brief other members of your household/workplace that you’re sitting an assessment, and they must not enter the room at any point. There is a 24-hour live chat function within the assessment software for technical support should you need it at any time. For Open Awards: In order to take your exam, you need to have the following equipment: A good quality laptop or PC with a minimum screen size of approx. 14” and minimum resolution of 1024 x 768. A stable internet connection with at least 3mbps. An integrated (i.e., fixed) webcam on your PC/ laptop or a portable webcam. If using a PC/ laptop with an integrated webcam, a reflective surface (e.g., a mirror) must be available. This will be used to show the invigilator the space immediately surrounding your screen and keyboard. A basic (non-scientific) calculator for maths assessments. You will have access to an on-screen calculator but may feel more comfortable using a separate calculator. Please note that all workings need to be added to the assessment platform if you use a separate calculator so that your workings can be marked. Plain paper. You will need to show this to your invigilator at the beginning of the exam to assure them that you do not have access to notes. A dictionary (where allowed). Supported Browsers Chrome: 34.0.1847 or above Microsoft Edge: Version 88.0.705.81 or newer Firefox: 31.0 or above Safari: 6.2 or above Safe Exam Browser 2.0.2 or above Please note: Chromebooks are not compatible with the Safe Exam Browser Browser settings Popups must be allowed. Guidance on how to do this below: Chrome Edge Firefox Safari

Highlights of the Course Course Type: Online Learning Duration: 1 hour 16 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft Word Understand the core competencies and principles of Microsoft Word Explore the various areas of Microsoft Word Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Understanding Ohm's Law in Parallel Circuits Master the skills you need to propel your career forward in parallel circuits. This course will equip you with the essential knowledge and skillset that will make you a confident electrical engineer and take your career to the next level. This comprehensive understanding ohm's law in parallel circuits course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this ohm's law made parallel circuits course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective parallel circuits practice and equip you with the essential skills, confidence and competence to assist you in the parallel circuits industry. You'll gain a solid understanding of the core competencies required to drive a successful career in parallel circuits. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for electrical engineer or for people who are aspiring to specialise in parallel circuits. Enrol in this understanding ohm's law in parallel circuits course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive understanding ohm's law in parallel circuits course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this parallel circuits can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This understanding ohm's law in parallel circuits course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This understanding ohm's law in parallel circuits 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 could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This understanding ohm's law in parallel circuits course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation 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. Course Curriculum Parallel Circuit Rules Parallel Circuit Rules 00:05:00 Parallel Circuit Rule 1 Explained 00:03:00 Parallel Circuit Rule 2 Explained 00:02:00 Parallel Circuit Rule 3 Explained 00:03:00 Parallel Circuit Rule 4 Explained 00:02:00 Parallel Resistance Formula and Calculations Two Formulas for Parallel Resistance 00:02:00 Calculating Total Resistance for More than Two Branches 00:03:00 Example 1 - Parallel Resistance Calculations 00:03:00 Example Two - Parallel Resistance Calculations 00:03:00 Formula Two - The Easy Way with a Calculator 00:04:00 Formula Two - The Easy Way with a Calculator 00:04:00 Example Three - Three Resistors in Parallel 00:04:00 Example Four - Try One on Your Own 00:03:00 Let's Get a Little Crazy 00:05:00 Using Parallel Resistance Shortcuts 00:04:00 Additional Practice Examples 00:02:00 Answers to the Additional Practice Examples 00:06:00 Ohm's Law Review Ohm's Law Review 00:01:00 Ohm's Law Formulas 00:03:00 Power Formula 00:01:00 Parallel Math Example Parallel Example 1 00:05:00 Parallel Example 2 00:04:00 Parallel Example 3 - Test Your Skills 00:01:00 Parallel Example 3 - Answers 00:05:00 Demo - Three Bulbs in Parallel 00:02:00 Bonus Lecture 00:02:00 Supplementary Resources Supplementary Resources - Ohm's Law Made Easy for Parallel Circuits 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Discover the ultimate guide to enhancing your efficiency and achieving your goals with proven productivity habits. Learn practical strategies, tips, and techniques to boost focus, organization, and time management for maximum effectiveness in work and life.

Empower yourself with essential first aid skills! Learn how to handle breathing problems, administer CPR, and effectively manage fractures in the workplace. Our comprehensive First Aid at Work course equips you with the knowledge and confidence to respond promptly and effectively in emergency situations. Enroll now to be a workplace hero and make a difference when it matters most.

Overview In the design of a bridge to the flight path of an aeroplane, mathematical principles are at play. Now, consider the power and promise held by those who master its intricacies. Welcome to our Math Fundamentals course. Math Fundamentals aligns with this pressing global requirement, laying the bedrock for understanding core concepts that shape academia and real-world applications. Initiating with a comprehensive introduction, this course dives deep into integers, exponents, fractions, and decimals and culminates in applied mathematics subjects like profit and loss, discount, and taxation.  With mathematical fluency increasingly becoming a non-negotiable asset, immersing oneself in Math Fundamentals stands not just as an educational prerequisite but as a vital life skill. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Math Fundamentals. It is available to all students, of all academic backgrounds. Requirements Our Math Fundamentals is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 14 sections • 67 lectures • 07:39:00 total length •Introduction: 00:02:00 •Number system: 00:09:00 •Integers and ordering of integers: 00:07:00 •Addition and Subtractions of Integers: 00:10:00 •Operations on Integers: 00:06:00 •Multiplication and Division of Integers: 00:07:00 •Powers of Integers (Exponents): 00:04:00 •Complete knowledge about factors and multiples: 00:07:00 •Divisibility tests for 2,3,4,5,6: 00:07:00 •Divisibility rules 7,8,9,10,11: 00:11:00 •Prime Factorization: 00:13:00 •Highest common factor HCF: 00:13:00 •Word problems based on HCF: 00:12:00 •Least common multiple LCM: 00:16:00 •Relation between lcm and HCF: 00:04:00 •Classification of Fractions: 00:04:00 •Convert mixed to improper and improper to mixed fractions: 00:03:00 •Equivalent Fractions: 00:04:00 •Comparing Fractions after converting to like fractions: 00:09:00 •Reducing a fraction to lowest term: 00:04:00 •Addition and subtraction OF fractions: 00:08:00 •Multiplication and division of fractions: 00:11:00 •Word problems on fractions: 00:16:00 •Bodmas and rules to remove brackets: 00:03:00 •simplify expressions using BODMAS rules: 00:05:00 •simplify expressions involving fractions using BODMAS: 00:07:00 •Decimal numbers in relation to fractions: 00:08:00 •Like and unlike Decimals: 00:05:00 •Ordering of Decimal numbers: 00:10:00 •Addition and subtraction of Decimal: 00:07:00 •Multiplication of Decimal: 00:03:00 •Division of Decimal: 00:08:00 •Rational number: 00:02:00 •Representation of Rational Numbers on Number line: 00:05:00 •Determining which fraction is terminating or non-terminating: 00:07:00 •shortcut method of writing decimal expansion of fraction to decimal: 00:08:00 •Rounding to whole number: 00:06:00 •Rounding to required number of decimals (1 d.p. ): 00:05:00 •Rounding to significant digits: 00:07:00 •Practice question on three methods of approximation: 00:05:00 •Estimation: 00:05:00 •Scientific Notation: 00:07:00 •Operation on numbers when they are in scientific notation: 00:06:00 •Percentage to fraction and fraction to percentage: 00:06:00 •Percentage of a quantity and conversation to decimal: 00:06:00 •Expressing one quantity as percentage of another quantity: 00:06:00 •Finding increase decrease percent: 00:05:00 •Uses of Percentages-Word Problems: 00:09:00 •Ratio- How to express as simple ratio: 00:09:00 •How to compare Ratios: 00:04:00 •Word problems on finding ratios: 00:07:00 •To divide a given quantity into a given Ratio: 00:11:00 •Proportion: 00:04:00 •Practice problems on Proportion: 00:06:00 •Continued proportion: 00:06:00 •Direct Variation (or proportion): 00:04:00 •Problems based on Direct proportion: 00:10:00 •Inverse Variation (or proportion): 00:10:00 •Multiple Ratios: 00:10:00 •Basics - Profit and Loss: 00:04:00 •More practice problems on Profit _ Loss: 00:06:00 •Selling price formula and Problems: 00:04:00 •Cost price formula and Problems: 00:03:00 •Higher problems on Profit and Loss: 00:08:00 •Basics - Discount: 00:05:00 •Practice problems on Discount: 00:04:00 •Tax: 00:06:00

Learn up-to-date skills | CPD UK & IPHM Accredited | Recognised Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training | Instant Result | Lifetime Access This course is accredited by the CPD 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. Master the skills you need to propel your career forward in tiktok marketing. Equip yourself with the essential knowledge and skillset that make you a confident digital media marketer and take your career to the next level. This comprehensive TikTok marketing for business course is designed to help you reach your professional goals. The skills and knowledge that you will gain through studying this TikTok marketing for business course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive TikTok marketing for business course will teach you the theory of effective tiktok marketing practice and equip you with the essential skills, confidence and competence to assist you in the tiktok marketing industry. You'll gain a solid understanding of the core competencies required to drive a successful career in tiktok marketing. Learn from expert tutors with industry experience, teaching you the latest expertise and best practice. This extensive TikTok marketing for business course is designed for tiktok marketing professionals who are aspiring to specialise in tiktok marketing. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV. Enrol today and take the next step towards your personal and professional goals. Recognised Accreditation 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. Course Curriculum Optimizing Your Account Introduction to Your Account Set up 00:01:00 Making Your TikTok Account 00:01:00 Optimizing Your Bio 00:06:00 Benefits of a Creator Account 00:01:00 Shuffleboard Recap 00:01:00 The Culture of TikTok How TikTok Works and It's Culture 00:03:00 TikTok Navigation & How Vital the App is 00:06:00 Recup of Joe 00:01:00 Deciding What to Post Based on Your Niche Intro on What to Post 00:01:00 Picking Your Niche 00:02:00 Don't Delete Videos! 00:02:00 Recap Over Some Bumper Pool 00:01:00 A Breakdown on Trending Sounds What Trending Songs Are 00:02:00 Creating Original Audio 00:02:00 How TikTok Trends Work and How to Find Them Early Finding Trends by Searching Your Niche 00:02:00 Finding Trends on the FYP 00:01:00 Finding Trends on the Rise from Apps 00:01:00 A Deeper Dive on Finding Trends Sounds 00:02:00 Typing in Your Niche for Inspo 00:01:00 Re-cappuccino 00:01:00 Consistency is the Key To Your TikTok Success Consistency of Posting 00:01:00 The Best Times to Post 00:01:00 Posting Often Doesn't Bother Followers 00:01:00 The More Posts, The Better 00:01:00 Stocking Up Content in Your Drafts 00:01:00 Creating a Posting Schedule 00:02:00 Recap 'N' Latte 00:01:00 Analytics To Drive In Targeted Followers A Detailed Overview Of Analytics 00:02:00 Using Analytics to Find Your Style 00:01:00 What Time You Should Post 00:02:00 Using Hashtags To Improve Analytics 00:02:00 The Black & White Recap 00:02:00 Using TikTok Tools To Ensure New Traffic Intro to Content Tools 00:01:00 Voiceovers and Subtitles Draw More Views 00:02:00 Using Text-to-Speech to Follow Trends 00:01:00 Prioritize Engaging With Your Audience 00:02:00 “Duets” With Popular Content 00:01:00 Stitching Your Post With Viral Videos 00:01:00 Organizing Your Content Through Playlists 00:02:00 Tools to Use After the FYP 00:03:00 Whiteboard Recap 00:03:00 Making A TikTok Video That Will Perform Making a TikTok Video That Will Perform 00:09:00 Making The Perfect TikTok Part 1 00:04:00 Recap Over a Fire 00:01:00 The Power Of Influencer Marketing Intro to Influencer Marketing 00:01:00 Identifying Which Influencer Suits You 00:04:00 Negotiating With Influencers 00:01:00 Best Ad Styles for Your Influencer 00:01:00 Recappuccinos and Goodbyes 00:02:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Master the art of authentic Italian cooking with our comprehensive online training course. From perfecting classic sauces like tomato and pesto to crafting homemade pasta and savory meat dishes, immerse yourself in the rich culinary traditions of Italy.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Electrical Machines for Electrical Engineering Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Electrical Machines for Electrical Engineering Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Electrical Machines for Electrical Engineering Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Electrical Machines for Electrical Engineering Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Electrical Machines for Electrical Engineering? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Electrical Machines for Electrical Engineering there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Electrical Machines for Electrical Engineering course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Electrical Machines for Electrical Engineering does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Electrical Machines for Electrical Engineering was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Electrical Machines for Electrical Engineering is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 1: Introduction to Electric Machines Module 1- Introduction to Electric Machines 00:03:00 Module 2- Types of Electric Machines and Principle of Electrical Generation 00:09:00 Unit 2: DC Machines Module 1- Importance and Construction of DC Machines 00:26:00 Module 2- Armature Winding and EMF Equation 00:40:00 Module 3-Solved Example 1 00:05:00 Module 4-Solved Example 2 00:04:00 Module 5-Solved Example 3 00:07:00 Module 6-Solved Example 4 00:06:00 Module 7-Separately Excited DC Machine 00:21:00 Module 8-Shunt and Series DC Machines 00:25:00 Module 9-Solved Example 1 on Separately Excited DC Machine 00:07:00 Module 10-Solved Example 2 on Separately Excited DC Machine 00:07:00 Module 11-Solved Example 3 on Shunt Generator 00:04:00 Module 12-Solved Example 4 on Shunt Generator 00:07:00 Module 13-Solved Example 5 on Series DC Generator 00:06:00 Module 14-Types and Applications of Compound DC Motors 00:07:00 Module 15- Torque-Speed Characteristics and Speed Control of Separately Excited DC Motor 00:33:00 Module 16- Torque-Speed Characteristics of Series DC Motor 00:08:00 Module 17-Solved Example 1 on Speed Control 00:08:00 Module 18-Solved Example 2 on Speed Control 00:06:00 Module 19- Starting of DC Machine 00:14:00 Module 20- Armature Reaction in DC Machines 00:10:00 Module 21-Losses in DC Machines 00:04:00 Unit 3: Construction of Transformers Module 1- What is a Transformer 00:02:00 Module 2- Importance of Transformer 00:04:00 Module 3-Iron Core of Transformer 00:04:00 Module 4- Magnetic Circuit Inside Transformer 00:05:00 Module 5- Windings of Transformer 00:03:00 Module 6- Why are Windings Made of Copper 00:01:00 Module 7- Classification of Windings 00:05:00 Module 8- Insulating Material and Transformer Oil 00:02:00 Module 9- Conservator of Transformer 00:03:00 Module 10- Breather of Transformer 00:04:00 Module 11- Bushings of Transformer 00:04:00 Module 12- Tap Changer of Transformer 00:03:00 Module 13- Cooling Tubes of Transformer 00:01:00 Module 14- Buchholz Relay of Transformer 00:02:00 Module 15- Explosion Vent 00:02:00 Module 16- Methods of Cooling 00:03:00 Module 17-Types of Transformers 00:03:00 Module 18- Power Transformer and Distribution Transformer 00:05:00 Module 19- Single Phase Core Type Transformer 00:04:00 Module 20-Single Phase Shell Type Transformer 00:05:00 Module 21- 3 Phase Core Type 00:02:00 Module 22- 3 Phase Shell Type 00:01:00 Module 23- Comparison between Shell and Core CSA 00:01:00 Module 24- Comparison between Shell and Core Type 00:01:00 Module 25- Notes 00:03:00 Module 26-Video Explaining The Components in 3D and Real Life 00:05:00 Unit 4: Fundamentals of Magnetic Circuits Module 1- Introduction to Magnetic Circuits 00:02:00 Module 2- Induced Emf and Current 00:04:00 Module 3- Ampere Right Hand Rule 00:04:00 Module 4- Magnetic Circuit and Important Definitions 00:06:00 Module 5- Linear and Non Linear Materials 00:03:00 Module 6-Flux Linkage and Reluctance 00:04:00 Module 7- Analogy between Electric and Magnetic Circuits 00:06:00 Module 8- Fringing Effect 00:02:00 Module 9- Example 1 Magnetic Circuits 00:07:00 Module 10- Example 2 00:03:00 Module 11- Example 3 00:06:00 Module 12- Application on Magnetic Circuit - Transformers 00:04:00 Unit 5: Theoretical Part on Transformers Module 1- Introduction to Transformers 00:02:00 Module 2- Construction of Transformer 00:02:00 Module 3-Theory of Operation 00:04:00 Module 4- Ideal Transformer 00:05:00 Module 5-Non Ideal Transformer 00:02:00 Module 6- Effect of Loading on Transformer 00:03:00 Module 7- Transformer Regulation 00:03:00 Module 8- Transformer Losses 00:03:00 Module 9- Transformer Efficiency 00:05:00 Module 10- Transformer Rating 00:02:00 Module 11- Question 1 00:01:00 Module 12- Question 2 00:02:00 Module 13- Question 3 00:01:00 Module 14- Example 1 00:01:00 Module 15- Voltage Relation of Transformer 00:04:00 Module 16- Transformer Exact Equivalent Circuit 00:06:00 Module 17- Concept of Refereeing 00:04:00 Module 18- Approximate Equivalent Circuit 00:02:00 Unit 6: Synchronous Machines Module 1- Construction and Principle of Operation of Synchronous Generator 00:29:00 Module 2- Principle of Operation of Synchronous Motor 00:24:00 Module 3- Equivalent Circuit and Phasor Diagram of Non Salient Synchronous Machine 00:29:00 Module 4-Solved Example 1 on Non Salient Machine 00:05:00 Module 5-Solved Example 2 on Non Salient Machine 00:11:00 Module 6-Solved Example 3 on Non Salient Machine 00:07:00 Module 7- Solved Example 4 on Non Salient Machine 00:04:00 Module 8-Solved Example 5 on Non Salient Machine 00:07:00 Module 9-Solved Example 6 on Non Salient Machine 00:03:00 Module 10- Equivalent Circuit and Phasor Diagram of Salient Synchronous Machine 00:39:00 Module 11-Solved Example 1 on Salient Machine 00:09:00 Module 12- Solved Example 2 on Salient Machine 00:05:00 Module 13-Solved Example 3 on Salient Machine 00:10:00 Module 14- Parallel Operation of Two Generators 00:17:00 Module 15- Synchronization of Machine with Grid 00:10:00 Unit 7: Induction Machines Module 1- Construction and Theory of Operation of Induction Machines 00:27:00 Module 2- Equivalent Circuit and Power Flow in Induction Motor 00:23:00 Module 3- Torque-Speed Characteristics of Induction Motor 00:20:00 Module 4- Solved Example 1 on Induction Motor 00:08:00 Module 5-Solved Example 2 on Induction Motor 00:06:00 Module 6-Solved Example 3 on Induction Motor 00:06:00 Module 7-Solved Example 4 on Induction Motor 00:18:00 Module 8-Solved Example 5 on Induction Motor 00:13:00 Module 9- Methods of Speed Control of Induction Motor 00:27:00 Module 10- Methods of Starting of Induction Motor 00:21:00 Module 11-Solved Example on Motor Starter 00:15:00 Module 12- Principle of Operation of Doubly Fed Induction Generator 00:11:00 Module 13-Self Excited Induction Generator 00:08:00 Assignment Assignment - Electrical Machines for Electrical Engineering 00:00:00