• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

3154 Courses in Leeds delivered Online

The Complete Python 3 Course: Beginner to Advanced

4.3(43)

By John Academy

Description: This diploma in C++ and Python programming course is a great way to get started in programming. It covers the study of the C++ and Python group of languages used to build most of the world's object oriented systems. The course is for interested students with a good level of computer literacy who wish to acquire programming skills. It is also ideal for those who wish to move to a developer role or areas such as software engineering. This is a great course to develop your coding skills. It teaches key features of imperative programming using C and is an ideal preliminary to the Object-Oriented Programming using Python. Join the course now! Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Python 3 Beginners Module 01 Introduction FREE 00:29:00 Starter Examples 00:33:00 Learning C Concepts 00:13:00 Module 02 Data Types and Inference 00:20:00 Sizeof and IEEE 754 00:33:00 Constants L and R Values 00:11:00 Operators and Precedence 00:25:00 Literals 00:26:00 Module 03 Classes and Structs FREE 00:22:00 Enums 00:14:00 Unions 00:16:00 Introduction to Pointers 00:11:00 Pointers and Array Indexing 00:12:00 Using Const with Pointers 00:09:00 Pointers to String Literals 00:12:00 References 00:14:00 Smart Pointers 00:22:00 Arrays 00:15:00 Standard Library Strings 00:13:00 More Standard Library Strings 00:18:00 Functions 00:06:00 More Functions 00:16:00 Function Pointers 00:15:00 Control Statements 00:18:00 Python 3 Intermediate Module 04 Installing Python FREE 00:17:00 Documentation 00:30:00 Command Line 00:17:00 Variables 00:29:00 Simple Python Syntax 00:15:00 Keywords 00:18:00 Import Module 00:17:00 Additional Topics 00:23:00 Module 05 If Elif Else 00:31:00 Iterable 00:10:00 For 00:11:00 Loops 00:20:00 Execute 00:05:00 Exceptions 00:18:00 Data Types 00:24:00 Module 06 Number Types 00:28:00 More Number Types 00:13:00 Strings 00:20:00 More Strings 00:11:00 Files 00:08:00 Lists 00:15:00 Dictionaries 00:04:00 Tuples 00:07:00 Sets 00:09:00 Module 07 Comprehensions 00:10:00 Definitions 00:02:00 Functions 00:06:00 Default Arguments 00:06:00 Doc Strings 00:06:00 Variadic Functions 00:07:00 Factorial 00:07:00 Function Objects 00:07:00 Module 08 Lambda 00:11:00 Generators 00:06:00 Closures 00:10:00 Classes 00:09:00 Object Initialization 00:05:00 Class Static Members 00:07:00 Classic Inheritance 00:10:00 Data Hiding 00:07:00 Python 3 Advanced Iterators and Generators FREE 00:16:00 Regular Expressions 00:19:00 Introspection and Lambda Functions 00:27:00 Metaclasses and Decorators 00:24:00 Modules and Packages 00:25:00 Working with APIs 00:15:00 Metaprogramming Primer 00:19:00 Decorators and Monkey Patching 00:21:00 XML and JSON Structure 00:10:00 Generating XML and JSON 00:17:00 Parsing XML and JSON 00:19:00 Implementing Algorithms 00:19:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Complete Python 3 Course: Beginner to Advanced
Delivered Online On Demand19 hours 30 minutes
£11.99

Data Analyst Training: Microsoft Power BI at QLS Level 7 Diploma

By Imperial Academy

Bring Your Data To Life | Designed by Industry Specialist | Level 7 | QLS Endorsed Diploma | Certificate Included

Data Analyst Training: Microsoft Power BI at QLS Level 7 Diploma
Delivered Online On Demand
£150

Nutrition And Weight Management Course For Beginners

4.3(43)

By John Academy

Embark on a transformative journey with our 'Nutrition and Weight Management Course for Beginners.' Unlock the secrets of balanced nutrition, explore effective weight management strategies, and learn how to tailor dietary habits to different life stages and health conditions. Gain the knowledge and skills needed for a healthier lifestyle. Join us on this educational adventure towards a balanced and nourishing life. Enroll now!

Nutrition And Weight Management Course For Beginners
Delivered Online On Demand
£24.99

0G53BG IBM SPSS Statistics Essentials (V26)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for New users of IBM SPSS Statistics Users who want to refresh their knowledge about IBM SPSS Statistics Anyone who is considering purchasing IBM SPSS Statistics Overview Introduction to IBM SPSS Statistics Review basic concepts in IBM SPSS Statistics Identify the steps in the research process Review basic analyses Use Help Reading data and defining metadata Overview of data sources Read from text files Read data from Microsoft Excel Read data from databases Define variable properties Selecting cases for analyses Select cases for analyses Run analyses for groups Apply report authoring styles Transforming variables Compute variables Recode values of categorical and scale variables Create a numeric variable from a string variable Using functions to transform variables Use statistical functions Use logical functions Use missing value functions Use conversion functions Use system variables Use the Date and Time Wizard Setting the unit of analysis Remove duplicate cases Create aggregate datasets Restructure datasets Merging data files Add cases from one dataset to another Add variables from one dataset to another Enrich a dataset with aggregated information Summarizing individual variables Define levels of measurement Summarizing categorical variables Summarizing scale variables Describing the relationship between variables Choose the appropriate procedure Summarize the relationship between categorical variables Summarize the relationship between a scale and a categorical variable Creating presentation ready tables with Custom Tables Identify table layouts Create tables for variables with shared categories Create tables for multiple response questions Customizing pivot tables Perform Automated Output Modification Customize pivot tables Use table templates Export pivot tables to other applications Working with syntax Use syntax to automate analyses Create, edit, and run syntax Shortcuts in the Syntax Editor Controlling the IBM SPSS Statistics environment Set options for output Set options for variables display Set options for default working folders This course guides students through the fundamentals of using IBM SPSS Statistics for typical data analysis. Students will learn the basics of reading data, data definition, data modification, data analysis, and presentation of analytical results. In addition to the fundamentals, students will learn shortcuts that will help them save time. This course uses the IBM SPSS Statistics Base; one section presents an add-on module, IBM SPSS Custom Tables. Introduction to IBM SPSS Statistics Review basic concepts in IBM SPSS Statistics Identify the steps in the research process Review basic analyses Use Help Reading data and defining metadata Overview of data sources Read from text files Read data from Microsoft Excel Read data from databases Define variable properties Selecting cases for analyses Select cases for analyses Run analyses for groups Apply report authoring styles Transforming variables Compute variables Recode values of categorical and scale variables Create a numeric variable from a string variable Using functions to transform variables Use statistical functions Use logical functions Use missing value functions Use conversion functions Use system variables Use the Date and Time Wizard Setting the unit of analysis Remove duplicate cases Create aggregate datasets Restructure datasets Merging data files Add cases from one dataset to another Add variables from one dataset to another Enrich a dataset with aggregated information Summarizing individual variables Define levels of measurement Summarizing categorical variables Summarizing scale variables Describing the relationship between variables Choose the appropriate procedure Summarize the relationship between categorical variables Summarize the relationship between a scale and a categorical variable Creating presentation ready tables with Custom Tables Identify table layouts Create tables for variables with shared categories Create tables for multiple response questions Customizing pivot tables Perform Automated Output Modification Customize pivot tables Use table templates Export pivot tables to other applications Working with syntax Use syntax to automate analyses Create, edit, and run syntax Shortcuts in the Syntax Editor Controlling the IBM SPSS Statistics environment Set options for output Set options for variables display Set options for default working folders Additional course details: Nexus Humans 0G53BG IBM SPSS Statistics Essentials (V26) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 0G53BG IBM SPSS Statistics Essentials (V26) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

0G53BG IBM SPSS Statistics Essentials (V26)
Delivered OnlineFlexible Dates
Price on Enquiry

Business Analytics for Beginners Using SASS Course

By One Education

Ready to dive into the numbers without getting buried in them? This course offers a smart introduction to the world of business analytics using SASS — a widely respected tool in the data analysis landscape. Whether you're navigating spreadsheets or spreadsheets are navigating you, this course will help you make sense of the noise and focus on what matters: informed decisions based on accurate analysis. You'll explore key analytics techniques through SASS that help organisations stay ahead in a data-driven marketplace. Designed for those with an interest in decoding business performance, the course walks you through data manipulation, statistical reporting, and pattern identification using SASS. With each module, you'll gain clarity in how data speaks and how to interpret it without needing a PhD in number crunching. It’s approachable, strategic, and ideal for anyone curious about data-driven business decisions — minus the complicated jargon or tangled cables. Learning Outcomes: Understand the basics of SAS data analysis Work with SAS datasets and raw data files Use option statements, ODS statements, and date functions to streamline data analysis Learn how to use multiple SAS datasets to enhance data analysis Develop effective data analysis strategies using SAS Our Business Analytics for Beginners Using SAS course is designed to help you gain a deeper understanding of data analysis using SAS. With 13 comprehensive modules, you will learn how to work with SAS datasets and raw data files, use option statements and ODS statements to streamline your data analysis process, and use date functions to analyse time-based data. You will also learn how to use multiple SAS datasets to enhance your data analysis and develop effective data analysis strategies using SAS. This course is perfect for recent graduates, entry-level data analysts, and professionals looking to enhance their data analysis skills. Whether you're just starting out in the world of data analysis or are an experienced professional looking to take your skills to the next level, this course will provide you with the tools you need to succeed. Business Analytics for Beginners Using SASS Course Curriculum Section 01: Introduction Section 02: SAS Dataset Section 03: Raw Data File Standard And Example Section 04: Raw Data File Non Standard Section 05: Append Section 06: Option Statements Section 07: Title n Foot Note Section 08: ODS statements Section 09: Date Functions Section 10: Multiple SAS datasets Section 11: Select Group Section 12: Do Loop Section 13: Array How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Recent graduates looking to start a career in data analysis Entry-level data analysts looking to enhance their skills Professionals looking to transition into the field of data analysis Business owners looking to gain a deeper understanding of data analysis Students looking to explore the field of data analysis Career path Data Analyst: £25,000 - £40,000 Business Analyst: £30,000 - £55,000 Marketing Analyst: £25,000 - £45,000 Data Scientist: £40,000 - £80,000 Senior Business Analyst: £50,000 - £90,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Business Analytics for Beginners Using SASS Course
Delivered Online On Demand8 hours
£12

Accredited Microsoft Excel 2010 for Beginners

By iStudy UK

As the most-used spreadsheet program in the world, learning how to use the Microsoft Excel will give you an advantage. This Microsoft Excel 2010 Essentials course is created to help you in learning the basics and importance of this program. In this course, you will learn the necessary skills, knowledge and information about how to plan and organise your data using the tools in this program. Learn the basics and common functions of Microsoft Excel that will help you finish your tasks faster. You will learn writing the right formula and functions that can save you time and become more productive in your work. Course Highlights Accredited Microsoft Excel 2010 for Beginners is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Microsoft Excel 2010 for Beginners into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 10 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Microsoft Excel 2010 for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Microsoft Excel 2010 for Beginners is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Accredited Microsoft Excel 2010 for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Accredited Microsoft Excel 2010 for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Excel FREE 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Accredited Microsoft Excel 2010 for Beginners 00:00:00 Mock Exam Mock Exam- Accredited Microsoft Excel 2010 for Beginners 00:20:00 Final Exam Final Exam- Accredited Microsoft Excel 2010 for Beginners 00:20:00

Accredited Microsoft Excel 2010 for Beginners
Delivered Online On Demand11 hours 10 minutes
£25

Child Counselling & DBT - CPD Certified

4.7(47)

By Academy for Health and Fitness

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that 1 in 10 children in the UK experience a mental health issue? If you work with children or young people, you may find yourself supporting those going through difficult times. This course bundle equips you with the knowledge and skills to navigate these situations effectively. Are you ready to make a positive impact on the lives of young people? This comprehensive Child Counselling & DBT bundle delves into the realms of child counselling, Dialectical Behaviour Therapy (DBT), cognitive Behavioural Therapy (CBT), and executive function development in children. You will learn about counselling approaches specifically designed for children and youth, addressing their emotional, behavioural, and developmental needs. Additionally, you'll gain insights into DBT and CBT, evidence-based therapies that can effectively treat a range of mental health conditions, including emotional dysregulation, anxiety, and depression. This Child Counselling & DBT Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Child Counselling Course 02: Diploma in Dialectical Behaviour Therapy (DBT) Course 03: Cognitive Behavioural Therapy Course Course 04: Executive Functions in Child Development Invest in your professional growth and embark on a career path that combines compassion, expertise, and a commitment to promoting positive mental health and well-being for the younger generation. Learning Outcomes of Child Counselling & DBT Develop expertise in child counselling techniques and youth interventions. Understand Dialectical Behaviour Therapy (DBT) and its applications. Learn Cognitive Behavioural Therapy (CBT) principles and practices. Gain insights into executive function development in children. Implement evidence-based therapies for mental health and behavioural challenges. Acquire essential skills for supporting child and adolescent well-being. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Child Counselling & DBT Get a free student ID card with Child Counselling & DBT Training program (£10 postal charge will be applicable for international delivery) The Child Counselling & DBT is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Child Counselling & DBT course materials The Child Counselling & DBT comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Child Counselling Module 01: Introduction To Counselling Module 02: Focusing Module 03: Assessment Module 04: Introduction To Child Psychology Module 05: Problems Of Childhood Module 06: Relationships Between Children And Parents Module 07: Understanding Between Children And Parents Module 08: Impacts Of Separation And Loss On Attachment Module 09: The Impact Of Child Neglect Module 10: Cyberbullying Module 11: Appropriate Questioning Module 12: Silence In Counselling Module 13: The Skill Of Confrontation Module 14: The Skill Of Simile And Metaphor Course 02: Diploma in Dialectical Behaviour Therapy (DBT) Introduction What Is Counselling & Psychotherapy About Dialectical Behaviour Therapy (DBT) DBT Strategies & 'Life Skills' Treatment By DBT DBT For Psychological Disorders Effectiveness Of DBT Course 03: Cognitive Behavioural Therapy Course Module 01: Introduction To CBT Module 02: CBT Theories And Principles Module 03: CBT Tools And Strategies Module 04: CBT Process Module 05: CBT For Personal Growth Module 06: Overcoming Anxiety And Depression Module 07: CBT For Children With Autism Course 04: Executive Functions in Child Development Introduction Part 1 Introduction Part 2 Lecture 1: Definition of Executive Lecture 2: Components of Executive Lecture 3.1: Development Of Executive Lecture 3.2: Affective Factors of Executive Functions Development Lecture 4: Importance of Executive Lecture 5: Assessment of Executive Lecture 6.1: Approaches that Import Lecture 6.2: Long-Term School-based Education Programs =========>>>>> And 2 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*4 = £51) CPD Hard Copy Certificate: £29.99 CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Teachers Counsellors Youth Workers Social Workers Parents Carers Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Child Therapist School Counsellor Educational Psychologist Social Worker Youth Worker Family Support Worker Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

Child Counselling & DBT - CPD Certified
Delivered Online On Demand23 hours
£25

Excel 2016 Advanced

By iStudy UK

If you are looking forward to advance your skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface, this Excel 2016 Advanced will be the perfect choice for you! Through the course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Additionally, you will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in your worksheets and workbooks. You will also learn about Excel's many collaboration features, as well as how to import and export data to and from your workbooks. What Will I Learn? Use Advanced IF Statements Use Advanced Lookup Functions Use Complex Logical and Text Functions Auditing Formulas Working with What-If Analysis Tools Protecting Worksheet and Workbook Use Advanced PivotTables and PowerPivot Tools Automate with Macros Work with Form Controls Ensure Data Integrity Collaborate in Excel Import and Export Data to a Text File Requirements Excel Introduction and Intermediate courses or equivalent experience. Who is the target audience? Students who want to expand their Excel knowledge. Introduction Introduction FREE 00:01:00 Using Advanced IF Statements Summarize Data with SUMIF FREE 00:04:00 Summarize Data with AVERAGIF 00:03:00 Summarize Data with COUNTIF 00:02:00 Using Advanced Lookup Functions Using VLOOKUP with TRUE to find an Approximate Match 00:04:00 Using HLOOKUP TRUE to find an Approximate Match 00:01:00 Using the Index Function 00:03:00 Using the Match Function 00:02:00 Creating a Combined Index and Match Formula 00:04:00 Comparing Two Lists with VLOOKUP 00:02:00 Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Using Complex Logical and Text Functions Creating a Nested IF Function 00:03:00 Using the IFERROR Function 00:02:00 Using the LEN Function 00:02:00 Using the TRIM Function 00:01:00 Using the Substitute Function 00:02:00 Formula Auditing Showing Formulas 00:01:00 Tracing Cell Precedents and Dependents 00:03:00 Adding a watch Window 00:02:00 Error Checking 00:02:00 What-If Analysis Tools Using the Scenario Manager 00:03:00 Using Goal Seek 00:02:00 Analyzing with Data Tables 00:02:00 Worksheet and Workbook Protection Protection Overview 00:02:00 Excel File Password Encryption 00:03:00 Allowing Specific Worksheet Changes 00:01:00 Adding Protection to only Certain Cells in a Worksheet 00:03:00 Additional Protection Features 00:02:00 Advanced Use of PivotTables and PowerPivot Using the Pivot Tables Charts Wizard 00:02:00 Adding a Calculated Field 00:02:00 Adding a Caculated Item 00:02:00 Apply Conditional Formatting to a Pivot Table 00:03:00 Using Filters in the Pivot Table Fields Pane 00:02:00 Creating Filter Pages for a Pivot Table 00:01:00 Enabling a Power Pivot Add In 00:04:00 Automating with Macros What are Macros 00:03:00 Displaying the Developer Tab and Enabling Macros in Excel 00:03:00 Creating a Basic Formatting Macro 00:03:00 Running a Macro 00:02:00 Assigning a Macro to a Button 00:02:00 Creating a More Complex Macro 00:02:00 Viewing and Editing the VBA Code for an Existing Macro 00:03:00 Adding a Macro to the Quick Access Toolbar 00:02:00 Working with Form Controls What are Form Controls 00:02:00 Adding Spin Buttons and Check Boxes to a Spreadsheet 00:02:00 Adding a Combo Box to a Spreadsheet 00:02:00 Ensuring Data Integrity What is Data Validation 00:01:00 Restricting Data Entries to Whole Numbers 00:02:00 Data Validation Restricting Data Entry to a List 00:01:00 Data Validation Restricting Data Entry to a Date 00:01:00 Data Validation Restricting Data Entry to Different Text Lengths 00:01:00 Composing Input Messages 00:02:00 Composing Error Alters 00:02:00 Finding Invalid Data 00:02:00 Editing and Deleting Data Validation Rules 00:01:00 Collaborating in Excel Working with Comments 00:03:00 Printing Comments and Errors 00:02:00 Sharing a Workbook 00:03:00 Tracking Changes in a Workbook 00:03:00 Working with Versions 00:02:00 Sharing Files via Email 00:02:00 Importing and Exporting Data to a Text File Importing a Text File 00:03:00 Exporting a Text File 00:01:00 Conclusion Course Recap 00:01:00 Course Certification

Excel 2016 Advanced
Delivered Online On Demand2 hours 21 minutes
£25

Skincare, Dermatology and Hair Fall Care Diploma

5.0(1)

By Empower UK Employment Training

Skincare, Dermatology and Hair Fall Care Diploma Welcome to the Skincare, Dermatology and Hair Fall Care Diploma course, your go-to resource for mastering the science and art of maintaining healthy skin and hair. Whether you are a skincare enthusiast, aspiring dermatologist, or someone looking to find effective solutions for skin and hair issues, this course offers the knowledge and techniques you need. Learning Outcomes: Acquire an in-depth understanding of the structure and functions of the skin and hair. Gain insights into personalized skincare for different skin types. Discover evidence-based anti-aging skincare strategies. Understand common skin diseases and their management. Learn the reasons behind hair graying and hair fall. Comprehend the role of nutrition in maintaining healthy skin and hair. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Skincare, Dermatology and Hair Fall Care Diploma: Structure and Functions: Begin your exploration into the world of dermatology by understanding the anatomical structure and physiological functions of skin. Skincare for Different Skin Types: Personalize your skincare regimen by learning how to identify and treat different skin types effectively. Anti-Aging Skincare: Unlock the secrets of maintaining youthful skin through scientifically proven anti-aging skincare practices. Common Skin Diseases: Gain expertise in identifying and managing prevalent skin diseases, empowering you to seek appropriate treatment. Causes of Hair Graying: Discover the underlying factors contributing to hair graying and how to manage this natural process gracefully. Nutrition and Hair Health: Uncover the impact of nutrition on the quality of your hair and learn how to sustain its health through balanced dietary practices.

Skincare, Dermatology and Hair Fall Care Diploma
Delivered Online On Demand3 hours 12 minutes
£5

Microsoft SQL Server Development for Everyone

4.9(27)

By Apex Learning

Overview This comprehensive course on Microsoft SQL Server Development for Everyone will deepen your understanding on this topic .After successful completion of this course you can acquire the required skills in this sector. This Microsoft SQL Server Development for Everyone comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft SQL Server Development for Everyone . It is available to all students, of all academic backgrounds. Requirements Our Microsoft SQL Server Development for Everyone is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 31 lectures • 05:48:00 total length •Introduction to SQL Server and Databases: 00:04:00 •Download and Install SQL Server Express: 00:05:00 •Connect to Database Instance and Create a Database: 00:06:00 •Drop or Remove Database: 00:04:00 •What is a Database Table?: 00:02:00 •Create an SQL Database Table: 00:32:00 •Insert Data into the Table with SQL Script: 00:15:00 •Insert Data into the Table with Management Studio: 00:05:00 •Select Data from the Table with SQL Script: 00:09:00 •More Advanced Select Queries Part 1: 00:18:00 •Update Data in the Table: 00:10:00 •Update Data in the Table with Management Studio GUI: 00:02:00 •Delete Data from the Table with SQL Script: 00:06:00 •Delete Data from the Table with Management Studio GUI: 00:01:00 •What are Relationships, Foreign Keys and Normalization: 00:11:00 •Create a Relationship in SQL Server: 00:19:00 •Insert Records in Related Tables: 00:13:00 •Run Queries on Related Tables: 00:19:00 •Left, Right and Full Joins: 00:11:00 •Grouping Data using SQL GROUP BY Clause: 00:12:00 •SQL AVG Aggregate Function: 00:11:00 •SQL COUNT Aggregate Function: 00:04:00 •SQL MAX and MIN Aggregate Functions: 00:04:00 •SQL SUM Aggregate Function: 00:04:00 •Create and Manage Views: 00:23:00 •Scalar Valued Functions: 00:27:00 •Inline Table Valued Functions: 00:09:00 •Stored Procedures: 00:28:00 •Table Triggers: 00:19:00 •Database Scripting, Backup and Restore: 00:15:00 •Assignment - Microsoft SQL Server Development for Everyone: 00:00:00

Microsoft SQL Server Development for Everyone
Delivered Online On Demand5 hours 48 minutes
£12