919 Logic courses in London delivered On Demand

Learning Objectives Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion   Pre-Requisites Intermediate Microsoft Excel training or equivalent experience is recommended.   Description This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code. Course Introduction Introduction 00:03:00 Section 01 Lesson 1-Adding the Developer Toolbar 00:05:00 Lesson 2-Understanding the VBA Editor 00:11:00 Lesson 3-Recording a Macro in Personal 00:10:00 Lesson 4-Understanding the Elements of the VBA Language 00:07:00 Lesson 5-Understanding Methods 00:05:00 Lesson 6-Understanding Comments 00:06:00 Lesson 7-Working with the Range Property and Worksheet Object 00:07:00 Lesson 8-Adding a Macro Button to a Spreadsheet 00:03:00 Lesson 9-Working with the ActiveCell Object 00:02:00 Lesson 10-Working with the Offset Property 00:08:00 Section 02 Lesson 1-Understanding Variables 00:07:00 Lesson 2-Working with Integer Variables 00:03:00 Lesson 3-Understanding Option Explicit 00:05:00 Lesson 4-Working with Other Variable Types 00:07:00 Section 03 Lesson 1-Working with IF Statements 00:04:00 Lesson 2-Working with ELSE 00:03:00 Lesson 3-Working with ELSEIF 00:03:00 Lesson 4-Understanding Conditional Operators 00:06:00 Lesson 5-Working with NOT, AND, and OR 00:07:00 Lesson 6-Working with Nested IF 00:04:00 Lesson 7-Working with Select Case 00:06:00 Lesson 8-Working with WITH and END WITH 00:05:00 Section 04 Lesson 1-Working with Text Strings 00:05:00 Lesson 2-Working with LCASE and UCASE Functions 00:05:00 Lesson 3-Working with LEN and TRIM Functions 00:07:00 Lesson 4-Working with LEFT, RIGHT, and MID Functions 00:07:00 Section 05 Lesson 1-Understanding Loops 00:02:00 Lesson 2-Working with For Next Loops 00:07:00 Lesson 3-Working with For Each Loops 00:06:00 Lesson 4-Working with Cells Property 00:08:00 Lesson 5-Working with Do Until Loops 00:09:00 Lesson 6-Working with Do While Loops 00:05:00 Section 06 Lesson 1-Calling Sub Procedures 00:05:00 Lesson 2-Working with Exit Sub 00:04:00 Lesson 3-Working with Message Boxes 00:08:00 Lesson 4-Working with Input Boxes 00:08:00 Lesson 5-Working with VBA Functions 00:12:00 Lesson 6-Working with Object Variable and Set 00:06:00 Section 07 Lesson 1-Understanding and Creating a User Form 00:08:00 Lesson 2-Adding Controls to a User Form 00:16:00 Lesson 3-Adding Code for a User Form 00:10:00 Lesson 4-Launching a User Form from Excel 00:05:00 Section 08 Lesson 1-Getting Started with Debugging 00:10:00 Lesson 2-Stepping Through Your Code 00:06:00 Lesson 3-Working with Breakpoints 00:03:00 Lesson 4-Working with the Immediate Window 00:05:00 Lesson 5-Working with the Locals Window 00:05:00 Lesson 6-Working with the Err Object 00:06:00 Lesson 7-Getting Help-v2 00:07:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 VBA Expert 00:00:00 Final Exam Final Exam - Excel 365 VBA Expert 00:20:00

Develop an Endless Runner game to get familiar with the interface and game development process while learning how to use Unreal Engine 5. Even if an endless runner game isn't your interest, this course provides the steps necessary to create a video game from start to finish. Explore fundamental concepts about game-making and utilize that knowledge in your future projects.

Level 3 & 5 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

This course is an excellent resource to learn network programming using Python. With the help of practical examples, you will learn how to automate networks with Telnet, Secure Shell (SSH), Paramiko, Netmiko, and Network Automation and Programmability Abstraction Layer with Multivendor support (NAPALM).

Overview Learn how to become an exemplary Receptionist and positively represent your company when interacting with all clients and customers. Every business needs an efficient administrator to manage the Front-Office, along with providing support and assistance to their boss. We can coach you to become an excellent Receptionist and gain all the required business skills that you'll need to succeed, and the confidence with which to use them. Description The course has been compiled by industry experts and provides an overview of the responsibilities of a valued Receptionist. You will be tutored in a wide range of administrative practises, so that you can immediately start to use them in the office. It also includes training in customer-facing etiquette and suggestions on how to positively improve your company's reputation with clients. Various other crucial office aptitudes will be covered, such as; Time Management, Travel Arrangement, Record Keeping, and Business Writing. Make sure you present the efficiency of your company by enrolling now. Learning outcomes:  Understand the basic requirements needed to run receptions areas efficiently Gain the all-round skills to be a first-class Receptionist Learn how to represent your boss and company in reception Be skilled in organising travel and arranging executive meetings for others Attain the ability to file and retrieve essential company records Acquire the skills to apply excellent communicate practises at work Display great customer service for clients and colleagues Be trusted to handle internal finances and petty cash funding Why People Love And Enrol In The Receptionist Skills From Studyhub: Instantly accessible CPD-accredited certificate on successful completion of this Receptionist Skills 24/7 access to the course for 12 months Study at your own pace No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) Efficient assessment and instant results Method of Assessment To assess your learning, you have to participate in an automated multiple-choice question exam. You have to score at least 60% to pass the exam and to qualify for CPD accredited certificates. After passing the exam, you will be able to apply for a certificate. To enhance your knowledge regarding the course and to further assess your learning, you are advised to complete the assignment questions provided at the end of the course, which you can complete anytime you wish.  After submitting the assignment, our expert tutor will assess your assignment and will give you feedback on your performance. Certification After completing the MCQ assessment, you will qualify for the CPD Certificate from Studyhub, as proof of your continued professional development. Certification is available in PDF format, for £9, or a hard copy can be sent to you via post, for just £15. Who is This course for? This course is primarily designed to provide coaching and training for those individuals who aspire to work as Receptionists or a similar role such as a Secretary or PA. Requirements There are no specific prerequisites to enrol in this Receptionist Skills. Anyone and everyone can take this course. The Receptionist Skills is fully accessible from any internet-enabled smart device. So, you can study from the comfort of your home! All you need is a passion for learning, literacy, and to be over the age of 16. Career Path This course provides training and a comprehensive overview of all the skills and knowledge that are needed by a Receptionist or a similar administrative role. As such, it will cover the following roles and careers:  Receptionist Administrative Manager Personal Assistant Private Secretary Human Resources staff Course Curriculum Office Admin and Reception Module 1: Introduction to Reception and Receptionist 00:11:00 Module 2: Business Telephone Skills 00:19:00 Module 3: Representing Your Boss and Company 00:34:00 Module 4: Mail Services and Shipping 00:25:00 Module 5: Travel Arrangements 00:24:00 Module 6: Organising Meeting and Conferences 00:25:00 Module 7: Time Management 00:35:00 Module 8: Record Keeping and Filing Systems 00:28:00 Module 9: Business Writing Skills 00:40:00 Module 10: Organisational Skills 00:25:00 Module 11: Communication Skills 00:25:00 Module 12: Customer Service 00:16:00 Module 13: Effective Planning and Scheduling 00:46:00 Module 14: Invoicing/Petty Cash 00:27:00 Module 15: Business Environment 00:19:00 Advanced MS Excel How to Get the most of the course 00:01:00 Text formulas in Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise (answers) 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise (answers) 00:01:00 Date and Time Formulas In Excel 00:06:00 Date and Time Formulas Exercise 00:01:00 Date and Time Exercise Formulas (answers) 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formula Exercise 00:01:00 Logic Formula Exercise (answers) 00:01:00 Financial Formula In Excel 00:06:00 Financial Formula Exercise 00:01:00 Financial Formula Exercise (answers) 00:02:00 Informational Formula In Excel 00:04:00 Informational Formula Exercise 00:01:00 Informational Formula Exercise (answers) 00:01:00 Getting Traffic To Your Site 01:00:00 Menu Example with Excel Vlookup 00:08:00 Wildcard Search with Excel Vlookup 00:09:00 Looking to the Left with Excel Vlookup 00:17:00 2-Way Lookup 00:14:00 Comparing Lists with Excel Vlookup 00:03:00 Microsoft Excel Vlookup Tips and Tricks 00:14:00 Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Enabling M in Power Query 00:02:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Simple Expressions 00:08:00 Simple Expressions - Nested Expressions 00:03:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Variables 00:08:00 Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Mock Exam Mock Exam - Office Admin and Reception 00:20:00 Final Exam Final Exam - Office Admin and Reception 00:20:00

Kickstart your career with this Salesforce Platform App Builder Certification program. Salesforce skills are in high demand, and you can learn the core concepts of online application development using Salesforce App Builder and Force.com Platform Fundamentals.

Develop a blockchain notary office on Ethereum and learn all about Solidity, Remix, Ganache, Geth, Metamask, and Truffle

Start your journey with the amazing Arduino development platform

Discrete Maths Teaching is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Discrete Maths Teaching and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 19 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Sets Introduction to Sets 00:01:00 Definition of Set 00:09:00 Number Sets 00:10:00 Set Equality 00:09:00 Set-Builder Notation 00:10:00 Types of Sets 00:12:00 Subsets 00:10:00 Power Set 00:05:00 Ordered Pairs 00:05:00 Cartesian Products 00:14:00 Cartesian Plane 00:04:00 Venn Diagrams 00:03:00 Set Operations (Union, Intersection) 00:15:00 Properties of Union and Intersection 00:10:00 Set Operations (Difference, Complement) 00:12:00 Properties of Difference and Complement 00:07:00 De Morgan's Law 00:08:00 Partition of Sets 00:16:00 Logic Introduction 00:01:00 Statements 00:07:00 Compound Statements 00:13:00 Truth Tables 00:09:00 Examples 00:13:00 Logical Equivalences 00:07:00 Tautologies and Contradictions 00:06:00 De Morgan's Laws in Logic 00:12:00 Logical Equivalence Laws 00:03:00 Conditional Statements 00:13:00 Negation of Conditional Statements 00:10:00 Converse and Inverse 00:07:00 Biconditional Statements 00:09:00 Examples 00:12:00 Digital Logic Circuits 00:13:00 Black Boxes and Gates 00:15:00 Boolean Expressions 00:06:00 Truth Tables and Circuits 00:09:00 Equivalent Circuits 00:07:00 NAND and NOR Gates 00:07:00 Quantified Statements - ALL 00:08:00 Quantified Statements - THERE EXISTS 00:07:00 Negations of Quantified Statements 00:08:00 Number Theory Introduction 00:01:00 Parity 00:13:00 Divisibility 00:11:00 Prime Numbers 00:08:00 Prime Factorisation 00:09:00 GCD & LCM 00:17:00 Proof Intro 00:06:00 Terminologies 00:08:00 Direct Proofs 00:09:00 Proofs by Contrapositive 00:11:00 Proofs by Contradiction 00:17:00 Exhaustion Proofs 00:14:00 Existence & Uniqueness Proofs 00:16:00 Proofs by Induction 00:12:00 Examples 00:19:00 Functions Intro 00:01:00 Functions 00:15:00 Evaluating a Function 00:13:00 Domains 00:16:00 Range 00:05:00 Graphs 00:16:00 Graphing Calculator 00:06:00 Extracting Info from a Graph 00:12:00 Domain & Range from a Graph 00:08:00 Function Composition 00:10:00 Function Combination 00:09:00 Even and Odd Functions 00:08:00 One to One (Injective) Functions 00:09:00 Onto (Surjective) Functions 00:07:00 Inverse Functions 00:10:00 Long Division 00:16:00 Relations Intro 00:01:00 The Language of Relations 00:10:00 Relations on Sets 00:13:00 The Inverse of a Relation 00:06:00 Reflexivity, Symmetry and Transitivity 00:13:00 Examples 00:08:00 Properties of Equality & Less Than 00:08:00 Equivalence Relation 00:07:00 Equivalence Class 00:07:00 Graph Theory Intro 00:01:00 Graphs 00:11:00 Subgraphs 00:09:00 Degree 00:10:00 Sum of Degrees of Vertices Theorem 00:23:00 Adjacency and Incidence 00:09:00 Adjacency Matrix 00:16:00 Incidence Matrix 00:08:00 Isomorphism 00:08:00 Walks, Trails, Paths, and Circuits 00:13:00 Examples 00:10:00 Eccentricity, Diameter, and Radius 00:07:00 Connectedness 00:20:00 Euler Trails and Circuits 00:18:00 Fleury's Algorithm 00:10:00 Hamiltonian Paths and Circuits 00:06:00 Ore's Theorem 00:14:00 The Shortest Path Problem 00:13:00 Statistics Intro 00:01:00 Terminologies 00:03:00 Mean 00:04:00 Median 00:03:00 Mode 00:03:00 Range 00:08:00 Outlier 00:04:00 Variance 00:09:00 Standard Deviation 00:04:00 Combinatorics Intro 00:03:00 Factorials 00:08:00 The Fundamental Counting Principle 00:13:00 Permutations 00:13:00 Combinations 00:12:00 Pigeonhole Principle 00:06:00 Pascal's Triangle 00:08:00 Sequence and Series Intro 00:01:00 Sequence 00:07:00 Arithmetic Sequences 00:12:00 Geometric Sequences 00:09:00 Partial Sums of Arithmetic Sequences 00:12:00 Partial Sums of Geometric Sequences 00:07:00 Series 00:13:00

Deal Price is Active! Save Now- £403! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Forensic Psychology: Criminal Profiling Course might help you get there! Expand your expertise with high-quality training - study Forensic Psychology: Criminal Profiling and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This online training course is accredited by CPD with 10 CPD points for professional development. Students can expect to complete this Forensic Psychology: Criminal Profiling training course in around 03 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our Forensic Psychology: Criminal Profiling course. You'll get a Free Student ID card by enrolling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. This training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join the course today - gear up with the essential skills to set yourself up for excellence! Please note that this course does not entitle you to join the HCPC register or recognised Practitioner Psychologists. But you will come across all the basic guidelines of Psychology to boost and shine your knowledge in this particular field of Psychology. Experts created the course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! Why Prefer this Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** Forensic Psychology: Criminal Profiling Course Module 01: Understanding Criminal Psychology The Criminal Process Varieties of Crime Explanations of Crime Crime Psychology Research Areas of Contribution Summary Module 02: Influence of Mental Disorders Aggression and Its Types Mental Illness Anxiety and Mood Disorders Schizophrenia and Psychotic Disorders Relationship of Aggression and Mental Illness Causation and Criminal Responsibility Personality Disorder Summary Module 03: Classification of Crime Misdemeanours and Felonies Personal Crimes Property Crimes Inchoate Crimes White Collar Crimes Summary Module 04: Forensic Science Forensics and Its Origin Forensic Pathology and Autopsies Toxicology Ballistics Anthropometry Fingerprints Summary Module 5: Criminal Profiling: Science, Logic and Metacognition Bias Science and Scientific Method Logic Metacognition Summary Module 6: Phases of Profiling Examining of Evidence Classification of Evidence Reconstruction Examining the Offender's Signature Generating a Profile Summary Module 7: Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice Traditional Approaches to Offender Profiling Behavioural Investigative Advisers: The Way they can Contribute BIA: Contribution Summary Module 08: Victimology Victims Consequences of Crime for Victims Victim Proneness Victim Facilitation Victim Rights Summary Module 09: The Criminal Justice System in England and Wales Introduction The Criminal Courts Police and Policing The Crown Prosecution Service Prisons and the Prison Service Summary Assessment Process Once you have finished the learning stages in the course, your abilities will be assessed by an automated multiple-choice question session, after which you will receive the results immediately. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This has been professionally designed for motivated learners who are looking to gain an essential understanding of the topic. Enrol on and learn a topic from anywhere, at any time! Disclaimer: Kindly be informed that completing this online course does not grant you the authority to practice as a Licensed Psychologist. If you are searching for a course that fulfills the HCPC's standards, please contact the HCPC or the RCSLT. Requirements Enrol on Forensic Psychology: Criminal Profiling with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the without any delay. We only ask that all students have a passion for learning and literacy, and be over the age of 16. Complete the online from your computer, tablet, or smartphone, and learn in a way that suits you. Career path After completing this Course, you are to start your career or begin the next phase of your career in this field. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.