28876 Courses delivered Online

★★ FREE PDF Certificate| PDF Transcript| Student ID| Assessment| Lifetime Access| Enrolment Letter ★★ Explore our comprehensive Health and Social Care course designed to equip you with the knowledge and skills needed for a rewarding career in the healthcare sector. Learn about patient care, community health, medical ethics, and social support systems through interactive modules and hands-on training. Ideal for aspiring healthcare professionals and those looking to enhance their expertise, this course provides a solid foundation for roles in nursing, social work, and healthcare administration. Enroll now to make a meaningful impact on individuals and communities. Ready to make a difference in healthcare? Our Health and Social Care course offers in-depth training on patient care, medical ethics, and community health. Perfect for aspiring nurses, social workers, and healthcare professionals. Start your journey today and help create healthier communities! #Healthcare #SocialCare #CareerInHealthcare #Nursing #SocialWork #CommunityHealth

This video course is a perfect resource to start learning how to make websites without coding. This course will make you familiar with all the latest features of Wix and in no time you'll have all the skills needed to create and publish a robust and powerful website using Wix.

Gain a professional qualification that will help you take your secretarial and administrative career to the next level with the Company Secretary Training Course. In this course you will learn; professional communication, time management and administrative skills, while also delivering on business processes. The Company Secretary Training Course cover; businesses operational skills, administrative skills along with improving your soft skills in the process. Your Learning Goals: Learn how to organise your working day and documentation Develop time-management skills to make your day more efficient Learn how to handle special tasks set by your manager Develop your communication skills Learn how to provide quality customer service Understand how to prioritise work Learn how to use Microsoft Office tools effectively Understand the importance of business writing and documentation. Who is this Course for? Company Secretary Training Course is 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 background. 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. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Company Secretary Training Course - Updated Version Module 01: Introduction to Office Administration 00:15:00 Module 02: Skills of an Effective Administrator 00:17:00 Module 03: Business Etiquette 00:20:00 Module 04: Business Telephone Skills 00:20:00 Module 05: Representing Your Boss and Company 00:37:00 Module 06: Mail Services and Shipping 00:28:00 Module 07: Travel Arrangements 00:26:00 Module 08: Organising Meeting and Conferences 00:29:00 Module 09: Time Management 00:36:00 Module 10: Record Keeping and Filing Systems 00:29:00 Module 11: Business Writing Skills 00:42:00 Module 12: Organisational Skills 00:27:00 Module 13: Communication Skills 00:28:00 Module 14: Customer Service 00:17:00 Module 15: Effective Planning and Scheduling 00:52:00 Module 16: Invoicing/Petty Cash 00:28:00 Company Secretary Training Course - Old Version Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 00:05:00 Module Three - Getting Organized (II) 00:05:00 Module Four - Managing Time 00:05:00 Module Five - Getting It All Done On Time 00:05:00 Module Six - Special Tasks 00:05:00 Module Seven - Verbal Communication Skills 00:05:00 Module Eight - Non-Verbal Communication Skills 00:05:00 Module Nine - Empowering Yourself 00:05:00 Module Ten - The Team of Two 00:05:00 Module Eleven - Taking Care of Yourself 00:05:00 Module Twelve - Wrapping Up 00:05:00 Administrative Management Module One - Getting Started 00:05:00 Module Two - Why Your Office Needs Administrative Procedures 00:05:00 Module Three - Gathering the Right Tools 00:05:00 Module Four - Identifying Procedures to Include 00:05:00 Module Five - Top Five Procedures to Record 00:05:00 Module Six - What to Include in Your Binder (I) 00:05:00 Module Seven - What to Include in Your Binder (II) 00:05:00 Module Eight - Organizing Your Binder 00:05:00 Module Nine - What Not to Include in the Procedure Guide 00:05:00 Module Ten - Share Office Procedure Guide 00:05:00 Module Eleven - Successfully Executing the Guide 00:05:00 Module Twelve - Wrapping Up 00:05:00 Organisational Skills Module One - Getting Started 00:05:00 Module Two - Remove the Clutter 00:05:00 Module Three - Prioritize 00:05:00 Module Four - Scheduling Your Time 00:05:00 Module Five - To Do Lists 00:05:00 Module Six - Paper and Paperless Storage 00:05:00 Module Seven - Organization in Your Work Area 00:05:00 Module Eight - Tools to Fight Procrastination 00:05:00 Module Nine - Organizing Your Inbox 00:05:00 Module Ten - Avoid the Causes of Disorganization 00:05:00 Module Eleven - Discipline is the Key to Stay Organized 00:05:00 Module Twelve - Wrapping Up 00:05:00 Personal Assistant Module One - Getting Started 00:30:00 Module Two - Working with Your Manager 01:00:00 Module Three - Administrative Soft Skills 01:00:00 Module Four - Effective Time Management 01:00:00 Module Five - Meeting Management 01:00:00 Module Six - Tools of the Trade (I) 01:00:00 Module Seven - Tools of the Trade (II) 01:00:00 Module Eight - Being an Effective Gatekeeper 01:00:00 Module Nine - Organizational Skills 01:00:00 Module Ten - Confidentiality Guidelines 01:00:00 Module Eleven - Special Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Business Writing Module One - Getting Started 00:30:00 Module Two - Working with Words 01:00:00 Module Three - Constructing Sentences 01:00:00 Module Four - Creating Paragraphs 01:00:00 Module Five - Writing Meeting Agendas 01:00:00 Module Six - Writing E-mails 01:00:00 Module Seven - Writing Business Letters 01:00:00 Module Eight - Writing Proposals 01:00:00 Module Nine - Writing Reports 01:00:00 Module Ten - Other Types of Documents 01:00:00 Module Eleven - Proofreading and Finishing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Self Esteem & Confidence Building Module One - Getting Started 01:00:00 Module Two - What Does Self-Confidence Mean To You 01:00:00 Module Three - Obstacles to Our Goals 01:00:00 Module Four - Communication Skills 01:00:00 Module Five - The Importance of Goal Setting 01:00:00 Module Six - Feeling the Part 01:00:00 Module Seven - Looking the Part 01:00:00 Module Eight - Sounding the Part 01:00:00 Module Nine - Powerful Presentations 00:30:00 Module Ten - Coping Techniques 01:00:00 Module Eleven - Dealing with Difficult Behavior 00:30:00 Module Twelve - Wrapping Up 00:15:00 Microsoft Word Module One - Getting Started 00:30:00 Module Two - Opening 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft PowerPoint Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel Module One - Getting Started 00:30:00 Module Two - Opening Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Advanced Piping & Instrumentation Diagrams P&IDs will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Advanced Piping & Instrumentation Diagrams P&IDs will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Advanced Piping & Instrumentation Diagrams P&IDs and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Advanced Piping & Instrumentation Diagrams P&IDs is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Advanced Piping & Instrumentation Diagrams P&IDs. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Advanced Piping & Instrumentation Diagrams P&IDs will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Introduction Introduction 00:04:00 About P&id's What's a P&ID ? 00:03:00 Why is a P&ID so important ? 00:02:00 Who uses P&ID's ? 00:06:00 How do P&ID's look like ? 00:08:00 Introduction to P&id Reading Introduction- PID READING 00:02:00 Anatomy of a P&ID 00:01:00 The title block 00:03:00 The drawing scale 00:03:00 The grid system 00:02:00 The revision block 00:03:00 Changes 00:02:00 Notes and legends 00:03:00 Basic P&id Symbols Valve symbols 00:14:00 Valve actuator symbols 00:09:00 Control valve designations 00:02:00 Standards and conventions for valve status 00:07:00 Process equipment symbols 00:12:00 Piping symbols 00:03:00 Pipe fitting symbols 00:03:00 Isolating, venting & draining symbols for ease of maintenance 00:05:00 Instrumentation 00:03:00 Sensing devices and detectors 00:04:00 Location symbols 00:04:00 Modifiers and transmitters 00:05:00 Indicators and recorders 00:03:00 Let's Get Some Practice : Basic P&id Symbols Example #1 : Identifying process equipment and flow paths 00:05:00 Example #2 : Identifying valve position and failure mode 00:03:00 Example #3 : Identifying the symbols 00:02:00 P&id Designation Codes Piping designation code 00:06:00 Equipment designation code 00:03:00 Instrument designation code 00:02:00 Miscellaneous designation codes 00:02:00 The Importance of Process Control The process 00:01:00 Process control 00:06:00 Control Theory Basics The control loop 00:02:00 Process control terms 00:10:00 Basic Process Control Systems (BPCS) Control loops : Feedback control 00:02:00 Pressure control loops 00:01:00 Flow control loops 00:01:00 Level control loops 00:01:00 Temperature control loops 00:01:00 Multi-variable loops 00:02:00 Feedforward control 00:02:00 Feedforward + Feedback 00:01:00 Cascade control 00:08:00 Split range control 00:03:00 Operations on control signals 00:02:00 Ratio control 00:02:00 Batch control 00:01:00 Selective control 00:01:00 Controllers 00:03:00 Advanced Process Control Do we need to control at all ? 00:01:00 Principles of equipment-wise control 00:10:00 Pipe control system 00:02:00 Control of a single pipe 00:02:00 Control of pressure in a pipe 00:03:00 Control of flow in a pipe 00:04:00 Flow merging 00:08:00 Flow splitting 00:05:00 Centrifugal pump control 00:04:00 Control valve vs Variable Frequency Drive (VFD) for centrifugal pumps 00:03:00 Minimum flow control for centrifugal pumps 00:09:00 Positive displacement pump control 00:02:00 Control by a recirculation pipe for PD pumps 00:03:00 Variable Speed Drive (VSD) control for PD pumps 00:01:00 Control by stroke adjustment for PD pumps 00:01:00 Compressor control system 00:02:00 Compressor capacity control 00:12:00 Compressor anti-surge control 00:03:00 Heat transfer equipment control 00:02:00 Heat exchanger direct control system 00:04:00 Heat exchanger bypass control system 00:04:00 Reactor temperature control 00:06:00 Air cooler control 00:02:00 Heat exchanger for heat recovery 00:01:00 Heat exchanger back pressure control 00:02:00 Basic fired heater control 00:08:00 Complex fired heater control 00:05:00 Container and vessel control 00:07:00 Container blanket gas control 00:02:00 Safety Instrumented Systems (SIS), Interlocks and Alarms Safety strategies 00:01:00 Concept of Safety Instrumented Systems (SIS) 00:01:00 SIS actions and types 00:14:00 SIS extent 00:02:00 SIS requirement 00:03:00 Anatomy of a SIS 00:02:00 SIS element symbols 00:01:00 SIS primary elements : Sensors 00:03:00 SIS final elements 00:04:00 Switching valve actuator arrangements 00:02:00 Valve position validation 00:02:00 Merging a switching valve and a control valve 00:03:00 SIS logics 00:01:00 Showing safety instrumented functions on P&ID's 00:07:00 Discrete control 00:05:00 Alarm system 00:02:00 Anatomy of alarm systems 00:02:00 Alarm requirements 00:06:00 Alarm system symbology in P&ID's 00:06:00 Concept of common alarms 00:01:00 Fire and Gas Detection Systems (FGS) 00:03:00 Electric motor control 00:07:00 P&ID representation of commands and responses 00:05:00 P&ID representation of inspection and repair 00:05:00 P&ID example of electro-motor control 00:04:00 P&id Examples : Let's Get Some Practice P&ID example #1 : Legend and specifications 00:05:00 P&ID example #2 : Hydrogen delivery station 00:16:00 P&ID example #3 : Acid system 00:13:00 P&ID example #4 : Centrifugal pump 00:09:00 P&ID example #5 : Utility station 00:04:00 P&ID example #6 : Waste water filter 00:08:00 P&ID example #7 : Steam separator 00:15:00 P&ID example #8 : Flare knock-out drum 00:14:00 P&ID example #9 : Centrifugal compressor 00:05:00 P&ID example #10 : Hydrogen production from shale gas 00:11:00 P&ID example #11 : Fired heater 00:07:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview of Penny Stock Day Trading Pattern for Consistent Profits Join our Penny Stock Day Trading Pattern for Consistent Profits course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Penny Stock Day Trading Pattern for Consistent Profits course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Penny Stock Day Trading Pattern for Consistent Profits course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! This Penny Stock Day Trading Pattern for Consistent Profits Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Penny Stock Day Trading Pattern for Consistent Profits. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online — Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion – Digital / PDF Certificate After completing the Penny Stock Day Trading Pattern for Consistent Profits course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Penny Stock Day Trading Pattern for Consistent Profits is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don’t have the time to devote to traditional education. Requirements You don’t need any educational qualification or experience to enrol in the Penny Stock Day Trading Pattern for Consistent Profits course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Penny Stock Day Trading Pattern for Consistent Profits Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.

Overview of Photo Magic - Edit Like a Pro Super Bundle Join our Photo Magic – Edit Like a Pro Super Bundle course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Photo Magic – Edit Like a Pro Super Bundle course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Photo Magic – Edit Like a Pro Super Bundle course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! This Photo Magic - Edit Like a Pro Super Bundle Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Photo Magic – Edit Like a Pro Super Bundle. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online — Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion – Digital / PDF Certificate After completing the Photo Magic – Edit Like a Pro Super Bundle course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Photo Magic – Edit Like a Pro Super Bundle is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don’t have the time to devote to traditional education. Requirements You don’t need any educational qualification or experience to enrol in the Photo Magic – Edit Like a Pro Super Bundle course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Photo Magic – Edit Like a Pro Super Bundle Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00

This bundle course has been specially designed to equip our learners with a more in-depth understanding of lettings negotiating by providing them with essential functional maths skills required for this role. By combining these related courses, learners will be able to apply their practical knowledge in the real world, to take their professionalism to the next level. Take steps to become a certified lettings negotiator and be equipped with the skills and practical knowledge to advise clients and support landlords in renting their properties with the Lettings negotiator Diploma. This beginners training program is designed to provide an insight into lettings management, exploring the role of a lettings negotiator and lettings agent in detail. You will learn about the different types of agents, how to carry out a property valuation, build a relationship with clients and much more. Possessing excellent maths skills is essential for anyone who wishes to work in the property market. The Functional Maths Training Course is designed to provide aspiring lettings negotiators with the necessary skills to master everyday maths problems related to lettings management. You will learn how to calculate overall profit and loss, develop crucial problem-solving skills and gain confidence in working with decimals, fractions and percentages. This training program includes practical exercises that can be applied in real-world scenarios and is an opportunity to learn valuable transferable skills. Learning Outcomes: Learn the fundamental principles and practices of lettings management Familiarise with the lettings agency agreements guideline Understand the differences between a lettings agent and estate agent Explore the day-to-day role and responsibilities of a lettings agent Develop a solid understanding of the property valuation process Gain advanced knowledge of functional maths and apply your new skills to everyday situations Develop your skills in logical thinking and problem-solving Learn how to work with decimals, percentages, fractions and much more Gain a solid understanding of ratios and proportion through practical exercises Understand how to calculate overall profit and loss Who is This Course for? This bundle course is ideal for aspiring lettings negotiators, or lettings agents who are new to the field and wish to gain the relevant skills and knowledge to take their career to the next level. This course is also ideal for anyone who works in the real estate industry and wishes to develop their skills in everyday maths. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career Path This bundle course is the ultimate package training certification for those who are interested in a career in property. On successful completion, you will have the opportunity to work in a wide range of related industries, in roles such as: Lettings Negotiator Lettings Agent Manager Estate Agent or Lettings Manager Course Curriculum **Letting Agent** Lettings Management Introduction to Lettings Management 00:20:00 Necessary Documents for Lettings Management 01:30:00 Lettings Agency Agreements Guideline 00:15:00 Types of Agents 00:15:00 Knowing Your Clients 00:30:00 Lettings Management Agent Services 00:20:00 Property Valuation 00:30:00 Property Negotiation 00:30:00 Property Management 00:30:00 Lettings Management Laws 00:30:00 Letting Agent Code of Practice Introduction to Letting Agent Code of Practice 00:20:00 Overarching Standards of Practice 00:30:00 Lettings 00:30:00 Management and Maintenance 00:20:00 Ending the Tenancy and Communications & Resolving Complaints 00:15:00 Arrangements 00:15:00 Being a Lettings Negotiator Home Loans 00:15:00 Knowing When You're Ready To Buy 00:15:00 Is Your Lake Home For Sale? 01:00:00 Legal System & Lettings Management UK An Introduction to the UK legal system 00:15:00 Different Types of Investment Structures 00:15:00 Title & Registration 00:15:00 Finance in Lettings Management 00:15:00 Investment Purchase Procedure 00:15:00 Acquisition Costs 00:15:00 Land Usage 00:15:00 Planning & Environment 00:15:00 Investment Structure & Key Legislations 00:15:00 **Functional Skills (Maths)** Integers ( Directed Numbers) Lecture 1 Introduction 00:02:00 Lecture 2 Multiplying any digit number by 11, 22, and 33 00:09:00 Lecture 3 Integers and ordering of integers 00:06:00 Lecture 4 Addition and Subtractions of Integers 00:07:00 Lecture 5 Operations on Integers 00:04:00 Lecture 6 Multiplication and Division of Integers 00:04:00 Lecture 7 Powers of Integers (Exponents) 00:04:00 Factors and Multiples Lecture 8 Complete knowledge about factors and multiples 00:06:00 Lecture 9 Divisibility tests for 2,3,4,5,6 00:07:00 Lecture 10 Divisibility rules 7,8,9,10,11 00:06:00 Lecture 11 Prime Factorization 00:06:00 Lecture 12 Highest Common Factor HCF 00:10:00 Lecture 13 Least Common Multiple LCM 00:16:00 Lecture 14 Relation between LCM and HCF 00:04:00 Fractions Lecture 15 Classification of Fractions 00:04:00 Lecture 16 Convert mixed to improper and improper to mixed fractions 00:03:00 Lecture 17 Equivalent Fraction 00:04:00 Lecture 18 Comparing Fractions after converting to like fractions 00:09:00 Lecture 19 Reducing a fraction to lowest term 00:04:00 Lecture 20 Addition and subtraction OF fractions 00:08:00 Lecture 21 Multiplication and division of fractions 00:11:00 Lecture 22 Word problems on fractions 00:16:00 Simplification Rule : BODMAS Lecture 23 BODMAS and rules to remove brackets 00:03:00 Lecture 24 Simplify expressions using BODMAS rules 00:05:00 Lecture 25 Simplify expressions involving fractions using BODMAS 00:07:00 Decimal numbers Lecture 26 Decimal numbers in relation to fractions 00:08:00 Lecture 27 Like and unlike Decimals 00:05:00 Lecture 28 Ordering of Decimal numbers 00:10:00 Lecture 29 Addition and subtraction of Decimal 00:07:00 Lecture 30 Multiplication of Decimal 00:03:00 Lecture 31 Division of Decimal 00:05:00 Rational Numbers Lecture 32 Rational number 00:02:00 Lecture 33 Representation of Rational Numbers on Number line 00:04:00 Lecture 34 Determining which fraction is terminating or non terminating 00:05:00 Lecture 35 shortcut method of writing decimal expansion of fraction to decimal 00:08:00 Approximation Lecture 36 Rounding to whole number 00:06:00 Lecture 37 Rounding to required number of decimals (1 d.p. ) 00:05:00 Lecture 38 rounding to significant digits 00:07:00 Lecture 39 Practice question on three methods of approximation 00:05:00 Estimation and Scientific Notation or Standard form Lecture 40 Estimation 00:05:00 Lecture 41 Scientific Notation 00:07:00 Lecture 42 Operation on numbers when they are in scientific notation 00:06:00 Percentage Lecture 43 Percentage to fraction and fraction to percentage 00:06:00 Lecture 44 Percentage of a quantity and conversation to decimal 00:06:00 Lecture 45 Expressing one quantity as percentage of another quantity 00:06:00 Lecture 46 Finding increase decrease percent 00:05:00 Lecture 47 Uses of percentages-Word Problems 00:09:00 Ratio and Proportion Lecture 48 Ratio- How to express as simple ratio 00:09:00 Lecture 49 How to compare Ratios 00:04:00 Lecture 50 Word problems on finding ratios 00:07:00 Lecture 51 To divide a given quantity into a given Ratio 00:11:00 Lecture 52 Proportion 00:04:00 Lecture 53 Practice problems on Proportion 00:06:00 Lecture 54 Continued proportion 00:06:00 Unitary Method and its Applications Lecture 55 Direct Variation ( or proportion) 00:04:00 Lecture 56 Problems based on Direct proportion 00:10:00 Lecture 57 Inverse Variation ( or proportion) 00:10:00 Lecture 58 Multiple Ratios 00:10:00 Profit , Loss, discount and Tax Lecture 59 Basics - Profit and Loss 00:04:00 Lecture 60 More practice problems on Profit & Loss 00:06:00 Lecture 61 Selling price formula and Problems 00:04:00 Lecture 62 Cost price formula and Problems 00:03:00 Lecture 63 Higher problems on Profit and Loss 00:08:00 Lecture 64 Basics - Discount 00:05:00 Lecture 65 Practice problems on Discount 00:04:00 Lecture 66 Tax 00:06:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Entry Level 2 Extended Award in Skills for Working in Child Care Industries Would you like to start a career in a childcare setting? Then, our entry level 2 extended award in skills for working in child care industries course will be perfect for you. This entry level 2 extended award in skills for working in child care industries provides foundational skills and knowledge for individuals aspiring to work in childcare. This entry level 2 extended award in skills for working in child care industries course covers child development and health and safety. Moreover, this entry level 2 extended award in skills for working in child care industries course includes effective communication, and supporting play and learning. This entry level 2 extended award in skills for working in child care industries course combines theoretical learning with practical activities to build confidence and competence. Participants of this entry level 2 extended award in skills for working in child care industries course gain an understanding of the roles and responsibilities within childcare settings. So, without further delay, join our entry level 2 extended award in skills for working in child care industries course for further education or entry-level positions in early years environments. Learning outcome of entry level 2 extended award in skills for working in child care industries Upon completing the entry level 2 extended award in skills for working in child care industries, learners will be able to: Understand basic principles of child development and learning. This entry level 2 extended award in skills for working in child care industries course demonstrates knowledge of health, safety, and hygiene practices in childcare settings. Communicate effectively with children, colleagues, and parents is a lesson part of this entry level 2 extended award in skills for working in child care industries course. Support play and learning activities for young children are also included in this entry level 2 extended award in skills for working in child care industries course. Through this entry level 2 extended award in skills for working in child care industries course, you can recognise the roles and responsibilities of childcare professionals. This entry level 2 extended award in skills for working in child care industries course applies practical skills to create a safe and nurturing environment. After completing this entry level 2 extended award in skills for working in child care industries course, you can identify areas for improvement. Special Offers of this Entry Level 2 Extended Award in Skills for Working in Child Care Industries Course This entry level 2 extended award in skills for working in child care industries Course includes a FREE PDF Certificate. Lifetime access to this entry level 2 extended award in skills for working in child care industries Course Instant access to this entry level 2 extended award in skills for working in child care industries Course Get FREE Tutor Support to this entry level 2 extended award in skills for working in child care industries Course Entry Level 2 Extended Award in Skills for Working in Child Care Industries Kickstart your career in childcare with the Entry Level 2 Extended Award in Skills for Working in Child Care Industries. This course provides essential skills and knowledge, covering everything from child development to health and safety. The Entry Level 2 Extended Award in Skills for Working in Child Care Industries also focuses on effective communication and supporting play and learning, ensuring you're well-prepared for the demands of childcare. Combining theoretical learning with practical activities, this course builds your confidence and competence. Enroll today to gain a strong foundation and step into the childcare industry with assurance and expertise! Who is this course for? Entry Level 2 Extended Award in Skills for Working in Child Care Industries This entry level 2 extended award in skills for working in child care industries course is for individuals with little to no childcare experience seeking entry-level roles or further education in the field. Requirements Entry Level 2 Extended Award in Skills for Working in Child Care Industries To enrol in this Entry Level 2 Extended Award in Skills for Working in Child Care Industries Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Skills for Working in Child Care Industries Course. Be energetic and self-motivated to complete our Skills for Working in Child Care Industries Course. Basic computer Skill is required to complete our Skills for Working in Child Care Industries Course. If you want to enrol in our Child Care Industries Course, you must be at least 15 years old. Career path Entry Level 2 Extended Award in Skills for Working in Child Care Industries This entry level 2 extended award in skills for working in child care industries course prepares individuals for roles such as: Childcare assistant Nursery aide Playgroup helper And further education in childcare.

Office Skills & Administration (Office Management) Training for Receptionist & Executive PA Enhance your communication, time management, and problem solving skills with our Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course! Are you willing to lead the managerial function in an organisation? Our Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course is a comprehensive program for you to enhance your knowledge and skills in this field. The Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course is divided into 13 modules, each of which focuses on a distinct management topic. The Foundations of Office Administration and the Basics of Microsoft Office Skills are covered in order in the Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. You will learn about mail services, shipment information, and quality maintenance from our Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. This Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course module will show you how to manage risks and challenges that you may encounter in your professional life. You will also learn business strategy, etiquette rule-making, and marketing technology in this Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. You could look into a variety of job options after completing the Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. Don't pass up this chance to make an investment in your future. Enroll in the Office Management and Administration course right away to begin your successful learning journey. Learning Outcomes Know about the fundamentals of Office Administration. Recognize the opportunities in Office Administration. Learn about the requirements, duties and responsibilities of Office Administration. Get knowledge about how to develop effective skills for office management and administration and how to become a great office administrator. Get an overview of shipping and mail services in the UK. Learn about royal mail services and the alternatives to royal mail. Understand the ways to create effective plans and schedules and Work Breakdown Structure (WBS)in project management. Get the ultimate guide to project planning. Recognize the importance and processes of risk management. Acknowledge effective techniques and skills to develop business writing skills. Know about business document structure, meaning and the importance of editing and Proofreading. Get an overview of time management. Learn about the basics of Microsoft Office Skills and the key benefits of using Microsoft Office Skills. Main Course: Level 5 Office Management and Administration Free Courses are including with this Office Skills & Administration (Office Management) Training for Receptionist & PA Course Along with The Level 5 Office Management and Administration Course, We Offer a free Diploma in Medical Receptionist and Secretary Course Along with The Level 5 Office Management and Administration Course, We Offer a free Executive Secretary & PA Training Course Special Offers of this Office Skills & Administration (Office Management) Training for Receptionist & PA Course This Office Skills & Administration (Office Management) Training for Receptionist & PA Course includes a FREE PDF Certificate. Lifetime access to this Office Skills & Administration (Office Management) Training for Receptionist & PA Course Instant access to this Office Skills & Administration (Office Management) Training for Receptionist & PA Course Get FREE Tutor Support to this Office Skills & Administration (Office Management) Training for Receptionist & PA Course Office Skills & Administration (Office Management) Training for Receptionist & Executive PA The Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course will help you better understand Job Search and Interview Skills and other important topics. You will have learned all of the necessary skills and knowledge to be successful in this sector after completing the Office Administration and Management course. The office management and administration course will help you better understand Job Search and Interview Skills and its key areas. You will have achieved all of the necessary skills and knowledge to be successful in this industry by completing an Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. Who is this course for? Office Skills & Administration (Office Management) Training for Receptionist & Executive PA For individuals hoping to get a head start or who want to become future professionals in this Office Management and Administration field, the Office Management and Administration course is perfect. This Office Management and Administration course has been created to strengthen your CV and increase your competence. Requirements Office Skills & Administration (Office Management) Training for Receptionist & Executive PA To enrol in this Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate Course, students must fulfil the following requirements. To join in our Course, you must have a strong command of the English language. To successfully complete our Course, you must be vivacious and self driven. To complete our Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Course. Career path Office Skills & Administration (Office Management) Training for Receptionist & Executive PA You will be able to grasp your abilities for a career in the appropriate employment field, such as: Office Management Assistant, Officer, or Office Management and Administration, after completing the Office Management and Administration course.