54007 Courses in Edinburgh delivered Online

Are you interested in a career in therapy and psychology-related topics? Are you currently studying psychology or counselling? Or do you have a passion for psychodynamic psychotherapy? Our Psychodynamic Psychotherapy course teaches everything you need to get started in this industry. This course will help you to obtain the necessary skills and knowledge to work with people who struggle with mental health issues and day-to-day challenges. This Psychodynamic Psychotherapy course is designed to equip you with the essential knowledge of approaches and useful techniques in psychotherapy. You will learn how to become a psychodynamic psychotherapist and also familiarise with new techniques which you can use to advance your career prospects in this field. Throughout this course, you will be guided step-by-step on how to build the key skills needed to become a psychodynamic psychotherapist or coach who specialises in using psychodynamic approaches at work. What you'll learn Approaches & Useful Techniques in Psychotherapy How Psychodynamic Psychotherapy works How to set up a therapeutic session The difference between 'Brief Therapy' and 'Long-term' treatment How to ask for a 'consent' and much more! Requirements Having an interest in Psychology or Psychotherapy related fields Who this course is for: Anyone who is interested in therapy and psychology-related topics Anyone who started their psychology or counselling studies Anyone who wants to understand what is 'Psychodynamic Psychotherapy' Introduction About the Tutor FREE 00:02:00 About the Course 00:04:00 What is Psychodynamic Psychotherapy? 00:10:00 What is Psychoanalytic Psychotherapy & Psychoanalysis? 00:14:00 How does Psychodynamic Psychotherapy work? 00:08:00 Core Principles of Psychodynamic Psychotherapy 00:11:00 The Purpose & the Goals 00:06:00 What is Psychodynamic Psychotherapy used for? (substance use, depression, PTSD) 00:12:00 Levels of Awareness Consciousness and the Unconscious 00:10:00 Psychodynamic Psychotherapy and the Unconscious 00:07:00 Defence Mechanisms / Psychological Defences: Denial 00:10:00 12. Repression 00:10:00 13. Rationalisation 00:06:00 14. Reaction Formation 00:09:00 15. Projection 00:08:00 16. Displacement 00:05:00 17. Regression 00:08:00 18. Sublimation 00:06:00 Conducting a Psychotherapy Session The Importance of a Therapeutic Relationship 00:06:00 Creating a Safe Place 00:09:00 Informed Consent (Beginning of the Treatment) 00:07:00 Setting Frame & Boundaries 00:10:00 Conducting an Assessment 00:11:00 Goal Setting with the Client 00:08:00 Therapist and the Client in Psychodynamic Psychotherapy Listening in Psychodynamic Therapy (Empathic Listening) 00:08:00 Transference 00:10:00 Countertransference 00:07:00 Techniques in Psychodynamic Therapy Free Association 00:07:00 Symbolism & Interpretation 00:05:00 Dream Interpretation - part 1 00:05:00 Dream Interpretation - part 2 00:11:00 What Else You Need to Know Sessions - how long, how often, how many? 00:08:00 Short-Term / Brief Psychodynamic Therapy 00:10:00 When do we 'end' Psychotherapy? 00:12:00 Medication and Therapy 00:07:00 Thank You & Good Bye! 00:03:00 Bonus Section Additional Techniques in Psychotherapy 00:12:00 Stress- & Anger Management in Psychotherapy 00:12:00 Acceptance & Commitment Therapy (ACT) 00:17:00

Hidden Secrets Of Selling Overview Looking to explore a career with high earning potential and flexible work environment? Working in sales is just what you need to grow your professional capabilities and continuously develop your skills.  The Hidden Secrets Of Selling course is devised to give you all the Cutting-edge Tools, Tips and Strategie you need to know to become a top-class sales manager. You will learn about the hidden secrets of sales and marketing techniques. The course will enlighten you on customer psychology which will help you a fulfil your target.  Working on sales is currently a huge scope for the new generation workforce. It's a great career opportunity for beginners who wants to gain first-hand professional experience. What you'll learn from this course This course is designed to give you the guidance you need to become a successful salesperson right from scratch. You'll learn: Basics through to advanced level Sales & Marketing Skills To deal with customer objections fast & effectively To be an effective & resourceful salesperson Various common misperceptions about marketing New cutting-edge sales techniques used by the learders Scientifically proven sales techniques developed by experts To get customers to buy from you over and over again The hidden psychology of selling Why you should choose this Hidden Secrets Of Selling Course from iStudy Here are a few reasons why you should choose this Hidden Secrets Of Selling Course over other generic courses that you find on the internet: Study at your own pace No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) CPD Qualification Standards and IAO accredited Fully compatible with any device Efficient exam system, assessment, and instant results Free Printable PDF Certificate immediately after completion Hard copy certificate is available, and you can get one for just £9! No prior qualifications are needed to take this course Improve your chance of gaining professional skills and boost your earning potential All these and we have our customer support team always ready to help you and make your learning experience as smooth and as enjoyable as possible.  Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below. Take a look and see just how much this course offers. We're sure you'll be satisfied with this course. Master the art of salling and gain the props to become a successful marketer Selling isn't an easy task. It's not like that you tell someone to buy a thing and he does as you told to do. You need to convince the buyer to sell a thing and if you don't know the proper approaches, you'll find it challenging. So, it's better to learn the selling approaches and strategies before you get into marketing.  Our Hidden Secrets Of Selling - Part 1 Course is designed to teach you the basic approaches and strategies so that you can be a good marketer. In this course, you'll explore the secrets of selling with which you can turn anyone into your customer and become a successful marketer.  What you'll learn Learn Basic Through Highly Advanced Sales & Marketing Skills Gain New Cutting-Edge Sales Techniques Used by The World's TOP Salespeople Eliminate Misperceptions About How To Be An Effective (& Wealthy) Salesperson Learn How To Deal With Customer Objections Fast & Effectively Learn The BEST Sales & Marketing Techniques ... That Have Been Proven Scientifically & In The Field Learn HOW to Get Customers To Buy From You OVER & OVER AGAIN! Discover The Secrets Of How The TOP Salespeople Become WEALTHY Learn The Hidden PSYCHOLOGY Of Selling & Marketing Who is this Course for? This course is a perfect fit for those who work in sales and marketing and want to build their career in this field.  Requirements No formal qualification is required for this course except basic knowledge of selling. This course fully compatible with any kind of device. Whether you are using a Windows computer, Mac, smartphone or tablet, 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 and will be equipped with the necessary knowledge and skills required to succeed in this sector. All of our courses 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. Introduction - "Hidden Secrets Of Selling" - Part 1 Introduction & Foundational Knowledge FREE 00:24:00 "Hidden Secrets Of Selling" - Main Trainings in 4 Parts Main Sales & Marketing Training - Part One 00:38:00 Main Sales & Marketing Training - Part Two 00:20:00 Main Sales & Marketing Training - Part Three 00:39:00 Main Sales & Marketing Training - Part Four 00:15:00

Overview Mindset is a set of assumptions, methods, or notions held by a person or a team. Growth mindset is the belief that most basic abilities can be developed through dedication and hard work. Success is a hard-earned thing and needs contingency. The goal of this Success training is to help you achieve your goals in the fastest, simplest and easiest way possible. This course will save you years of research time and avoid frustration and struggle. Learn to Develop a Successful. Growth Mindset. This Principles Of Success - Growth Mindset course is based on scientific research & principles that will give you fast results.  Having these tools & strategies will make becoming successful so much easier, dramatically increase the results you get & help you achieve your goals in far less time. Growth mindset is now a buzzword in all walks of life including study, business, work and so much more. What you'll learn from this course This course is designed to give you the guidance you need to become a successful salesperson right from scratch. You'll learn: To set big goals & a growth mindset Difference between real decisions & wishes About consistency, The key to success Nothing is impossible with the right growth mindset The necessity and better ways of accountability To explore new adventurous ways to Success The way your language can shape your Success How failure can add to your success Why you should choose this Principles Of Success - Growth Mindset Course from iStudy Here are a few reasons why you should choose this Principles Of Success - Growth Mindset Course over other generic courses that you find on the internet: Study at your own pace No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) CPD Qualification Standards and IAO accredited Fully compatible with any device Efficient exam system, assessment, and instant results Free Printable PDF Certificate immediately after completion Hard copy certificate is available, and you can get one for just £9! No prior qualifications are needed to take this course Improve your chance of gaining professional skills and boost your earning potential All these and we have our customer support team always ready to help you and make your learning experience as smooth and as enjoyable as possible.  Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below. Take a look and see just how much this course offers. We're sure you'll be satisfied with this course. Course Highlights Principles Of Success - Growth Mindset is an award-winning and the best selling course that has been given the CPD Qualification Standards & 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 Principles Of Success - Growth Mindset into 13 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 1 hour, 5 minutes hours 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. Who is this Course for? Principles Of Success - Growth Mindset is CPD Qualification Standards 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 Principles Of Success - Growth Mindset 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 Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Principles Of Success - Growth Mindset 1 - Introduction - Growth Mindset 00:02:00 2 - Awareness & Planning Is Key 00:06:00 3 - Investing In Your Physical Health 00:06:00 4 - Investing In Your Mental Health 00:08:00 5 - Letting Go Of Negativity 00:09:00 6 - Adopting The Attitude Of A Winner 00:09:00 7 - Build People Up - Not Down 00:02:00 8 - Embracing Positivity 00:04:00 9 - Being Yourself 00:03:00 10 - Finding Your Place & Purpose.mp4 00:03:00 11 - Dedicating Time To What Matters Most 00:05:00 12 - Final Thoughts & Ideas 00:04:00 PROMO - Growth Mindset.mp4 00:04:00

Course Description Get instant knowledge from this bite-sized Change Management Basics: Part 1 course. This course is very short and you can complete it within a very short time. In this Change Management Basics: Part 1 course you will get fundamental ideas of change management, the key understanding of stakeholder engagement and so on. Enrol in this course today and start your instant first step towards learning about change management. Learn faster for instant implementation. Learning Outcome Familiarise with change management Understand change and the individual Gain in-depth knowledge of the change and the organisation Learn about communication and stakeholder engagement How Much Do Change Managers Earn? Senior - £93,000 (Apprx.) Average - £59,000 (Apprx.) Starting - £37,000 (Apprx.) Requirement Our Change Management Basics: Part 1 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. Change Management Basics: Part 1 Module 01: Change Management 00:23:00 Module 02: Change and the Individual 00:31:00 Module 03: Change and the Organisation 00:32:00 Module 04: Communication and Stakeholder Engagement 00:16:00 Assignment Assignment - Change Management Basics: Part 1 00:00:00

This is NOT a Programming course, the Goal is to understand the theory behind the creation of games. You will learn about many different aspects of Game Design and how they work, such as: What a Game is (Goal, Interaction, Obstacles, and Rules) Types of Games (Digital, Analog, and Gamification) Game Loops Game Arcs Game Roles Game Industry (Publishers, Game Studios and Indie Game Studios) Game Purposes Layers of a Digital Game Tutorials (Explicit, Implicit) Licensing (Royalty free, Creative Commons) Game Design Document (+ Template) Crowdfunding Publishing Games (Google Play, App Store, Steam and Itch io) By the end of some classes, I'll challenge you to do some exercises, to help you learn better. They are not mandatory, but they can make you become a better game designer. You will also answer some Quizzes, to help you memorize what you learnt even more. You'll also be able to download the presentation used in this course. This course will help you create a bionic eye, after your know how games are made, playing them will never be the same again. What you'll learn Understand what makes a game be a game Get to know in which area the student fits better Know the differences between the different types of Game Producers Know the different Games Purposes Learn how to adjust and choose the best tutorial for each Target Audience Find free assets to use in their games, even commercially Fill a basic Game Design Document for their own games Choose the best Store to publish games, according to the team's goal Requirements There are absolutely no prerequisites to take this course. Who is the target audience? People who want to learn about the Game Industry People who want to understand Game Theory Anyone who plans to work with Games in any area Humans that want to create a Bionic eye and play games as a Game Designer Teams who want to learn how to earn money by making games Game Structure Introduction 00:01:00 What Is A Game 00:06:00 Game Types 00:06:00 Game Loops 00:06:00 Game Arcs 00:04:00 Game Indutry Game Roles - Part 1 00:07:00 Game Roles - Part 2 00:07:00 Game Industry 00:06:00 Game Purposes 00:04:00 Game Layers Game Layers 00:06:00 Tutorials 00:06:00 Licensing 00:06:00 Development Game Design Document and Game Design Canvas 00:06:00 Crowdfunding 00:05:00 Publishing 00:04:00 Top 10 Game Designer Mistakes 00:06:00 Thank You And Congratulations 00:01:00 Resources Resources - Welcome To Game Design - Introduction to Game Design Theory 00:00:00 Course Certification

Learning Objectives Introduction , Designing Tables for Better Data Entry , Sharing Data with Other Applications , Working with Action Queries , Advanced Query Techniques , Automating Processes with Macros , Advanced Form Techniques , Advanced Report Techniques , Conclusion   Pre-Requisites Access 365 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.   Module 1: Design Tables for Better Data Entry Reviewing Table Design Principles 00:11:00 Setting Field Size, Formats, and Captions 00:11:00 Setting Default Values and Required Fields 00:05:00 Restricting Data Entry-Validation Rules 00:07:00 Restricting Data Entry-Input Masks 00:09:00 Module 2: Share Data with Other Apps Exporting Tables and Queries to Excel 00:05:00 Exporting Data to a SharePoint List 00:02:00 Importing Data from Excel 00:06:00 Importing Data from a SharePoint List 00:02:00 Linking External Data Sources 00:05:00 Using Word Merge 00:06:00 Module 3: Work with Action Queries What are Action Queries 00:04:00 Creating an Update Query 00:06:00 Creating an Append Query 00:04:00 Creating a Delete Query 00:04:00 Creating a Make Table Query 00:04:00 Changing Start Number of an Auto Number Field 00:04:00 Module 4: Advanced Query Techniques Modifying Query Joins 00:06:00 Using Self Joins to Combine Data 00:06:00 Creating Find Unmatched and Find Duplicate Queries 00:09:00 Creating Parameter Queries 00:05:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:06:00 Summarizing Query Data with Totals 00:04:00 Creating Crosstab Queries 00:06:00 Module 5: Automate Processes with Macros Understanding Macro Basics 00:14:00 Creating Macros to Open Forms by Record 00:09:00 Validating Data Entry with Macros 00:10:00 Creating a Macro to Automate Data Entry 00:08:00 Advanced Data Entry Using Macros and DLOOKUP 00:11:00 Module 6: Advanced Form Techniques Using Conditional Formatting 00:04:00 Working with the New Label Name Property 00:03:00 Organizing Form Fields with Tab Controls 00:09:00 Creating an Option Group Control 00:06:00 Creating a Combo Box Control 00:04:00 Configuring a Combo Box Control to Show Search Results 00:04:00 Using a Subform to Show Data From a Related Table 00:06:00 Module 7: Advanced Report Techniques Inserting a Chart on a Report 00:07:00 Showing Data in Columns 00:07:00 Inserting a Subreport 00:05:00 Configuring Reports with Parameter Queries 00:03:00 Sending Reports 00:03:00 Resource Resource - Access 365 Intermediate 00:00:00 Final Exam Final Exam - Access 365 Intermediate 00:20:00

Description Here at iStudy, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses. Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this Inner Healing Miracles. The certification that you will receive upon completing this Inner Healing Miracles will help to boost your resume and will help you stand out among your peers in the competitive job market. Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from iStudy. Enrol now! Why You Should Choose Inner Healing Miracles Lifetime access to the course No hidden fees or exam charges 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? Inner Healing Miracles is CPD Qualification Standards and CiQ accredited, 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 Inner Healing Miracles 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. The Secrets to Having Emotional Freedom Course Promo 00:03:00 Lesson 01: Introduction 00:02:00 Lesson 02: Dealing With Repressed Emotions 00:07:00 Lesson 03: Emotions - How To Release Negative Emotions Before They Affect Your Health 00:09:00 Lesson 04: Emotional Exhaustion - What It Is And How To Treat It 00:05:00 Lesson 05: Trapped Emotions - How To Release Emotions Stuck In Your Body 00:06:00 Lesson 06: Emotional Turbulence 00:03:00 Lesson 07: Coping With Emotional Pain 00:05:00 Lesson 08: A Mindfulness Practice For Welcoming Your Emotions 00:10:00 Lesson 09: Building Better Mental Health 00:04:00 Lesson 10: Conclusion - Final Thoughts & Ideas 00:01:00 Downloadable Resources Resource - The Secrets to Having Emotional Freedom 00:00:00

Description Here at iStudy, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses. Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this Fast Learner BluePrint. The certification that you will receive upon completing this Fast Learner BluePrint will help to boost your resume and will help you stand out among your peers in the competitive job market. Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from iStudy. Enrol now! Why You Should Choose Fast Learner BluePrint Lifetime access to the course No hidden fees or exam charges 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? Fast Learner BluePrint is CPD Qualification Standards and CiQ accredited, 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 Fast Learner BluePrint 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. Speed Learning Training Course Promo 00:03:00 Lesson 01: Introduction 00:02:00 Lesson 02: Skill, Learning, and Acquisition 00:09:00 Lesson 03: Smart Learners and Efficient Learning 00:04:00 Lesson 04: 10 Remarkable Traits of Successful Learners 00:04:00 Lesson 05: Learning Styles to Help You Learn Faster and Smarter 00:04:00 Lesson 06: 10 Tactics on Increasing Brain Power, Memory, and Motivation to Learn Better 00:08:00 Lesson 07: 8 Powerful Learning Hacks to Boost Your Learning Ability 00:05:00 Lesson 08: 5 Hacks to Speed up the Learning Process 00:03:00 Lesson 09: 8 Ways to Train Your Brain to Learn Faster and Remember More 00:04:00 Lesson 10: Simple Brain Training Habits to Boost Your Brain Power 00:05:00 Lesson 11: Conclusion - Final Thoughts & Ideas 00:01:00

Learning Objectives Introduction , Customizing Excel , Analyzing Data with Logical Functions , Working with Lookup Functions , Using Text Functions , Working with Date and Time Functions , Formula Auditing , What-If Analysis , Worksheet and Workbook Protection , Automating with Macros , Working with Form Controls , Ensuring Data Integrity , Collaborating in Excel , Importing and Exporting Data to a Text File , Conclusion   Pre-Requisites Excel 365 Introduction and Intermediate courses or equivalent experience.   Description This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Course Introduction Introduction 00:01:00 Section 01 Lesson 01-Customizing the Ribbon 00:09:00 Lesson 02-Customizing the Quick Access Toolbar 00:06:00 Lesson 03-Customizing the General and Formula Options 00:04:00 Lesson 04-Customizing the AutoCorrect Options 00:03:00 Lesson 05-Customizing the Save Defaults 00:04:00 Lesson 06-Customizing Advanced Excel Options 00:03:00 Section 02 Lesson 01-Working with the Most Common Logical Functions 00:03:00 Lesson 02-Understanding IF Functions 00:06:00 Lesson 03-Evaluating Data with the AND Function 00:05:00 Lesson 04-Evaluating Data with the OR Function 00:03:00 Lesson 05-Creating a Nested IF Function 00:05:00 Lesson 06-Using the IFS Function 00:03:00 Lesson 07-Summarizing Data with SUMIF 00:03:00 Lesson 08-Summarizing Data with AVERAGEIF 00:02:00 Lesson 09-Summarizing Data with COUNTIF 00:02:00 Lesson 10-Summarizing Data with MAXIFS and MINIFS 00:03:00 Lesson 11-Using the IFERROR Function 00:03:00 Section 03 Lesson 01-What are Lookup Functions 00:03:00 Lesson 02-Using VLOOKUP 00:08:00 Lesson 03-Using HLOOKUP 00:03:00 Lesson 04-Using VLOOKUP with TRUE 00:04:00 Lesson 05-Using HLOOKUP with TRUE 00:02:00 Lesson 06-Using the Index Function 00:03:00 Lesson 07-Using the MATCH Function 00:03:00 Lesson 08-Combining INDEX and MATCH 00:04:00 Lesson 09-Comparing Two Lists with VLOOKUP 00:02:00 Lesson 10-Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Lesson 11-Using the New XLookup Function-v2 00:07:00 Lesson 12-Using Dynamic Array functions-v2 00:06:00 Lesson 13-Other New Functions-v2 00:04:00 Section 04 Lesson 01-What are Text Functions 00:01:00 Lesson 02-Using CONCAT, CONCATENATE, AND TEXTJOIN 00:04:00 Lesson 03-Using Text to Columns 00:02:00 Lesson 04-Using LEFT, RIGHT, and MID Functions 00:03:00 Lesson 05-Using UPPER, LOWER, and PROPER Functions 00:02:00 Lesson 06-Using the Len Function 00:03:00 Lesson 07-Using the Trim Function 00:01:00 Lesson 08-Using the SUBSTITUTE Function 00:02:00 Section 05 Lesson 01-What are Date and Time Functions 00:02:00 Lesson 02-Using TODAY, NOW, and DAY Functions 00:03:00 Lesson 03-Using NETWORKDAYS and YEARFRAC Functions 00:03:00 Section 06 Lesson 01-Showing Formulas 00:03:00 Lesson 02-Tracing Precedents and Dependents 00:04:00 Lesson 03-Adding a Watch Window 00:04:00 Lesson 04-Error Checking 00:04:00 Section 07 Lesson 01-Using the Scenario Manager 00:07:00 Lesson 02-Using Goal Seek 00:03:00 Lesson 03-Analyzing with Data Tables 00:04:00 Section 08 Lesson 01-Understanding Protection 00:02:00 Lesson 02-Encrypting Files with Passwords 00:05:00 Lesson 03-Allowing Specific Worksheet Changes 00:02:00 Lesson 04-Adding Protection to Selected Cells 00:03:00 Lesson 05-Additional Protection Features 00:03:00 Section 09 Lesson 01-What are Macros 00:03:00 Lesson 02-Displaying the Developer Tab 00:03:00 Lesson 03-Creating a Basic Formatting Macro 00:05:00 Lesson 04-Assigning a Macro to a Button 00:03:00 Lesson 05-Creating Complex Macros 00:04:00 Lesson 06-Viewing and Editing the VBA Code 00:04:00 Lesson 07-Adding a Macro to the Quick Access Toolbar 00:03:00 Section 10 Lesson 01-What are Form Controls 00:02:00 Lesson 02-Adding a Spin Button and Check Boxes 00:04:00 Lesson 03-Adding a Combo Box 00:07:00 Section 11 Lesson 01-What is Data Validation 00:02:00 Lesson 02-Restricting Data Entry to the Whole Numbers 00:02:00 Lesson 03-Restricting Data Entry to a List 00:04:00 Lesson 04-Restricting Data Entry to a Date 00:02:00 Lesson 05-Restricting Data Entry to Specific Text Lengths 00:01:00 Lesson 06-Composing Input Messages 00:02:00 Lesson 07-Composing Error Alerts 00:03:00 Lesson 08-Finding Invalid Data 00:02:00 Lesson 09-Editing and Deleting Validation Rules 00:01:00 Section 12 Lesson 01-Working with Comments-v2 00:03:00 Lesson 02-Printing Comments and Errors 00:02:00 Lesson 03-Sharing a Workbook 00:04:00 Lesson 04-Co-Authoring in Excel 00:02:00 Lesson 05-Tracking Changes in a Workbook 00:03:00 Lesson 06-Working with Versions 00:03:00 Lesson 07-Sharing files Via Email-v2 00:03:00 Section 13 Lesson 01-Importing a Text File 00:04:00 Lesson 02-Exporting Data to a Text File 00:01:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 Advanced 00:00:00 Final Exam Final Exam - Excel 365 Advanced 00:20:00

Are you facing difficulty in dieting? Do you want to stay fit and want to maintain a healthy diet and nutrition for your body? This Dieting Course will help to gain a crystal clear knowledge and strategies about the rules of dieting. By the end of the course, you will gain information on what, when and how to eat healthy, and nutritious food. Course Description: A slim and fit body is every human's dream. DASH or Dietary Approaches to Stop Hypertension is a type of diet that is designed to treat or prevent high blood pressure (hypertension). By reducing the sodium in your diet and by ensuring a variety of foods rich in potassium, calcium and magnesium, the diet helps you lose weight. Obesity is one of the biggest problems in developed nations. Both adult and kids are affected by the problem. The present course will guide you to learn the proper dieting and fitness activities to avoid obesity and to become healthy and fit. Course Highlights Dash Dieting Course 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 Dash Dieting Course into 10 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 9 hours 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 Dash Dieting Course 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? Dash Dieting Course 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 Dash Dieting 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 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. Introduction 00:30:00 What Is This Thing The DASH Diet? 01:00:00 The History Of The DASH Diet 01:00:00 Is The DASH Diet All It's Cracked Up To Be? 01:00:00 Incorporating The DASH Diet Into Your Lifestyle 01:00:00 What To Eat And What To Avoid 01:00:00 A Day In The Life Of A DASH Diet 01:00:00 How Do I Shop For Groceries On The DASH Diet? 01:00:00 Dang! How Do I Eat At Restaurants On The DASH Diet? 01:00:00 Start Today 00:30:00 Mock Exam Final Exam