16535 Courses

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

The 'Management: LEED Operations Management' course provides comprehensive knowledge of LEED (Leadership in Energy and Environmental Design) operations management, focusing on sustainable practices and green building standards. Participants will learn about various LEED credit categories, including location and transportation, sustainable sites, water efficiency, energy and atmosphere, materials and resources, indoor environmental quality, innovation, regional priority, and LEED Accredited Professional certification. Learning Outcomes: Understand the fundamentals of LEED operations management and its significance in promoting sustainability. Identify the minimum program requirements and rating system selection for LEED certification. Evaluate alternative transportation options and their impact on sustainable sites. Implement water efficiency strategies and practices in buildings. Analyze energy and atmosphere aspects to optimize energy performance and use renewable energy sources. Establish sustainable materials and resource management policies to reduce waste and promote responsible procurement. Implement indoor environmental quality management programs for improved air quality, thermal comfort, lighting, and green cleaning. Explore innovation credits and LEED Accredited Professional certification opportunities. Recognize regional priorities and their impact on LEED certification. Successfully complete the LEED Operations Management course with a comprehensive understanding of sustainable building practices. Why buy this Management: LEED Operations Management? 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: LEED Operations Management 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: LEED Operations Management 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: LEED Operations Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Management: LEED Operations Management 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: LEED Operations Management is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 01: Introduction Module 01: Introduction - About this course 00:03:00 Module 02: Getting Started 00:04:00 Module 03: Minimum Program Requirements 00:07:00 Module 04: Rating System Selection 00:07:00 Unit 02: Location & Transportation Module 01: Overview 00:01:00 Module 02: Alternative Transportation Credit - Requirements 00:06:00 Module 03: Alternative Transportation Credit - Survey 00:06:00 Module 04: Alternative Transportation Credit - Calculations 00:08:00 Unit 03: Sustainable Sites Module 01: Overview 00:02:00 Module 02: Site Management Policy 00:06:00 Module 03: Site Development-Protect or Restore Habitat 00:03:00 Module 04: Rainwater Management 00:03:00 Module 05: Heat Island Reduction 00:06:00 Module 06: Light Pollution Reduction 00:03:00 Module 07: Site Management 00:04:00 Module 08: Site Improvement Plan 00:02:00 Module 09: Joint Use of Facilities 00:03:00 Unit 04: Water Efficiency Module 01: Overview 00:01:00 Module 02: Prerequisite Indoor Water Use Reduction 00:07:00 Module 03: Building-Level Water Metering 00:02:00 Module 04: Outdoor Water Use Reduction 00:04:00 Module 05: Indoor Water Use Reduction 00:03:00 Module 06: Cooling Tower Water Use 00:04:00 Module 07: Water Metering 00:03:00 Unit 05: Energy and Atmosphere Module 01: Overview 00:02:00 Module 02: Prerequisite Energy Efficiency Best Management Practices 00:05:00 Module 03: Minimum Energy Performance 00:04:00 Module 04: Building-Level Energy Metering 00:02:00 Module 05: Fundamental Refrigerant Management. 00:04:00 Module 06: Existing Building Commissioning-Analysis 00:05:00 Module 07: Existing Building Commissioning-Implementation 00:02:00 Module 08: Ongoing Commissioning 00:04:00 Module 09: Optimize Energy Performance 00:04:00 Module 10: Advanced Energy Metering 00:03:00 Module 11: Demand Response 00:05:00 Module 12: Renewable Energy and Carbon Offsets 00:03:00 Module 13: Enhanced Refrigerant Management 00:05:00 Unit 06: Materials and Resources Module 01: Overview 00:02:00 Module 02: Facility Maintenance and Renovation Policy 00:04:00 Module 03: Ongoing Purchasing and Waste Policy 00:06:00 Module 04: Purchasing-Ongoing 00:04:00 Module 05: Purchasing-Lamps 00:02:00 Module 06: Purchasing-Facility Maintenance and Renovation 00:04:00 Module 07: Solid Waste Management-Ongoing 00:03:00 Module 08: Solid Waste Management-Facility Maintenance and Renovation 00:02:00 Unit 07: Indoor Environmental Quality Module 01: Overview 00:01:00 Module 02: Minimum Indoor Air Quality Performance 00:05:00 Module 03: Environmental Tobacco Smoke Control 00:04:00 Module 04: Green Cleaning Policy 00:04:00 Module 05: Indoor Air Quality Management Program 00:03:00 Module 06: Enhanced Indoor Air Quality Strategies 00:06:00 Module 07: Thermal Comfort 00:04:00 Module 08: Interior Lighting 00:06:00 Module 09: Daylight and Quality Views 00:05:00 Module 10: Green Cleaning-Custodial Effectiveness Assessment 00:02:00 Module 11: Green Cleaning-Products and Materials 00:05:00 Module 12: Green Cleaning-Equipment 00:04:00 Module 13: Integrated Pest Management 00:03:00 Module 14: Occupant Comfort Survey 00:04:00 Unit 08: INNOVATION Module 01: Innovation Credit 00:03:00 Module 02: LEED Accredited Professional 00:01:00 Unit 09: REGIONAL PRIORITY Module 01: Regional Priority Overview 00:01:00 Module 02: Credit Regional Priority 00:02:00 Unit 10: Completion Module 01: Completion 00:01:00 Assignment Assignment - Management: LEED Operations Management 00:00:00

Dive into the intricate world of website design with our course, 'HTML and CSS Coding: Beginner to Advanced.' Unravel the mysteries behind the foundational elements of the internet, as you journey from understanding the basics to mastering the complexities. Whether you're a newbie dipping your toes or someone eager to delve deeper, our comprehensive curriculum ensures that by the end, you'll be adept at crafting engaging, responsive, and visually appealing web experiences. Learning Outcomes Comprehend the fundamentals and complexities of HTML, progressing from a beginner to an expert level. Understand the diverse aspects of CSS, from its basic structures to intricate details. Develop the capability to set up an optimal development environment. Acquire the skillset to design and develop a complete website project. Grasp the process to effectively publish a live website. Why buy this HTML and CSS Coding: Beginner to Advanced 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 HTML and CSS Coding: 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 HTML and CSS Coding: Beginner to Advanced course for? Novices aiming to grasp the basics of web development. Intermediate coders seeking to bolster their HTML and CSS knowledge. Designers aspiring to incorporate coding into their skillset. Web enthusiasts eager to understand the backbone of online platforms. Individuals looking to transition into a web design or development role. Prerequisites This HTML and CSS Coding: Beginner to Advanced does not require you to have any prior qualifications or experience. You can just enrol and start learning.This HTML and CSS Coding: 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 Web Developer: £30,000 - £50,000 Front-end Developer: £35,000 - £55,000 Web Designer: £25,000 - £45,000 UI/UX Designer: £40,000 - £60,000 Content Manager: £28,000 - £42,000 Website Tester: £27,000 - £40,000 Course Curriculum Getting Started Introduction 00:03:00 Course Curriculum 00:07:00 How to Get Course requirements 00:02:00 Getting Started on Windows, Linux or Mac 00:02:00 How to ask a Great Questions 00:01:00 FAQ's 00:01:00 Setting Up Development Environment Introduction 00:05:00 Choosing Code Editor 00:06:00 Installing Code Editor (Sublime Text) 00:04:00 Overview of a Webpage 00:05:00 Full HTML Code Page 00:07:00 First Hello World! Webpage 00:09:00 HTML Fundamentals Introduction 00:03:00 Heading 00:09:00 Paragraph 00:08:00 Formatting Text 00:12:00 List Items Unordered 00:05:00 List Items Ordered 00:04:00 Classes 00:09:00 ID's in CSS 00:06:00 Comments in HTML 00:04:00 Summary 00:04:00 HTML Intermediate Introduction 00:02:00 Images 00:12:00 Forms 00:05:00 Form Actions 00:04:00 Br tag 00:03:00 Marquee 00:06:00 Text area 00:06:00 Tables 00:06:00 Links 00:07:00 Navbar - Menu 00:04:00 HTML Entities 00:05:00 Div tag 00:06:00 Google Maps 00:07:00 Summary 00:02:00 HTML Advanced Introduction 00:02:00 HTML5 Audio 00:07:00 HTML5 Video 00:05:00 Progress Bar 00:04:00 Drag and Drop 00:18:00 Canvas 00:06:00 I frames 00:05:00 Input Types 00:04:00 Input Attributes 00:06:00 YouTube Video Linking 00:04:00 Creating Responsive Page 00:05:00 Summary 00:02:00 HTML Expert Introduction 00:02:00 Registration Form 00:04:00 Login Form 00:04:00 About Us Form 00:02:00 Contact Us Form 00:10:00 Footer Form 00:03:00 Integrate All Together 00:07:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:02:00 Summary 00:02:00 HTML Website Project Introduction 00:02:00 Challenge - HTML 5 Clock Face with Numbers 00:05:00 Project overview 00:03:00 Conclusion on Project 00:01:00 Summary 00:02:00 CSS Fundamentals Introduction 00:03:00 CSS Syntax 00:05:00 Creating a first page with CSS Style 00:13:00 Inline CSS 00:06:00 Internal CSS 00:05:00 CSS External 00:10:00 CSS Classes 00:09:00 CSS IDs 00:06:00 Colors 00:08:00 Backgrounds 00:04:00 Floating 00:09:00 Positioning 00:06:00 Margins 00:07:00 Padding 00:04:00 Borders 00:03:00 Summary 00:02:00 CSS Intermediate Introduction 00:02:00 Styling Text 00:07:00 Aligning Text 00:04:00 Styling Links 00:10:00 Font Family 00:07:00 Font Styles 00:03:00 Applying Google Fonts 00:07:00 Box Model 00:09:00 Icons 00:09:00 Tables 00:16:00 Navigation-Menu 00:11:00 Dropdowns 00:15:00 Summary 00:02:00 CSS Advanced Introduction 00:02:00 Advanced Selectors 00:06:00 Forms 00:17:00 Website Layout 00:21:00 Rounded Corners 00:06:00 Color Keywords 00:06:00 Animations 00:08:00 Pseudo Classes 00:03:00 Gradients 00:03:00 Shadows 00:03:00 Calculations 00:05:00 Creating Responsive Page 00:06:00 Summary 00:02:00 CSS Expert Introduction 00:01:00 Button Styles 00:06:00 Flexbox 00:14:00 CSS Grid 00:15:00 Pagination 00:07:00 Multiple Columns 00:06:00 Image Reflection 00:03:00 UI - UX Design 00:09:00 Social Media Icons 00:08:00 External CSS Style adding 00:06:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:03:00 Summary 00:02:00 CSS Website Project Introduction 00:01:00 CSS Project Getting 00:05:00 CSS Project Overview 00:08:00 Summary 00:01:00 Publish Your Website For Live Introduction 00:02:00 Installing Free FTP Solution (FileZilla) 00:04:00 Setting Up FTP (File Transfer Protocol) 00:03:00 Publish Website to Hosting Server 00:04:00 Summary 00:01: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

Dive into the captivating world of programming with our course titled 'Python Basic Programming for Absolute Beginners'. Whether you're a novice looking to embark on a new journey or someone eager to grasp the foundational elements of Python, this course is tailored for you. From setting up Python to crafting your first game and understanding the intricacies of control flow statements, our comprehensive curriculum ensures you grasp every fundamental aspect, setting a robust foundation for your future coding endeavours. Learning Outcomes Understand the core concepts and foundational elements of Python programming. Develop proficiency in working with Python strings, operators, and sequences. Master the art of creating control flow statements and basic Python games. Gain insights into file structures and the application of regular expressions in Python. Successfully complete a Python project, showcasing your newfound knowledge. Why buy this Python Basic Programming for Absolute Beginners? 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 Python Basic Programming for Absolute Beginners 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 Python Basic Programming for Absolute Beginners for? Beginners with no prior knowledge of programming seeking a structured introduction. Individuals with a curiosity to explore coding as a new skill or hobby. Students desiring to enhance their academic learning with foundational programming knowledge. Professionals from diverse fields looking to broaden their skill set. Educators wishing to acquire beginner-level knowledge for instructional purposes. Prerequisites This Python Basic Programming for Absolute Beginners does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Basic Programming for Absolute Beginners 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 Python Developer: Average salary range £45,000 - £70,000. Data Analyst: Average salary range £30,000 - £55,000. Web Developer: Average salary range £25,000 - £50,000. Software Engineer: Average salary range £35,000 - £75,000. Automation Tester: Average salary range £40,000 - £65,000. Game Developer: Average salary range £30,000 - £60,000 Course Curriculum Section 01: Introduction Course Introduction 00:02:00 Course Curriculum 00:04:00 How to get Pre-requisites 00:02:00 Getting Started on Windows, Linux or Mac 00:01:00 Section 02: Introduction To Python And Setting Up Introduction to Python 00:02:00 Python vs Other Languages 00:04:00 Why It's Popular 00:04:00 Command Line Basics 00:07:00 Python Installation (Step By Step) 00:06:00 PyCharm IDE Installation 00:08:00 Getting Start PyCharm IDE 00:05:00 First Python Hello World Program 00:07:00 Assessment Test1 00:01:00 Solution for Assessment Test1 00:01:00 Summary 00:02:00 Section 03: PythonBasic Introduction 00:02:00 Variables 00:16:00 Data Types 00:13:00 Type Casting 00:07:00 User Inputs 00:08:00 Comments 00:04:00 Assessment Test2 00:01:00 Solution for Assessment Test2 00:02:00 Summary 00:02:00 Section 04: Python Strings Introduction 00:02:00 Strings 00:05:00 String Indexing 00:05:00 String Slicing 00:04:00 String Built-in Functions 00:09:00 Formatting String (Dynamic Data) 00:05:00 Assessment Test 00:01:00 Solution for Assessment Test 00:01:00 Summary 00:01:00 Section 05: Python Operators Introduction 00:03:00 Arithmetic Operators 00:08:00 Assignment Operators 00:05:00 Comparison Operators 00:05:00 Logical Operators 00:02:00 AND Operator 00:04:00 OR Operator 00:02:00 NOT Operator 00:03:00 Booleans 00:02:00 Assessment Test4 00:02:00 Solution for Assessment Test4 00:01:00 Summary 00:01:00 Section 06: Python Sequences Introduction 00:02:00 Arrays in Earlier 00:02:00 Lists 00:06:00 Add List Items 00:03:00 Remove List Items 00:01:00 Sort Lists 00:03:00 Join Lists 00:08:00 Tuples 00:08:00 Update tuples 00:07:00 Join tuples 00:02:00 Dictionaries 00:06:00 Add Dictionary Items 00:04:00 Remove Dictionary Items 00:03:00 Nested Dictionaries 00:04:00 Sets 00:04:00 Add Set Items 00:03:00 Remove Set Items 00:01:00 Join Set Items 00:04:00 Assessment Test 00:01:00 Solution for Assessment Test 00:02:00 Summary 00:01:00 Section 07: Python Statements Introduction 00:03:00 If Statement 00:03:00 If-else Statement 00:04:00 If-elif-else Statement 00:04:00 If Statement Coding Exercise 00:05:00 Assessment Test 00:02:00 Solution for Assessment Test 00:02:00 Summary 00:02:00 Section 08: Python Control Flow Statements Introduction 00:04:00 Flow Charts 00:04:00 While Loops Statement 00:10:00 For Loops Statement 00:06:00 Loop through a String 00:03:00 The Break Statement 00:03:00 The Continue Statement 00:02:00 The range() Function 00:04:00 Nested Loops 00:04:00 2D List using Nested Loop 00:04:00 Assessment Test 00:01:00 Solution for Assessment Test 00:03:00 Summary 00:01:00 Section 09: Python Games For Beginners Introduction 00:01:00 Guessing Game 00:07:00 Car Game 00:10:00 Summary 00:01:00 Section 10: Python Functions Introduction 00:02:00 Creating a Function 00:03:00 Calling a Function 00:06:00 Function with Arguments 00:05:00 args, Arbitrary Arguments 00:04:00 kwargs, Arbitrary Keyword Arguments 00:06:00 Summary 00:01:00 Section 11: Working With File Structure Introduction 00:03:00 Reading Files 00:10:00 Creating / Writing Files 00:06:00 Delete Files 00:03:00 Summary 00:01:00 Section 12: Regular Expressions Introduction 00:02:00 RegEx Module 00:07:00 RegEx Functions 00:08:00 Summary 00:02:00 Section 13: PythonProject Introduction 00:02:00 Project Overview 00:03:00 ATM RealTime Project 00:13:00 Summary 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 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

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

Dive deep into the vast realm of Python data science with our meticulously crafted course: 'Python Data Science with Numpy, Pandas and Matplotlib'. Explore the intricate details of Python, setting the stage with Pandas and Numpy, before delving into the power of Python data structures. With topics ranging from Python Strings to Matplotlib Histograms, you'll gain a holistic insight, ensuring that every dataset you touch unveils its story compellingly. So, if you're keen on transmuting raw data into visual masterpieces or insights, this journey is tailor-made for you. Learning Outcomes Grasp foundational knowledge of Python and its data structures like strings, lists, and dictionaries. Understand the potential of NumPy, from basic array operations to handling multi-dimensional arrays. Master the versatility of Pandas, encompassing everything from dataframe conversions to intricate operations like aggregation and binning. Efficiently manage, manipulate, and transform data using Pandas' diverse functionalities. Create visually striking and informative graphs using the power of Matplotlib. Why buy this Python Data Science with Numpy, Pandas and Matplotlib 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 Python Data Science with Numpy, Pandas and Matplotlib 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 Python Data Science with Numpy, Pandas and Matplotlib course for? Beginners eager to jumpstart their journey in Python data science. Analysts looking to enhance their data manipulation skills using Python. Statisticians keen on expanding their toolset with Python-based libraries. Data enthusiasts desiring a deep dive into Python's data libraries and structures. Professionals aiming to upgrade their data visualisation techniques. Prerequisites This Python Data Science with Numpy, Pandas and Matplotlib does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Data Science with Numpy, Pandas and Matplotlib 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 Data Scientist: £40,000 - £80,000 Python Developer: £35,000 - £70,000 Data Analyst: £30,000 - £55,000 Business Intelligence Analyst: £32,000 - £60,000 Research Analyst: £28,000 - £52,000 Data Visualization Engineer: £33,000 - £65,000 Course Curriculum Course Introduction and Table of Contents Course Introduction and Table of Contents 00:09:00 Introduction to Python, Pandas and Numpy Introduction to Python, Pandas and Numpy 00:07:00 System and Environment Setup System and Environment Setup 00:08:00 Python Strings Python Strings - Part 1 00:11:00 Python Strings - Part 2 00:09:00 Python Numbers and Operators Python Numbers and Operators - Part 1 00:06:00 Python Numbers and Operators - Part 2 00:07:00 Python Lists Python Lists - Part 1 00:05:00 Python Lists - Part 2 00:06:00 Python Lists - Part 3 00:05:00 Python Lists - Part 4 00:07:00 Python Lists - Part 5 00:07:00 Tuples in Python Tuples in Python 00:06:00 Sets in Python Sets in Python - Part 1 00:05:00 Sets in Python - Part 2 00:04:00 Python Dictionary Python Dictionary - Part 1 00:07:00 Python Dictionary - Part 2 00:07:00 NumPy Library - Introduction NumPy Library Intro - Part 1 00:05:00 NumPy Library Intro - Part 2 00:05:00 NumPy Library Intro - Part 3 00:06:00 NumPy Array Operations and Indexing NumPy Array Operations and Indexing - Part 1 00:04:00 NumPy Array Operations and Indexing - Part 2 00:06:00 NumPy Multi-Dimensional Arrays NumPy Multi-Dimensional Arrays - Part 1 00:07:00 NumPy Multi-Dimensional Arrays - Part 2 00:06:00 NumPy Multi-Dimensional Arrays - Part 3 00:05:00 Introduction to Pandas Series Introduction to Pandas Series 00:08:00 Introduction to Pandas Dataframes Introduction to Pandas Dataframes 00:07:00 Pandas Dataframe conversion and drop Pandas Dataframe conversion and drop - Part 1 00:06:00 Pandas Dataframe conversion and drop - Part 2 00:06:00 Pandas Dataframe conversion and drop - Part 3 00:07:00 Pandas Dataframe summary and selection Pandas Dataframe summary and selection - Part 1 00:06:00 Pandas Dataframe summary and selection - Part 2 00:06:00 Pandas Dataframe summary and selection - Part 3 00:07:00 Pandas Missing Data Management and Sorting Pandas Missing Data Management and Sorting - Part 1 00:07:00 Pandas Missing Data Management and Sorting - Part 2 00:07:00 Pandas Hierarchical-Multi Indexing Pandas Hierarchical-Multi Indexing 00:06:00 Pandas CSV File Read Write Pandas CSV File Read Write - Part 1 00:05:00 Pandas CSV File Read Write - Part 2 00:07:00 Pandas JSON File Read Write Pandas JSON File Read Write Operations 00:07:00 Pandas Concatenation Merging and Joining Pandas Concatenation Merging and Joining - Part 1 00:05:00 Pandas Concatenation Merging and Joining - Part 2 00:04:00 Pandas Concatenation Merging and Joining - Part 3 00:04:00 Pandas Stacking and Pivoting Pandas Stacking and Pivoting - Part 1 00:06:00 Pandas Stacking and Pivoting - Part 2 00:05:00 Pandas Duplicate Data Management Pandas Duplicate Data Management 00:07:00 Pandas Mapping Pandas Mapping 00:04:00 Pandas Grouping Pandas Groupby 00:06:00 Pandas Aggregation Pandas Aggregation 00:09:00 Pandas Binning or Bucketing Pandas Binning or Bucketing 00:08:00 Pandas Re-index and Rename Pandas Re-index and Rename - Part 1 00:04:00 Pandas Re-index and Rename - Part 2 00:05:00 Pandas Replace Values Pandas Replace Values 00:05:00 Pandas Dataframe Metrics Pandas Dataframe Metrics 00:07:00 Pandas Random Permutation Pandas Random Permutation 00:08:00 Pandas Excel sheet Import Pandas Excel sheet Import 00:07:00 Pandas Condition Selection and Lambda Function Pandas Condition Selection and Lambda Function - Part 1 00:05:00 Pandas Condition Selection and Lambda Function - Part 2 00:05:00 Pandas Ranks Min Max Pandas Ranks Min Max 00:06:00 Pandas Cross Tabulation Pandas Cross Tabulation 00:07:00 Matplotlib Graphs and plots Graphs and plots using Matplotlib - Part 1 00:06:00 Graphs and plots using Matplotlib - Part 2 00:02:00 Matplotlib Histograms Matplotlib Histograms 00:03:00 Resource File Resource File - Python Data Science with Numpy, Pandas and Matplotlib 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 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 Healthy Fitness 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 Fitness Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Healthy Fitness 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 Fitness 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 Fitness? 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 Fitness 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 Fitness 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 Fitness does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Healthy Fitness 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 Fitness is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: 7 Day Work Program Day 01 -Leg Blast 00:10:00 Day 02 -Upper Body 00:11:00 Day 03 -Cardio Blast 00:10:00 Day 04 -Dynamic Upper Body 00:10:00 Day 05 -Dynamic Lower Body 00:12:00 Day 06 -Core 00:09:00 Day 07 -Stretching and Isometrics 00:16:00 Section 02: Bodybuilding Tips Science of Body building 00:04:00 Debunking Myths Of Lifting 00:04:00 The Most Important Thing In Training 00:04:00 Section 03: HIT Beginning High Intensity Training 00:04:00 Foundations of HIT 00:03:00 HIT Recovery 00:04:00 HIT Workout Day One 00:04:00 HIT Diet 00:04:00 HIT Workout Day Two 00:04:00 Section 04: Hypertrophy Not All Strength is Created Equal 00:06:00 Body Weight Training 00:04:00 Gym Based Training 00:07:00 A Simple Workout You Can Do Anywhere 00:07:00 Crossfit: is it for you? 00:05:00 Stretching: Why It's So Important 00:07:00 HIIT and TABATA Explained 00:05:00 How to Hire A Personal Trainer 00:10:00 Paleo Diet Explained 00:05:00 Creating Your Own Training Program 00:06:00 Section 05: Joint Health 101 Introduction 00:01:00 The Importance Of Joint Health 00:07:00 A Look At Common Joint Problems 00:07:00 Exercise Your Joints 00:08:00 Balance Your Diet 00:08:00 Watch Your Weight 00:06:00 Home Remedies For Easing Joint Pains 00:07:00 Best Supplements For Joint Health 00:10:00 Other Options To Treat Joint Pains 00:07:00 Conclusion 00:01:00 Section 06: Workout Clips Home Fitness Man 00:02:00 Workout Aid your Recovery 00:01:00 Workout Aim past your goal 00:01:00 Workout Air Your Dirty Laundry 00:01:00 Workout Avoid Tendinitis 00:01:00 Workout Back Flys 00:01:00 Workout Back to Comfort 00:01:00 Workout Be a Lightweight 00:01:00 Workout Be an Early Bird 00:01:00 Workout Be an Energizer Bunny 00:01:00 Workout Become a Better Runner 00:01:00 Workout Bike more Efficiently 00:01:00 Workout Bike Uphill Better 00:01:00 Workout Biking 00:01:00 Workout Break out the Cash 00:01:00 Workout Breathe as You Rise 00:01:00 Workout Build Your Back 00:01:00 Workout Catch Baseballs Better 00:01:00 Workout Catch the Spiral 00:01:00 Workout Chin-Ups 00:01:00 Workout Close Grip Bench 00:01:00 Workout Close Grip Lat Pull-Down 00:01:00 Workout Count Backwards from 100 00:01:00 Workout Create Constructive Sleep Habits 00:01:00 Workout Crumple and Crush 00:01:00 Workout Crunches 00:01:00 Workout Deadlift 00:01:00 Workout Dips 00:01:00 Workout Diversify for Ultimate Success 00:01:00 Workout Do it in Parts 00:01:00 Workout Elliptical 00:01:00 Workout Exercise Bike 00:01:00 Workout Incline Dumbbell Press 00:01:00 Workout Incline Reverse Flys 00:01:00 Workout Jump Rope 00:01:00 Workout Jumping Jacks 00:01:00 Workout Knee Push-Ups 00:01:00 Workout Leg Curls 00:01:00 Workout Leg Extensions 00:01:00 Workout Leg Press 00:01:00 Workout Leg Raises 00:01:00 Workout Lower Back Raises 00:01:00 Workout Lunges 00:01:00 Workout Military Press 00:01:00 Workout Oblique Crunches 00:01:00 Workout Oblique Sit-Ups 00:01:00 Workout Overhead Triceps Extension 00:01:00 Workout Preacher Curl 00:01:00 Workout Pull-Ups 00:01:00 Workout Push-Ups 00:01:00 Workout Runner 00:01:00 Workout Running Treadmill 00:01:00 Workout Seated Row 00:01:00 Workout Shoulder Press 00:01:00 Workout Side Dumbbell Raise 00:01:00 Workout Single Arm Curl 00:01:00 Workout Sit-ups 00:01:00 Workout Squats 00:01:00 Workout Triceps Kickback 00:01:00 Workout Upright Barbell Rows 00:01:00 Workout Walking 00:01:00 Workout Wide Grip Pull-Down 00:01:00 Assignment Assignment -Healthy Fitness 2 weeks, 1 day