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 Business Strategy Planning will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Strategy Planning comes with accredited certification, 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 Business Strategy Planning. It is available to all students, of all academic backgrounds. Requirements Our Business Strategy Planning 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 24 sections • 163 lectures • 14:21:00 total length •Learn Business Fundamentals and Create Your Own Business Plan Today!: 00:02:00 •Quickfire Strategy Quiz How much do you know about your business strategy?: 00:02:00 •Quickfire Strategy Quiz - My 'Answers': 00:10:00 •How to get the most from this Course: 00:09:00 •Using the Course Map Matrix: 00:06:00 •Guide to the Course Assignments: 00:04:00 •Download All Course Materials Here: 00:03:00 •Section Introduction: Connecting Business Strategy to the Business Plan: 00:02:00 •Business Strategy to Business Plan: 00:04:00 •What do we mean by Business Strategy?: 00:02:00 •What is a Business Plan?: 00:06:00 •What do we mean by Corporate Strategy?: 00:07:00 •Should You Be Creating Shareholder Value?: 00:07:00 •Introduction to Strategic Management: 00:06:00 •Section Introduction: The Value of Strategic Analysis: 00:01:00 •Strategic Analysis - The First Step: 00:02:00 •What is Strategic Analysis?: 00:05:00 •Frameworks for Strategic Analysis: 00:10:00 •Strategic Analysis Frameworks Case Study: Apple: 00:11:00 •Section Introduction: Frameworks and Theories Business Strategists Must Know: 00:02:00 •Why are these Business Models important?: 00:02:00 •The Story of the Hedgehog and the Fox: 00:03:00 •Why are Management Theories Useful in Business Strategy?: 00:09:00 •SWOT Analysis: 00:05:00 •Introduction to Michael Porter's Five Forces Model: 00:06:00 •Lafley and Martin Five Step Strategy Model: 00:06:00 •The 5Cs Model: 00:06:00 •What is PEST or Broad Factors Analysis?: 00:05:00 •PESTEL Analysis: 00:05:00 •Ansoff Matrix: 00:07:00 •Value Chain: 00:05:00 •Business Model Synthesis: 00:08:00 •Black Swan Events - Coronavirus: 00:05:00 •Section Introduction: Critical Evaluation of Leadership: 00:01:00 •Vision and Leadership - Starting at the Top: 00:06:00 •What Skills Are We Looking For In Management?: 00:07:00 •What is the Purpose of a Vision Statement?: 00:03:00 •Section Introduction: Products Services and Competitive Advantage: 00:02:00 •What do we mean by Products and Services: 00:03:00 •Why Product Differentiation is Critical: 00:05:00 •Product Diversification in Business Strategy: 00:06:00 •How Does Quality Management fit into your Business Strategy?: 00:04:00 •What do we mean by Competitive Advantage?: 00:06:00 •Bowman's Strategic Clock - Strategic Positioning: 00:09:00 •Products, Services and Technology in the Business Plan: 00:06:00 •Section Introduction: Competition - Know Your Enemy: 00:02:00 •Competitor Analysis: 00:05:00 •BCG Matrix: 00:06:00 •Competitors and Competitive Forces: 00:10:00 •Competitive Intensity: 00:09:00 •Industry Life Cycle: 00:05:00 •Competition - Business Plan Tie In: 00:02:00 •Section Introduction: Industry, Markets and Competition: 00:02:00 •What do we mean by External Strategic Analysis: 00:09:00 •How Does Industry Analysis Help?: 00:05:00 •Conducting PEST or Broad Factors External Analysis: 00:11:00 •What are the Business and Funding Life Cycles?: 00:10:00 •Value Chains: Connecting Companies to their External Environment: 00:08:00 •Addressing the Total Addressable Market (TAM): 00:05:00 •Market Segmentation: Choosing Customers: 00:07:00 •Bargaining Power of Suppliers: 00:06:00 •Bargaining Power of Customers/Buyers: 00:06:00 •Business Plan: Industry, Markets and Competition: 00:04:00 •Section Introduction - Operations and Customer Management: 00:02:00 •What are Business Operations?: 00:03:00 •Strategic Analysis with the Business Model Canvas: 00:14:00 •How can Corporate Structure impact Strategy?: 00:07:00 •Organisational Development: 00:04:00 •Reviewing the Operations of the Firm: 00:03:00 •Click and Mortar - Online meets Offline: 00:05:00 •eCommerce Business Models: 00:06:00 •Internal Strategic Analysis - Business Plan Tie In: 00:05:00 •Section Introduction: Six Minute Strategist SWOT Assignment: 00:02:00 •Section Introduction: Customer Value Proposition: 00:02:00 •Understanding the Customer Value Proposition: 00:03:00 •Positioning Your Firm in the Market: 00:04:00 •What do we mean by a Profit Model?: 00:05:00 •Hax's Delta Model: 00:09:00 •Switching Costs and Customer Strategy: 00:03:00 •Managing the Customer Experience: 00:05:00 •What is the Customer Journey?: 00:06:00 •Customers, Customer Value and the Business Plan: 00:03:00 •Section Introduction: Sales and Marketing: 00:02:00 •The 5 Ps of Marketing: 00:06:00 •How Can You Plan Your Marketing?: 00:11:00 •Push Marketing Strategy: 00:03:00 •Pull Marketing Strategy: 00:04:00 •Understanding AIDA: 00:07:00 •Progressive Sequence of 9 Agreements: 00:07:00 •Pricing Strategies: 00:11:00 •Sales and Marketing in the Business Plan: 00:06:00 •Section Introduction: Digital Business Strategy Transformation: 00:02:00 •Why Do You Need A Digital Strategy Blueprint?: 00:07:00 •What Skills and Assets do you need to be a Digital Entrepreneur?: 00:07:00 •Digital Strategy Blueprint Overview: 00:18:00 •Digital Strategy - Customer Centric Transformation: 00:07:00 •Digital Strategy - Customer Experience Transformation: 00:05:00 •Digital Strategy - Customer Channel Transformation: 00:06:00 •Digital Strategy - Customer Engagement Transformation: 00:19:00 •Digital Strategy - Digital Skills Transformation: 00:04:00 •Digital Strategy - Tools and Resources: 00:02:00 •Section Introduction: Understanding Financial Statements: 00:02:00 •Overview of Financial Statements: 00:03:00 •GAAP: Accruals vs Cash Accounting: 00:06:00 •Income Statement or Profit and Loss Account: 00:08:00 •Introduction to the Balance Sheet: 00:11:00 •Cash Flow Statement: 00:06:00 •Cash Flow Metrics Explained: 00:09:00 •Case Study - Apple Financial Statements: 00:04:00 •Financial Statements in the Business Plan: 00:06:00 •Section Introduction: Strategic Financial Analysis: 00:01:00 •What is Financial Analysis?: 00:11:00 •Income Statement Profitability Ratios: 00:04:00 •Balance Sheet Ratio Analysis: 00:12:00 •Cash Flow Statement Analysis: 00:05:00 •Valuation Ratios: 00:04:00 •Section Introduction: Financial Analysis - Case Study and Assignment: 00:01:00 •Apple Inc Financial Analysis - Solution: 00:03:00 •Discussion of Measurements of Growth Analysis: 00:05:00 •Discussion of Measures of Profitability Analysis: 00:07:00 •Discussion of Trading Performance Analysis: 00:03:00 •Discussion of Working Capital (Liquidity and Efficiency) Analysis: 00:12:00 •Section Introduction: Future Business Strategy Analyser Assignment: 00:01:00 •Section Introduction: Goal Setting and Performance Management: 00:02:00 •Introduction to Goal Setting: 00:03:00 •What do we mean by SMART Goals?: 00:04:00 •Key Performance Indicators: 00:04:00 •Strategic Dashboards: 00:07:00 •Corporate Performance Management: 00:04:00 •Objectives and Key Results: 00:04:00 •Year over Year Performance: 00:04:00 •Section Introduction: Growth Strategies: 00:02:00 •Organic vs Inorganic: 00:03:00 •The Advantage of First Mover Advantage: 00:05:00 •The Importance of Scalability: 00:04:00 •Merger and Acquisitions Growth Strategies: 00:10:00 •Buy and Build Growth Strategy: 00:08:00 •Negative Growth- Company Recovery Strategies: 00:09:00 •Post Coronavirus Strategies: 00:06:00 •Growth Strategies Business Plan Tie In: 00:03:00 •Section Introduction: Valuation, Funding, Exits and Returns: 00:02:00 •Valuation and Funding - A Consequence of our Business Strategy: 00:04:00 •How to Value a Company: 00:11:00 •Sources of Equity Funding: 00:08:00 •What is a Pre-Money Valuation?: 00:06:00 •How to Create a Pitch Deck for Investors: 00:06:00 •Sources and Uses of Funds in the Business Plan: 00:02:00 •What is a Cap Table?: 00:05:00 •Exit Strategies and Returns: 00:09:00 •Transaction Cost Management: 00:02:00 •Section Introduction: Risk Assessment: 00:01:00 •Risk Assessment - Strategic Plan Summary: 00:02:00 •Section Introduction: Business Plan Synthesis: 00:03:00 •Business Plan Synthesis: 00:03:00 •Business Plan - Executive Summary: 00:02:00 •Business Plan - History and Background: 00:02:00 •Business Plan - Management Summary: 00:04:00 •Business Plan Appendicies: 00:04:00 •Key Questions Check List: 00:01:00 •Business Plan - Audience Targeting: 00:03:00 •Business Plan Refinement: Types of Businesses: 00:02:00 •Summary and Wrap Up: 00:05:00 •Additional File: 00:00:00
Follow your dreams by enrolling on the Microsoft Excel Masterclass course today and develop the experience, skills and knowledge you need to enhance your professional development. Microsoft Excel Masterclass will help you arm yourself with the qualities you need to work towards your dream job. Study the Microsoft Excel Masterclass training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Microsoft Excel Masterclass course will allow you to enhance your CV, impress potential employers, and stand out from the crowd. This Microsoft Excel Masterclass course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Microsoft Excel Masterclass course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Microsoft Excel Masterclass course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Microsoft Excel Masterclass course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Microsoft Excel Masterclass course. The Microsoft Excel Masterclass course is designed by industry experts and is tailored to help you learn new skills with ease. The Microsoft Excel Masterclass is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Microsoft Excel Masterclass when it suits you. Access the Microsoft Excel Masterclass course modules from any internet-enabled device, including computers, tablets, and smartphones. The Microsoft Excel Masterclass course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Microsoft Excel Masterclass now and start learning instantly! What You Get Out Of Studying Microsoft Excel Masterclass With Janets: Receive a digital Certificate upon successful completion of the Microsoft Excel Masterclass course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Microsoft Excel Masterclass training course is delivered through Janets' online learning platform. Access the Microsoft Excel Masterclass content from any internet-enabled device whenever or wherever you want to. The Microsoft Excel Masterclass course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment To successfully complete the Microsoft Excel Masterclass course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Microsoft Excel Masterclass course. After successfully passing the Microsoft Excel Masterclass course exam, you will be able to apply for a CPD-accredited certificate as proof of your Microsoft Excel Masterclass qualification. Certification All students who successfully complete the Microsoft Excel Masterclass course can instantly download their digital certificate. You can also purchase a hard copy of the Microsoft Excel Masterclass course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Microsoft Excel Masterclass is ideal for those who already work in this sector or are an aspiring professional. This Microsoft Excel Masterclass course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Microsoft Excel Masterclass is open to all students and has no formal entry requirements. To study the Microsoft Excel Masterclass course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Microsoft Excel Masterclass is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Microsoft Excel Masterclass and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Microsoft Excel Beginners Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Workbooks - Microsoft Excel Beginners Workbooks - Microsoft Excel 2019 00:00:00 Microsoft Excel Intermediate Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Workbooks - Microsoft Excel Intermediate Workbooks - Microsoft Excel Intermediate 00:00:00 Microsoft Excel Advanced Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Workbooks - Microsoft Excel Advanced Workbooks - Microsoft Excel Masterclass 00:00:00 Mock Exam Mock Exam - Microsoft Excel Masterclass 00:20:00 Final Exam Final Exam - Microsoft Excel Masterclass 00:20: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.
"Transform Your Career with the Microsoft Excel Certificate Online Bundle Course! Attention all professionals, entrepreneurs, and aspiring data analysts! Are you looking to enhance your skills and stand out in a competitive job market? Look no further! This comprehensive online bundle course combines the power of Microsoft Excel with crucial leadership and life coaching techniques to bring you a unique and comprehensive learning experience. In this bundle course, you will master the latest version of Microsoft Excel 2019, exploring its vast features and capabilities, which will teach you how to analyse data and make informed decisions using Excel's powerful data analysis tools. But it doesn't stop there. This bundle course also focuses on Leadership & Team Management and Life Coaching, respectively. These courses will equip you with the skills and knowledge to effectively lead and manage teams, as well as guide you towards a fulfilling personal and professional life. Don't miss this opportunity to level up your career and take your skills to the next level. Enrol in the Microsoft Excel Certificate Online Bundle Course today and embark on a journey towards success. The training materials of this Microsoft Excel bundle are available online for you to learn at your own pace and fast-track your career with ease. Course 01: Microsoft Excel 2019 Course 02: Data Analysis In Microsoft Excel Course 03: Leadership & Team Management Course 04: Life Coaching Course Learning Outcomes Here are a few important skills you will achieve from our course: Understanding of the latest version of Microsoft Excel 2019, including its features and capabilities. Ability to perform data analysis and make informed decisions using Excel's data analysis tools. Knowledge of leadership and team management principles and practices. Understanding of life coaching techniques to enhance personal and professional growth. Improved skills in managing and analysing data, leading and managing teams, and personal and professional development. Enhanced career prospects and competitiveness in the job market through the acquisition of in-demand skills and knowledge. Key Features Accredited by CPD Instant e-certificate Fully online, interactive Microsoft Excel course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases This Microsoft Excel Certificate Online Bundle Course is designed for professionals, entrepreneurs, and aspiring data analysts who are looking to enhance their skills and stand out in a competitive job market. It is also suitable for individuals who are interested in improving their data analysis skills, leadership abilities, and personal and professional development. Whether you are seeking to advance your career or start a new one, this course offers a comprehensive learning experience to meet your needs and help you achieve your goals. How You will be Benefited from Bundle You'll discover how to master Microsoft Excel skills while exploring relevant and essential techniques. All through this self-paced training, you will get engaging learning materials and acquire the necessary knowledge to work with various concepts to gain a competitive advantage in the employment market. Accreditation All of our courses included in this Microsoft Excel bundle are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Microsoft Excel course, you will immediately be sent digital certificates for the bundle courses. CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Excel Certificate Online Bundle Course is designed for professionals, entrepreneurs, and aspiring data analysts who are looking to enhance their skills and stand out in a competitive job market. It is also suitable for individuals who are interested in improving their data analysis skills, leadership abilities, and personal and professional development. Whether you are seeking to advance your career or start a new one, this course offers a comprehensive learning experience to meet your needs and help you achieve your goals. Requirements There are no formal requirements for this bundle courses to be enrolled. Career path This Microsoft Excel Certificate Course will facilitate your path to pursuing a career in - Investigator Data Analyst Business Analyst Excel Administrator Project Manager Well, let's talk about money, shall we? The average salary for these jobs in the UK is £28,000 per year. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.
Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Strategy for Management Consultants & Business Analysts bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The Strategy for Management Consultants & Business Analysts related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Strategy for Management Consultants & Business Analysts bundle will help you build a solid foundation to become a proficient worker in the sector. This Strategy for Management Consultants & Business Analysts Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :Successful Business Networking Skills Course Course 02 :Advanced Business Plan Course 03 :Business Management Training Course 04 :Business Process Management Course 05 :Business Etiquette & Professionalism Course 06 :Crisis Management Course 07 :Strategic Planning Process Course 08 :Fundamentals of Stakeholder Management Course 09 :Supply Chain Management Course 10 :HR and Payroll Administrator Course Course 11 :Office Skills Course 12 :SAP Controlling (CO) - Product Costing with S4HANA Course 13 :Business Intelligence | Basics of Data & Data Mining Course 14 :Financial Business Analysis Course 15 :Sage 50 Training Course 16 :Logistics & Operations Management - Level 5 Course 17 :Digital Marketing Diploma Level 3 Course 18 :Management Tools for Quality Control Course 19 :Business Development & Sales Course 20 :Strategic Business Management Course 21 :Business Productivity Training Course Course 22 :Managing Budgets Course 23 :Business Analysis Course 24 :Xero Accounting Diploma Course 25: Online Bookkeeping and Quickbooks Course Course 26: Social Media Marketing for Your Business Course 27: Surviving Small Business in Pandemic & Recession Course 28: Business Law Course 29: Certificate in Purchasing and Procurement Course 30: Six Sigma & Lean Process 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made Strategy for Management Consultants & Business Analysts bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Strategy for Management Consultants & Business Analysts Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Strategy for Management Consultants & Business Analysts bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Strategy for Management Consultants & Business Analysts Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.
Overview of Xero Accounting and Bookkeeping Online Join our Xero Accounting and Bookkeeping Online course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Xero Accounting and Bookkeeping Online course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Xero Accounting and Bookkeeping Online course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! Get a quick look at the course content: This Xero Accounting and Bookkeeping Online Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Xero Accounting and Bookkeeping Online. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Xero Accounting and Bookkeeping Online course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Xero Accounting and Bookkeeping Online is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Disclaimer Please be aware that this Xero Accounting and Bookkeeping Online is not certified or endorsed by Xero. Completing this course will not grant you any Xero certificate, certification, or badge. However, you will receive a CPD QS certificate upon completion of the course. Requirements You don't need any educational qualification or experience to enrol in the Xero Accounting and Bookkeeping Online course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Xero Accounting and Bookkeeping Online Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Introduction Introduction 00:02:00 Getting Started Introduction - Getting Started 00:01:00 Signing up to Xero 00:04:00 Quick Tour of Xero 00:12:00 Initial Xero Settings 00:13:00 Chart of Accounts 00:14:00 Adding a Bank Account 00:08:00 Demo Company 00:04:00 Tracking Categories 00:07:00 Contacts 00:12:00 Invoices and Sales Introduction - Invoices and Sales 00:01:00 Sales Screens 00:04:00 Invoice Settings 00:13:00 Creating an Invoice 00:18:00 Repeating Invoices 00:07:00 Credit Notes 00:06:00 Quotes Settings 00:03:00 Creating Quotes 00:07:00 Other Invoicing Tasks 00:03:00 Sending Statements 00:03:00 Sales Reporting 00:05:00 Bills and Purchases Introduction - Bills and Purchases 00:01:00 Purchases Screens 00:04:00 Bill Settings 00:02:00 Creating a Bill 00:13:00 Repeating Bills 00:05:00 Credit Notes 00:06:00 Purchase Order Settings 00:02:00 Purchase Orders 00:08:00 Batch Payments 00:12:00 Other Billing Tasks 00:02:00 Sending Remittances 00:03:00 Sending Remittances 00:03:00 Purchases Reporting 00:05:00 Bank Accounts Introduction - Bank Accounts 00:01:00 Bank Accounts Screens 00:07:00 Automatic Matching 00:04:00 Reconciling Invoices 00:06:00 Reconciling Bills 00:03:00 Reconciling Spend Money 00:05:00 Reconciling Receive Money 00:04:00 Find and Match 00:04:00 Bank Rules 00:09:00 Cash Coding 00:03:00 Remove and Redo vs Unreconcile 00:04:00 Uploading Bank Transactions 00:07:00 Automatic Bank Feeds 00:06:00 Products and Services Introduction - Products and Services 00:01:00 Products and Services Screen 00:02:00 Adding Services 00:03:00 Adding Untracked Products 00:03:00 Adding Tracked Products 00:07:00 Fixed Assets Introduction - Fixed Assets 00:01:00 Fixed Assets Settings 00:06:00 Adding Assets from Bank Transactions 00:06:00 Adding Assets from Spend Money 00:05:00 Adding Assets from Bills 00:02:00 Depreciation 00:04:00 Payroll Introduction - Payroll 00:01:00 Payroll Settings 00:15:00 Adding Employees 00:18:00 Paying Employees 00:10:00 Payroll Filing 00:04:00 VAT Returns Introduction - VAT Returns 00:01:00 VAT Settings 00:02:00 VAT Returns - Manual Filing 00:06:00 VAT Returns - Digital Filing 00:06:00 Assignment Assignment - Xero Accounting and Bookkeeping Online 00:00:00 Recommended Materials Workbook - Xero Accounting and Bookkeeping Online 00:00:00
Overview 2 day course on key interest rate derivative products, covering both theory (product mechanics, market conventions and valuation) and practice (wide range of applications for wide range of market participants showcased) Who the course is for Interest rate traders, salespeople and quants Asset-liability management staff with banks and insurance companies Fixed income and credit asset managers / hedge funds / pension funds / insurance companies Corporate treasurers Risk management Anyone using interest rate derivatives Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now
Overview Learn about contract triggers, including European vs. American style, and variations like one-touch, no-touch, and double no-touch options. Who the course is for Risk managers IT System developers Traders and derivatives teams Consultants and brokers Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now
Embark on a journey to master the multifaceted world of business with our comprehensive Business Studies course. From financial acumen to strategic analysis, and from human resources to contract law, equip yourself with the skills necessary to navigate and lead in the dynamic business landscape.