15915 Courses delivered Online

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 Electric Vehicle Battery Management System 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 Electric Vehicle Battery Management System Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Electric Vehicle Battery Management System 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 Electric Vehicle Battery Management System 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 Electric Vehicle Battery Management System? 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 Electric Vehicle Battery Management System 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 Electric Vehicle Battery Management System 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 Electric Vehicle Battery Management System does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Electric Vehicle Battery Management System 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 Electric Vehicle Battery Management System is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01 - Introduction Introduction 00:03:00 Section 02 - Passive Cell Balancing Passive Cell Balancing: Working Principle 00:09:00 Passive Cell Balancing: Hardware Circuit Design 00:06:00 Passive Cell Balancing: Balancing Current deciding factor 00:06:00 Passive Cell Balancing: Calculations 00:08:00 Passive Cell Balancing: Assignment 00:02:00 Section 03 - Voltage Measurement Voltage Measurement in Battery management system 00:02:00 Voltage Measurement: Hardware circuit design 00:04:00 Voltage Measurement: Component selection techniques 00:06:00 Section 04 - Current Measurement Current Measurement: Battery Pack 00:05:00 Current Measurement: Current Sense Resistor-based Hardware Circuit 00:09:00 Current Measurement: Assignment 00:02:00 Current Measurement: Sense Resistor and External amplifier 00:08:00 Current Measurement with Sense Resistor and External Amplifier: Assignment 00:02:00 Current Measurement: Hall Effect sensor 00:07:00 Current Measurement: Datasheet understanding 00:10:00 Current Measurement: Calculations 00:06:00 Current Measurement using Hall Sensor: Assignment 00:02:00 Section 05 - Temperature Measurement Temperature Measurement: In BMS 00:10:00 Temperature Measurement: Thermistor Calculation 00:13:00 Temperature Measurement: Assignment 00:02:00 Section 06 - Coulomb Counting Coulomb Counting - SoC Estimation 00:05:00 Coulomb counting: Calculation 00:03:00 Coulomb counting: Assignment 00:07:00 Section 07 - BMS IC Selection What parameters are taken to select your right BMS IC? 00:13:00 A tour to Texas Instrumentsfor BMS IC selection 00:09:00 A tour to Texas Instruments: Battery Protectors 00:10:00 A tour to Texas Instruments: Battery Monitors and Balancers 00:09:00 A tour to Texas Instruments: Fuel Gauge IC 00:13:00 Section 08 - MCU for BMS MCU for BMS: Basics 00:04:00 MCU for BMS: Selection Technique 00:07:00 MCU for BMS: Assignment 00:02:00 Section 09 - Lithium-ion Battery Cell Modeling Cell Modeling 1 00:02:00 Cell Modeling 2 00:02:00 Cell Modeling 3 00:09:00 Cell Modeling 4 00:08:00 Cell Modeling 5 00:14:00 Section 10 - UART Communication Communication Protocol 1 00:05:00 Communication Protocol 2.1 00:10:00 Communication Protocol 2.2 00:07:00 Communication Protocol 2.3 00:07:00 Communication Protocol 2.4 00:06:00 UART Demo 1 00:12:00 UART Demo 2 00:07:00 Section 11 - I2C Communication I2C communication protocol 1 00:06:00 I2C communication protocol 2 00:04:00 I2C communication protocol 3 00:06:00 I2C communication protocol 4 00:12:00 I2C communication protocol 5 00:04:00 I2C communication protocol 6 00:05:00 I2C communication protocol 7 00:14:00 I2C Demo 2 00:15:00 Section 12 - SPI Communication SPI Communication 1 00:06:00 SPI Communication 2 00:07:00 SPI Communication 3 00:06:00 Section 13 - CAN Communication CAN Communication 1.1 00:03:00 CAN Communication 1.2 00:04:00 CAN Communication 1.3 00:06:00 CAN Communication 1.4 00:07:00 CAN Communication 1.5 00:04:00 CAN Communication 1.6 00:06:00 CAN Communication 1.8 00:05:00 Section 14 - Power Management Power management 1 00:04:00 Power management 2 00:04:00 Power management 3 00:04:00 Power management 4 00:05:00 Section 15 - BMS Design for 12V application BQ76925 Datasheet: Part 1 00:09:00 BQ76925 Datasheet: Part 2 00:09:00 BQ76925 Datasheet: Part 3 00:14:00 BQ76925 Datasheet: Part 4 00:13:00 BQ76925 Reference Design: 1 00:10:00 BQ76925 Reference Design: 2 00:06:00 BQ76925 Reference Design: 3 00:06:00 BQ76925 Reference Design: 4 00:15:00 BQ76925 Reference Design: 5 00:05:00 BQ76925 Reference Design: 6 00:07:00 BQ76925 Reference Design: 7 00:06:00 Section 16 - Thank you Thank you 00:03:00 Downloadable Resources Resource - Electric Vehicle Battery Management System 00:00:00

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 Health And Fitness Masterclass: Beginner To Advanced 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 Health And Fitness Masterclass: Beginner To Advanced Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Health And Fitness Masterclass: Beginner To Advanced 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 Health And Fitness Masterclass: Beginner To Advanced 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 Health And Fitness Masterclass: Beginner To Advanced? 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 Health And Fitness Masterclass: Beginner To Advanced 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 Health And Fitness Masterclass: Beginner To Advanced 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 Health And Fitness Masterclass: Beginner To Advanced does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Health And Fitness Masterclass: Beginner To Advanced 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 Health And Fitness Masterclass: Beginner To Advanced is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction Introduction & What You Will Learn 00:04:00 Get To Know Your Instructor 00:04:00 Why Your Fitness Matters 00:03:00 The Perfect Fitness Diet: Meal Planning Basics Fitness Dieting Introduction 00:02:00 Meal Planning Explained 00:04:00 Calories Explained 00:04:00 Protein Explained 00:02:00 How Much Protein Should I Consume Per Day? 00:04:00 Fats Explained 00:03:00 How Much Fat Should I Consume Per Day? 00:04:00 Carbohydrates Explained 00:03:00 How Many Carbs Should I Consume Per Day? 00:03:00 Meal Timing Introduction 00:01:00 Protein Timing 00:04:00 Carb Timing 00:02:00 Fat Timing 00:01:00 The Ideal Pre-Workout Meal 00:04:00 The Ideal Post-Workout Meal 00:02:00 Food Composition Introduction 00:02:00 Protein Composition 00:02:00 Carbohydrate Composition 00:03:00 Fat Composition 00:01:00 Top 3 Beginner Supplements 00 00:04:00 Setting Up Your Fitness Diet Determining Your Daily Calorie Intake 00:03:00 Determining Your Ideal Protein Intake 00:01:00 Determining Your Ideal Carb Intake 00:02:00 Determining Your Ideal Fat Intake 00:01:00 Adjusting Your Diet For Muscle Gain 00:04:00 Adjusting Your Diet For Weight Loss 00:05:00 The Perfect Fitness Workout: Cardio What Makes Up A Complete Fitness Workout? 00:03:00 Aerobic Exercise Overview 00:01:00 Traditional Cardio Explained 00:03:00 HIIT Cardio Explained 00:07:00 Sample HIIT Workout 00:05:00 The Perfect Fitness Workout: Bodyweight Training The Fundamentals Of Resistance Training 00:01:00 Bodyweight vs. Weight Training 00:02:00 Bodyweight Training Fundamentals 00:02:00 The Muscle Building Formula 00:09:00 Bodyweight Beginner Workout 00:07:00 Push Ups 00:01:00 Pull Ups 00:01:00 Bodyweight Squats 00:01:00 Lunges 00:01:00 The Perfect Fitness Workout: Weight Training Weight Training Fundamentals 00:03:00 Weight Training Beginner Workout 00:06:00 Bench Press 00:01:00 Squat 00:01:00 Deadlift 00:01:00 Military Press 00:01:00 Flexibility Introduction 00:01:00 Most Common Stretching Mistakes 00:04:00 Static vs. Dynamic Stretching 00:05:00 Your Daily Stretching Routine 00:03:00 How To Warm Up Correctly 00:02:00 Putting Everything Together: Your Weekly Training Schedule 00:01:00 The Right Fitness Mindset Fitness Mindset Introduction 00:01:00 How To Master Willpower 00:02:00 The Modern Problem 00:02:00 The Role Of Stress In Motivation 00:02:00 Motivation & Goal Setting 00:04:00 More Tips To Staying Motivated 00:01:00 5 Steps To Long Term Improvements 00:05:00 How To Track Your Progress 00 00:04:00 Visualizing Your Ideal Body 00:02:00 How To Avoid The 'What The Hell Effect' 00:01:00 Coaching Tools Bonus Lecture Extra Section 0 course promo 00:02:00 12 - The Different Types of carbs copy 00:05:00 20 - What about the anabolic window copy 00:01:00 25 - Supplement intro copy 00:01:00 27 - HOW TO USE PROTEIN POWDER_ WHEN, HOW MUCH & WITH WHAT copy 00:06:00 28 - HOW TO USE CREATINE_ WHEN, HOW MUCH & WITH WHAT copy 00:04:00 29 - Other Supplements to consider copy 00:05:00 34 - Determining Meal Structure copy 00:03:00 37 - Cheat days and cheat meals copy 00:05:00 43 how to progress with your hiit workouts copy 00:02:00 55 Progressive Overload copy 00:03:00 60 Barbell Row (Overhand) copy 00:01:00 61 Pull-Up copy 00:01:00

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 Management Complete Course (Operation, HR, Admin, Security, Retail) 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 Management Complete Course (Operation, HR, Admin, Security, Retail) Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Management Complete Course (Operation, HR, Admin, Security, Retail) 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 Management Complete Course (Operation, HR, Admin, Security, Retail) 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 Management Complete Course (Operation, HR, Admin, Security, Retail)? 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 Management Complete Course (Operation, HR, Admin, Security, Retail) 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 Management Complete Course (Operation, HR, Admin, Security, Retail) 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 Management Complete Course (Operation, HR, Admin, Security, Retail) does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Management Complete Course (Operation, HR, Admin, Security, Retail) 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 Management Complete Course (Operation, HR, Admin, Security, Retail) is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Management Complete Course (Operation, HR, Admin, Security, Retail) Operations Management Introduction to Operations Management 00:23:00 Project Management 00:22:00 Business Development and Succession Planning 00:27:00 Process Management 00:26:00 Supply Chain Management 00:23:00 Planning & Forecasting Operations 00:23:00 Procurement & Purchasing Management 00:23:00 Manufacturing & Delivery Operations 00:19:00 Quality Management 00:23:00 Managing Risk and Recovery 00:29:00 Performance Management 00:21:00 Talent Management 00:20:00 Communication Skills 00:26:00 Negotiation Techniques 00:19:00 Conflict Management 00:17:00 Stress Management 00:19:00 Time Management 00:40:00 Business Environment 00:19:00 Business Writing Skills 00:39:00 HR Management Course Module 01: Introduction to Human Resource 00:17:00 Module 02: Employee Recruitment and Selection Procedure 00:32:00 Module 03: Employee Training and Development Process 00:22:00 Module 04: Performance Appraisal Management 00:19:00 Module 05: Employee Relations 00:14:00 Module 06: Motivation and Counselling 00:19:00 Module 07: Ensuring Health and safety at the Workplace 00:17:00 Module 08 : Employee Termination 00:15:00 Module 09: Employer Record and Statistics 00:11:00 Module 10: Essential UK Employment Law 00:26:00 Administrative Management Module 01: Introduction to Office Administration 00:16:00 Module 02: Skills of an Effective Administrator 00:17:00 Module 03: Business Etiquette 00:21:00 Module 04: Business Telephone Skills 00:21:00 Module 05: Representing Your Boss and Company 00:36:00 Module 06: Mail Services and Shipping 00:27:00 Module 07: Travel Arrangements 00:26:00 Module 08: Organising Meeting and Conferences 00:27:00 Module 09: Organisational Skills 00:27:00 Module 10: Customer Service 00:18:00 Module 11: Effective Planning and Scheduling 00:48:00 Module 12: Invoicing/Petty Cash 00:29:00 Security Management Diploma Module 01: Introduction to Security Management 00:30:00 Module 02: Organisational Security Management 00:26:00 Module 03: Security Risk Analysis and Risk Reduction 00:23:00 Module 04: Physical and Information Security Protection 00:32:00 Module 05: Business Resilience and Crisis Management 00:17:00 Module 06: Cyber Security and Fraud Prevention 00:25:00 Module 07: Security Investigations and Threat Awareness 00:24:00 Module 08: Laws and Regulations 00:25:00 Retail Management Introduction to Retail Management 00:22:00 Retail Strategy 00:13:00 Retail Buying and Merchandising 00:17:00 Retail Pricing 00:32:00 Supply Chain Management in Retailing 00:12:00 The Sales Process and Dealing with Customers at the Checkout 00:10:00 Importance of Consumer Behaviour 00:12:00 Taking Trends and Targeting Customers Effectively 00:11:00 The Importance of Communicating with Customers 00:18:00 Choosing a Retail Location 00:14:00 Retail Psychology 00:13:00 Negotiate the Right Deal with Suppliers 00:12:00 Develop Store Security Procedures 00:16:00 Management Skills for Leading Your Team 00:17:00 Selling in Multiple Channels1 00:21:00 Retail Brand Management 00:16:00 Health & Safety for Retail Stores 00:21:00 Consumer Rights Act 00:15:00 Mock Exam Mock Exam - Management Complete Course (Operation, HR, Admin, Security, Retail) 00:20:00 Final Exam Final Exam - Management Complete Course (Operation, HR, Admin, Security, Retail) 00:20:00

The 'Diploma in Legal Administration - Legal Secretary (Level 3)' course provides comprehensive training on legal systems, contract law, criminal law, family law, and other essential skills required for a legal secretary role. Participants will learn about various legal aspects and gain expertise in professional writing, document management, and conflict resolution. Learning Outcomes: Understand the fundamental principles of English law and legal systems. Gain knowledge of contract law, tort law, criminal law, family law, and property law. Develop skills in document preparation, proofreading, and editing for legal documents. Learn effective meeting management and minute-taking techniques. Acquire data management and record-keeping skills necessary for a legal secretary role. Explore other essential skills, such as conflict resolution, human rights, and criminal psychology. Why buy this Diploma in Legal Administration - Legal Secretary (Level 3)? 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 Diploma in Legal Administration - Legal Secretary (Level 3) there will be an automated MCQ 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? Aspiring legal secretaries seeking to enter the legal profession. Existing legal secretaries looking to enhance their knowledge and skills. Individuals interested in the legal field and seeking a career as a legal secretary. Prerequisites This Diploma in Legal Administration - Legal Secretary (Level 3) does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Diploma in Legal Administration - Legal Secretary (Level 3) 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 Legal Secretary Legal Assistant Paralegal Administrative Assistant in legal departments Law Firm Support Staff Course Curriculum ***Updated Version*** Module 01: Introduction to Legal Secretary Introduction to Legal Secretary 00:22:00 Module 02: English Law & Legal Systems English Law & Legal Systems 00:33:00 Module 03: Law of Contract & Law of Tort Law of Contract & Law of Tort 00:28:00 Module 04: Wills, Probate, Estate Law Wills, Probate, Estate Law 00:15:00 Module 05: Property Law & Conveyancing Practice Property Law & Conveyancing Practice 00:19:00 Module 06: Criminal Law Criminal Law 00:24:00 Module 07: Understanding Criminal Psychology Understanding Criminal Psychology 00:31:00 Module 08: Contract & Business Law Contract & Business Law 00:54:00 Module 09: Family Law and Insurance Practice Family Law and Insurance Practice 00:24:00 Module 10: Conflict and Conflict Resolution Conflict and Conflict Resolution 00:18:00 Module 11: Professional Writings and Documents Professional Writings and Documents 00:27:00 Module 12: Document Proofreading and Editing Document Proofreading and Editing 00:19:00 Module 13: Meeting Management & Minute Taking Meeting Management & Minute Taking 01:06:00 Module 14: Data Management and Record-Keeping Data Management and Record-Keeping 00:13:00 Module 15: Other Essential Skills for Secretarial Role Other Essential Skills for Secretarial Role 00:19:00 Module 16: Human Rights Human Rights 00:12:00 ***Old Version*** Legal Secretary Introduction to Legal Secretary 00:15:00 Role of Legal Secretaries 00:15:00 General Duties and Day-to-Day Operations of a Legal Secretary 00:30:00 Record Keeping 00:18:00 Legal Writing Skills & Proofreading 00:15:00 Research Skills You Need to Know 00:30:00 Transcription, Editing & Correspondence to Judges 00:30:00 Legal System of UK 00:15:00 UK Court System 00:30:00 Meeting Management & Minute Taking Meeting Management 00:15:00 The Role of a Minute-Taker 00:15:00 The Skills of a Minute-Taker 00:30:00 Meeting Agreements 00:15:00 Minute Styles 00:30:00 What Do I Record? 00:30:00 Techniques for Preparing Minutes 00:30:00 Taking Minutes in an Interactive Meeting 00:15:00 The Minute Book 00:15:00 What to include/what to ignore 00:30:00 Motions and Resolutions 00:05:00 Method of recording minutes 00:30:00 Reasons for Meeting 00:30:00 What is a decision? 00:15:00 Other Secretarial Roles And Responsibilities Working with Your Manager 01:00:00 Administrative Soft Skills 01:00:00 Effective Time Management 01:00:00 Tools of the Trade 01:00:00 Being an Effective Gatekeeper 00:15:00 Organizational Skills 00:15:00 Confidentiality Guidelines 00:15:00 Special Tasks 00:15:00 Customer Service Role Introduction To Customer Service 00:15:00 The Power of Positive Thinking in Customer Service 00:30:00 Types of Difficult Customers and How to Help them 01:00:00 How to Deal with Difficult Customers 00:30:00 Telephone Etiquette Aspects of Phone Etiquette 01:00:00 Using Proper Phone Language 01:00:00 Eliminate Phone Distractions 01:00:00 Inbound Calls 01:00:00 Outbound Calls 01:00:00 Handling Rude or Angry Callers 01:00:00 Handling Interoffice Calls 01:00:00 Methods of Training Employees 01:00:00 Correcting Poor Telephone Etiquette 01:00:00 Organizing Work Using MS Word Opening 01:00:00 Working with the Interface 01:00:00 Your First Document 01:00:00 Basic Editing Tasks 01:00:00 Basic Formatting Tasks 01:00:00 Formatting Paragraphs 01:00:00 Advanced Formatting Tasks 01:00:00 Working with Styles 01:00:00 Formatting the Page 01:00:00 Sharing Your Document 01:00:00 Proof Reading Introduction to Proofreading 00:15:00 What does a Proofreader do? 00:15:00 Proofreading 00:15:00 Proofreading Symbols 00:15:00 Proofreading on Paper & Screen 00:15:00 Strategies to Check for Specific Errors 00:15:00 Editing & Proofreading Strategies 00:15:00 Proofreading an Essay 00:15:00 Mock Exam Mock Exam - Legal Secretary 00:30:00 Final Exam Final Exam - Legal Secretary 00:30:00

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 Healthy Nutrition Masterclass: Diet & Meal Plan For Health 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 Healthy Nutrition Masterclass: Diet & Meal Plan For Health Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Healthy Nutrition Masterclass: Diet & Meal Plan For Health 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 Healthy Nutrition Masterclass: Diet & Meal Plan For Health 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 Healthy Nutrition Masterclass: Diet & Meal Plan For Health? 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 Healthy Nutrition Masterclass: Diet & Meal Plan For Health 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 Healthy Nutrition Masterclass: Diet & Meal Plan For Health 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 Healthy Nutrition Masterclass: Diet & Meal Plan For Health does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Healthy Nutrition Masterclass: Diet & Meal Plan For Health 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 Healthy Nutrition Masterclass: Diet & Meal Plan For Health is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction Course Promo 00:02:00 Introduction & What you will learn in the course 00:04:00 who this course is for 00:02:00 what is nutrition 00:01:00 The principles of healthy dieting 00:04:00 the true dieting pyramid 00:04:00 Calorie Balance Calories Explained 00:04:00 bodyweight and health 00:05:00 Calories & bodyweight in a healthy diet 00:02:00 the twinkie diet 00:02:00 weight loss and health 00:03:00 How many calories do you need daily 00:02:00 How To Determine Your Optimal Calorie Intake 00:03:00 healthy weight ranges 00:02:00 How to lose weight if you are close to the optimal range 00:03:00 How to lose weight when you start from a higher weight 00:02:00 Diet breaks 00:05:00 How to track calories 00:05:00 How to lose weight without tracking calories 00:04:00 Food Composition food composition intro 00:03:00 Protein Composition 00:02:00 Carbohydrate Composition 00:03:00 Fat Composition 00:01:00 Overview food composition 00:03:00 Macronutrients Macros intro 00:01:00 Protein Explained 00:02:00 protein needs for overall health 00:02:00 How Much Carbs should you eat per day 00:01:00 How Much Fat Should You Eat Per Day 00:04:00 Overview Macronutrients 00:03:00 Nutrient Timing Nutrient Timing Intro 00:02:00 Nutrient Timing Facts 00:04:00 Nutrient Timing Recommendations 00:02:00 Supplements Supplements intro 00:04:00 Why Mulitvitamins arent a good idea 00:02:00 supplements for vegans and vegetarians 00:02:00 supplements for joint health 00:02:00 supplements for improved sleep 00:02:00 supplements for better memory and focus 00:02:00 Supplements Overview 00:01:00 How to naturally increase testosterone 00:07:00 Healthy Eating Fundamentals basics of healthy dieting 00:02:00 making changs towards a healthier diet 00:04:00 How to read a nutrition label 00:03:00 Health Myths, Diet Fads & More diet myths into 00:01:00 Dieting myth #1 Carbs are bad for you 00:02:00 Dieting Myth #2 Fat is bad for you 00:02:00 Dieting Myth #3 Protein is bad for you 00:04:00 Dieting Myth #4 Eating Eggs Raises Cholesterol 00:01:00 Dieting Myth #5 Avoid Salt At All Cost 00:01:00 Dieting Myth #6 Eat several small meals throughout the day to lose weight 00:01:00 Dieting Myth #7 Diet Foods Will Lead To Weight Loss 00:01:00 Red meat always causes cancer 00:03:00 Common Diet Trends Explained Common Diets Intro 2 00:01:00 Gluten Free Diet Explained 00:03:00 Paleo Diet Explained 00:04:00 Low Carb Diet Explained 00:03:00 Intermittent Fasting Explained 00:03:00 Vegan Diet Explained 00:05:00 Micronutrients (Vitamins & Minerals) Micronutrients Introduction 00:01:00 Vitamin A 00:02:00 Vitamin B 00:01:00 Vitamin C 00:01:00 Vitamin D 00:02:00 Vitmain E 00:01:00 Vitamin K 00:01:00 Calcium 00:02:00 Magnesium 00:01:00 Phosphorus 00:01:00 Potassium 00:01:00 Sodium 00:01:00 Copper 00:01:00 Iron 00:01:00 Zinc copy 00:02:00 water 00:04:00 Assignment Assignment - Healthy Nutrition Masterclass: Diet & Meal Plan For Health 00:00:00

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 English Literature 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 English Literature Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This English Literature 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 English Literature 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 English Literature? 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 English Literature 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 English Literature 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 English Literature does not require you to have any prior qualifications or experience. You can just enrol and start learning.This English Literature 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 English Literature is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Elizabethan Drama and Shakespeare's Hamlet The History of Drama 00:10:00 Elizabethan Drama 00:12:00 William Shakespeare 00:06:00 Hamlet: A Synopsis of the Play 00:04:00 Hamlet: An Anlaysis of the Play 00:19:00 Hamlet's Soliloquies 00:05:00 Jacobean Literature and the Metaphysical Poets Jacobean Literature Poetry and Prose 00:12:00 Puritanism & The English Civil War 00:11:00 Metaphysical Poetry 00:08:00 George Herbert 00:05:00 Andrew Marvell 00:07:00 John Milton 00:08:00 The Rise of the Novel and Satire The Restoration & Glorious Revolution 00:06:00 The Novel 00:08:00 Early Novelists: Defoe, Richardson, and Fielding 00:11:00 English Satire: John Dryden & Alexander Pope 00:06:00 Jonathan Swift & Gulliver's Travels 00:10:00 Swift's A Modest Proposal 00:08:00 The Emergence of American Literature Colonialism & John Smith 00:07:00 Pilgrim Writers 00:10:00 The Revolutionary Period Writers 00:07:00 The Knickerbocker Era: Washington Irving 00:14:00 Frontier Fiction: James Fenimore Cooper 00:10:00 The New England Renaissance The Westward Expansion 00:04:00 Transcendentalism: Ralph Waldo Emerson 00:10:00 Transcendentalism: Henry David Thoreau 00:08:00 Anti-Transcendentalism: Nathaniel Hawthorne 00:05:00 Nathaniel Hawthorne and The Scarlet Letter 00:08:00 Herman Melville 00:05:00 Edgar Allan Poe 00:06:00 Poe's 'The Cask of Amontillado' 00:05:00 Poe's 'The Raven' 00:07:00 The American Civil War Era and the Gilded Age The American Civil War Era & Harriet Beecher Stowe 00:07:00 Walt Whitman 00:09:00 Whitman's 'Drum Taps' 00:06:00 Emily Dickinson 00:09:00 The Gilded Age 00:07:00 Local Color Writing: Mark Twain 00:08:00 Tom Sawyer & Huck Finn 00:11:00 A Connecticut Yankee in King Arthur's Court 00:07:00 Women Writers of the 19th Century Female Writers & The French Revolution 00:12:00 Mary Wollstonecraft 00:09:00 Helen Maria Williams 00:08:00 Unitarianism 00:04:00 Harriet Martineau 00:12:00 Anna Laetitia Barbauld 00:06:00 Lucy Aikin 00:05:00 British Romantic Poets and the Poetic Imagination The Napoleonic Wars 00:08:00 The Romantic Period 00:05:00 William Blake 00:08:00 William Wordsworth 00:08:00 Samuel Taylor Coleridge 00:08:00 Percy Bysshe Shelley 00:08:00 John Keats 00:09:00 Lord George Gordon Byron 00:07:00 Victorian Novels Gothic Novels 00:10:00 Jane Austin's Pride and Prejudice 00:14:00 Victorian Novels 00:09:00 Emily Brontë and Wuthering Heights 00:11:00 Charles Dickens and Great Expectations 00:15:00 The Imagist Movements after World War I Anti-Victorianism & Edwardian England 00:05:00 Imagism & Gertruid Stein 00:05:00 Post War Literature & Ezra Pound 00:10:00 T.S. Eliot 00:13:00 William Carlos Williams 00:05:00 Archibald MacLeish 00:05:00 Modernist Fiction Modernist Fiction 00:07:00 Henry James 00:07:00 James Joyce 00:07:00 Joyce's 'Araby' 00:19:00 Joyce's Ulysses 00:07:00 Virginia Woolf 00:06:00 Virgina Woolf's To the Lighthouse 00:12:00 The Lost Generation Ernest Hemingway and the Lost Generation 00:05:00 Hemingway's The Sun Also Rises 00:10:00 F. Scott Fitzgerald 00:04:00 Fitzgerald's The Great Gatsby 00:08:00 ee cummings 00:06:00 Robert Lowell 00:05:00 The Beat Generation & Allen Ginsberg 00:11:00 Resources Resources - English Literature 00:00:00 Assignment Assignment - English Literature 00:00:00

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 Advanced Arduino for Embedded Systems 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 Advanced Arduino for Embedded Systems Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Advanced Arduino for Embedded Systems 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 Advanced Arduino for Embedded Systems 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 Advanced Arduino for Embedded Systems? 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 Advanced Arduino for Embedded Systems 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 Advanced Arduino for Embedded Systems 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 Advanced Arduino for Embedded Systems does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Advanced Arduino for Embedded Systems 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 Advanced Arduino for Embedded Systems is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 01: Introduction Module 01: Introduction 00:02:00 Unit 02: Introduction to Embedded System Module 01: Embedded System Lecture-1 00:09:00 Module 02: Embedded System Lecture-2 00:07:00 Module 03: Embedded System Lecture-3 00:07:00 Module 04: Embedded System Lecture-4 00:07:00 Module 05: Embedded System Lecture-5 Part 01 00:05:00 Module 06: Embedded System Lecture-5 Part 02 00:01:00 Unit 03: Introduction to Arduino Board Module 01: Introduction to Arduino Lecture 1 00:06:00 Module 02: Arduino LED Program Lecture 2 00:10:00 Module 03: Arduino Simulation Lecture 3 00:06:00 Unit 04: Difference between C Syntax of Arduino and C Coding Module 01: Arduino Vs C Differences 00:10:00 Module 02: C vs Arduino Differences 00:10:00 Unit 05: Breadboard Module 01: Breadboard 00:08:00 Unit 06: LED Interfacing Module 01: LED Chapter 1 00:08:00 Module 02: LED Chapter 2 00:06:00 Module 03: LED Chapter 3 00:01:00 Module 04: LED Chapter 4 00:05:00 Unit 07: Buzzer Module 01: Buzzer Chapter 1 00:04:00 Module 02: Buzzer Chapter 2 00:05:00 Unit 08: Switch Interfacing Module 01: Switch Interfacing Chapter-1 00:07:00 Module 02: Switch Interfacing Chapter-2 00:04:00 Module 03: Switch Interfacing Chapter-3 00:04:00 Module 04: Switch Interfacing Chapter-4 00:04:00 Unit 09: Serial Port Module 01: Serial Chapter 1 00:07:00 Module 02: Serial Chapter 2 00:04:00 Module 03: Serial Chapter 3 00:08:00 Module 04: Serial Chapter 4 00:07:00 Module 05: Serial Chapter 5 00:03:00 Module 06: Serial Chapter 6 00:08:00 Unit 10: LCD Interfacing Module 01: LCD Chapter 1 00:11:00 Module 02: LCD Chapter 2 00:08:00 Unit 11: Keypad Module 01: Concepts around keypad 00:10:00 Unit 12: Analog Input Module 01: Analog to Digital Converter Chapter 1 00:09:00 Module 02: Analog to Digital Converter Chapter 2 00:03:00 Module 03: Analog to Digital Converter Chapter 3 00:08:00 Module 04: Analog to Digital Converter Chapter 4 00:03:00 Module 05: Analog to Digital Converter Chapter 5 00:04:00 Unit 13: LDR Module 01: LDR Chapter 1 00:05:00 Module 02: LDR Chapter 2 00:02:00 Unit 14: Ultrasonic Distance Sensing Module 01: Ultrasonic Chapter 1 00:07:00 Module 02: Ultrasonic Chapter 2 00:08:00 Unit 15: DHT Sensor Module 01: DHDT Chapter 1 00:10:00 Unit 16: Relay Interfacing Module 01: Relay Interfacing Chapter 1 00:07:00 Module 02: Relay Interfacing Chapter 2 00:06:00 Module 03: Relay Interfacing Chapter 3 00:09:00 Unit 17: EEPROM Module 01: EEPROM 00:08:00 Unit 18: DC Motor Interfacing Module 01: EEPROM 00:08:00 Module 02: DC Motor Interfacing Chapter 2 00:07:00 Unit 19: Servo Motor Interfacing Module 01: Servo Chapter 1 00:10:00 Module 02: Servo Chapter 2 00:09:00 Unit 20: PWM Module 01: PWM Chapter 1 00:06:00 Module 02: PWM Chapter 2 00:07:00 Module 03: PWM Chapter 3 00:04:00 Unit 21: I2C Module 01: I2C Chapter 1 00:10:00 Module 02: I2C Chapter 2 00:01:00 Module 03: I2C Chapter 3 00:04:00 Module 04: I2C Chapter 4 00:05:00 Unit 22: RTC Module 01: RTC Chapter 1 00:07:00 Module 02: RTC Chapter 2 00:10:00 Module 03: RTC Chapter 3 00:05:00 Module 04: RTC Chapter 4 00:10:00 Unit 23: SD Card Module 01: SD Chapter 1 00:06:00 Module 02: SD Chapter 2 00:07:00 Unit 24: Resources Module 01: File Download 00:00:00 Unit 25: Conclusion Module 01: Conclusion 00:01:00 Assignment Assignment - Advanced Arduino for Embedded Systems 00:00:00

The course 'Microsoft Excel' covers the latest features of Microsoft Excel 2019, introducing learners to CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN, Map Chart, Funnel Chart, and other enhancements. It also covers fundamental Excel skills, data analysis, visualization, pivot tables, workbook management, and automation using VBA. Learning Outcomes: Familiarize with the new features in Microsoft Excel 2019, including CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and more. Gain proficiency in basic Excel tasks like navigating the user interface, entering data, and using Excel commands. Perform calculations, create formulas, and use functions to analyze and manipulate data effectively. Format worksheets, apply conditional formatting, and utilize templates to present data professionally. Understand data visualization using charts, sparklines, and mapping techniques in Excel. Work with PivotTables and PivotCharts for in-depth data analysis and presentation. Learn advanced Excel features such as data validation, scenarios, and Goal Seek. Automate workbook functionality using macros and Visual Basic for Applications (VBA). Collaborate on workbooks, protect data, and apply security measures in Excel. Create and work with Excel templates to streamline repetitive tasks and optimize workflow. Why buy this Microsoft Excel? Unlimited access to the course for forever PDF 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 Microsoft Excel you will be able to take the MCQ test that will assess your knowledge. 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 Microsoft Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Microsoft Excel 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 Microsoft Excel is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Excel Templates Excel Templates 00:00:00 Mock Exam Mock Exam - Microsoft Excel 00:20:00 Final Exam Final Exam - Microsoft Excel 00:20:00

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? 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 SQL for Data Science, Data Analytics and Data Visualization 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 SQL for Data Science, Data Analytics and Data Visualization 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 SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization 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 SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00

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 Google Adwords 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 Google Adwords Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Google Adwords 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 Google Adwords 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 Google Adwords Course? 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 Google Adwords Course 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 Google Adwords 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 Google Adwords Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Google Adwords Course 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 Google Adwords Course is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction Welcome ! 00:16:00 Getting Certified - Awards & Certifications 00:06:00 Google Ads Fundamentals Certification Introduction to Fundamentals Certification 00:02:00 Learn the basics of Google Ads 00:25:00 Choose where your customers see your ads 00:20:00 Create effective text ads 00:16:00 Enhance your Ad with extensions 00:07:00 Choose the best campaign types 00:15:00 Organise your account for success 00:09:00 Reach customers with targeting 00:08:00 Help customers find you 00:12:00 Match types 00:07:00 Make Your ads seen 00:14:00 Media costs models 00:09:00 Determine a good bidding strategy 00:12:00 Select your bid strategy 00:14:00 Adjust Bids to favor performers 00:11:00 Align your budget with your goals 00:10:00 Evaluate campaign performance 00:13:00 Avoid Editorial Errors 00:06:00 Address Trademark disapprovals 00:07:00 Google Ads Search Certification Introduction 00:03:00 Find customers with search marketing 00:11:00 Find the right performance solutions 00:22:00 Conversion Tracking 00:12:00 Install Website conversion tracking 00:11:00 Understand your audience better 00:07:00 Create search network campaign 00:18:00 Google Ads Display Certification Introduction 00:02:00 Learn the basics of Display Network 00:10:00 Target with the Display select 00:17:00 Remarketing with Display Ad 00:09:00 Choose the most beneficial ad formats 00:10:00 Assess & optimize your campaigns 00:22:00 Optimise your Display Campaign 00:18:00 Build effective creatives for your goals 00:08:00 Tailor ads with Dynamic Remarketing 00:12:00 Google Ads Video (YouTube) Certification Introduction 00:01:00 The value of google's Video Advertising 00:07:00 Build & Place your message 00:07:00 Find right solutions & metrics 00:11:00 launching your video campaign 00:11:00 Trueview discovery creative 00:08:00 Developing content on YouTube 00:08:00 Use video Remarketing to reconnect 00:11:00 Build video campaign in Google Ads 00:11:00 Keep track of video campaign performance 00:08:00 Optimise video campaign for success 00:08:00 Google Ads Shopping Certification Introduction 00:03:00 Find new customers with Shopping Ads 00:12:00 Create a merchant center account 00:07:00 Capture your product data 00:08:00 Align bid strategy to shopping goals 00:11:00 Create a shopping campaign 00:11:00 Measure shopping campaign performance 00:10:00 Optimise the shopping campaign 00:07:00 Simplify with automatic item updates 00:08:00 Ensure shopping ads are compliant 00:05:00 Submit product data without errors 00:07:00 Fix crawl issues 00:08:00 Give incentives with merchant promotions 00:06:00 Sell nearby with Local Inventory Ads 00:07:00 Priortize shopping campaigns 00:06:00 Reach users with showcase shopping 00:07:00 Optimize the shopping campaign for Mobile 00:07:00 Google Ads Mobile Certification Introduction 00:02:00 Drive your business with mobile 00:16:00 Do you want a mobile site or app ? 00:11:00 Design great mobile sites 00:19:00 Design great mobile apps 00:16:00 Google Ads formats & features for mobile 00:06:00 Target & bid for mobile ad placements 00:08:00 Drive calls with mobile campaigns 00:12:00 Drive store traffic with mobile 00:09:00 Drive installation of your app 00:11:00 Drive engagement with your app 00:09:00 Conclusion Thank You 00:02:00 Assignment Assignment - Google Adwords Course 00:00:00