8075 Courses delivered Online

Embark upon a journey of discovery with the 'AutoCAD VBA Programming - Beginner course,' where your first steps into the realm of programming within AutoCAD will lay a solid foundation for future innovation. This course is meticulously designed to guide you through the essentials, commencing with a comprehensive introduction that sets the stage for your learning adventure. As the curtain rises, you will be introduced to the robust Integrated Development Environment (IDE) where the magic of coding comes to life. Progressing through the syllabus, your insight into the AutoCAD Object Model will expand, revealing the intricacies of harnessing VBA to manipulate this powerful design tool. You'll delve into the world of variables, learning to juggle the data that acts as the building blocks of robust programming structures. As you advance, the course unveils the secret to crafting interactive user interfaces with User Forms and Controls, enabling you to tailor the AutoCAD experience like never before. The crescendo of your learning expedition peaks with mastering decision-making through Conditionals and exploiting the power of Looping to automate repetitive tasks, culminating in your ability to conjure up precise drawing objects with VBA scripts. Your newfound competence will also include troubleshooting your own code with Debugging techniques and navigating unforeseen errors with adept Error Handling strategies, ensuring that you conclude the course poised to tackle real-world challenges with confidence. Learning Outcomes: Gain an understanding of VBA within AutoCAD to create custom scripts. Develop the capability to construct and manipulate user interfaces in AutoCAD. Acquire the skills to make logical decisions and automate tasks through coding. Learn the strategies to identify and correct errors in VBA scripts. Master the application of VBA to enhance precision in AutoCAD drawings. Why buy this AutoCAD VBA Programming - Beginner course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the AutoCAD VBA Programming - Beginner course Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? Individuals keen to learn programming within a CAD environment. Professionals in the design industry looking to add automation to their toolkits. Beginners in programming aiming to apply their skills in technical drawing. CAD technicians aspiring to increase efficiency in their workflow. Design students seeking to supplement their studies with technical scripting abilities. Prerequisites This AutoCAD VBA Programming - Beginner course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This AutoCAD VBA Programming - Beginner course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path CAD Technician - £20,000 to £35,000 per annum VBA Developer - £30,000 to £60,000 per annum AutoCAD Designer - £25,000 to £40,000 per annum BIM Coordinator - £35,000 to £50,000 per annum Structural Engineer - £28,000 to £48,000 per annum Architectural Technologist - £22,000 to £35,000 per annum Course Curriculum Unit 01: Introduction Module 01: Introduction 00:04:00 Module 02: Course Content Identified 00:06:00 Unit 02: VBA Integrated Development Environment (IDE) Module 01: Setting-up the Environment (Installing VBA IDE) 00:01:00 Module 02: Downloading and Installing AutoCAD VBA IDE 00:04:00 Module 03: Identify and Understand VBA IDE Components (Toolbars and Windows) 00:03:00 Module 04: VBA IDE Walkthrough 00:14:00 Unit 03: Understanding AutoCAD Object Model in VBA Module 01: Examining AutoCAD VBA Object Model Structure 00:07:00 Module 02: Examining AutoCAD Object Model Structure Part 2 00:06:00 Unit 04: Using Variables in VBA Module 01: Working on Variables 00:01:00 Module 02: Using Variables in the Program 00:14:00 Unit 05: User Forms and Controls Module 01: User Forms and Controls Topic Breakdown 00:02:00 Module 02: Using Label, Textbox and Command Button Controls 00:10:00 Module 03: Using ListBox Control 00:06:00 Module 04: Using ComboBox Control 00:09:00 Module 05: Using CheckBox Control 00:08:00 Module 06: Using OptionButton Control 00:03:00 Module 07: Using MultiPage Control 00:10:00 Module 08: Using MultiPage Control Continued 00:14:00 Module 09: Using Frame Control 00:03:00 Unit 06: Conditionals and Decisions in VBA Module 01: Conditions and Decisions Course Outline 00:01:00 Module 02: IF-THEN-ELSE Condition 00:02:00 Module 03: IF-THEN-ELSEIF Condition 00:04:00 Module 04: Conditional Operators in VBA 00:04:00 Module 05: Logical Operators in VBA 00:07:00 Module 06: SELECT CASE Statement in VBA 00:05:00 Unit 07: Looping and Iterations in VBA Module 01: Looping and Iterations Overview 00:02:00 Module 02: Using DO-WHILE Loop in VBA 00:04:00 Module 03: Using DO-UNTIL Loop in VBA 00:02:00 Module 04: Using FORNEXT Loop in VBA 00:02:00 Module 05: Using FOREACHNEXT Loop in VBA 00:03:00 Unit 08: Drawings Objects in VBA Module 01: Drawing Objects Overview 00:01:00 Module 02: Draw a Line Object using Utility Function 00:03:00 Module 03: Draw a Line Object using Points from User's Input 00:07:00 Module 04: Draw a Circle Object Using Utility Functions 00:03:00 Module 05: Draw a Text Object using Utility Functions 00:05:00 Module 06: Draw a LWPolyline and Polyline Objects 00:06:00 Unit 09: Code Debugging in VBA Module 01: Code Debugging Overview3 00:01:00 Module 02: Code Debugging in VBA Demo3 00:12:00 Module 03: Code Debugging in VBA Demo Continued 00:02:00 Unit 10: Error Handling in VBA Module 01: Error Handling Course Outline 00:02:00 Module 02: Error Handling in VBA Demo 00:13:00 Unit 11: Conclusion Module 01: Conclusion and Thank you! 00:01:00 Assignment Assignment - AutoCAD VBA Programming - Beginner course 00:00:00

Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course Online Climate change is the most critical issue facing the globe right now. Climate change may be categorised into two categories: those caused by natural forces and those caused by man. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course will educate you about all the fundamentals of climate change so you may create positive changes. You will learn about the effects of pollution as well as the challenges to a sustainable future, and how to overcome these barriers. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course also will address the benefits of renewable energy and how to minimise energy usage and carbon footprints for a better future. The environment is today undergoing its most significant crisis. Everyone has the ability to make a difference and contribute to a more sustainable future for future generations. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course will also include the core skills and knowledge to effectively support climate change programs and connect students to the world's most extensive network of professionals, organisations, and authorities. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course is perfect for students who are interested in environmental and sustainability concerns and wish to pursue a long-term career in the field. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course is ideal for those who want to work as an environmental specialist. The course will place a strong emphasis on project methods. So, are you looking for the most professional course in Understanding Climate Change and Environmental Awareness? Do you already work in this field but want to improve your knowledge? If so then don't be concerned. We are here to meet your needs. Our professionals created this Level 2 Certificate in Understanding Climate Change and Environmental Awareness course to provide you with advanced skills, knowledge, and confidence to help you build a long-term career in this field. Main Course: Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course Free Courses included with Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course Along with Climate Change and Environmental Awareness Course you will get free Level 7 Environmental Engineering Diploma Special Offers of this Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course: This Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course includes a FREE PDF Certificate. Lifetime access to this Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course Instant access to this Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course 24/7 Support Available to this Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course Online This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course helps students to understand about climate changes as well as investigates how the weather changes over time. They accomplish this by observing the wind, temperature, lightning, sunlight, and rainfall. This information assists them in making sense of climate patterns and variations, as well as allowing professionals to observe how human activity influences the weather. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course helps students to understand about how society can adapt and reduce the effects of climate change as well as how an environmental specialist can positively protect the environment. We leave no stone unturned, and whether you are ready to take This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course in your career as an environmental specialist or simply want to improve your current skills, we will assist you in every step of the way. Simply log on to our online portal, where you will find all of the necessary learning materials of this Level 2 Certificate in Understanding Climate Change and Environmental Awareness course. When you study for a qualification online, You are completely in charge of your study schedule. There are no time-consuming classes to attend or long commutes to endure. You will be able to work on your own time and at your own pace once enrolled. So, enrol today in this powerful Level 2 Certificate in Understanding Climate Change and Environmental Awareness course and start preparing to succeed! Who is this course for? Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course Online Our fully-loaded Level 2 Certificate in Understanding Climate Change and Environmental Awareness course offers vital teachings and career insights to both beginners in the sector and current specialists. Whether you want to make your career as an environmental specialist or advance to a higher level of the environment awareness related sector, this course will help you. You may become more aware of the challenges surrounding climate change and the environment by completing the Level 2 Certificate in Understanding Climate Change and Environmental Awareness course. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course is perfect for students interested in a profession such as; Environmental Specialist. Agricultural Inspector. Hydrologist. Requirements Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course Online To enrol in this Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course. Be energetic and self-motivated to complete our Course. Basic computer Skill is required to complete our Understanding Climate Change and Environmental Awareness Course. If you want to enrol in our Course you must be at least 15 years old. Career path Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course Online This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course is for anybody who wishes to work in a capacity that can promote positive change and assist their organisation in being more environmentally friendly by understanding climate change.

CRM: Customer Relationship Management Would you want to learn about various methods for choosing tools and the best ways to keep customers? Our in-depth CRM Course (Customer Relationship Management) will assist you in expanding your knowledge about the CRM sector. Our CRM Course (Customer Relationship Management) provides an introduction to Customer Relationship Management (CRM) along with its all functions. Also, the CRM Course (Customer Relationship Management) explains CRM strategies, and data analysis in CRM and CRM Databases. Moreover, this CRM Course (Customer Relationship Management) includes difficulties handling processes. Additionally, the CRM Course (Customer Relationship Management) explain how to deepen the customer relationship and the future of CRM. Enhance your organisational efficiency and maximise business growth through our effective CRM Course (Customer Relationship Management) practices! Learning Outcome of CRM Course (Customer Relationship Management) This CRM Course (Customer Relationship Management) will teach you about: Introduction to CRM Course (Customer Relationship Management). The CRM Course (Customer Relationship Management) explains CRM fundamentals. CRM Course (Customer Relationship Management) also includes CRM strategies. Data analysis in CRM and collecting CRM databases are parts of this CRM Course (Customer Relationship Management). Through the CRM Course (Customer Relationship Management), you will learn about deepening customer relationships. Handling customer complaints and the future of CRM is elaborately explained in this CRM Course (Customer Relationship Management). Special Offers of this CRM: Customer Relationship Management Course This CRM: Customer Relationship Management Course includes a FREE PDF Certificate. Lifetime access to this CRM: Customer Relationship Management Course Instant access to this CRM: Customer Relationship Management Course Get FREE Tutor Support to this CRM: Customer Relationship Management Course CRM: Customer Relationship Management Unlock the potential of your business with our CRM: Customer Relationship Management course. This CRM: Customer Relationship Management course provides a comprehensive introduction to all CRM functions, ensuring you grasp the fundamentals of managing customer relationships. You’ll explore effective CRM: Customer Relationship Management strategies, master data analysis in CRM, and gain expertise in navigating CRM databases. Additionally, our CRM: Customer Relationship Management course covers the intricacies of handling process challenges, helping you deepen customer relationships. Plus, you'll get insights into the future of CRM: Customer Relationship Management, making this course your gateway to mastering customer engagement. Who is this course for? CRM: Customer Relationship Management This CRM: Customer Relationship Management is intended for individuals who wish to enhance their company chances and cultivate solid client connections. Requirements CRM: Customer Relationship Management To enrol in this CRM: Customer Relationship Management Course, students must fulfil the following requirements. To join in our CRM: Customer Relationship ManagementCourse, you must have a strong command of the English language. To successfully complete our CRM: Customer Relationship Management Course, you must be vivacious and self driven. To complete our CRM: Customer Relationship Management Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this CRM: Customer Relationship Management Course. Career path CRM: Customer Relationship Management You may work as a manager, customer service manager, CRM analyst, and many other roles after finishing this CRM: Customer Relationship Management!

Do your inner guts tell you to pursue a career in the hairdresser industry? Have you spent a lot of time watching videos on hair designs? If you are one of them, the Hairdressing Training course is one of the best online hairdressing courses for you. In the UK, the hairdressing sector has grown 35%. Luckily, a hairdresser's average income is more than £25,000 annually, making it a lucrative career in the UK.  The first module of this CPD-accredited online hairdressing course focuses on the role of hairdressers and how it evolves with the trend. This module will educate you to assess the human skull so that you can create fabulous hairstyles for your clients. You will also explore versatile hair types like curly, straight, and wavy. It will help you to understand hair properties and the impact of specific hair types on hairstyling. The first module ends with introducing you to the hair salon equipment and furniture. The second module will teach you how to create sleek and timeless one-length hairstyles. Moreover, you will discover the hidden technique that leads to a smooth, balanced, uniform layer. Furthermore, the skills to add volume and texture to the long hair will also be introduced. With the completion of module three, you will become a master in cutting and styling curly hair and fringe hair. Module three of this online hairdresser course for beginners focuses on hair braiding. You will learn about multiple types of hair braids and their applications. Besides, an in-depth lesson on health and safety will help you to ensure a safe & hygienic salon environment for the clients. Get enrolled in this online hairdressing course with certificates for a secure future in the hairdressing industry. Learning Outcome Ability to identify versatile hair types and to recommend suitable styling & products Gain expertise in analysing face shape to provide top-notch hairstyles to enhance client's facial shape Achieve the skills to perform multiple hair cutting along with precisions Acquire the proficiency to create intricate braided hairstyles Learn salon safety & hygiene to ensure the healthy well-being of clients Capable of doing creative hair styling for clients Entry Requirement Passionate about hairdressing Basic academic knowledge Fast internet connection Smartphone/Laptop/PC Career path Professional Hair Stylist Salon Manager Freelance Hairdresser Hair Educator Fashion Stylist Product Sales Representative Course Curriculum Introduction to Hairdressing Who are Hairdressers? 00:15:00 Anatomy of the skull 00:15:00 Hair Type 00:15:00 Face shapes, Characteristics & Style concepts 00:15:00 Hair Salon Equipments & Furnitures 00:15:00 Hair Cutting Cutting the Hair 00:15:00 Cutting hair - One length hair 00:15:00 Cutting hair - Uniform Layer 00:15:00 Cutting hair - Short graduation 00:15:00 Cutting hair - Long graduation 00:15:00 Cutting hair - Curly hair 00:15:00 Cutting hair - Fringes 00:15:00 Hair Braiding Braiding Hair 00:00:00 Applying Braiding Techniques 01:00:00 Finishing Hair 00:15:00 Health & Safety in Hairdressing 01:00:00 Hair Styling About Of Hair Style 00:30:00 Check Out Your Face Shape 01:00:00 Choosing Your Style On Your Shape 01:00:00 Best Hairstyles For A Long Face 00:30:00 Best Hairstyles For A Square Face 00:30:00 Best Hairstyles For A Round Face 00:30:00 Best Hairstyles For A Heart Shaped Face 01:00:00 How To Love Your Style 00:30:00 Wrapping Up 00:02:00 Recommended Materials Workbook - Hairdressing Training 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Data Science Overview Introduction to Data Science 00:01:00 Data Science: Career of the Future 00:04:00 What is Data Science. 00:02:00 Data Science as a Process 00:02:00 Data Science Toolbox 00:03:00 Data Science Process Explained 00:05:00 What's Next 00:01:00 R and RStudio Engine and Coding Environment 00:03:00 Installing R and RStudio 00:04:00 RStudio: A Quick Tour 00:04:00 Introduction to Basics Arithmetic With R 00:03:00 Variable Assignment 00:04:00 Basic data types in R 00:03:00 Vectors Creating a Vector 00:05:00 Naming a Vector 00:04:00 Arithmetic Calculations On Vectors 00:07:00 Vector selection 00:06:00 Selection By Comparison 00:04:00 Matrices What's a Matrix 00:02:00 Analyzing Matrices 00:03:00 Naming a Matrix 00:05:00 Adding Columns and Rows To a Matrix 00:06:00 Selection of Matrix Elements 00:03:00 Arithmetic with Matrices 00:07:00 Factors What is Factor 00:02:00 Categorical Variables and Factor Levels 00:04:00 Summarizing a Factor 00:01:00 Ordered Factors 00:05:00 Data Frames What's a Data Frame 00:03:00 Creating a Data Frame 00:04:00 Selection of Data Frame elements 00:03:00 Conditional selection 00:03:00 Sorting a Data Frame 00:03:00 Lists Why Would You Need Lists 00:01:00 Creating Lists 00:03:00 Selecting Elements From a List 00:03:00 Adding more data to the list 00:02:00 Relational Operators Equality 00:03:00 Greater and Less Than 00:03:00 Compare Vectors 00:03:00 Compare Matrices 00:02:00 Logical Operators AND, OR, NOT Operators 00:04:00 Logical Operators with Vectors and Matrices 00:04:00 Reverse the result: (!) 00:01:00 Relational and Logical Operators Together 00:06:00 Conditional Statements The IF Statement 00:04:00 IF…ELSE 00:03:00 The ELSEIF Statement 00:05:00 Full Exercise 00:03:00 Loops Write a While Loop 00:04:00 Looping With More Conditions 00:04:00 Break: Stop the While Loop 00:04:00 What's a For Loop 00:02:00 Loop Over a Vector 00:02:00 Loop Over a List 00:03:00 Loop Over a Matrix 00:03:00 For Loop With Conditionals 00:01:00 Using Next and Break With For Loop 00:03:00 Functions What is Function 00:02:00 Arguments Matching 00:03:00 Required and Optional Arguments 00:03:00 Nested functions 00:02:00 Writing Own Functions 00:03:00 Functions With No Arguments 00:02:00 Defining Default Arguments In Functions 00:04:00 Function Scoping 00:02:00 Control Flow in Functions 00:03:00 R Packages Installing R Packages 00:01:00 Loading R Packages 00:04:00 Different Ways To Load a Package 00:02:00 The Apply Family - Lapply What Is Lapply and When Is Used. 00:04:00 Use Lapply With User-Defined Functions 00:03:00 Lapply and Anonymous Functions 00:01:00 Use lapply With Additional Arguments 00:04:00 The Apply Family - Sapply & Vapply What is Sapply 00:02:00 How to Use Sapply 00:02:00 Sapply With Your Own Function 00:02:00 Sapply With a Function Returning a Vector 00:02:00 When Can't sapply Simplify. 00:02:00 What is Vapply and Why is it Used. 00:04:00 Useful Functions Mathematical Functions 00:05:00 Data Utilities 00:08:00 Regular Expressions Grepl & Grep 00:04:00 Metacharacters 00:05:00 Sub & Gsub 00:02:00 More Metacharacters 00:04:00 Dates And Times Today and Now 00:02:00 Create and Format Dates 00:06:00 Create and Format Times 00:03:00 Calculations with Dates 00:03:00 Calculations with Times 00:07:00 Getting and Cleaning Data Get and Set Current Directory 00:04:00 Get Data From the Web 00:04:00 Loading Flat Files 00:05:00 Loading Excel files 00:03:00 Plotting Data in R Base Plotting System 00:03:00 Base plots: Histograms 00:03:00 Base plots: Scatterplots 00:05:00 Base plots: Regression Line 00:03:00 Base plots: Boxplot 00:03:00 Data Manipulation With dplyr Introduction to Dplyr Package 00:04:00 Using the Pipe Operator (%>%) 00:02:00 Columns component: select() 00:05:00 Columns component: rename() and rename_with() 00:02:00 Columns Component: Mutate() 00:02:00 Columns Ccomponent: Relocate() 00:02:00 Rows Component: Filter() 00:01:00 Rows Component: Slice() 00:04:00 Rows Component: Arrange() 00:01:00 Rows Component: Rowwise() 00:02:00 Grouping of Rows: Summarise() 00:03:00 Grouping of Rows: Across() 00:02:00 COVID-19 Analysis Task 00:08:00 Supplementary Resources Supplementary Resources - Learning R Programming for Data Science 00:00:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Overview of Mental Health Awareness Diploma Mental health issues affect 1 in 4 people in the UK each year. With growing awareness, demand for mental health services is rising. There are opportunities for meaningful careers supporting those experiencing mental ill health. This Mental Health Awareness Diploma quips you with knowledge and skills for healthcare, education, social services, and management roles. You’ll gain a comprehensive understanding of mental health while developing practical abilities to enact positive change. Make a difference and join the critical effort to support mental wellbeing. This Mental Health Awareness Diploma will help you to learn: Understand the range of mental health conditions and their symptoms Learn about assessment, diagnosis and treatment of mental health problems Gain knowledge of mental health legislation, services and social attitudes Develop skills to support those experiencing mental ill health Be able to promote positive mental health and wellbeing Understand the impact of mental health in the workplace and the role of employers. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Mental Health Awareness Diploma. 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 Mental Health Awareness Diploma 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? Healthcare professionals, including nurses, social workers, counsellors, Teachers, lecturers, and education professionals Managers and HR professionals Individuals wanting to promote mental health awareness Students studying psychology, healthcare, social care Anyone wanting to understand mental health better? Requirements You don’t need any educational qualification or experience to enrol in the Mental Health Awareness Diploma 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 Mental Health Nurse - £24K to £40K/year Counsellor - £20K to £60K/year Psychologist - £26K to £60K/year Social Worker - £23K to £40K/year Teacher - £25K to £41K/year

Follow your dreams by enrolling on the Autism and Mental Health course today and develop the experience, skills and knowledge you need to enhance your expert development. Autism and Mental Health will help you arm yourself with the qualities you need to work towards your dream job. Study the Autism and Mental Health training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Autism and Mental Health course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Autism and Mental Health course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Autism and Mental Health course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Autism and Mental Health course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Autism and Mental Health course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Autism and Mental Health course. The Autism and Mental Health course is designed by industry experts and is tailored to help you learn new skills with ease.  Autism and Mental Health is incredibly valuable and allows you to study at your own pace. With full course access for one year, you can complete Autism and Mental Health when it suits you. Access the Autism and Mental Health course modules from any internet-enabled device, including computers, tablets, and smartphones. The Autism and Mental Health course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Autism and Mental Health now and start learning instantly! Please note: This course only gives you the theoretical knowledge that you need to excel in this field. This Autism and Mental Health doesn't entitle you to practise as an expert in this specific field. What You Get Out Of Studying Autism and Mental Health With Janets: Receive a digital Certificate upon successful completion of the Autism and Mental Health course Get taught by experienced, expert instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Autism and Mental Health training course is delivered through Janets' online learning platform. Access the Autism and Mental Health content from any internet-enabled device whenever or wherever you want to. The Autism and Mental Health course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Who Is This Course For: Autism and Mental Health is ideal for those who already work in this sector or are an aspiring expert. This Autism and Mental Health course is designed to enhance your expertise and boost your CV. Learn key skills and gain an expert lesson to prove your newly-acquired knowledge. Requirements: The Autism and Mental Health is open to all students and has no formal entry requirements. To study the Autism and Mental Health course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: Autism and Mental Health is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete Autism and Mental Health and gain an industry-acknowledged lesson that will help you excel in finding your ideal job. Course Content Autism and Mental Health - Updated Version Autism Training Module 1: Autism Spectrum Disorder (ASD) 00:25:00 Module 2: Learning Difficulties Related to Autism 00:23:00 Module 3: Autism Diagnosis 00:16:00 Module 4: Cognitive Approaches in Autism 00:17:00 Module 5: Dealing with Autistic Individuals 00:22:00 Module 6: Other Considerations for Dealing with Autistic Individuals 00:19:00 Module 7: Engagement in Autism Awareness 00:13:00 Children's Mental Health Introduction to Mental Health 00:24:00 Community Mental Health Teams (CMHTs) 00:17:00 Child Psychology 00:31:00 Introduction to Child Development 00:54:00 Childhood and Adolescent 00:13:00 Attachment and Relationship Building in Childhood 00:52:00 Eating & Sleeping Disorders 00:43:00 Factors that Influence Development 00:38:00 Cognitive Development 00:25:00 Social and Emotional Development 00:43:00 Problems of Infancy 00:20:00 Problems of Childhood 00:23:00 Mock Exam Mock Exam - Autism and Mental Health 00:20:00 Final Exam Final Exam - Autism and Mental Health 00:20:00 Autism and Mental Health - Old Version Module 01: Mental Health of Children Children's Mental Health Basics 00:30:00 Nurturing Positivity And Confidence 01:00:00 Recognise Changed Behaviour In Your Child 01:00:00 About Birth Defects 01:00:00 About Behaviour Disorders 01:00:00 Mental Health Games For Children 01:00:00 Make Sure You Take Care Of Yourself As Well 00:30:00 Module 02: Autism The Basics About Autism: What Is It? 00:30:00 What Are the Factors that Contribute A Child to Autism 01:30:00 Autism and Genetics 01:30:00 What Are the Basic Symptoms of Autism 01:00:00 What Are the Speech and Communication Problems of Autism 01:00:00 Autism and Body Language 01:00:00 Autism, Toxic Metals, and Vaccines 00:30:00 The Cause of Autism Might Be Found in Autistic Mice 00:30:00 Autism: The Need for Increased Research 00:30:00 How is Autism Treated 01:00:00 How Is Autism Diagnosed 00:30:00 Myths about Autism 00:10:00 How to Look for Autism Signs in Infants 00:30:00 How Can Families Cope With an Autistic Child and the Financial Burden 00:30:00 The Differences Between Asperger's Syndrome and Autism 01:00:00 Autism Assistance Dogs 01:00:00 Teaching Autistic Children 01:00:00 The Fixation Behavior of an Autistic Child 00:30:00 The Autism Society of America 00:30:00 Childproofing Your Home for Your Autistic Child 00:30:00 Autism and Nutritional Supplements 01:00:00 Toilet Training the Autistic Child 01:00:00 Difficulties of an Autistic Adult 01:00:00 Alternative Treatments for Autism 01:00:00 Assignment Assignment - Autism And Mental Health 2 weeks Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Follow your dreams by enrolling on the Family Crisis Management and Relationship Building course today and develop the experience, skills and knowledge you need to enhance your professional development. Family Crisis Management and Relationship Building will help you arm yourself with the qualities you need to work towards your dream job. Study the Family Crisis Management and Relationship Building training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Family Crisis Management and Relationship Building course will allow you to enhance your CV, impress potential employers, and stand out from the crowd. This Family Crisis Management and Relationship Building course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Family Crisis Management and Relationship Building course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Family Crisis Management and Relationship Building course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Family Crisis Management and Relationship Building course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Family Crisis Management and Relationship Building course. The Family Crisis Management and Relationship Building course is designed by industry experts and is tailored to help you learn new skills with ease. The Family Crisis Management and Relationship Building is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Family Crisis Management and Relationship Building when it suits you. Access the Family Crisis Management and Relationship Building course modules from any internet-enabled device, including computers, tablets, and smartphones. The Family Crisis Management and Relationship Building course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Family Crisis Management and Relationship Building now and start learning instantly! What You Get Out Of Studying Family Crisis Management and Relationship Building With Janets Free PDF certificate upon successful completion of the Family Crisis Management and Relationship Building Full one-year access to Family Crisis Management and Relationship Building Course materials Instant assessment results with the Family Crisis Management and Relationship Building No hidden fees with the Family Crisis Management and Relationship Building Full tutor support available from Monday to Friday with the Family Crisis Management and Relationship Building Study the Family Crisis Management and Relationship Building at your own pace Benefit from instant feedback through mock exams and multiple-choice assessments Gain a complete understanding of Family Crisis Management and Relationship Building Accessible, informative modules taught by expert instructors Get 24/7 help or advice from our email and live chat teams with the Family Crisis Management and Relationship Building Study the Family Crisis Management and Relationship Building in your own time through your computer, tablet or mobile device Improve your chance of gaining professional skills and better earning potential by completing the Family Crisis Management and Relationship Building Description  The Family Crisis Management and Relationship Building training course is delivered through Janets' online learning platform. Access the Family Crisis Management and Relationship Building content from any internet-enabled device whenever or wherever you want to. The Family Crisis Management and Relationship Building course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Family Crisis Management and Relationship Building course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Family Crisis Management and Relationship Building course. After successfully passing the Family Crisis Management and Relationship Building course exam, you will be able to apply for a CPD-accredited certificate as proof of your Family Crisis Management and Relationship Building qualification. Certification All students who successfully complete the Family Crisis Management and Relationship Building course can instantly download their digital certificate. You can also purchase a hard copy of the Family Crisis Management and Relationship Building course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Family Crisis Management and Relationship Building is ideal for those who already work in this sector or are an aspiring professional. This Family Crisis Management and Relationship Building course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Family Crisis Management and Relationship Building is open to all students and has no formal entry requirements. To study the Family Crisis Management and Relationship Building course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Family Crisis Management and Relationship Building is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Family Crisis Management and Relationship Building and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Module 1 - The role of family support worker The functions, work environment, and daily activities of a family support worker 00:15:00 The key responsibilities of a family support worker and different specialisations 00:15:00 The key qualities of a family support worker and what a family support worker should expect 00:15:00 Duties as a family support worker 00:15:00 Professional development, career prospects, and anticipated salary as a family support worker 00:05:00 A day in the life of a family support worker 00:15:00 Pros and cons of being a family support worker 00:05:00 Work-life balance as a family support worker 00:15:00 Top tips for family support workers 00:05:00 Module 2 - Legislation, policy, and guidance Introduction to legislation, policy, and guidance 00:05:00 Overview of legislation - England 00:15:00 The Children and Families Act 2014 00:30:00 Policy and guidance - England 00:15:00 Overview of legislation - Scotland 00:05:00 Policy and guidance - Scotland 00:15:00 Overview of legislation - Northern Ireland 00:05:00 Policy and guidance - Northern Ireland 00:05:00 Overview of legislation - Wales 00:05:00 Policy and guidance - Wales 00:05:00 Module 3 - The family issues and solving them Parental mental health - how to help children living with parents with mental health problems 00:15:00 Parental mental health - assessing the risk of mental health problems 00:05:00 Parental mental health - intervention and support for children and families 00:15:00 Parental substance misuse - how to help children living with parents who misuse alcohol and drugs 00:05:00 Parental substance misuse - assessing the risk of parental alcohol and drug misuse 00:05:00 Parental substance misuse - intervention and support for children and families 00:05:00 Domestic abuse - what is domestic abuse? 00:05:00 Separation, divorce, and parental responsibility 00:05:00 Separation, divorce, and contact 00:05:00 General advice on talking about difficult topics 00:15:00 Books to help talking about difficult topics 00:15:00 Module 4 - Safeguarding - assessing need and providing help Introduction to safeguarding - a child-centred, coordinated approach 00:30:00 Early help 00:30:00 Access, referral, and information sharing 00:30:00 Disabled children, carers, youth establishments, and contextual safeguarding 00:15:00 Assessment purpose, protocols, principles, and parameters 00:15:00 Analysis, outcomes, and timeliness 00:30:00 Processes for managing individual Part 1 00:30:00 Processes for managing individual Part 2 00:15:00 Processes for managing individual Part 3 00:15:00 Module 5 - Building relationships Types of family and what makes healthy families 00:15:00 Why relationships are key to good social work 00:30:00 The importance of relationships in social work to relationships in social work 00:30:00 The personal qualities required for relationship building 00:15:00 Working on empathy to build relationships 00:15:00 The professional attributes required for relationship building 00:15:00 Self-knowledge and professional use of self in relationship building 00:15:00 Taking an individualised approach, involving the parents, what parents want from the relationship, sharing information, and building trust 00:30:00 Challenges in relationship building 00:15:00 The difference between getting the relationship right and getting it wrong 00:30:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Color Psychology 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 Color Psychology 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 Color Psychology 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 Color Psychology 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 Color Psychology. 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 Color Psychology 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 Section 01: Welcome to Lifehacking with Color Psychology Introduction: Use Color to Ramp up Your Influence 00:03:00 What Is Color and How Can It Affect You? 00:03:00 Section 02: Taste the Rainbow: The Warm Colors Red: Warning. -This Lecture Is Not For People With High Blood Pressure! 00:06:00 Orange: Use This Color Trick to Be More Productive At Work 00:03:00 Yellow: Could This Color Be Disturbing the Peace at Home? 00:05:00 Section 03: Cool Like That: The Cool Colors Green: Your Best Friend on a Busy Tuesday at Work 00:06:00 Blue: This Power Color Can Help Get You the Vote or the Job. 00:07:00 Purple: A Go-To Color for Gurus 00:03:00 Section 04: The Big Crayon Box: "Special" Colors Brown and Tan: The Best Colors to Help Salvage Your Reputation. 00:07:00 Silver and Gray: For Modern People Only 00:02:00 White: How to Make Your Website More Professional. 00:04:00 Black: Learn why this Color is Best Kept OUT of the Classroom. 00:05:00 Pink: How This Color Will Help Your Sports Team Win Again and Again. 00:04:00 Section 05: Putting It All Together Case Study #1: Influence the Audience's Mood through Color in Film/Animation 00:08:00 Case Study #2: What I Wore to my Last Job Interview 00:08:00 Case Study #3: How to Use Color Psychology to Boost Your Website (New Site) 00:13:00 Section 06: Updates, Extras, and Goodies Thank You for Taking This Course 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview This Upgrade Your Excel Skills course will unlock your full potential and will show you how to excel in a career in Upgrade Your Excel Skills. So upskill now and reach your full potential. Everything you need to get started in Upgrade Your Excel Skills is available in this course. Learning and progressing are the hallmarks of personal development. This Upgrade Your Excel Skills will quickly teach you the must-have skills needed to start in the relevant industry. In This Upgrade Your Excel Skills Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Upgrade Your Excel Skills to help you advance your career. Acquire a comprehensive understanding of various Upgrade Your Excel Skills topics and tips from industry experts. Learn in-demand Upgrade Your Excel Skills that are in high demand among UK employers, which will help you to kickstart your career. This Upgrade Your Excel Skills course covers everything you must know to stand against the tough competition in the Upgrade Your Excel Skills field.  The future is truly yours to seize with this Upgrade Your Excel Skills. Enrol today and complete the course to achieve a Upgrade Your Excel Skills certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Upgrade Your Excel Skills course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Upgrade Your Excel Skills course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Upgrade Your Excel Skills course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Upgrade Your Excel Skills is suitable for anyone aspiring to start a career in Upgrade Your Excel Skills; even if you are new to this and have no prior knowledge on Upgrade Your Excel Skills, this course is going to be very easy for you to understand.  And if you are already working in the Upgrade Your Excel Skills field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Upgrade Your Excel Skills course is a win-win for you in all aspects.  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 This Upgrade Your Excel Skills course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Upgrade Your Excel Skills 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 Upgrade Your Excel Skills course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Unit 01: Introduction Welcome 00:02:00 Unit 02: Excel Productivity Tips -Part 1 Camera Tool 00:05:00 Add Line Break in Formula Bar 00:03:00 Advanced Copy-Paste using Office Clipboard 00:03:00 Navigation between Worksheets using Shortcut Keys 00:01:00 Flash Fill 00:02:00 Add Multiple Rows and Columns Quickly 00:02:00 Delete Blank Rows 00:03:00 Multi Level Row and Column Sorting 00:04:00 Add Sparklines 00:03:00 Paste Special - Transpose 00:03:00 Unit 03: Excel Productivity Tips - Part 2 Snap to Grid 00:03:00 Create Custom Auto fill List 00:06:00 Absolute Cell Reference 00:03:00 Import Data from Web page 00:04:00 Move Cell Direction 00:03:00 Delete Data using Mouse 00:02:00 Status Bar Quick Calculations 00:03:00 Link Text Boxes to Cell 00:04:00 Phone Number and ZIP Code Format 00:04:00 Speaking Cell 00:05:00 Unit 04: Excel Productivity Tips - Part 3 Invisible Text 00:03:00 Worksheet Grouping 00:04:00 Advanced Transpose 00:04:00 XLStart Folder 00:03:00 Use Slicers 00:05:00 Convert Text to Numbers 00:03:00 Hiding Workbook Elements 00:02:00 Useful Shortcut Keys 00:03:00 Sort data from Left to Right 00:03:00 Advanced Filter (Complex) 00:11:00 Unit 05: Excel Productivity Tips - Part 4 Email as PDF 00:02:00 Synchronous Scrolling 00:03:00 Quick Analysis of data within Excel 00:02:00 Fill blank cells with Value 00:03:00 Hidden Chart Source Data 00:03:00 Two more Shortcuts 00:03:00 Add Blank Rows 00:03:00 Custom views in Excel 00:06:00 EMBED Feature 00:04:00 Adding Country code in Mobile Numbers 00:04:00 Unit 05: Excel Productivity Tips - Part 5 Plot an Average Line to a Chart 00:04:00 3D Referencing 00:04:00 Extract Unique Values 00:03:00 Excel Array Formula 00:04:00 Forecast Sheet 00:04:00 Add Spin Controls in Excel 00:05:00 Move Data using Mouse 00:01:00 Add new entry in Auto Correct to use across Office Applications 00:05:00 Find Differences between Two Lists 00:02:00 Find formulas Quickly 00:02:00 Unit: 06 Wrap Up Thank You 00:01:00