Have you always dreamt of a high-flying career in the world of sales? Do you love the idea of working with customers on a daily basis? Does the thrill of the chase inspire you to work harder? If so, the Sales Management for Salesforce Course is perfect for you. Starting by building a foundational knowledge of the basics of sales, the course then teaches you a deeper understanding of the sales techniques you can use to boost your selling power to superstar status. The Sales Management for Salesforce Course will ensure you know how to tackle any sales problem you come up against, meaning you can be confident you'll always close the deal! What You Will Learn From the Sales Management for Salesforce Course: Discover the mindset you need to excel in the world of sales. Build your organisational skills and ensure you're prepared for every sales call. Learn the importance of product knowledge and how to emphasise the features and benefits of your products. Look at how to begin and close sales calls with customers. Delve into the reasons why people buy and how to use this in the sales process. Learn the essential sales techniques you need to know to succeed. Discover how to hold a high price and increase average order value. Look at how to sell in the long term and discover how you can get recommended to other potential customer. Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Sales Skills For Beginners Mindset Attitude 00:01:00 Values 00:03:00 Beliefs 00:02:00 How to Change Beliefs 00:04:00 Goals 00:06:00 Focus 00:02:00 The Extra Mile 00:03:00 Team Player 00:02:00 Accentuate the Positive 00:03:00 Be a Winner! 00:02:00 Organizational Skills Pre-call Research 00:02:00 Gaining Appointments 00:04:00 Pre-call Planning 00:04:00 Route Planning 00:04:00 Prioritizing your Time 00:02:00 Controlling the Controlable 00:03:00 Product Knowledge Know your Products 00:03:00 Features and Benefits 00:03:00 Customer Perception 00:02:00 Sales Calls Beginning Sales Calls 00:03:00 Listening & Question Listening Skills Part 1 00:07:00 Listening Skills Part 2 00:05:00 Uncovering Needs 00:05:00 Closing Sales Calls Closing a Sales Call 00:04:00 Following Up Post Call Analysis 00:05:00 Follow Up Actions 00:02:00 Onwards 00:01:00 Final Thoughts 00:01:00 Mastering Sales Techniques The Guaranteed Way to Improve Your Sales Technique The Number One Universal Killer Question in Selling 00:03:00 The Importance of Establishing the Clients Expectations 00:02:00 How to Close the Sale Without Sounding like a Salesman 00:04:00 Why People Buy and How to Get Them to Buy from Us People Buy Emotionally and Justify Logically. What to Do About It 00:04:00 Don't Assume You Know the Buyer's Priorities 00:05:00 How to Unearth the Buyer's Strategic Needs 00:03:00 The Importance of Implications 00:04:00 Why People Don't Buy and How to Counteract Any Objection Being Prepared for Objections 00:04:00 The Most Common Objections and How to Handle Them 00:04:00 How to Get People to Choose What You Want Them To 00:04:00 What Buyers Say and What They Really Mean 00:03:00 Holding a High Price What Does Value For Money Really Mean? 00:03:00 Five Proven Techniques to Save Money and Make Money 00:04:00 The Words: 'Typically', 'Realistically', 'Currently', 'Given' and 'Yet' 00:02:00 Justifying Your Price - the Power of One 00:04:00 The Final 'Killer Questions' That Allow You to Negotiate More Successfully 00:04:00 Win-Win and Increasing Average Order Value The Real Meaning of 'Win-Win' 00:04:00 The Rules for Discounting 00:03:00 How to Hold a High Price 00:04:00 How to Increase Average Order 00:03:00 The Compromise Effect 00:03:00 Sales Techniques You Need to Know All You Need to Know About Time Management 00:03:00 Recognising the Moment That Matters and the Role of 'Enough' 00:06:00 What to Do When It Starts Going Wrong 00:05:00 How to Understand Other People - Can You Clarify? 00:04:00 How to Build Your Reputation and Getting Your Client to Feel Indebted to You 00:04:00 Selling in the Long Term and Being Recommended 00:04:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Neurology: Neuroplasticity Practice Diploma Unlock the power of your brain with our Neurology: Neuroplasticity Practice Diploma. Explore cutting-edge techniques and exercises in Neurology to reshape your mind. Turn the latest Neurology research into actionable changes in your life. Learning Outcomes: Identify core principles of Neuroplasticity within Neurology. Apply physical Neuroplasticity techniques in Neurology practice. Integrate spiritual aspects of Neuroplasticity into Neurology. Implement Neuroplasticity exercises for anxiety and depression, guided by Neurology. Design Neuroplasticity exercises suitable for children, rooted in Neurology. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Neurology: Neuroplasticity Practice Diploma: Neurology: Intro to Neuroplasticity: Understand the foundational principles of Neuroplasticity within the domain of Neurology. Physical Neuroplasticity in Neurology: Master physical Neuroplasticity techniques and their applications in Neurology. Spiritual Neuroplasticity in Neurology: Learn how to incorporate spiritual Neuroplasticity in your Neurology practice. Neuroplasticity Exercises for Anxiety and Depression: Deploy specific Neuroplasticity exercises to alleviate anxiety and depression, following Neurology best practices. Neurology: Breaking Bad Habits: Explore the role of Neuroplasticity in habit formation and eradication in Neurology. Neuroplasticity Exercises for Kids: Craft age-appropriate Neuroplasticity exercises for children based on advanced Neurology research.
Course Title: Trigonometry for Electrical Engineering Overview: Unlock the Power of Trigonometry in Electrical Engineering! Are you ready to elevate your understanding of trigonometry and apply it directly to the field of Electrical Engineering? Our comprehensive course, 'Trigonometry for Electrical Engineering,' is meticulously designed to empower aspiring and seasoned electrical engineers alike, providing a deep dive into the fundamental principles of trigonometry and its practical applications in the realm of electrical systems. Key Features: Relevance to Electrical Engineering:Tailored specifically for electrical engineering professionals and students, this course focuses on real-world applications of trigonometry in electrical circuits, signal processing, and communication systems. Practical Problem Solving:Gain hands-on experience by solving practical problems and exercises designed to bridge the gap between theoretical knowledge and real-world scenarios encountered in electrical engineering projects. Comprehensive Curriculum:Covering essential trigonometric concepts such as sine, cosine, tangent, and their applications in AC circuits, phasors, and impedance, this course ensures a thorough understanding of trigonometry within an electrical engineering context. Interactive Learning:Engage with dynamic and interactive learning materials, including video lectures, simulations, and quizzes, to reinforce your understanding and foster a practical approach to problem-solving. Industry-Experienced Instructors:Learn from seasoned electrical engineers who bring a wealth of industry experience, sharing insights and best practices to help you apply trigonometric concepts effectively in your professional endeavors. Project-Based Assessments:Showcase your skills through project-based assessments that simulate real-world challenges in electrical engineering, allowing you to demonstrate your mastery of trigonometry in practical applications. Flexible Learning Schedule:Access course materials at your own pace, enabling you to balance your professional commitments while advancing your knowledge in trigonometry for electrical engineering. Who Should Enroll: Electrical engineering students seeking a comprehensive understanding of trigonometry. Electrical engineers looking to strengthen their skills and enhance problem-solving capabilities. Professionals working in related fields interested in applying trigonometry to electrical systems. Take the Next Step: Enroll in 'Trigonometry for Electrical Engineering' today and unlock the potential to excel in your electrical engineering career. Whether you're a student aspiring to build a strong foundation or a seasoned professional aiming to stay at the forefront of industry advancements, this course is your gateway to mastering trigonometry in the context of electrical engineering. Don't miss out on this opportunity to elevate your skills and open doors to new possibilities in the dynamic field of electrical engineering! Course Curriculum Introduction To trigonometry For Electrical Engineering Course Introduction To trigonometry For Electrical Engineering Course 00:00 Point Lines Angles Point Lines Angles 00:00 Intersecting Parallel Lines Triangles Intersecting Parallel Lines Triangles 00:00 Triangles Triangles 00:00 The Pythagorean Theorem The Pythagorean Theorem 00:00 Unique Triangles Ratios Unique Triangles Ratios 00:00 Trig Functions Tangents Trig Functions Tangents 00:00 The Unit Circle The Unit Circle 00:00 Trig Identities Trig Identities 00:00 Trig Identities Trig Identities 00:00 Double Half Angle Formulas Double Half Angle Formulas 00:00 Trig Functions In The Time Domain Draft Lesson 00:00
ð Unlock the Power of Efficient Encounters ð Are you tired of unproductive meetings that seem to go on forever? Want to transform your gatherings into dynamic, purpose-driven sessions that yield tangible results? Look no further than 'Efficient Encounters: A Comprehensive Handbook for Productive Meetings' - your ultimate guide to mastering the art of effective meetings! ð Here's what you'll discover in each module: ð Module 01: Mastering Meetings - A Complete Practical Guide to Meetings Get ready to dive into the fundamentals! Learn the ins and outs of conducting successful meetings, from setting objectives to creating an inclusive environment where every voice is heard. ð¤ Module 02: What to Expect Understand the meeting landscape and anticipate what makes a meeting truly effective. Explore the key elements that contribute to successful encounters and set the stage for productivity. ð° Module 03: The Cost of Meetings Discover the real impact of unproductive meetings on your time, resources, and organizational goals. Uncover strategies to minimize wasteful meetings and maximize your ROI. ð Module 04: Types of Meetings Not all meetings are created equal! Explore various meeting formats and understand when to utilize each type to achieve specific objectives efficiently. â° Module 05: Timing and Scheduling Timing is crucial! Learn the art of scheduling meetings effectively to optimize participation, minimize disruptions, and make the most of everyone's time. ð¤ Module 06: The Meeting Get equipped with practical tools and techniques to lead engaging and purposeful meetings. Learn to manage discussions, navigate conflicts, and drive toward actionable outcomes. ð Module 07: After Meeting Minutes Ensure your meetings are impactful even after they end. Master the art of taking concise and actionable meeting minutes to keep everyone aligned and accountable. ð Module 08: Considerations Explore various factors influencing successful meetings, including technology, cultural considerations, and diverse perspectives. Elevate your meeting game to the next level! ð¯ Ready to revolutionize the way you conduct meetings and make them a catalyst for progress? Enroll in 'Efficient Encounters' today and unlock the secrets to hosting purpose-driven, efficient meetings that drive results! ð Don't let unproductive meetings drain your time and resources. Join our community of meeting masters and embark on a journey toward impactful encounters! Sign up now! ð Course Curriculum Mastering Meetings - A Complete Practical Guide to Meetings What to Expect What to Expect 00:00 About Me 00:00 The Cost of Meetings What and Why 00:00 The Cost of Meetings 00:00 Types of Meetings Red Amber and Green Meetings 00:00 Timing and Scheduling Do You Need A Meeting 00:00 Timing Considerations 00:00 Contents of the Invite 00:00 Scheduling Etiquette 00:00 Considerations for Externals 00:00 The Meeting as an Opportunity 00:00 The Meeting Chairing Meetings - Intro 00:00 Chairing Meetings - Your Agenda 00:00 Chairing Meetings - Kicking Off 00:00 Chairing Meetings - During The Meeting 00:00 After Meeting Minutes After Meeting Minutes - Followups 00:00 Considerations Considerations as an Attendee 00:00 Conclusion 00:00
Are you currently involved with online sales? Or do you want to join the online world through marketing and sales? Do you wish to know effective strategies of lead generation? Then worry no more, this course will help you with that! Description: Lead Generation is essential to ensure the stability of your online sales. This course is designed to help you become an expert in online marketing. This will give you the correct information and help you through Lead Generation. In this course, you will be able to learn the basics of Lead Generation and how to create newsletters. You will acquire knowledge to upgrade your online marketing skills and be able to become more profitable. This course is perfect for anyone who needs to know about Lead Generations since it will help you build your online activities for you to be able to expand. Who is the course for? Marketing professionals who want to be an expert in Lead Generation People are interested in learning Lead Generation and how it works Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Lead Generation Crash Course will be very beneficial and helpful, especially to the following careers: Bloggers Businessmen Entrepreneurs Marketing and Promotions Specialists Marketing Managers Marketing Professionals Sales Managers Sales and Promotions Specialists Top Executives. Lead Generation Crash Course Introduction 01:00:00 Way To Use Of Newsletters 01:00:00 Utilizing Visualization Goals 00:30:00 Importance of Blogs 01:00:00 The Extraordinary Power of Visualizing Success 00:30:00 Wrapping Up 00:15:00 Mock Exam Mock Exam- Lead Generation Crash Course 00:20:00 Final Exam Final Exam- Lead Generation Crash Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Unleash the power of a resilient back with our groundbreaking course. In a world where physical health is paramount, fortify your foundation with invaluable insights. Dive into the science of injury prevention, unraveling the secrets to maintaining a robust spine. Discover the art of identifying lurking risks, ensuring you stay one step ahead. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access From the nuances of posture to the finesse of lifting techniques, master the essentials. Engage in back-friendly exercises and sculpt a body that stands resilient. Navigate injury prevention strategies and learn the alchemy of creating safe environments. Elevate your vitality and future-proof your physical well-being with this transformative journey. Course Curriculum Module 01: Introduction to Back Injury Prevention Module 02: Identifying Risk Factors for Back Injuries Module 03: Maintaining Proper Posture Module 04: Safe Lifting Techniques Module 05: Back-Friendly Exercises and Physical Activities Module 06: Injury Prevention Strategies and Creating a Safe Environment Learning Outcomes: Cultivate awareness of potential back injury risk factors. Perfect the art of maintaining an optimal and health-conscious posture. Hone the finesse of safe lifting techniques for daily activities. Integrate back-friendly exercises into your routine for enduring strength. Devise injury prevention strategies, creating a safe and secure environment. Foster a resilient spine, unlocking the secrets to lifelong well-being. CPD 10 CPD hours / points Accredited by CPD Quality Standards Preventing Back Injuries 1:32:10 1: Module 01: Introduction to Back Injury Prevention 12:54 2: Module 02: Identifying Risk Factors for Back Injuries 12:40 3: Module 03: Maintaining Proper Posture 16:27 4: Module 04: Safe Lifting Techniques 16:34 5: Module 05: Back-Friendly Exercises and Physical Activities 15:04 6: Module 06: Injury Prevention Strategies and Creating a Safe Environment 18:31 Who is this course for? Individuals seeking to fortify their physical health foundation. Professionals keen on preventing back injuries in their daily routines. Anyone curious about creating a safe and health-conscious living environment. Fitness enthusiasts aspiring to incorporate back-friendly exercises into their regimen. Individuals committed to mastering the art of safe lifting for lifelong vitality. Career path Occupational Health and Safety Advisor Personal Fitness Trainer Physical Therapist Workplace Ergonomics Consultant Fitness Class Instructor Health and Wellness Coach Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.
Unleash the power of a resilient back with our groundbreaking course. In a world where physical health is paramount, fortify your foundation with invaluable insights. Dive into the science of injury prevention, unraveling the secrets to maintaining a robust spine. Discover the art of identifying lurking risks, ensuring you stay one step ahead. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access From the nuances of posture to the finesse of lifting techniques, master the essentials. Engage in back-friendly exercises and sculpt a body that stands resilient. Navigate injury prevention strategies and learn the alchemy of creating safe environments. Elevate your vitality and future-proof your physical well-being with this transformative journey. Course Curriculum Module 01: Introduction to Back Injury Prevention Module 02: Identifying Risk Factors for Back Injuries Module 03: Maintaining Proper Posture Module 04: Safe Lifting Techniques Module 05: Back-Friendly Exercises and Physical Activities Module 06: Injury Prevention Strategies and Creating a Safe Environment Learning Outcomes: Cultivate awareness of potential back injury risk factors. Perfect the art of maintaining an optimal and health-conscious posture. Hone the finesse of safe lifting techniques for daily activities. Integrate back-friendly exercises into your routine for enduring strength. Devise injury prevention strategies, creating a safe and secure environment. Foster a resilient spine, unlocking the secrets to lifelong well-being. CPD 10 CPD hours / points Accredited by CPD Quality Standards Preventing Back Injuries 1:32:10 1: Module 01: Introduction to Back Injury Prevention 12:54 2: Module 02: Identifying Risk Factors for Back Injuries 12:40 3: Module 03: Maintaining Proper Posture 16:27 4: Module 04: Safe Lifting Techniques 16:34 5: Module 05: Back-Friendly Exercises and Physical Activities 15:04 6: Module 06: Injury Prevention Strategies and Creating a Safe Environment 18:31 Who is this course for? Individuals seeking to fortify their physical health foundation. Professionals keen on preventing back injuries in their daily routines. Anyone curious about creating a safe and health-conscious living environment. Fitness enthusiasts aspiring to incorporate back-friendly exercises into their regimen. Individuals committed to mastering the art of safe lifting for lifelong vitality. Career path Occupational Health and Safety Advisor Personal Fitness Trainer Physical Therapist Workplace Ergonomics Consultant Fitness Class Instructor Health and Wellness Coach Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.
Course Overview Master the art and strategy of bid writing with this comprehensive course to equip you with the expertise to transform your proposals into successful bids. The power of a well-crafted proposal is unmatched; it is a catalyst for new business opportunities and a bridge to successful partnerships. With the rise of competitive markets, the importance of bid writing cannot be overstated. When honed, it is a skill that can give your business the competitive edge it needs. This carefully curated and meticulously structured course dives into the nuances of bid writing, from understanding the proposal process to presenting your bid effectively. It covers many critical subjects, including planning and development, structuring bids, finding unique selling points, cost estimation, and more. Enrol today and start your journey to becoming a successful bid writer! Key Features of the Course Gain a CPD certificate upon course completion. Benefit from 24/7 learning assistance. Engage with compelling learning materials to enhance comprehension. Learn at your own pace, anytime, anywhere. Who is this Course For? This course is designed for anyone interested in or currently engaged in procurement and those seeking to enhance their bid writing skills. What You Will Learn The fundamentals of bid writing and proposal development. Structured approaches to writing compelling bids. Identification of unique selling points to distinguish your proposals. Accurate estimation and costing methods for effective pricing. Quality control mechanisms to produce flawless bids. Strategies for effective client presentations. The utilisation of templates for streamlined proposal building. Why Enrol in This Course Stand out in your field by mastering the essential skills of bid writing. With high ratings and recent updates reflecting industry trends, this course ensures learners stay ahead of the curve. Requirements Basic knowledge of business processes is recommended but not compulsory. Career Path Bid Manager: £50,000 per annum Procurement Officer: £30,000 per annum Contract Manager: £45,000 per annum Business Development Manager: £60,000 per annum Sales Director: £75,000 per annum Proposal Coordinator: £35,000 per annum Commercial Director: £80,000 per annum Certification Upon completion of the course, learners will receive a CPD certificate as a testament to their new skills. Course Curriculum 1 sections • 12 lectures • 06:00:00 total length •Module 01: Bid Writing: 00:30:00 •Module 02: Planning and Developing the Bid: 00:30:00 •Module 03: Structured Approach to Writing Bids: 00:30:00 •Module 04: Understanding the Proposal: 00:30:00 •Module 05: Proposal Process: 00:30:00 •Module 06: Focusing on Clients and Customers: 00:30:00 •Module 07: Finding Unique Selling Points: 00:30:00 •Module 08: Estimation Method: 00:30:00 •Module 09: Costing and Pricing: 00:30:00 •Module 10: Quality Control (Editing): 00:30:00 •Module 11: Client Presentation: 00:30:00 •Module 12: Templates for Proposal Building: 00:30:00
Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Introduction Introduction 00:03:00 Part 1: Forecasting Basics of Forecasting 00:05:00 Creating Linear Model with Trendlines 00:08:00 1.1 Getting Data Ready For Regression Model Gathering Business Knowledge 00:03:00 Data Exploration 00:03:00 The Data and the Data Dictionary 00:07:00 Univariate analysis and EDD 00:03:00 Discriptive Data Analytics in Excel 00:10:00 Outlier Treatment 00:04:00 Identifying and Treating Outliers in Excel 00:04:00 Missing Value Imputation 00:03:00 Identifying and Treating missing values in Excel 00:04:00 Variable Transformation in Excel 00:03:00 Dummy variable creation: Handling qualitative data 00:04:00 Dummy Variable Creation in Excel 00:07:00 Correlation Analysis 00:09:00 Creating Correlation Matrix in Excel 00:08:00 1.2 Forecasting Using Regression Model The Problem Statement 00:01:00 Basic Equations and Ordinary Least Squares (OLS) method 00:08:00 Assessing accuracy of predicted coefficients 00:14:00 Assessing Model Accuracy: RSE and R squared 00:07:00 Creating Simple Linear Regression model 00:02:00 Multiple Linear Regression 00:05:00 The F - statistic 00:08:00 Interpreting results of Categorical variables 00:05:00 Creating Multiple Linear Regression model 00:07:00 1.3 Handling Special Events Like Holiday Sales Forecasting in presence of special events 00:02:00 Excel: Running Linear Regression using Solver 00:08:00 Excel: Including the impact of Special Events 00:22:00 1.4 Identifying Seasonality & Trend for Forecasting Models to identify Trend & Seasonality 00:06:00 Excel: Additive model to identify Trend & Seasonality 00:09:00 Excel: Multiplicative model to identify Trend & Seasonality 00:06:00 Market Basket Analysis Market Basket and Lift - Introduction 00:08:00 Named Ranges - Excel 00:10:00 Indirect Function - Excel 00:05:00 2-way lift calculation in Excel 00:11:00 2-way lift calculation - Dynamic 00:07:00 2-way lift data table creation 00:07:00 3-way lift calculation 00:19:00 Store Layout optimization using Lift values 00:15:00 RFM (Recency, Frequency, Monetary) Analysis RFM (recency, frequency, monetary) Analysis 00:08:00 RFM Analysis in Excel- Part 1 00:16:00 RFM Analysis in Excel- Part 2 00:12:00 Part 2: Pricing Part 2: Pricing Steps of setting a Pricing policy 00:03:00 Different Pricing Objectives 00:07:00 2.1 Estimating Demand Estimating Demand 00:07:00 Forms of Demand Curve 00:02:00 Excel: Estimating Linear Demand Curve 00:08:00 Excel: Estimating Power Demand curve with Elasticity 00:05:00 Excel: Estimating Power Demand Curve with points 00:03:00 Subjective Demand curve 00:01:00 Excel: Estimating Subjective Demand Curve 00:02:00 2.3 Evaluating Pricing Strategies Price Bundling 00:07:00 Types of Bundling 00:08:00 The Bundling Problem 00:04:00 Excel: Solving Bundling problem Part 1 00:14:00 Excel: Solving Bundling problem Part 2 00:08:00 Non-Linear Pricing Strategies 00:03:00 Excel: Solving Bundling problem (Price Reversal) 00:08:00 3.1 Lifetime Customer Value Lifetime Customer Value - Key concepts 00:09:00 Lifetime Customer Value - Excel model 00:11:00 3.2 Variations And Sensitivity Analysis Sensitivity Analysis in Excel 00:07:00 Variations in finding customer value 00:07:00 Appendix 1: Excel Crash Course Basics 00:08:00 Worksheet Basics 00:16:00 Entering values and Formulas 00:07:00 Data Handling Basics - Cut, Copy and Paste 00:14:00 Saving and Printing - Basics 00:09:00 Basic Formula Operations 00:13:00 Mathematical Formulas 00:19:00 Textual Formulas 00:17:00 Logical Formulas 00:11:00 Date-Time Formulas 00:07:00 Lookup Formulas ( V Lookup, Hlookup, Index-Match ) 00:08:00 Data Tools 00:19:00 Formatting data and tables 00:18:00 Pivot Tables 00:08:00 Advance Excel- Solver, Data tables 00:15:00 Assessment Assessment - Retail Analytics In Microsoft Excel Diploma 00:10: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