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

2991 Link courses delivered Online

Microsoft Office 2007 Excel Intermediate - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2007 Excel Intermediate - Complete Video Course will provide you with experience at creating more elaborate worksheet and workbooks n Microsoft Office Excel 2007 to display data in more effective ways. In this series you will work with multiple worksheets and workbooks, you will learn how to switch between workbooks and even copy worksheets, you will also get 3D formulas: 3D formulas will allow you to link the worksheets, and also add something call the Watch-Window. You will learn to create and manage all these linked workbooks as well as creating workspaces which will allow you to manage the workbook as well. Before getting this course you must have the basic skills of Microsoft Excel 2007. This level will give you an advanced knowledge you need to know about Microsoft Excel. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 Excel Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2007 Excel Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Using Multiple Worksheets and Workbooks Using Multiple Workbooks FREE 00:04:00 Linking Worksheets with 3-D Formulas 00:06:00 Linking Workbooks 00:11:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:17:00 Using Functions to Format Text 00:13:00 Working with Styles 00:07:00 Working with Themes 00:11:00 Other Advanced Formatting 00:13:00 Outlining and Subtotals Outlining and Consolidating Data 00:11:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:12:00 Managing Names 00:04:00 Lists and Tables Examining Lists 00:03:00 Sorting and Filtering Lists 00:07:00 Advanced Filtering 00:12:00 Working with Tables 00:22:00 Web and Internet Features Saving Workbooks as Web Pages 00:11:00 Using Hyperlinks 00:04:00 Distributing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:08:00 Combination Charts 00:05:00 Graphic Elements 00:09:00 Documenting and Auditing Auditing Features 00:05:00 Comments in Cells and Workbooks 00:08:00 Protection 00:05:00 Workgroup Collaboration 00:13:00 Templates and Settings Application Settings 00:05:00 Built-in Templates 00:07:00 Creating and Managing Templates 00:10:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2007 Excel Intermediate - Complete Video Course
Delivered Online On Demand4 hours 56 minutes
£22

Developing Self-Compassion

By Human Givens College

– in yourself and others Research shows that exercising self-compassion creates more resilience against stress, greater ability to focus, increases happiness and optimism, improves relationships and more. This live online course explains why and gives you a range of effective techniques you can use straight away…  Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm BST) Absolutely brilliant live workshop from beginning to end!CARMEL AUSTIN Many people struggle with showing themselves compassion – they may be highly critical of themselves, or wracked with feelings of shame, self-doubt or self-worth – but with the right approach it is possible to help them develop this key component of recovery and wellbeing. This new online self-compassion course provides you with all you need to know to bring self-compassion into your practice, your personal life and the lives of others – with plenty of time to try out the techniques for yourself. Join our expert tutor Julie Johnson live online on Tuesday 4th June 2024 for this helpful CPD training delivered via Zoom. When you book, we’ll email your booking confirmation – your link for joining the Zoom workshop will be sent the day before the event – numbers are limited so book soon to ensure your place. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties, so you’ll also get a recording afterwards for a limited time to maximise your learning. Why take this course Being compassionate towards ourselves when things go wrong, or we are struggling to cope, is not self-pity – it is an essential skill that can be learnt and developed, giving people the strength to move forward. When things don’t go our way or we feel we can’t cope – or something bad has happened to us – we may feel ashamed or blame ourselves for not being good enough, capable enough, strong enough and so on. This negative self-criticism can be highly damaging and hold us back. It is far more empowering to turn towards ourselves with compassion (which is what self-compassion literally means). Helping people to find the best ways to draw out their self-compassion is a skill that needs to be learned. Different from empathy (the ability to appreciate what another person is experiencing) and from self-pity (which is self-focused, exaggerates personal suffering and is disempowering and draining), self-compassion enhances resilience, allowing us to recognise our personal failings while appreciating that we are all human and make mistakes – thus helping us to move on past them. Learning how to use self-compassion from a human givens perspective makes it an extra-valuable tool for supporting our clients in getting their innate needs met and making best use of their innate resources. It may also help you in your own life. This indepth 1-day live online self-compassion experiential training day shows you how. A wonderful online learning experience, jam-packed full of useful teaching and loads of references to resources for further self study and development...KARSTEN ALVA-JORGENSEN, EXECUTIVE COACH What will you learn What self-compassion is and isn’t Research findings that demonstrate the positive effects on the body and mind of exercising self-compassion Why some people find self-compassion difficult The roots of self-compassion A new empowering perspective on making mistakes How practising self-compassion helps our ability to problem solve An important adjunctive tool for working with harsh self-criticism, trauma, emotional pain; bereavement, loss, change, and chronic-conditions Why self-compassion increases resilience Simple techniques for self-soothing and self-care How to apply these new understandings in therapy The especial value of using these techniques with parents and children How to bring these technique seamlessly into everyday life Ways that self-compassion helps with meeting emotional needs The impact of self-compassionate practice on organisations How self-compassion can help children become happier and kinder Why compassion for oneself enhances sense of status Ways that exercising self-compassion lowers emotional arousal and unhelpful thinking How self-compassion differs from both compassion and empathy The dangers of too much self-compassion How self-compassion helps focus the imagination positively Creative applications of self-compassion How self-compassion maps onto every human need and innate emotional resource, making it an essential tool in every HG practitioner’s toolbox Practical examples and case histories to learn from Who is this course suitable for? Anyone interested for personal or professional reasons Including anyone working as a practitioner helping those in mental distress or with chronic physical conditions Anyone interested in skills to help promote their own wellbeing and that of others Anyone working or living with children, or young and older people Anyone working with parents Anyone working within a caring context, such as carers, teachers, NHS workers, foster carers, social workers etc Therapists, counsellors and mental health professionals Course Programme The ‘Developing Self-Compassion’ live online training day starts at 9.15am and runs until 4.00pm. (BST). 9.15am Join the Zoom meeting 9.00am Introduction to self-compassion 11.00am Comfort break and discussion 11.30am Unpacking self-compassion 1.00pm Lunch break 1.45pm Self-compassion skills 2.45pm Comfort break and discussion 3.00pm Pulling it all together 4.00pm End days This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Developing Self-Compassion
Delivered OnlineFlexible Dates
£145

Learn the Art and Science of EFT (Emotional Freedom Techniques or “The Tapping Technique”) in this EFT workshop and join millions worldwide who are learning this life-changing technique. EFT, commonly referred to as Tapping, has gained rapid popularity because it has been demonstrated to quickly and effectively resolve dysfunctional feelings, thoughts, behaviors and beliefs which can lead to challenges in relationships, health, work and more. Basically, if there are negative emotions and stress involved, EFT may well be able to resolve those aspects that can lead to significant relief and ease in one’s life. Learn to implement this powerful mind-body approach which is supported by peer-reviewed research, drawing from the fields of interpersonal neurobiology, neuroplasticity models and the field of epigenetics. If you are ready to transform your health, your relationships and your vision of who you truly are, then come join us to learn EFT Tapping techniques. If your life is grounded in being of service to others, then EFT will quickly become your tool of choice. Whether you are curious about EFT for self-help or you are in the healing/helping professions, this training will give you confidence in the art of its delivery. From the professional working with clients to the laymen looking for self-application, everyone walks away having the skills to succeed with this extraordinary healing modality. This online format did not at all hinder the delivery of the content and technique whatsoever and we were able to do everything that we could have done in person. Alina and Craig created a very safe space, gave us plenty of demos, lots of practice time and welcomed all of our questions. They also broke up the day with ample breaks and Eden energy exercises to help avoid screen fatigue. Alina and Craig are experts in their field and top-notch EFT instructors. I highly recommend their online courses.— CARSON HILL EFT LEVEL 1 The Basics The preparation for the EFT Level 1 includes approximately 3 hours of advance work, including watching several short online videos and the reading of 2 articles that explore both the history of EFT and the scientific premises for how EFT works. Note that last minute signups will not be allowed without contacting us due to this requirement. EFT Level 1, The Basics, is the foundation of any EFT training. It covers the core aspects of EFT with a focus on how you can use tapping as a self help tool and how to teach your clients how to apply it as a self-regulating technique. Learn how to apply EFT for issues related to physical symptoms, for cravings and addictions and more. See below for an outline of materials covered. An outline of subject matter covered in this first day include: The Science Behind EFT Understanding Shifting Aspects The Importance of Being Specific Psychological Reversal & Secondary Gain Cognitive Belief Shifts How Traumatic Events Imprint on the Brain Finding the Right Words to Use An introduction to both Tell the Story and the Movie Techniques for working with traumatic events The Movie Technique Working with Pain and Physical Symptoms EFT for Cravings and Aspects of Addictions Participants who take this program will be issued a Certificate of Attendance that they have completed EFT Level 1. This is the first step along the path to obtain Certified EFT Practitioner through EFT International, but should not be put forth as a certification in itself. I wholeheartedly recommend training in EFT with Craig and Alina. I recently took their EFT level 1 and 2 live online training and it was a fantastic experience. The virtual environment in Zoom was great and everything worked perfectly, and I learned so many things. I appreciate the way they break down important concepts and share their many years of experience, and the emphasis they put on generating and maintaining safety and rapport with the client at all times.— BRUNO SADE, PSYCHOLOGIST EFT LEVEL 2 Foundational Skills The two-day EFT Level 2 workshop is designed for those practitioners who have taken the pre-requisite EFT Level 1 and are either in practice or preparing to be and will be able to apply EFT when working with clients. This may include but not be limited to social workers, counselors, therapists, health care practitioners, life coaches and those who may be wishing to pursue EFT certification. It reviews and expands upon the basic aspects of the Art and Science of EFT taught in the EFT 1 course. Additional techniques are taught to expand your repertoire and offer skillful and effective ways of working with different client populations and expanding your ability to work with deeper issues. Of course, as in all EFT Tapping Training workshops, new material is presented using a variety of learning styles including partnered teaching methods, demonstrations, paired and small group experiential applications, video examples and more to ensure that no one walks away without fully understanding everything that is taught. Most importantly, this EFT Level 2 workshop will hone your practice skills. Greater attention and time will be spent on personal observation to assist you in mastering the techniques learned. Enhanced instruction on asking key questions for uncovering core issues will be provided. The following subject matter will be taught in Level 2 with an emphasis on personal practice of techniques learned with direct observation and support from the trainers: The Gentle Techniques for Intense Issues including Sneaking Up on the problem, Tearless Trauma and the somato-emotional process of Chasing the Pain (Sensation) Understanding the Nature of and working with Traumatic Events Clearing Limiting Beliefs Questions for Uncovering Core Issues Core Issues and Physical Symptoms Working over the Telephone or Internet EFT in Groups Using EFT with Children Scope of Practice, Informed Consent and the EFT Ethics Code Participants who take this program will be issued a Certificate of Attendance that they have completed EFT Level 2. This is the second instructional step along the certification path for EFT International Accredited Certified EFT Practitioner, but should not be put forth as a certification in itself. Read about EFT and course descriptions Presenting Certified Trainers Alina Frank and Craig Weiner, DC Cost For the combination three day Level 1 and 2 combined training, the tuition is $799 ($749 early bird special if purchased 30 days prior to the workshop start date). Both EFT Levels 1 and 2 are pre-requisites for EFT International EFT certification. Location Online Hours Both EFT Level 1 and 2 training courses begin promptly at 9 am with registration beginning at 8:30 am Seattle/Los Angeles time zone. A 15 minute break is provided in the morning and afternoon. A 90 minute lunch break is offered beginning at approximately 12:30 pm. The class ends each day at 6 pm. EFT International Certification Process Attendance and completion of this training in no way constitutes “certification” and no attendee should consider themselves or promote themselves as a Certified EFT Practitioner based solely upon attendance of this training. All the requirements for completing certification will be discussed during the workshop and can be found on our EFT Certification page. Alina Frank and Dr Craig Weiner have taught and mentored thousands of individuals and professionals throughout the North America and Europe and are sought after speakers and presenters in the field of EFT instruction and EFT practice development and are EFT International Accredited Master Trainers and EFT International Supervising Mentors. CEUs, Certificates & Letters of Completion Approved Continuing Education Hours 24 CEUs have been pre-approved for NY LMHCs and may be available through 716CEU, LLC which is recognized by the New York State Education Department’s State Board for Mental Health Practitioners as an approved provider of continuing education for licensed mental health counselors. #MHC-0241. Please inquire for further details regarding whether this specific training will have CEs offered and any requirements and costs involved for receiving CEs. 24 CE hours for NY Social Workers have been pre-approved and may be available through Tree of Hope Counseling, an approved NYS Continuing Education Contact Hours (CEU) provider for Social Workers (#SW0322). Please inquire for further details regarding whether this specific training will have CEs offered and any requirements and costs involved for receiving CEs. The EFT Tapping Training Institute, with Craig Weiner and Alina Frank as trainers, have been pre-approved for 24 continuing education credit hours for online Emotional Freedom Techniques Level 1-2 training for the Canadian Counselling and Psychotherapy Association. Members of CCPA will receive transcripts at no cost listing all attended events assessed as Continuing Education Credit. Non‐members must attach a cheque for $30.00 payable to CCPA to have CEC’s recorded and to have a transcript issued. Every person who fully attends the workshop training will receive a completion certificate with the course hours listed. Certificates of Completion Official Letters of Completion are available upon request for courses. They are signed by our Trainers, has the attendees name, date of completion and the number of educational hours. The letter will be sent to the course participant as a PDF email attachment. It is the responsibility of each participant to submit the letter to the appropriate certifying board in order to determine if they will receive any type of credit. Certificates of Completion for Courses Participants of the following courses offered by the EFT Tapping Training Institute may receive a Certificate of Completion upon graduation (provided in a PDF format and sent via email): EFT Levels 1-2 EFT Level 3 Matrix Reimprinting Foundational Training Other courses may be able to provide either a Certificate of Completion or a Letter of Completion upon graduation. BIPOC Scholarship Program Please visit our Scholarship Guidelines & Application page for details. Cancellation Policy A complete refund, minus $150 administration fee, is given up to 3 weeks (21 days) prior to workshop’s start date. If cancellation occurs for any reason within the 3 weeks prior to the event, the student may apply the tuition paid towards any future EFT or Matrix Reimprinting workshops offered by us. AS THERE IS MATERIAL TO REVIEW PRIOR TO THE FIRST DAY OF TRAINING, REGISTRATION CLOSES 24 HOURS BEFORE THE START OF THE TRAINING SO THAT YOU CAN REVIEW THE MATERIALS IN ADVANCE. IF YOU DO NOT RECEIVE THE LINK OF THIS MATERIAL VIA EMAIL WITHIN 24 HOURS OF REGISTERING, PLEASE CONTACT US IMMEDIATELY.

EFT Level 1-2
Delivered OnlineFlexible Dates
£589 to £628

Online Web Application for iPad Course Level 3

4.8(9)

By Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Online Web Application for iPad Course Level 3
Delivered Online On Demand2 hours 42 minutes
£25

Affiliate Marketing Diploma

By iStudy UK

Beats - the headphone company - spends 90% of their budget in marketing, as they have identified that this is one of the most crucial parts of selling a product. This is absolutely true, as you can see that Apple phones keep outselling Samsung all the time even though they are the same and Samsung products are cheaper. This strategy about marketing could now be applied by you too through this Affiliate Marketing Diploma course. Affiliate marketing is essentially marketing and selling for other people and getting a percentage of that sale in return. Through this course you will learn how affiliate marketing works. This is not however going to be a guideline to cheat visitors, search engines or do anything unethical. In this course you will learn how to get started with affiliate marketing and how to structure your websites in order to generate large amounts of traffic. You have to remember this is not a get rich quick scheme; you have to keep working on your credibility and on your affiliate sites. If you get this course you will be able to learn about generating revenues using affiliate marketing in the right way. Course Highlights Affiliate Marketing Diploma is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Affiliate Marketing Diploma into 15 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 8 hours, 15 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Affiliate Marketing Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Affiliate Marketing Diploma is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Affiliate Marketing Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Affiliate Marketing Diploma Introduction FREE 00:15:00 Affiliate - Blueprint FREE 00:30:00 Website Layout FREE 00:30:00 The Absolute Simplest And Easiest Way To Get Started! 01:00:00 How exactly do you pick a topic? 00:45:00 How to Find Good Content And Fill Up Your Website 00:30:00 Search Engine Optimization is a must - each step of the way 00:30:00 Make Your Sites Easy To Edit And Link To Other Sites You Own 01:00:00 Make As Many Sites As You Like With Out Spending More Money 00:15:00 Pumping Your Websites Full Of Traffic 01:00:00 Using forums to really get the traffic flowing 00:30:00 Using articles to generate traffic 00:30:00 Great places to get FREE keyword rich links 00:15:00 Sticking It All Together And Getting Everything To Work 00:15:00 How To Save Some Time 00:30:00

Affiliate Marketing Diploma
Delivered Online On Demand8 hours 15 minutes
£25

Internal Audit Emerging Risks for 2021 and Beyond - Part 4

By Study Plex

This session is part four in our series on Internal Audit Focus and Emerging Risks for 2021 and Beyond. The world has changed. 2020 was an unprecedented year for all professions. Internal auditors were faced with a tremendous impact to their audit plans causing refocus and realignment of not just projects but resources. As a profession, internal auditors have traditionally focused on past events or as some would say, taking the look in the rear-view mirror. Most financial or accounting professionals can look at previous year data and tell management where past mistakes were made. With the evolving landscape, risks and economy that have been spurred on by the pandemic of 2021, internal auditors must look to stretch their skills to areas that are most valued by their organizations. Today's insight may well be tomorrow's hindsight. Part one of the series evaluated three core categories that impact the “Hot Topic” areas for internal auditors to focus on in the future. These included: Heightened Focus on Organizational Resilience Elevated Macro Environment Uncertainty Humanization vs. Dehumanization of the Workforce After reviewing these areas, we will then link them to “Hot Spot” topics as identified by the Gartner group that internal audit should be attuned to in 2021 and years forward. In session one we delved into the topics of IT Governance and Data Governance. Within Part Two of the series, we examined: Cyber Vulnerabilities Business Continuity Disaster Recovery Talent Resilience Corporate Social Responsibility Within Part Three of the series, we examined: Third-Party management Supply Chain management Data and Analytics Learning Objectives Explore Risk Management and Culture. Explore and examine risk management and culture and evaluate methods internal audit can use to evaluate their organizational processes. Identify and examine workforce management and workplace audit concepts and evaluate methods internal audit can use to evaluate their organizational processes. Recognize and examine corporate financial management concepts and evaluate methods internal audit can use to evaluate their organizational processes. 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 Introduction and Overview Introduction to Internal Audit Emerging Risks for 2021 and Beyond - Part 4 00:09:00 Continuous Play Risk Culture 00:11:00 Challenges 00:11:00 Workforce Management and Workplace Audit 00:07:00 Workforce Management and Workplace Audit Cont'd 00:13:00 Corporate Financial Management 00:09:00 Summary 00:04:00 Supplementary Resources Supplementary Resources - Internal Audit Emerging Risks for 2021 and Beyond - Part 4 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Internal Audit Emerging Risks for 2021 and Beyond - Part 4
Delivered Online On Demand
£19.99

Master In Keyword Research & SEO

4.8(9)

By Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Master In Keyword Research & SEO
Delivered Online On Demand2 hours 5 minutes
£25

Access - intermediate (In-House)

By The In House Training Company

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

Access - intermediate (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Professional Depression Counselling Diploma

By iStudy UK

The Professional Depression Counselling Diploma course is designed to teach you how to counsel people with depression. Throughout the course, you will learn various counselling and psychological theories and approaches so that you can implement the methods while counselling. The course teaches you how to diagnose people with depression. Topic included the signs of depression, the techniques of helping the clients who suffer from the major depressive episode and sleeping problems, the different types of depression, effective antidepressants, the link between neurotransmitters such as serotonin, dopamine and depression, and more. You will learn what is happening in the brain while experiencing depression. The course helps you to choose the right approaches to counselling for the treatment of depression. You will also be able to treat bipolar disorder and know whether disorders can be treated with omega three supplements, art therapy, tai chi and yoga or not. What Will I Learn? have a thorough theoretical knowledge about depression and counselling work as a 'helper' who specialises in 'depression' use counselling approaches in everyday life and career! know what is happening to someone who is depressed (brain, body, cognition) know how a person with depression can be diagnosed Requirements have an interest in psychology or counselling! want to help those who suffer with depression ready to do some learning! Module: 01 About Course FREE 00:03:00 About Tutor FREE 00:02:00 01. Intro Depression 00:05:00 02. Melancholy History 00:07:00 03. Signs of Depression 00:07:00 04. Brain Depression 00:06:00 05. Neurons Depression 00:09:00 06. Stress Depression 00:10:00 07. Environment Health 00:04:00 Module: 02 08. Sleep Disorders 00:06:00 09. Somatic Symptoms 00:06:00 10. Risk_factors 00:08:00 11: Module 1 End Qs 00:05:00 12: Classification Methods 00:07:00 13. Cyclymia 00:06:00 14. Creativity Depression 00:07:00 15. Dysthymia Atypica 00:07:00 16. Bipolar Manic 00:06:00 17. Antenatal Postpaturm D 00:09:00 18. Bereavement Grief 00:09:00 Module: 03 19. Dysthymia Children 00:04:00 20. Elderly 00:07:00 21. Psychosocial Health Elderly 00:03:00 22. Module 2 Qs 00:04:00 23. Neurogenesis 00:04:00 24. MOI 00:04:00 25. Serotonin Syndrome 00:03:00 26. SSRIs 00:04:00 27. Tyramine 00:03:00 28. Medical Stats 00:10:00 29. Module 3 Qs 00:03:00 Module: 04 30. Lifestyle Diet DD 00:07:00 31. St John's Wort 00:05:00 32. Omega 3 00:04:00 33. Tai Chi Qigong 00:04:00 34. Yoga 00:04:00 35. Acupuncture 00:03:00 36. Art Music Therapy 00:08:00 37. Module 4 Qs 00:04:00 38. Person Centred Approach 00:07:00 39. Family Couples Therapy 00:09:00 40. Step Care Approach 00:10:00 Module: 05 41. Psychodynamic IPT 00:06:00 42. REBT 00:06:00 43. Hypnotherapy 00:05:00 44. Hypnotherapy PTSD 00:05:00 45. Gestalt Therapy 00:06:00 46. Therapeutic Relationship 00:07:00 47. Knowledge Qualities 00:03:00 48. Module 5 Qs 00:03:00 49. Thanks Good Bye! 00:03:00 Additional Study Materials Additional Study Materials: Professional Depression Counselling Diploma 00:00:00

Professional Depression Counselling Diploma
Delivered Online On Demand4 hours 47 minutes
£25

Maximizing Efficiency Through Google Applications

By Compete High

🚀 Unlock Your Productivity Potential with 'Maximizing Efficiency Through Google Applications' Online Course! 🚀   Are you tired of drowning in a sea of unorganized emails, scattered documents, and missed deadlines? Do you wish there was a magic wand to transform your work life into a seamless, efficient, and highly productive experience?   Look no further! Introducing our groundbreaking online course: 'Maximizing Efficiency Through Google Applications.' 🌐✨   🔥 What's Inside? 🔥   🚀 Master the Power of Gmail: Say goodbye to email overwhelm! Learn advanced techniques to streamline your inbox, automate responses, and effortlessly manage your communication flow.   🗂️ Google Drive Mastery: Discover the art of collaborative document creation and storage. Unleash the full potential of Google Drive to keep your files organized, accessible, and secure.   📅 Calendar Control: Never miss a deadline again! Maximize your scheduling efficiency with Google Calendar hacks, enabling you to manage your time like a pro.   📊 Data Dominance with Google Sheets: Turn raw data into actionable insights! Dive deep into Google Sheets and unlock the secrets of data analysis and visualization.   🤖 Automation Awesomeness with Google Apps Script: Become a Google Apps Script wizard! Automate repetitive tasks and customize your Google Apps to work seamlessly for you.   🎯 Optimize Your Workflows: Discover how to integrate various Google Applications to create personalized, efficient workflows tailored to your specific needs.   💼 Business Boost: Explore how Google Applications can supercharge your business operations, enhance collaboration, and drive success.   🎓 Expert-Led Learning: Benefit from the expertise of industry professionals who have mastered the art of productivity through Google Applications. Learn from real-world examples and practical scenarios.   🌐 Accessible Anytime, Anywhere: Our online course is designed to fit your busy schedule. Access the materials whenever and wherever it suits you, and progress at your own pace.   🏆 Transform Your Professional Life: By the end of this course, you'll not only be a Google Applications pro but also a productivity powerhouse. Transform your professional life and achieve more than you ever thought possible!   🚨 Don't Miss Out! Enroll Now and Take Control of Your Productivity Destiny! 🚨   Ready to revolutionize the way you work? Click the link below and embark on a journey to maximize efficiency through the unparalleled power of Google Applications!   🌟 Join the ranks of successful professionals who have harnessed the full potential of Google Applications. Your optimized, efficient, and productive future starts now! 🌟   Course Curriculum Basic Overview 00:00 Base Account Settings 00:00 G-Mail 00:00 G-Mail Productivity 00:00 Google Tasks 00:00 Desktop and Mobile Synchronization 00:00 Google Sites 00:00 Google Voice for Audio Contact and SMS 00:00 Google Voice for Business Tracking 00:00 Google Photos and Google Sites 00:00 Google Photos 00:00 Allo-Hangouts and Messenges 00:00 Google Duo for Video Calling 00:00 Chrome Remote Desktop 00:00 Google Keep 00:00 Google Drive 00:00 Google Calendar for Collaboration 00:00 Google Custom Search 00:00 Export Google Docs To WordPress 00:00 Conclusion 00:00 Advanced Overview 00:00 Create Text With Voice Typing 00:00 Record Audio in Google Chrome 00:00 Publish Audio On Google Podcasts 00:00 Publish Books on Google Play 00:00 Google Docs for Shared Word Processing 00:00 Google Sheets for Shared Calcualtion 00:00 Import and Export with Excel 00:00 Google Slides for Shared Presentations 00:00 Import and Export with PowerPoint 00:00 Recording A Voice Over with Google Slides 00:00 Presenting Live Using Google Slides 00:00 Google Hangouts for Real Time Video 00:00 Create Branded Video Content With YouTube 00:00 Create Branded Video Content For YouTube 00:00 Publishing Indexed (Google) Documents 00:00 Google Research Tools 00:00 Citation of Sources 00:00 Using Blogger 00:00 Conclusion 00:00

Maximizing Efficiency Through Google Applications
Delivered Online On Demand1 hour 20 minutes
£25