3078 Exercises courses

Key Objectives for the Training provision Effective listening to a client's needs and requirements during various stages of the sales process. Engage in meaningful communication with clients, learn to identify challenges and opportunities that relate to the prospects. Overcome the identified challenge. Build long term rapport and establish trust with the prospect throughout the sales process, Ensure continued customer satisfaction that can turn into repeat business. Be able to build rapport with customers or clients. Know the right questions to ask to fully understand the customer or client’s needs without putting on any pressure. Be able to check you have the right information from the customer or client. Be able to match products and services to the customer or client using the information you have gathered. Be able to influence effectively. Know how to stand out from your competitors. Stage 1 – Research the Company’s ‘Value Propositions’ and USP Analysis  Conducting 30 min confidential interviews with a cross-section of the eligible Attendees & the Stakeholders, in order to gain an objective understanding of the various scenarios and clients that the Participants work with. the Company’s ‘Value Propositions’ Unique Selling Points The Customers’ journey(s) The Competition’s offers for analysis and comparisons. From these findings, a carefully calibrated bespoke Programme will be designed and delivered.  Stage 2 - Design the Bespoke 2 x day Course  nd Stage 3 - Delivery of the Course Programme This Programme can be delivered in 2 x consecutive days, or split between 2 – 3 weeks, to make it more ‘work-friendly’ – if required. It is very practical and commercially focussed in approach, with lots of interactive exercises designed to draw out the learning applications via the debriefings. The ‘Real Play’ scenarios on day 2 will be based on specific case studies drawn from the Research findings so that they are authentic to optimise the learning. Individual Action Plans will be captured at the end of each day to be debriefed by the Participants’ respective Line Managers.  Template Programme Day One – Foundation – Strategic Approach Section One – The Principles of Consultative Selling Defining ‘Consultative Selling’ The Company’s ‘Unique Selling Points’ & Value Proposition The Consultative Selling model – the five stages Avoiding appearing ‘pushy’, ‘pressurising’ or ‘talking through the sale’ Section Two –Strategy & Preparation  ‘Buy-Class’ Matrix Strategic plan Template – matching services/products to identified needs & opportunities. Preparing a range of objectives Constants and variables – USP’s Researching key Client/Decision Makers’ priorities, profile & background (LinkedIn etc.) Preparing for potential & likely Objections Section Three – Email etiquette & ‘influencing’ email correspondence.  Email etiquette A.B.S.U.R.D model Clarity and tone – discovery of clients’ needs & motivational factors. Techniques to influence and ‘nudge’. Ensuring the data and content have a ‘gentle’ motivational & appealing message. Top Tips Day Two – Practical Application Section Four – Rapport Building & Effective Communication skills ‘Behaviour Labelling’ techniques – setting a positive tone. Asking Open Questions – gaining a full understanding of the clients’ priorities & expectations. EQ - Inviting opinions; perspectives; experiences – winning confidence. Active Listening – focus and commitment to understand. ‘Reading the room’ – adapting to responses and reactions. Maintaining focus on relevant topics that the Client cares about; carefully consider the opportunities to influence. But NO PRESSURE! Building a ‘bond of trust’ with commitments and authentic, shared values. Section Five – Explaining the Benefits – aligned to the Customers’ Priorities Understanding ‘Why do People Buy?’ Research data analysis. Open questions that lead to understanding the key issues and Clients’ priorities. Avoiding the danger of ‘pressurising’ the Client. Responding to objections effectively, with confidence and sensitivity. Explaining the benefits that are aligned to the Clients’ stated requirements. Making the Data ‘sing’ – memorable takeaways for the Client. Augmented benefits – Brand confidence; Case studies; Warranty; Service; Range; Flexibility etc. in alignment with their stated preferences/requirements Differentials compared to Competitors Section Six – Winning Commitment Inviting commitment – with confidence Consultative Selling Closing techniques (e.g. Alternative Close/Assumptive Close et al) Avoiding ‘talking through the sale’ – knowing when to ‘Shut UP!’ Confirming agreement – ensuring Clients’ motivation for repeat business Section Seven – Practical Application ‘Real Play’ From the Research findings, carefully devised scenarios can be generated to provide the most valuable learning opportunities to underpin all the skills & techniques covered in the Programme.  Potential Real Play scenarios: A well-established customer has indicated that they are soon to be opening up additional new offices – this presents an opportunity to arrange for the Company to support them with their upcoming needs. After some very positive feedback and with the upcoming contract renewal imminent – how can the Company give the Customer more high-quality support in other areas of their business? A Competitor has been to see the client and they have prompted some concerns about ‘value for money’ & ‘quality of service’. How Real Play works… The group is split the group into 2 sub-groups, one with our Professional Actor (option available); the other with the Trainer or a willing Participant. Each group has a brief and has to instruct their Trainer/Actor/Participant on how to approach the scenario supplied. The Actor and Trainer (or willing Participant) perform the role play(s) as instructed by their respective teams; however, during the action they can be paused for further recommendations or direction. The outcome is the responsibility of the team(s) – not the performers. Debrief the full Programme Individual Action Plans - to be followed through. ‘Best Practices’ for application into the business Options for Exercises within the Programme  Sample Exercise – Red & White  There is a specific time managed agenda and itinerary, which puts the group under pressure.  The key challenge is for the sub-groups to maximise the commercial value from the task, however there is always a great danger that the individuals attempt to gain financial progress at the expense of the other group! Debriefing points: Persuasive communication and influence across barriers Gaining buy-in when others are sceptical Strategic planning accounting for others’ behaviours Sample Exercise – Communication Challenge Each Participant has different pieces of information, but are not allowed to share it visually. They are only allowed to communicate to work out the solution hidden among the large amount of data. Debrief: Structured approach Maintaining focus through distractions/interference Active Listening Controlled communication Sample Exercise – Persuasive emails Sample emails are shared to be critiqued and improved upon to be debriefed: Tone & impact Making the Data ‘sing’ Influential & motivational language Customer centric message. Sample Exercise –Juggling   Each Participant has to pass the ‘Customers’ (Juggling balls) carefully through the system with all the other Participants to reach a profitable conclusion  Debrief: EQ to read the room and effectively communicate, when the pressure is on Customer focus and adapting to challenges Devising a plan that wins buy-in Overcoming competing ideas to get to ‘best practice’ Consistent commitment, communication and motivational drivers that influenced performance. Sample Exercise –Critical Path  The group are provided with 30 x discs and some ‘post-it’ notes. (no pens or pencils are allowed) Their brief is to create a grid shape with the 30 x discs, which will act as ‘stepping stones’ for the ‘Critical Path’ But they have to follow the correct order through the grid from the start to finish, which they will have to work out through ‘trial & error’ All of the team must pass through the ‘Critical Path’ worked out on the grid, observing the constraints, within the time limit. No talking is permitted once they start using the materials Debrief: - Clear communication focussing on the ‘client’s journey’ Planning for challenges Identifying risks and mitigating them Role allocations & support Quality control and disciplines  Sample Exercise –Back to Back  Each Participant is positioned back-to-back with a partner. They have to work out precisely what the ‘statement’ given to the other person is without looking around. Each person has a different brief. Debrief: - Asking Open Questions Active Listening Accuracy in identifying the objective.

Gym Instructor: Gym Instructor Course Online Tomorrow will be stronger than today! - This gym instructor training is all you need if you enjoy working out and want to make a living from your hobby. Our gym instructor course is intended to give trainees comprehensive knowledge of physical fitness and wellness. Your knowledge and practicality will be put to the test as a gym instructor. After completing this gym instructor course, you'll be able to assist your clients in reaching their fitness objectives and launch a lucrative career in the fitness sector. This Gym Instructor course will lead you to the pinnacle of achievement whether you are a newcomer in this sector or seeking to increase your expertise. It can, however, also lead to a highly fulfilling and happy job as a gym instructor. You will gain a thorough understanding of bodybuilding and weight training via our gym instructor course. In our gym instructor course, the variety of exercises, method of workout plan, and nutrition plan will also be briefly discussed. The workouts will all vary based on the individual's weight, height, and body type. So, in your duty as a gym instructor, you must care for their demands. Along with exercise, clients also need to get proper sleep and occasionally need supplements, which are exhaustively covered in our course for gym instructors. Don't be late if you want to be passionate about exercise. Just enrol in our Gym Instructor course to boost your fitness profession! Main Course: Gym Instructor Course Free Courses are including with this Gym Instructor: Gym Instructor Course Gym Instructor Course, We Offer a free Fitness Instructor Course Gym Instructor Course, We Offer a free Personal Trainer Course Special Offers of this Gym Instructor: Gym Instructor Course This Gym Instructor Course includes a FREE PDF Certificate. Lifetime access to this Gym Instructor Course Instant access to this Gym Instructor Course Get FREE Tutor Support to this Gym Instructor Course Gym Instructor: Gym Instructor Course Online Gaining new knowledge and skills is always necessary when working as a gym instructor; this course, "Gym Instructor: Gym Instructor," will equip you with all the information and abilities you need to be successful in this industry. This course on Gym Instructor will teach you about the science underlying the development of muscle. The Gym Instructor: A variety of bodybuilding and weight loss exercises, including bench presses, dumbbell squats, curls, lunges, deadlifts, bicycle crunches, and many more, are covered in the Gym Instructor course. Who is this course for? Gym Instructor: Gym Instructor Course Online Anyone who is interested in entering the fitness sector and pursuing a career as a gym instructor should take this course. Requirements Gym Instructor: Gym Instructor Course Online To enrol in this Gym Instructor: Gym Instructor Course, students must fulfil the following requirements. To join in our Gym Instructor Course, you must have a strong command of the English language. To successfully complete our Gym Instructor Course, you must be vivacious and self driven. To complete our Gym Instructor Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Gym Instructor Course Career path Gym Instructor: Gym Instructor Course Online You will have many job options available to you once you have finished this gym instructor training course. such as a nutritionist, gym instructor fitness coach, or physical trainer.

Overview Do you have the skills of a life coach? Have you ever considered a successful career in life coaching and CBT therapy?This Life Coaching and Cognitive Behavioural Therapy (CBT) Complete Bundle course will provide you with a solid understanding of life coaching. It'll cover many practical exercises, enabling you to master tools, techniques and the skills required to start your own coaching practice, if this is your motivation. Moreover, this course is a perfect starting point for anyone who is interested in a therapy career or for those who want to use CBT as a self help model.Don't be late. Enroll today and help to change people's lives with a brand new rewarding career in life coaching and CBT therapy.Please Note: Occupational Therapists and Clinical Psychologists must be registered with the Health and Care Professions Council (HCPC), which is the statutory regulator of the professions. Please note, that completion of the course does not entitle a person to join the HCPC Register or use the protected titles of Occupational Therapist or Clinical Psychologist. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Life Coaching and Cognitive Behavioural Therapy (CBT) Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our Life Coaching and Cognitive Behavioural Therapy (CBT) Complete Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 26 sections • 164 lectures • 10:11:00 total length •What You Will Learn: 00:06:00 •Get To Know Your Instructor: 00:02:00 •How To Get Your CPD Certificates: 00:01:00 •What Is Life Coaching: 00:05:00 •The Benefits Of Becoming A Life Coach: 00:04:00 •The Difference Between Coaching, Therapy, Mentoring & Training: 00:03:00 •The Responsibilities Of A Life Coach: 00:03:00 •Coaching Fundamentals Overview: 00:02:00 •Listening Introduction: 00:02:00 •The 3 Kinds Of Listening As A Coach: 00:05:00 •Your Listening Template: 00:11:00 •Questioning Introduction: 00:01:00 •Questioning & Coaching: 00:03:00 •How Coaching Questions Are Different From Normal Questions: 00:02:00 •The Different Types Of Coaching Questions: 00:12:00 •Questions Summary: 00:03:00 •Building Trust Introduction: 00:01:00 •The Trust Checklist Exercise: 00:03:00 •How To Build Trust As A Coach: 00:08:00 •More Trust Building Strategies: 00:05:00 •Understanding Personalities Overview: 00:03:00 •Big Five Personality Model: 00:02:00 •Myers Briggs Personality Model: 00:04:00 •Your Personality Model: 00:09:00 •How To Bring Out Your Strengths With This Model: 00:10:00 •Coaching Models Introduction: 00:02:00 •GROW Model Explained: 00:05:00 •STEPPPA Model Explained: 00:08:00 •FUEL Model Explained: 00:03:00 •CLEAR Model Explained: 00:04:00 •Why We Will Use The GROW Model: 00:01:00 •Step 1 Introduction: 00:03:00 •Why Defining Your Values Is Important: 00:03:00 •How To Define Your Personal Values: 00:06:00 •What Does Your Ideal Life Look Like?: 00:04:00 •The 4 Biggest Goal Setting Mistakes To Avoid: 00:06:00 •Stretch Goals Explained: 00:03:00 •Why You Should Start With Long Term Goals: 00:05:00 •Setting Your First Long Term Goal: 00:06:00 •Turning Long Term Goals Into Short Term Goals: 00:05:00 •Next Steps: 00:01:00 •Step 2 Introduction: 00:01:00 •Status Quo Explained: 00:06:00 •Wheel Of Life Excercise Explained: 00:06:00 •Big Rocks Exercise Explained: 00:05:00 •Coaching Example Step 2: 00:05:00 •Step 3 Introduction: 00:01:00 •How To Brainstorm With Your Client(s): 00:05:00 •How To Evaluate Your Brainstorming Ideas: 00:05:00 •'Spheres Of Influence' Excerise Explained: 00:03:00 •'Not To Do List' Exercise Explained: 00:04:00 •Coaching Example Step 3: 00:07:00 •Step 4 Introduction: 00:01:00 •The 80/20 Rule Applied To Coaching: 00:04:00 •How To Design An Action Plan: 00:03:00 •Coaching Example Step 4: 00:05:00 •GROW Model Recap: 00:03:00 •Structuring Your Sessions Introduction: 00:01:00 •How To Define Your Coaching Ground Rules: 00:03:00 •How Much Should You Charge: 00:05:00 •The Pre Coaching Call: 00:03:00 •Your First Coaching Session: 00:03:00 •Progress Evaluation Sessions: 00:05:00 •My Recommended Coaching Timeline: 00:03:00 •Client Coach Relationship Intro: 00:01:00 •What Clients Expect From Their Coaches: 00:04:00 •Why Clients Choose One Coach Over Another: 00:02:00 •Client Coach Boundaries: 00:03:00 •How To Retain Clients Long Term: 00:05:00 •Advanced Coaching Strategies Introduction: 00:01:00 •Reframing Explained: 00:07:00 •Managing Emotional States: 00:07:00 •Understanding Representational Systems: 00:08:00 •Personal SWOT Analysis: 00:06:00 •Johari Window - Developing Self Awareness: 00:05:00 •Giving Good Feedback As A Coach: 00:05:00 •Part 2 Introduction: 00:03:00 •What It Means To Be Healthy: 00:04:00 •What Does A Health Coach Do?: 00:03:00 •How Can You Combine Life Coaching & Health Coaching: 00:02:00 •Diet Introduction: 00:01:00 •Your Health & Diet: How They Are Linked: 00:04:00 •The Consequences Of Following A Bad Diet: 00:04:00 •How To Eat For Longevity: 00:02:00 •What Are Calories? Explained: 00:04:00 •The Relationship Between Bodyweight And Health: 00:05:00 •Calories & Bodyweight In A Healthy Diet: 00:02:00 •The Surprising Results Of The Twinkie Diet: 00:02:00 •The Relationship Between Weight Loss And Health: 00:03:00 •Figuring Out How Many Daily Calories You Need: 00:02:00 •Calculating Your Total Daily Calories: 00:03:00 •Healthy Weight Ranges: 00:02:00 •The Best Foods For A Healthier Life: 00:02:00 •Best Protein Foods: 00:01:00 •Best Carbohydrate Foods: 00:01:00 •Best Dietary Fat Foods: 00:01:00 •How Much Of Each (Protein, Carbs, Fat)?: 00:04:00 •What About The Remaining Calories: 00:01:00 •Client Assessment Introduction: 00:01:00 •Client Interview: 00:04:00 •How To Create A Diet Plan For Clients: 00:09:00 •Calculating BMI: 00:03:00 •Cardio Introduction: 00:01:00 •The Different Types Of Cardio: 00:02:00 •Creating A Cardio Workout For A Client: 00:04:00 •How To Monitor Your Heart Rate During A Workout: 00:02:00 •Cardio vs Weigh Training - Which Is Better For Weight Loss: 00:07:00 •Weight Training Introduction: 00:01:00 •Muscle Building Formula: 00:07:00 •The Science Behind Muscle Growth: 00:04:00 •Weight Training vs Bodyweight Training: 00:02:00 •How To Create A Beginner Workout Plan: 00:09:00 •5 Most Important Aspects Of Lifting Form: 00:03:00 •Progressive Overload: 00:03:00 •Hormones Introduction: 00:02:00 •The 3 Types Of Hormones: 00:03:00 •The Endocrine System Explained: 00:04:00 •Hormones & Heart Disease: 00:04:00 •Anabolic Steroids: Why They Are So Dangerous: 00:04:00 •Most Important Hormones Overview: 00:01:00 •Insulin: 00:04:00 •Glucagon: 00:02:00 •Adrenaline: 00:03:00 •Cortisol: 00:04:00 •Ghrelin: 00:02:00 •Leptin: 00:03:00 •Thyroid Hormones: 00:02:00 •Estrogen: 00:03:00 •Growth Hormone: 00:01:00 •Testosterone: 00:03:00 •How To Build Your Own Supplement Stack: 00:09:00 •Top 3 Beginner Supplements For Muscle Growth: 00:04:00 •The Best Supplements To Boost Immunity: 00:04:00 •The Best Supplements For Vegans & Vegetarians: 00:02:00 •The Best Supplements For Joint & Bone Health: 00:02:00 •The Best Supplements For Fat Loss: 00:04:00 •Apex Learning Motivation Introduction: 00:02:00 •How To Get Out Of A Workout Rut: 00:09:00 •What Is Nutrient Density: 00:04:00 •Is Brown Sugar Better Than White Sugar: 00:03:00 •What Should You Train On Your First Day At The Gym?: 00:07:00 •Are Microwaves Harmful?: 00:05:00 •Fresh vs Frozen Food: Which Is Healthier: 00:04:00 •Part 3 Introdudction: 00:02:00 •The Difference Between Stress & Anxiety: 00:03:00 •Short vs Long Term Stress: 00:02:00 •The Effects Of Stress & Anxiety On Your Body: 00:05:00 •Proven Stress Management Strategies & Techniques: 00:03:00 •The Benefits Of Calm Breathing: 00:03:00 •Breathing Exercise #1 - Three Part Breath: 00:02:00 •Breathing Exercise #2 - Bellows Breath: 00:02:00 •Progressive Muscle Relaxation: 00:03:00 •Complete PMR Routine: 00:07:00 •Sleeping For A Longer Life: 00:04:00 •Tips To Fall Asleep Faster: 00:03:00 •Supplements For Improved Sleep: 00:02:00 •What Is Emotional Self Care: 00:05:00 •How To Accept Yourself: 00:03:00 •Taming Your Inner Critic: 00:06:00 •Getting A Different Perspecitive: 00:04:00 •Acknowledging Your Qualities: 00:03:00 •Getting Rid Of Time Consuming Commitments: 00:06:00 •How To Say 'No' To Others: 00:05:00 •Resources - Life Coach Training - Guideline For The Startup: 00:00:00

Overview This comprehensive course on Positive Psychology Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Positive Psychology Masterclass comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Positive Psychology Masterclass. It is available to all students, of all academic backgrounds. Requirements Our Positive Psychology Masterclass is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 13 sections • 164 lectures • 08:40:00 total length •Create Capacity for True Success: 00:06:00 •Disconnect From the Grind: 00:04:00 •Create the Routine to Disconnect: 00:02:00 •Commit To the Disconnect Process: 00:02:00 •Activity: Define Your Disconnect Time: 00:02:00 •Stop Negative Self-Talk In Its Tracks: 00:05:00 •Identify Your Source of Pain: 00:01:00 •Acknowledge the Negative Thought: 00:02:00 •Define Yourself Relative to the Thought: 00:04:00 •Describe a New Reality: 00:04:00 •Verbalize the Positive Thought: 00:03:00 •Activity: Release a Negative Thought: 00:02:00 •Keep Your Joy Intact and Healthy With Positive Thoughts: 00:03:00 •Play the Vulnerability Game: 00:02:00 •Create Healthy Boundaries to Stay Positive: 00:03:00 •Make Your Process Attainable: 00:02:00 •Activity: Make Your Positivity a Reality: 00:01:00 •Become a Grounded Person Others Are Attracted To: 00:08:00 •Identify What Gives You Anxiety and Frustrations: 00:02:00 •Assume You're Not Grounded: 00:06:00 •Track What You Feel Obligated to Do: 00:04:00 •Identify When You Can't Turn Your Mind Off: 00:02:00 •Activity: Identify What Gives You Anxiety and Frustrations: 00:02:00 •Ground Yourself in A Positive Way: 00:03:00 •Assume You Are Not Fully Grounded: 00:02:00 •Assume You Have Nothing to Prove to Anybody: 00:01:00 •Set Aside Enough Time To Become Grounded: 00:02:00 •Discover the Grounding Breathing Exercise: 00:04:00 •Discover the Grounding Finger Exercise: 00:03:00 •Apply These Physical Grounding Exercises Daily In Your Life: 00:03:00 •Activity: Ground Yourself in A Positive Way: 00:02:00 •Solve Your Anxiety with Gratitude: 00:07:00 •Create a Gratitude Journal: 00:01:00 •Activity: Solve Your Anxiety with Gratitude: 00:01:00 •Solve Your Frustrations by Turning Them Around: 00:13:00 •Activity: Solve Your Frustrations by Turning Them Around: 00:01:00 •Be Significant Consistently: 00:10:00 •Become More Curious (Vs. Impressive) with People: 00:05:00 •Employ Curiosity Daily to Boost Your Positivity: 00:10:00 •Activity: Boost Your Baseline Positivity with Curiosity: 00:02:00 •Become a Good Judge of Character: 00:05:00 •Employ Character Assessing Questions: 00:04:00 •Assess Character during Conversation: 00:03:00 •Activity: Define and Identify High-Character for Yourself: 00:01:00 •Give and Expect Nothing In Return: 00:05:00 •Avoid Survival Mode: 00:02:00 •Activity: Be Comfortable Being Overt About Giving: 00:01:00 •Make People Feel Safe around You: 00:03:00 •Create Gratitude, Curiosity, and Optimism: 00:02:00 •Express Gratitude: 00:02:00 •Develop Curiosity: 00:02:00 •Practice Optimism: 00:02:00 •Activity: Enhance Your Three P's Of Mental Aptitude: 00:01:00 •Stay Even-Tempered and Patient: 00:04:00 •Recognize When You Are Being a Hare and Discourage the Rat: 00:03:00 •Activity: Map Your Positive Vision for Your Life: 00:02:00 •Maintain Responsibility and Realism: 00:02:00 •Set Positive, Realistic Goals Responsibly: 00:06:00 •Activity: Be Responsible For a Realistic Vision: 00:01:00 •Keep Your Hard Work from Going out The Window: 00:05:00 •Master Your Character and Concentration: 00:04:00 •Turn Around Character-Lacking Behaviors: 00:05:00 •Master Your Focus: 00:05:00 •Activity: Concentrate On Your Character to Master Positivity: 00:01:00 •Master Your Confidence and Courage: 00:02:00 •Grow the Seeds of Confidence: 00:03:00 •Have Courage to Put Your Confidence to Work: 00:03:00 •Use Courage to Grow Confidence: 00:02:00 •Activity: Grow Your Confidence and Courage: 00:02:00 •Identify and Mastery Your Capacity: 00:06:00 •Stabilize the Rollercoaster with Consistency: 00:05:00 •Activity: Manage Your Capacity and Consistency: 00:02:00 •How to Overcome Constant Negativity: 00:05:00 •Let Go of Holding Grudges: 00:03:00 •Redefine Your Success in Challenging Situations: 00:02:00 •Examine Non-Successful Situations: 00:01:00 •Determine Your Control over Upsetting Events: 00:02:00 •Activity: Release a Grudge: 00:02:00 •Be Difficult To Offend: 00:03:00 •Become Others-Focused: 00:05:00 •Activity: Write an Others-Focused Mission Statement: 00:01:00 •Neutralize Toxic People: 00:07:00 •Neutralize Toxic People Already In Your Life: 00:05:00 •Activity: Neutralize Toxic People: 00:02:00 •Don't Just Talk About 'It,' Be 'It': 00:04:00 •Identify How Gritty You Are: 00:01:00 •Describe Your Own Grit: 00:01:00 •Activity: Take the Grit Scale Assessment: 00:02:00 •Set Up Your Environment for Self-Control: 00:02:00 •Get Some Sleep: 00:01:00 •Purge Yourself of Negativity: 00:02:00 •Follow a Healthy, Daily Routine: 00:01:00 •Live With Zest and Excitement: 00:01:00 •Rise Up and Be Real: 00:02:00 •Activity: Incorporate the Five Healthy/Daily Habits in Your Life: 00:02:00 •Make Your Grit Sustainable: 00:02:00 •Direct Yourself to Sustained Grit: 00:02:00 •Focus On Solutions, Not Problems: 00:02:00 •Activity: Self-Coach To Sustain Your Grit: 00:01:00 •Become More Comfortable In Your Own Skin: 00:06:00 •Become More Relaxed: 00:02:00 •Work On Yourself to Help Others: 00:05:00 •Try a Form of Meditation: 00:02:00 •Activity: Create a Gratitude List: 00:01:00 •Get Physically Fit: 00:10:00 •Exercise to Feel Alive: 00:04:00 •Get to Sleep: 00:03:00 •Activity: Identify New Positive Healthy Habits: 00:01:00 •Develop Strong Body Language: 00:04:00 •Make a Strong First Impression: 00:04:00 •Make Eye Contact: 00:03:00 •Present Good Posture: 00:03:00 •Activity: Develop Strong Body Language: 00:02:00 •Practice the Respect That People Gravitate Toward: 00:04:00 •Identify Positive Boundaries: 00:04:00 •Demonstrate Positive Boundary Practices: 00:04:00 •Protect Your Mental and Emotional Health: 00:03:00 •Activity: Identify Your Positive Boundaries: 00:01:00 •Recognize Boundaries Where You Fall Short: 00:02:00 •Create Your Own Boundaries: 00:03:00 •Make Creating and Evaluating Them Routine: 00:02:00 •Activity: Reign in Your Boundary Short-Comings: 00:02:00 •Use Grit to Enforce: 00:02:00 •Use Conative Strengths to Enforce: 00:03:00 •Determine Your Boundary Enforcement Helpers: 00:02:00 •Activity: Enforce Your Boundaries: 00:01:00 •Become the Person You Are Meant To Be: 00:07:00 •Know Yourself through Strengths and Weaknesses: 00:07:00 •Solicit Input from Leaders: 00:03:00 •Enhance Your Strengths: 00:03:00 •Activity: Self-Identify Your Strengths: 00:01:00 •Embrace Change in Your Life: 00:04:00 •Become Proactive To Welcome Change In Your Life: 00:08:00 •Activity: Embrace Change to Achieve a Goal: 00:01:00 •Learn To Say 'No': 00:09:00 •Learn To Say No To Other Non-Key Commitments: 00:05:00 •Use Your Positive Success to Bring Positive Success to Others: 00:05:00 •Identify Your Greatest Gift for Others: 00:02:00 •Seek Outside Counsel: 00:02:00 •Assess To Gain Understanding: 00:02:00 •Activity: Consolidate Insights on Your Gift: 00:02:00 •Live Out the People You Serve: 00:04:00 •Honor Your Commitments to Your Team: 00:03:00 •Honor Your Commitments to Yourself: 00:03:00 •Activity: Reflect On Your Business Practices: 00:02:00 •Live Out How Well You Serve Others: 00:02:00 •Harness Your Vision: 00:02:00 •Be a Go-Giver: 00:02:00 •Activity: Apply the Five Laws: 00:01:00 •Be Free From a World of Struggle and Hurt: 00:09:00 •Identify Whose Business It Is: 00:02:00 •Identify When It's Your Business: 00:02:00 •Identify When It's Other People's Business: 00:05:00 •Activity: Identify Whose Business It Is: 00:01:00 •Find Safety to Detach: 00:01:00 •Separate Your Life from Who You Are As a Person: 00:05:00 •Separate a Value from a Thought: 00:06:00 •Show Empathy without Picking up The Rope: 00:11:00 •Activity: Find Safety to Detach: 00:02:00 •Look Forward to the Next No: 00:01:00 •Take Turtle Steps to Detach: 00:03:00 •Take Bigger Steps to the Next No: 00:06:00 •Activity: Look Forward to the Next No: 00:01:00 •Assignment - Positive Psychology Masterclass: 00:00:00

Every Wednesday at 16:05 – 16:40 (Newmarket Academy) or Every Saturday at 8:45 – 9:20 or 10:00 – 10:35 (Exning Community Church Hall) The piano is one of the most popular instruments among all western instruments. At M&L Music School we equip our piano players with all the necessary skills to play different styles of music using good technique. From beginners to grade 8 level (grade 5 is a level that would be enough to gain an A in a GCSE solo instrumental assessment). Piano Group Lessons are an encouraging and challenging environment that can be highly motivational. Learning and playing the piano in a group allows students to practice and perform in front of other people while building confidence. Our piano classes consist of learning pieces using notated music and by ear; scales; sight-reading; aural and technique exercises. We can prepare students to take Trinity guildhall grades, ABRSM, and Rock School piano or keyboard exams as well as performances. Book first lesson here: https://mandlschoolofperformingarts.com/book-first-lesson/

Duration 3 Days 18 CPD hours This course is intended for This in an intermediate and beyond-level course is geared for experienced Python developers looking to delve into the exciting field of Natural Language Processing. It is ideally suited for roles such as data analysts, data scientists, machine learning engineers, or anyone working with text data and seeking to extract valuable insights from it. If you're in a role where you're tasked with analyzing customer sentiment, building chatbots, or dealing with large volumes of text data, this course will provide you with practical, hands on skills that you can apply right away. Overview This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities. Throughout the course you'll: Master the fundamentals of Natural Language Processing (NLP) and understand how it can help in making sense of text data for valuable insights. Develop the ability to transform raw text into a structured format that machines can understand and analyze. Discover how to collect data from the web and navigate through semi-structured data, opening up a wealth of data sources for your projects. Learn how to implement sentiment analysis and topic modeling to extract meaning from text data and identify trends. Gain proficiency in applying machine learning and deep learning techniques to text data for tasks such as classification and prediction. Learn to analyze text sentiment, train emotion detectors, and interpret the results, providing a way to gauge public opinion or understand customer feedback. The Hands-on Natural Language Processing (NLP) Boot Camp is an immersive, three-day course that serves as your guide to building machines that can read and interpret human language. NLP is a unique interdisciplinary field, blending computational linguistics with artificial intelligence to help machines understand, interpret, and generate human language. In an increasingly data-driven world, NLP skills provide a competitive edge, enabling the development of sophisticated projects such as voice assistants, text analyzers, chatbots, and so much more. Our comprehensive curriculum covers a broad spectrum of NLP topics. Beginning with an introduction to NLP and feature extraction, the course moves to the hands-on development of text classifiers, exploration of web scraping and APIs, before delving into topic modeling, vector representations, text manipulation, and sentiment analysis. Half of your time is dedicated to hands-on labs, where you'll experience the practical application of your knowledge, from creating pipelines and text classifiers to web scraping and analyzing sentiment. These labs serve as a microcosm of real-world scenarios, equipping you with the skills to efficiently process and analyze text data. Time permitting, you?ll also explore modern tools like Python libraries, the OpenAI GPT-3 API, and TensorFlow, using them in a series of engaging exercises. By the end of the course, you'll have a well-rounded understanding of NLP, and will leave equipped with the practical skills and insights that you can immediately put to use, helping your organization gain valuable insights from text data, streamline business processes, and improve user interactions with automated text-based systems. You?ll be able to process and analyze text data effectively, implement advanced text representations, apply machine learning algorithms for text data, and build simple chatbots. Launch into the Universe of Natural Language Processing The journey begins: Unravel the layers of NLP Navigating through the history of NLP Merging paths: Text Analytics and NLP Decoding language: Word Sense Disambiguation and Sentence Boundary Detection First steps towards an NLP Project Unleashing the Power of Feature Extraction Dive into the vast ocean of Data Types Purification process: Cleaning Text Data Excavating knowledge: Extracting features from Texts Drawing connections: Finding Text Similarity through Feature Extraction Engineer Your Text Classifier The new era of Machine Learning and Supervised Learning Architecting a Text Classifier Constructing efficient workflows: Building Pipelines for NLP Projects Ensuring continuity: Saving and Loading Models Master the Art of Web Scraping and API Usage Stepping into the digital world: Introduction to Web Scraping and APIs The great heist: Collecting Data by Scraping Web Pages Navigating through the maze of Semi-Structured Data Unearth Hidden Themes with Topic Modeling Embark on the path of Topic Discovery Decoding algorithms: Understanding Topic-Modeling Algorithms Dialing the right numbers: Key Input Parameters for LSA Topic Modeling Tackling complexity with Hierarchical Dirichlet Process (HDP) Delving Deep into Vector Representations The Geometry of Language: Introduction to Vectors in NLP Text Manipulation: Generation and Summarization Playing the creator: Generating Text with Markov Chains Distilling knowledge: Understanding Text Summarization and Key Input Parameters for TextRank Peering into the future: Recent Developments in Text Generation and Summarization Solving real-world problems: Addressing Challenges in Extractive Summarization Riding the Wave of Sentiment Analysis Unveiling emotions: Introduction to Sentiment Analysis Tools Demystifying the Textblob library Preparing the canvas: Understanding Data for Sentiment Analysis Training your own emotion detectors: Building Sentiment Models Optional: Capstone Project Apply the skills learned throughout the course. Define the problem and gather the data. Conduct exploratory data analysis for text data. Carry out preprocessing and feature extraction. Select and train a model. ? Evaluate the model and interpret the results. Bonus Chapter: Generative AI and NLP Introduction to Generative AI and its role in NLP. Overview of Generative Pretrained Transformer (GPT) models. Using GPT models for text generation and completion. Applying GPT models for improving autocomplete features. Use cases of GPT in question answering systems and chatbots. Bonus Chapter: Advanced Applications of NLP with GPT Fine-tuning GPT models for specific NLP tasks. Using GPT for sentiment analysis and text classification. Role of GPT in Named Entity Recognition (NER). Application of GPT in developing advanced chatbots. Ethics and limitations of GPT and generative AI technologies.

A cosy feminine container of intuitive singing, nurturing touch and authentic expression.

Duration 5 Days 30 CPD hours This course is intended for This introductory-level Python course is geared for experienced users who want to use Python in web development projects, or system administrators and web site administrators who want to use Python to support their server installations, as well as anyone else who wants to automate or simplify common tasks with the use of Python scripts. Basic familiarity with any programming or scripting language would be helpful, along with a working, user-level knowledge of Unix/Linux, Mac, or Windows. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Throughout the hands-on course students, will learn to write essential Python scripts using the most current and efficient skills and techniques. Working in a hands-on learning environment, guided by our expert team, attendees will learn to: Create working Python scripts following best practices Use python data types appropriately Read and write files with both text and binary data Search and replace text with regular expressions Get familiar with the standard library and its work-saving modules Use lesser known but powerful Python data types Create 'real-world', professional Python applications Work with dates, times, and calendars Know when to use collections such as lists, dictionaries, and sets Understand Pythonic features such as comprehensions and iterators Write robust code using exception handling Mastering Python Programming is an introductory and beyond-level practical, hands-on Python training course that leads the student from the basics of writing and running Python scripts to more advanced features such as file operations, regular expressions, working with binary data, and using the extensive functionality of Python modules. Extra emphasis is placed on features unique to Python, such as tuples, array slices, and output formatting. This comprehensive, practical course provides an in-depth exploration of working with the programming language, not an academic overview of syntax and grammar. Students will immediately be able to use Python to complete tasks in the real world. An overview of Python What is python? Python Timeline Advantages/Disadvantages of Python Getting help with pydoc The Python Environment Starting Python Using the interpreter Running a Python script Python scripts on Unix/Windows Editors and IDEs Getting Started Using variables Builtin functions Strings Numbers Converting among types Writing to the screen Command line parameters Flow Control About flow control White space Conditional expressions Relational and Boolean operators While loops Alternate loop exits Array types About array types (AKA sequences) Lists and list methods Tuples Indexing and slicing Iterating through a sequence Nested sequences Sequence functions, keywords, and operators List comprehensions Generator Expressions Working with files File overview Opening a text file Reading a text file Writing to a text file Reading and writing raw (binary) data Converting binary data with struct Dictionaries and Sets About dictionaries Creating dictionaries Iterating through a dictionary About sets Creating sets Working with sets Functions Defining functions Parameters Global and local scope Nested functions Returning values Sorting The sorted() function Alternate keys Lambda functions Sorting collections Using operator.itemgetter() Reverse sorting Errors and Exception Handling Syntax errors Exceptions Using try/catch/else/finally Handling multiple exceptions Ignoring exceptions Modules and Packages The import statement Module search path Creating Modules Using packages Function and Module aliases An Introduction to Python Classes About o-o programming Defining classes Constructors Methods Instance data Properties Class methods and data Regular Expressions RE syntax overview RE Objects Searching and matching Compilation flags Groups and special groups Replacing text Splitting strings Using the Standard Library The sys module Launching external programs Math functions Random numbers Reading CSV data Dates and Times Working with dates and times Translating timestamps Parsing dates from text Formatting dates Calendar data Working with the File System Paths, directories, and filenames Checking for existence Permissions and other file attributes Walking directory trees Creating filters with fileinput Using shutil for file operations Advanced Data Handling Defaultdict and Counter Prettyprinting data structures Compressed archives (zip, gzip, tar, etc.) Persistent data Network Programming Using requests Grabbing web content Sending email Using SSH for remote access Using FTP Writing real-life applications Reading input files a la Unix Parsing command-line options Detecting the current platform Implementing logging Additional course details: Nexus Humans Mastering Python Programming (TTPS4820) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Mastering Python Programming (TTPS4820) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Master essential leadership skills and discover what it takes to become a great team manager or supervisor with the Team Management Skills course. This comprehensive course examines the characteristics and principles of effective leadership, from goal setting and providing feedback, to resolving conflict and managing your time. Our instructor-led training units are ideal for those who are new to their role and wish to fine tune their management style and approach to boos ttheir professional development. Master the art of public speaking, learn how to engage your audience and get your point across effectively with the Communication and Public Speaking Diploma. This training program will help you boost your confidence in delivering presentations and improve your body language to project confidence. This skills-based diploma also provides guidance on how to work with visual aids, plan your notes and overcome your fears and self-doubts. This course is ideal for those in customer or client-facing roles. Your Learning Goals: Develop your skills in time management, leadership and communication Understand how to provide constructive feedback and delegate work effectively Learn how to motivate teams and bring out the best in your employees Be able to resolve conflict and disagreements with professionalism Define your management style and understand which approach works for you Master the art of body language and learn how to project confidence in the workplace Improve your delivery in presentations and public speaking Know how to keep your audience engaged and use visual aids effectively Learn how to get your point across and express your ideas with conviction Discover practical mental exercises to help you remember your lines Who is this Course for? This course is ideal for line managers, supervisors and team leaders who are new to their role and wish to enhance their skillset. This masterclass is also suitable for anyone who wants to improve their public speaking and confidence in working with teams. 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 On successful completion, learners will have the practical skills and knowledge to kickstart their career and explore opportunities in the following roles: Team Manager Team Leader/Supervisor Entrepreneur Motivational Speaker Coach/Mentor Course Curriculum **Team Management** Introduction Getting Started 00:01:00 Setting Expectations Setting Expectations 00:03:00 Setting Expectations Case Study 00:01:00 Setting Goals Setting Goals 00:06:00 Setting Goals Case Study 00:01:00 Assigning Work Assigning Work 00:04:00 Assigning Work Case Study 00:01:00 Degrees of Delegation Degrees of Delegation 00:03:00 Degrees of Delegation Case Study 00:01:00 Implementing Delegation Implementing Delegation 00:07:00 Implementing Delegation Case Study 00:01:00 Providing Feedback Providing Feedback 00:05:00 Providing Feedback Case Study 00:01:00 Managing Your Time Managing Your Time 00:05:00 Managing Your Time Case Study 00:01:00 Resolving Conflict Resolving Conflict 00:04:00 Resolving Conflict Case Study 00:01:00 Tips for Special Situations Tips for Special Situations 00:05:00 Tips for Special Situations Case Stud 00:01:00 A Survival Guide for the New Supervisor A Survival Guide For The New Supervisor 00:03:00 A Survival Guide For The New Supervisor Case Study 00:01:00 Wrapping Up Wrapping Up 00:01:00 **Effective Communication** Working on Basics 101 Skill Of The Mouth 00:09:00 Communication 00:04:00 It's In The Eyes 00:05:00 You Have 40 Seconds 00:02:00 Body Language 00:06:00 Art Of Speaking 00:06:00 Working On It 102 Putting It Together 00:05:00 Content Is Key 00:06:00 To Joke Or Not To Joke 00:02:00 Learn Your Lines 00:06:00 Visual Aids 00:03:00 Working On Me 103 Walk The Talk 00:05:00 What Gives You The Edge 00:05:00 It's The Heart That Counts 00:04:00 Mirror Time 00:05:00 How To Deal With Stress 00:04:00 Fake it Till You Make It 00:07:00 Preparation On The Day 00:05:00 Working On Them 104 People Don't Care How much you know until they know how much you care 00:04:00 They Really Are Naked 00:03:00 Sing The Right Song 00:06:00 Know Your Venue 00:04:00 Public Speaking - Why Do It? 00:04:00 Conclusion Hello and Goodbye 00:02:00 Goodbye HD Final Online 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Excel VBA/Macros Foundations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Excel VBA/Macros Foundations course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00