1816 Courses delivered Online

Overview This comprehensive course on Legal Secretary and Office Skills Diploma will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Legal Secretary and Office Skills Diploma comes with accredited certification, 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 Legal Secretary and Office Skills Diploma. It is available to all students, of all academic backgrounds. Requirements Our Legal Secretary and Office Skills Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 52 lectures • 07:53:00 total length •Module 01: Introduction to Legal Secretary: 00:22:00 •Module 02: English Law & Legal Systems: 00:33:00 •Module 03: The Legal Workplace & Professionals: 00:45:00 •Module 04: Law of Contract & Law of Tort: 00:28:00 •Module 05: Wills, Probate and Estate Law Practice: 00:15:00 •Module 06: Property Law & Conveyancing Practice: 00:19:00 •Module 07: Family Law and Insurance Practice: 00:24:00 •Module 08: Professional Writings and Documents: 00:27:00 •Module 09: Document Proofreading and Editing: 00:19:00 •Module 10: Meeting Management & Minute Taking: 01:06:00 •Module 11: Customer Service and Telephone Handling Skills: 00:21:00 •Module 12: Data Management and Record-Keeping: 00:13:00 •Module 13: Other Essential Skills for Secretarial Role: 00:19:00 •Module 14: Professional Conduct and Ethics: 00:25:00 •New Word Document and Templates: 00:02:00 •Tabs, Ribbons and Groups: 00:03:00 •Zoom and Rulers in Word: 00:02:00 •Editing the Word Document: 00:03:00 •Insert Pictures with Word: 00:05:00 •Insert Shape and Text Box in Word: 00:02:00 •Review Tab in Word: 00:03:00 •Layout in Word: 00:02:00 •File Options in Word: 00:02:00 •Closing and Reopening in Word: 00:01:00 •New PowerPoint Presentation and Templates: 00:02:00 •Tabs Ribbons and Groups in PowerPoint: 00:03:00 •First Slide and Designing the Slide: 00:02:00 •Home Tab and Updates in PowerPoint: 00:02:00 •Buttons in PowerPoint: 00:01:00 •Inserting Pictures in PowerPoint: 00:04:00 •Presentation Mode: 00:01:00 •Animations Tab: 00:05:00 •File Options in Word: 00:02:00 •Closing and Reopening in Word: 00:01:00 •Setting Up Outlook with Accounts: 00:03:00 •Tabs, Ribbons and Groups in Outlook: 00:03:00 •Navigation Bar in Outlook: 00:01:00 •Organizing Outlook with Favorites and Folders: 00:03:00 •Additional Options inside Outlook Tabs: 00:01:00 •Reading, Writing and Receiving Emails: 00:08:00 •Attaching Items in Outlook Mails: 00:03:00 •The View Tab in Outlook: 00:02:00 •Create a Rule to move emails to a folder: 00:04:00 •Insert a screen shot from Excel: 00:02: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 •Assignment - Legal Secretary and Office Skills Diploma: 00:00:00 •Order Your Certificate: 00:00:00

Overview Every legal executive and busy solicitor needs an efficient Legal Secretary in their office, and you get the training and confidence to take that role. This comprehensive course is designed to give you the abilities and knowledge to work in a law firm, regardless of your current experience in this area. The Legal Secretaries Advanced Diploma course contains a range of modules that will rapidly teach you the skills needed to succeed in law office administration. You will learn how to produce, update, and distribute forms that will form the basis of contracts. Additionally, you will gain extensive knowledge of the UK Justice System. 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 Legal Secretaries Advanced Diploma. It is available to all students, of all academic backgrounds. Requirements Our Legal Secretaries Advanced Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 65 lectures • 14:00:00 total length •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:30: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: 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 •Minute Taking tips: 00:30:00 •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 •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 •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 •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 •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 - Legal Secretaries Advanced Diploma: 00:20:00 •Final Exam - Legal Secretaries Advanced Diploma: 00:20:00

Overview This comprehensive course on Night Photography will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Night Photography comes with accredited certification, 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 Night Photography. It is available to all students, of all academic backgrounds. Requirements Our Night Photography is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 10 sections • 60 lectures • 04:21:00 total length •Module 1: Introduction to the Course: 00:02:00 •Module 2: What is Night Photography: 00:01:00 •Module 1: Photography Equipment Introduction: 00:01:00 •Module 2: Camera: 00:02:00 •Module 3: Sensor Size: 00:03:00 •Module 4: Lenses: 00:03:00 •Module 5: Prime VS Zoom: 00:02:00 •Module 6: Tripods: 00:02:00 •Module 7: Filters: 00:02:00 •Module 8: Accessories: 00:05:00 •Module 1: Introduction to Basics: 00:01:00 •Module 2: What is ISO: 00:02:00 •Module 3: ISO Practical: 00:02:00 •Module 4: What is Aperture: 00:02:00 •Module 5: What is Shutter Speed: 00:03:00 •Module 6: Shutter Speed Practical: 00:04:00 •Module 7: Exposure Triangle: 00:03:00 •Module 1: Introduction to Advanced Basics: 00:01:00 •Module 2: Histogram: 00:03:00 •Module 3: RAW vs JPEG: 00:03:00 •Module 4: What is RAW: 00:02:00 •Module 5: Dynamic Range: 00:03:00 •Module 6: Kelvin Temp: 00:03:00 •Module 1: Introduction - How to Plan: 00:02:00 •Module 2: Light Pollution: 00:03:00 •Module 3: Weather App: 00:03:00 •Module 4: PhotoPills: 00:06:00 •Module 5: Feature of PhotoPills: 00:07:00 •Module 6: PRO Tip for Night Sky Planning: 00:03:00 •Module 1: How to Focus: 00:07:00 •Module 2: Base Settings: 00:02:00 •Module 3: Practical Base Setting: 00:02:00 •Module 4: Underexposed: 00:02:00 •Module 5: Overexposed Part 1: 00:02:00 •Module 6: Overexposed Part 2: 00:03:00 •Module 7: Pro Tip to Find Composition Fast: 00:02:00 •Module 1: Introduction to Composition: 00:02:00 •Module 2: Foreground: 00:03:00 •Module 3: Scale: 00:03:00 •Module 4: Reflection: 00:03:00 •Module 5: Low Light Cityscape Photography: 00:04:00 •Module 6: Creating Simple Light Trails: 00:03:00 •Module 1: Light Pollution Filter: 00:02:00 •Module 2: Exposure Blending: 00:03:00 •Module 3: Artificial Light: 00:03:00 •Module 4: Focus Stacking: 00:04:00 •Module 5: Time Lapse: 00:05:00 •Module 6: Star Trails: 00:03:00 •Module 1: Editing - Introduction: 00:02:00 •Module 2: Basic Overview: 00:19:00 •Module 3: Global VS Local Adjustment: 00:09:00 •Module 4: Editing Night Photography Images: 00:22:00 •Module 5: Proper Artificial Light: 00:15:00 •Module 6: Blending Multiple Exposure: 00:13:00 •Module 7: Focus Stack- Photoshop: 00:07:00 •Module 8: Focus Stack- Helicon: 00:06:00 •Module 9: Time Lapse: 00:06:00 •Module 10: Star Trails: 00:11:00 •Module 11: Adobe Lightroom Pro Tips: 00:14:00 •Assignment - Night Photography: 00:00:00

Overview Enrol in our Coding with HTML, CSS, & Javascript today and build the necessary skills, knowledge and experience to transform your career. The Coding with HTML, CSS, & Javascript could enhance your continuing professional development thus propelling you more towards your dream job. This Coding with HTML, CSS, & Javascript could be your key, if you are interested in a long term career in the field of Coding with HTML, CSS, & Javascript. This Coding with HTML, CSS, & Javascript course consists of a number of easy to digest, in-depth modules which are designed to provide you with detailed knowledge on Coding with HTML, CSS, & Javascript. This Coding with HTML, CSS, & Javascript aims to accompany you through your journey to help you become a master of Coding with HTML, CSS, & Javascript. Learn through a mixture of interactive lessons and online study materials. 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 Coding with HTML, CSS, & Javascript. It is available to all students, of all academic backgrounds. Requirements Our Coding with HTML, CSS, & Javascript is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 7 sections • 66 lectures • 08:06:00 total length •1.1 Intro: 00:03:00 •1.2 Install the Tools and Get Started: 00:05:00 •2.1 Intro to HTML: 00:01:00 •2.2 What is HTML: 00:11:00 •2.3 Start a New HTML File & Use Tags: 00:12:00 •2.4 Header Tags: 00:05:00 •2.5 Edit Text: 00:09:00 •2.6 Links: 00:09:00 •2.7 Images: 00:10:00 •2.8 Lists: 00:04:00 •2.9 Challenge 1: 00:16:00 •2.10 HTML Outro: 00:01:00 •3.1 CSS Intro: 00:04:00 •3.2 Add CSS Styles: 00:16:00 •3.3 Classes and IDs: 00:07:00 •3.4 Borders: 00:06:00 •3.5 Sizing: 00:04:00 •3.6 Padding and Margin: 00:07:00 •3.7 Text Styles: 00:04:00 •3.8 DIVs: 00:08:00 •3.9 Postioning: 00:08:00 •3.10 Hover: 00:03:00 •3.11 Easily Center Elements: 00:02:00 •3.12 Fonts: 00:06:00 •3.13 Challenge: 00:23:00 •3.14 CSS Outro: 00:01:00 •4.1 Intro to Bootstrap: 00:02:00 •4.2 Install Bootstrap: 00:10:00 •4.3 Indenting and Containers: 00:07:00 •4.4 The Grid System: 00:16:00 •4.5 Images: 00:07:00 •4.6 Buttons: 00:06:00 •4.7 Challenge 3: 00:11:00 •4.8 Bootstrap Outro: 00:01:00 •5.1 Landing Page Intro: 00:01:00 •5.2 Sketch Your Landing Page: 00:05:00 •5.3 The Top Section: 00:16:00 •5.4 Polish the Top Section: 00:06:00 •5.5 Adding Images: 00:11:00 •5.6 The Main Points Section: 00:14:00 •5.7 Collecting Emails With an Opt-In Form: 00:11:00 •5.8 Challenge 4: 00:03:00 •5.9 Landing Page Outro: 00:02:00 •6.1 Business Site Intro: 00:01:00 •6.2 Sketch Up: 00:03:00 •6.3 Using Fancy Font Logo: 00:07:00 •6.4 Carousel Basics: 00:10:00 •6.5 Carousel Extras: 00:09:00 •6.6 Text on Images: 00:15:00 •6.7 Phone Number Icon: 00:04:00 •6.8 Google Maps: 00:13:00 •6.9 Font Awesome: 00:09:00 •6.10 Challenge 4: 00:08:00 •6.11 Business Site Outro: 00:01:00 •7.1 Intro: 00:01:00 •7.2 Portfolio Sketch: 00:08:00 •7.3 Jumbotron: 00:10:00 •7.4 Nav Bar: 00:24:00 •7.5 Panels: 00:11:00 •7.6 Challenge 5: 00:13:00 •7.7 Portfolio Outre: 00:01:00 •8.1 Hosting: 00:01:00 •8.2 Bluehost: 00:06:00 •8.3 Uploading: 00:05:00 •8.4 Tips: 00:11:00 •8.5 Hosting Outro: 00:01:00

Overview This comprehensive course on IELTS Writing Task 2 Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This IELTS Writing Task 2 Masterclass comes with accredited certification, 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 IELTS Writing Task 2 Masterclass. It is available to all students, of all academic backgrounds. Requirements Our IELTS Writing Task 2 Masterclass is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 5 sections • 56 lectures • 10:09:00 total length •Welcome Aboard: 00:11:00 •Fundamentals of Writing Task 2: 00:07:00 •The 6 Types of Questions: 00:10:00 •How to Get a High Score: 00:09:00 •How This Course is Structure: 00:03:00 •First Ingredient: Task Achievement: 00:10:00 •Second Ingredient: Coherence and Cohesion: 00:10:00 •Third Ingredient: Grammatical Range and Accuracy: 00:03:00 •Grammar: Tenses: 00:17:00 •Grammar: Articles and Agreement: 00:09:00 •Grammar: Active vs. Passive Voice: 00:07:00 •Grammar: Simple & Compound Sentences: 00:15:00 •Grammar: Complex Sentences: 00:09:00 •Grammar: Correlative Conjunctions: 00:09:00 •Grammar: Relative Clauses: 00:11:00 •Grammar: Conditional Sentences: 00:11:00 •Grammar: Combining Elements: 00:06:00 •Grammar: Punctuation: 00:18:00 •Grammar: Writing Numbers: 00:08:00 •Fourth Ingredient: Lexical Resource: 00:02:00 •Lexical Resource: Useful Expressions: 00:05:00 •Lexical Resource: Collocations: 00:11:00 •Lexical Resource: Topic-Related Vocabulary: 00:09:00 •Lexical Resource: Word Formation: 00:20:00 •Introduction to Part 2 - The Recipe: 00:13:00 •How to Create Outlines: 00:39:00 •How to Generate Ideas: 00:08:00 •How to Write Introductions - Basics: 00:09:00 •How to Write Introductions for Agree-Disagree Questions: 00:08:00 •How to Write Introductions for Advantage-Disadvantage Questions: 00:08:00 •How to Write Introductions for Problem-Solution Questions: 00:06:00 •How to Write Introductions for Discuss-Opinion Questions: 00:06:00 •How to Write Introductions for Opinion Questions: 00:05:00 •How to Write Introductions for Two-Part Questions: 00:05:00 •How to Write Body Paragraphs - Basics: 00:21:00 •How to Write Body Paragraphs for Agree-Disagree Questions: 00:11:00 •How to Write Body Paragraphs for Advantage-Disadvantage Questions: 00:12:00 •How to Write Body Paragraphs for Problem-Solution Questions: 00:15:00 •How to Write Body Paragraphs for Discuss-Opinion Questions: 00:13:00 •How to Write Body Paragraphs for Opinion Questions: 00:11:00 •How to Write Body Paragraphs for Two-Parts Questions: 00:11:00 •How to Write Conclusions - Basics: 00:03:00 •How to Write Conclusions for Agree-Disagree Questions: 00:06:00 •How to Write Conclusions for Advantage-Disadvantage Questions: 00:06:00 •How to Write Conclusions for Problem-Solution Questions: 00:07:00 •How to Write Conclusions for Opinion Questions: 00:06:00 •How to Write Conclusions for Two-Part Questions: 00:04:00 •How to Check Your Work: 00:06:00 •Practice Question 1 in Real-Time: 00:12:00 •Breakdown of Strategy for Practice Question 1: 00:19:00 •Breakdown of Ingredients for Practice Question 1: 00:16:00 •Practice Question 2 in Real-Time: 00:42:00 •Breakdown of Strategy for Practice Question 2: 00:24:00 •Breakdown of Ingredients for Practice Question 2: 00:16:00 •Final Tips - Writing Task 2: 00:11:00 •Assignment - IELTS Writing Task 2 Masterclass: 00:00:00

Overview Become a skilled professional by enrolling in the Office Skills course.This comprehensive Office Skills is designed to cover all the key topics you need to excel in the field of office administration and reception. This extensive course will teach you how to handle a comprehensive range of essential office admin duties, compose critical business letters and handle complex mail and shipping requirements. It will provide you with technical skills to meet the dynamic challenges facing modern companies.Convert your passion and enthusiasm into a prosperous career by enrolling in the Office Skills course. 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 Office Skills. It is available to all students, of all academic backgrounds. Requirements Our Office Skills is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 16 sections • 56 lectures • 11:17:00 total length •Module 01: Introduction to Reception and Receptionist: 00:28:00 •Module 02: Business Telephone Skills: 00:21:00 •Module 03: Representing Your Boss and Company: 00:36:00 •Module 04: Mail Services and Shipping: 00:27:00 •Module 05: Travel Arrangements: 00:26:00 •Module 06: Organising Meeting and Conferences: 00:27:00 •Module 07: Time Management: 00:37:00 •Module 08: Record Keeping and Filing Systems: 00:30:00 •Module 09: Business Writing Skills: 00:42:00 •Module 10 :Organisational Skills: 00:27:00 •Module 11: Communication Skills: 00:27:00 •Module 12: Customer Service: 00:18:00 •Module 13: Effective Planning and Scheduling: 00:48:00 •Module 14: Invoicing/Petty Cash: 00:29:00 •Module 15: Business Environment: 00:18:00 •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:05: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

Overview This comprehensive course on Windows 10 Pro Complete Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Windows 10 Pro Complete Training comes with accredited certification, 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Windows 10 Pro Complete Training. It is available to all students, of all academic backgrounds. Requirements Our Windows 10 Pro Complete Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 43 lectures • 04:21:00 total length •Course Overview: 00:05:00 •Easily download ISO Images: 00:10:00 •Lab - Creating a Virtual Install of Windows 10 Pro Using VirtualBox: 00:16:00 •Lab - Create Virtual Install of Server 2016 Full GUI Using VirtualBox: 00:13:00 •Taking a Snapshot of Your Current configuration: 00:04:00 •Perform a Windows 10 Upgrade for Free: 00:09:00 •Preparing Your Network for Active Directory: 00:10:00 •Lab - Prepare Server 2016 for Promotion to a Domain Controller: 00:10:00 •Lab - Promote Server 2016 to a Domain Controller: 00:09:00 •Lab - Join a Windows 10 Workstation to a Microsoft Domain: 00:15:00 •Installing WDS on a Windows Server Using VirtualBox: 00:18:00 •Deploy a Windows 10 Client Using WDS: 00:09:00 •lab - Create an Unattended Install of Windows 10 Pro: 00:17:00 •Turn the Windows 10 Firewall Off or On: 00:01:00 •Allow an app through the Windows 10 firewall: 00:05:00 •Add a rule or port to a Windows 10 firewall: 00:05:00 •Allow PING for Windows 10: 00:04:00 •Disable the UAC User Account Control in Windows 10: 00:02:00 •Using netsh to Manage the Windows Firewall: 00:05:00 •Using Powershell to Gather Firewall Information: 00:04:00 •Change your IP address in Windows 10: 00:05:00 •Add a second IP address in Windows 10: 00:09:00 •Enable System Restore on Windows 10: 00:03:00 •Create a System Restore point on Windows 10: 00:02:00 •Recover using System Restore on Windows 10: 00:04:00 •Fix TCPIP Corruption in Windows 10 Using Netsh: 00:02:00 •Repair Windows 10 with System File Checker (SFC): 00:03:00 •Repair Windows 10 System files offline Using SFC: 00:04:00 •Use ReadyBoost to Speed up Windows 10: 00:05:00 •Reset Your Network Adapter: 00:06:00 •Lab - Troubleshooting Internet Connectivity: 00:16:00 •NSLookup: 00:05:00 •Windows Reliability Monitor: 00:04:00 •Disable the Lock Screen on Windows 10: 00:03:00 •Disable Superfetch via Windows Services: 00:03:00 •Disable Screen Saver in Windows 10 using REGEDIT: 00:02:00 •Disable Windows 10 Automatic Logoff For Inactivity: 00:02:00 •Overview of the Windows 10 Shutdown and Restart buttons: 00:01:00 •Rename your Windows 10 computer: 00:01:00 •Change the date and time in Windows 10: 00:03:00 •Create a new local user in Windows 10: 00:04:00 •Rearm the 30-day evaluation Period for Windows 10 Pro: 00:03:00 •Assignment - Windows 10 Pro Complete Training: 00:00:00

Overview Gain in-depth knowledge of safeguarding with our Safeguarding and Counselling Advanced Diploma course. This course will provide you with the essential skills needed to promote vulnerable peoples' welfare and shield them from harm. People who are abused are vulnerable and need specialist help. You can be the one to take action to reduce risk and protect children. After successful completion, you will be more than capable of spotting the signs of abuse, protecting fundamental human rights both verbally and physically, identifying the abuser, securing adequate child care, and more. You will have the skills to support children and take action in the event of full disclosure. Enrol today to ensure the safety and wellbeing of the children under your care. 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 Safeguarding and Counselling Advanced Diploma. It is available to all students, of all academic backgrounds. Requirements Our Safeguarding and Counselling Advanced Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 60 lectures • 10:20:00 total length •Module 01: Introduction to Safeguarding: 00:21:00 •Module 01: An Introduction to Safeguarding of Vulnerable Adults: 00:30:00 •Module 03: Laws and Guidance: 00:43:00 •Module 04: Safeguarding Legislations: 00:30:00 •Module 05: Understanding Abuse and Neglect: 00:36:00 •Module 06: Child Abuse: 00:49:00 •Module 7: Sexual Abuse: 00:38:00 •Module 08: Understanding the Importance of Communication in Care: 00:30:00 •Module 09: Sharing Information and Responding To a Disclosure: 00:30:00 •Module 10: Record Keeping: 00:18:00 •Module 11: Risks and Risk Assessment: 00:16:00 •Introduction: 00:05:00 •Melancholy and the History of Counselling: 00:07:00 •Signs of Depression: 00:07:00 •Depression and the Brain: 00:06:00 •Depression and Neurons: 00:09:00 •Stress and depression: 00:10:00 •Environmental and Health Factors: 00:04:00 •Depression and Sleep Disorders: 00:06:00 •Somatic Symptoms: 00:06:00 •Risk Factors: 00:07:00 •Module 1: Assessment Questions: 00:05:00 •Classifying Depression & Different Classification Methods: 00:07:00 •Cyclothymia: 00:06:00 •Depression and Creative Minds: 00:07:00 •Dysthymia, Pre-Menstrual Dysphoric Disorder, and Atypical Depression: 00:07:00 •Bipolar / Manic Depression: 00:06:00 •Antenatal & Postpartum Depression: 00:09:00 •Bereavement and Grief: 00:09:00 •Dysthymia in Children and Adolescents: 00:04:00 •Depression and the Elderly: 00:06:00 •Psychosocial & Health Factors in the Elderly: 00:03:00 •Module 2: Assessment Questions: 00:04:00 •Neurogenesis: 00:04:00 •Monoamine Oxidase Inhibitors: 00:04:00 •Serotonin Syndrome: 00:03:00 •Selective Serotonin Reuptake Inhibitors: 00:03:00 •Tyramine: 00:03:00 •Medication Statistics and Doctors in the UK & USA: 00:10:00 •Module 3: Assessment Questions: 00:03:00 •Lifestyle management, Diet, Exercise, Meditation: 00:07:00 •St John's Wort (hypericum perforatum): 00:05:00 •Omega 3 Fatty Acids: 00:04:00 •Tai chi, Qigong: 00:04:00 •Yoga: 00:04:00 •Acupuncture: 00:03:00 •Art Therapy & Music Therapy: 00:08:00 •Module 4 Assessment Questions: 00:04:00 •Person Centred Therapy: 00:07:00 •Family or Couples Therapy: 00:09:00 •Stepped Care Model (approach): 00:10:00 •Psychodynamic/Dynamic Interpersonal Therapy: 00:06:00 •Rational Emotive Behavioural Therapy: 00:06:00 •Clinical Hypnotherapy & Cognitive Behavioural Therapy: 00:05:00 •Clinical Hypnotherapy for Post Traumatic Stress Disorder: 00:05:00 •Gestalt Therapy: 00:06:00 •The Therapeutic Relationship: 00:07:00 •Knowledge and Qualities Necessary to a Counsellor: 00:03:00 •Module 5 assessment questions: 00:03:00 •Thank You and Good Bye!: 00:03:00

Overview This comprehensive course on Data Science & Machine Learning with R will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Science & Machine Learning with R comes with accredited certification, 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 Data Science & Machine Learning with R. It is available to all students, of all academic backgrounds. Requirements Our Data Science & Machine Learning with R is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 10 sections • 69 lectures • 22:07:00 total length •Data Science and Machine Learning Introduction: 00:03:00 •What is Data Science: 00:10:00 •Machine Learning Overview: 00:05:00 •Who is This Course for: 00:03:00 •Data Science and Machine Learning Marketplace: 00:05:00 •Data Science and Machine Learning Job Opportunities: 00:03:00 •Getting Started: 00:11:00 •Basics: 00:06:00 •Files: 00:11:00 •RStudio: 00:07:00 •Tidyverse: 00:05:00 •Resources: 00:04:00 •Unit Introduction: 00:30:00 •Basic Type: 00:09:00 •Vector Part One: 00:20:00 •Vectors Part Two: 00:25:00 •Vectors - Missing Values: 00:16:00 •Vectors - Coercion: 00:14:00 •Vectors - Naming: 00:10:00 •Vectors - Misc: 00:06:00 •Creating Matrics: 00:31:00 •List: 00:32:00 •Introduction to Data Frames: 00:19:00 •Creating Data Frames: 00:20:00 •Data Frames: Helper Functions: 00:31:00 •Data Frames Tibbles: 00:39:00 •Intermediate Introduction: 00:47:00 •Relational Operations: 00:11:00 •Conditional Statements: 00:11:00 •Loops: 00:08:00 •Functions: 00:14:00 •Packages: 00:11:00 •Factors: 00:28:00 •Dates and Times: 00:30:00 •Functional Programming: 00:37:00 •Data Import or Export: 00:22:00 •Database: 00:27:00 •Data Manipulation in R Introduction: 00:36:00 •Tidy Data: 00:11:00 •The Pipe Operator: 00:15:00 •The Filter Verb: 00:22:00 •The Select Verb: 00:46:00 •The Mutate Verb: 00:32:00 •The Arrange Verb: 00:10:00 •The Summarize Verb: 00:23:00 •Data Pivoting: 00:43:00 •JSON Parsing: 00:11:00 •String Manipulation: 00:33:00 •Web Scraping: 00:59:00 •Data Visualization in R Section Intro: 00:17:00 •Getting Started: 00:16:00 •Aesthetics Mappings: 00:25:00 •Single Variable Plots: 00:37:00 •Two Variable Plots: 00:21:00 •Facets, Layering, and Coordinate Systems: 00:18:00 •Styling and Saving: 00:12:00 •Creating with R Markdown: 00:29:00 •Introduction to R Shiny: 00:26:00 •A Basic R Shiny App: 00:31:00 •Other Examples with R Shiny: 00:34:00 •Machine Learning Part 1: 00:22:00 •Machine Learning Part 2: 00:47:00 •Starting a Data Science Career Section Overview: 00:03:00 •Data Science Resume: 00:04:00 •Getting Started with Freelancing: 00:05:00 •Top Freelance Websites: 00:05:00 •Personal Branding: 00:05:00 •Importance of Website and Blo: 00:04:00 •Networking Do's and Don'ts: 00:04:00

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Save Up To £4,169 and get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Fix cars and equip yourself with the essential life skills with this Car Maintenance & Life Skills course. This Car Maintenance & Life Skills course will teach you the fundamental car maintenance procedures and equip you with imperative life skills. It is an ideal course for aspiring car mechanics and newcomers to the field. Enhance your expertise and take steps towards your very own car mechanic business by learning from the experts. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Long with this Car Maintenance & Life Skills course, you will get 10 premium courses Eleven PDF and an Original hardcopy certificate, a transcript and a student ID card. Courses are included in this Car Maintenance & Life Skills Bundle: Course 1: Car Maintenance & Life Skills Course 2: Basic Automotive Engineering: Onboard Diagnostics Course 3: Engine Lubricant System Training - Level 4 Course 4: Hybrid Vehicle Expert Training Course 5: Motorbike Repairing and Maintenance Diploma Course 6: Driver Safety Awareness Certificate - CPD Certified Course 7: Driving Theory Test Preparation Course 8: Electrician Skills Complete Bundle Course 9: Electrical and Fire Safety Training - Level 2 Course 10: First Aid Training Course 11: Personal Hygiene Car Maintenance & Life Skills will provide you with the CPD certificate that you'll need to succeed. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Car Maintenance & Life Skills has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Car Maintenance & Life Skills is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Car Maintenance & Life Skills: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home Curriculum Course 1: Car Maintenance & Life Skills Module 1: Safety Rules & Introduction to Tools Module 2: General Maintenance for Car Mechanics Module 3: Dashboard Indicator Lights Module 04: Tyres Module 5: Internal Combustion Engines & Engine Oil Module 6: The Cooling System Module 7: The Fuel System Module 8: The Electrical System Module 9: The Drive Train Module 10: Brakes Module 11: Buying a Car Course 2: Basic Automotive Engineering: Onboard Diagnostics Unit 01: Introduction Unit 02: Various Aspects of Onboard diagnostics Unit 03: Various systems Course 3: Engine Lubricant System Training - Level 4 Introduction Functions & Components of Lubrication System Basic Working of the Lubrication System Properties, Additives & Designations of Lube Oils Lab Analysis & Diagnostics of the Lubrication Oil Course 4: Hybrid Vehicle Expert Training Introduction Types of Hybrid Electric Vehicles Degree of Hybridisation Components of HEVs Regenerative Systems Course 5: Motorbike Repairing and Maintenance Diploma Introduction to Motorbike Maintenance Basics of Engine Engine Cooling and Lubrication Ignition Suspension Intake, Fuel, Clutch and Exhaust Systems Electrical Maintenance Wheels, Tires and Brakes Maintenance Transmission, Frame and Steering Cleaning, Setting Up and Storage Troubleshooting Course 6: Driver Safety Awareness Certificate - CPD Certified Introduction to Safe Driving Reading the Signals and Marks on the Road Pre-Journey Safety Check (Vehicle and Driver) Safe Driving Tactics for Driving in the UK Driving in Poor Condition Driving and Human Health In the Events of Accidents and Breakdowns Laws and Policies Involving Road Safety Course 7: Driving Theory Test Preparation Driving Test Rules For Pedestrians and Users of Powered Wheelchairs and Mobility Scooters General Rules, Techniques and Advice for All Drivers And Riders Rules for Drivers And Motorcyclists Driving in Adverse Weather Conditions Signs, Signals and Road Markings Maintenance, Breakdowns and Other Incidents Using the Road and Parking DSA Practical Driving Test Preparation for the Test Day of the Test Your Test Result Things to Remember Sample Theory Test Questions Course 8: Electrician Skills Complete Bundle Module 01: Introduction and Basics Module 02: Electrical Units and Ohm's Laws Module 03: Direct Current Module 04: Alternating Current Basics Module 05: Voltage and Resistance Module 06: Capacitance and Capacitors Module 07: Magnetism Module 08: Safety Precautions Course 9: Electrical and Fire Safety Training - Level 2 Module 01: Introduction and Basics Module 02: Introduction to Fire Safety Module 03: Voltage and Resistance Module 04: Capacitance and Capacitors Module 05: Safety Precautions Module 06: Fire Safety Legislation Module 07: Measures of Fire Safety Module 08: Fire Emergency: Evacuation Procedures Course 10: First Aid Training Introduction to Workplace First Aid Legal Framework for Workplace First Aid Incident Management at Work Primary Survey Secondary Survey Basic First-Aid Techniques Dealing with Minor Injuries at the Workplace Secondary Illness Loss of Responsiveness and CPR Secondary Illness Breathing Problems Secondary Illnesses and Injuries Dealing With Fractures and Dislocations Call for an Emergency Course 11: Personal Hygiene Module 01: Introduction to Personal Hygiene and a Brief History Module 02: Looking Clean, Smelling Clean Module 03: Improving and Maintaining Oral Health Module 04: Care of the Eyes Module 05: Ear Care Secrets Module 06: Foot & Nail Care in Personal Hygiene Module 07: Hair Care Hygienic Ways Module 08: Hygienic Approach to Skin Care Module 09: Maintain Good Toilet Hygiene Module 10: Potential Hygiene Guidelines Module 11: Personal Hygiene During Coronavirus Pandemic How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery inside the U.K. is Free. International students have to pay a £3.99 postal charge. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Car Maintenance & Life Skills. It is available to all students, of all academic backgrounds. Requirements Our Car Maintenance & Life Skills 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 wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having this CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Certificates Certificate of completion Digital certificate - Included