3456 Link courses

Overview Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work. This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it. You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in MS Excel 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 21 sections • 90 lectures • 22:14:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •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 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •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 •Apply Text Formats: 00:16: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:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •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 •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 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •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 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •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 •Create a Macro Using the Macro Recorder: 01:00:00 •Edit a Macro: 01:00:00 •Debug a Macro: 00:30:00 •Customize the Quick Access Toolbar and Hotkeys: 00:30:00 •Set Macro Security: 01:00:00 •Insert Text: 00:30:00 •Format Text: 00:30:00 •Sort Data: 00:30:00 •Duplicate Data: 01:00:00 •Generate a Report: 01:00:00 •Determine the Dialog Box Type: 00:15:00 •Capture User Input: 01:00:00 •Insert, Copy, and Delete Worksheets: 00:30:00 •Rename Worksheets: 00:30:00 •Modify the Order of Worksheets: 00:15:00 •Print Worksheets: 00:30:00 •Create User-Defined Functions: 00:30:00 •Automate SUM Functions: 00:30:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Advanced Diploma in MS Excel: 00:05:00

Overview Are you ready to dive into data analysis and unlock valuable insights that can drive business growth? Introduction to Data Analysis is a comprehensive course designed to provide learners with a solid foundation in the principles and techniques of data analysis. This course will equip you with the essential skills and knowledge to thrive in data analysis. With a comprehensive curriculum spanning 22 modules, you will delve deep into the world of data, from understanding its fundamentals to harnessing it for meaningful insights. Our expertly crafted curriculum covers data collection, process management, statistical tools, control charts, and strategies to deal with variation.Enrol today in this Introduction to Data Analysis course to succeed in all areas of your life. Let your skill become your greatest asset! Key Features of the Course This course equips learners with the essential tools and knowledge to analyse and interpret data accurately. The course is accredited, ensuring its recognition and credibility within the professional community. Learners will have access to 24/7 learning assistance, allowing them to seek guidance and support whenever needed. Who is This course for? This Introduction to Data Analysis course is suitable for students & professionals from various fields, including business, finance, marketing, healthcare, and more. It is also beneficial for individuals looking to enhance their data analysis skills for personal or professional development. What You Will Learn Throughout the course, you will delve into various modules that cover essential concepts and tools for data analysis. Starting with an introduction to process management principles, you will progress through topics such as the voice of the process, customer feedback analysis, and data visualisation using tools like Pareto charts, histograms, and run charts. You will also gain a deep understanding of variation and control charts and learn how to interpret and use them effectively for process improvement. By the end of the course, learners will have a solid understanding of these topics and be able to apply their knowledge to real-world data analysis scenarios. Why Enrol in This Course Data analysis is one of the most sought-after skills in today's job market. According to LinkedIn, data analysis is among the top 10 most in-demand skills for 2023. Data analysis can help you: Improve your decision-making skills and confidence Enhance your problem-solving and critical-thinking abilities Boost your creativity and innovation potential Increase your productivity and efficiency Advance your career and create earning potential Requirements There are no specific prerequisites for this course. However, a basic understanding of mathematics and statistics will be beneficial. Access to a computer with an internet connection is also required to complete the course. Career Path Completing this Introduction to Data Analysis course can lead to various career opportunities in data analysis. Some of the course-related professions in the UK, along with their average salaries, include: Data Analyst (£35,000 - £45,000 per year) Business Analyst (£40,000 - £55,000 per year) Financial Analyst (£40,000 - £60,000 per year) Market Research Analyst (£25,000 - £40,000 per year) Operations Analyst (£35,000 - £50,000 per year) Healthcare Data Analyst (£35,000 - £50,000 per year) Quality Control Analyst (£25,000 - £35,000 per year) Certification Upon successful completion of the course, learners will receive a CPD certificate, validating their achievement and demonstrating their commitment to professional development in the field of data analysis. Course Curriculum 3 sections • 24 lectures • 02:13:00 total length •Module 01: Introduction: 00:02:00 •Module 02: Agenda and Principles of Process Management: 00:06:00 •Module 03: The Voice of the Process: 00:05:00 •Module 04: Working as One Team for Improvement: 00:04:00 •Module 05: Exercise: The Voice of the Customer: 00:03:00 •Module 06: Tools for Data Analysis: 00:07:00 •Module 07: The Pareto Chart: 00:03:00 •Module 08: The Histogram: 00:03:00 •Module 09: The Run Chart: 00:04:00 •Module 10: Exercise: Presenting Performance Data: 00:05:00 •Module 11: Understanding Variation: 00:06:00 •Module 12: The Control Chart: 00:06:00 •Module 13: Control Chart Example: 00:04:00 •Module 14: Control Chart Special Cases: 00:06:00 •Module 15: Interpreting the Control Chart: 00:10:00 •Module 16: Control Chart Exercise: 00:07:00 •Module 17: Strategies to Deal with Variation: 00:06:00 •Module 18: Using Data to Drive Improvement: 00:14:00 •Module 19: A Structure for Performance Measurement: 00:06:00 •Module 20: Data Analysis Exercise: 00:06:00 •Module 21: Course Project: 00:03:00 •Module 22: Test your Understanding: 00:17:00 •Resources - Introduction to Data Analysis: 00:00:00 •Assignment - Introduction to Data Analysis: 00:00:00

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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 Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •Prepaid Expenses Accounting Definition: Prepayments: 00:03:00 •Prepaid Expense Example: How Accounting works for Prepayments: 00:03:00 •Advantages and Disadvantages of Prepaid Expenses: 00:03:00 •Introduction to PRO Excel Models and Formulas: 00:06:00 •Date Function: 00:05:00 •EOMONTH Function: 00:04:00 •DATEVALUE function: 00:03:00 •IF Function: 00:08:00 •IFS Function (Office 365 Only): 00:07:00 •VLOOKUP Function: 00:07:00 •MATCH Function: 00:05:00 •INDIRECT Function: 00:02:00 •NAMED Ranges: Name Manager: 00:03:00 •Advanced Version of VLOOKUP Function: 00:07:00 •Introduction to Model and Control Panel Tab (Important Sheet Tab): 00:08:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 1): 00:05:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 2): 00:06:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 3): 00:06:00 •IFS Function - Month End date Prepayment calculation: 00:04:00 •Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary): 00:09:00 •Protecting Formulas Cells and Fields in the Model: 00:04:00 •Exact Date Prepaid Amortisation calculation Intro: 00:03:00 •Formulas update and Model Changes for Exact Prepaid Exps Calculation: 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1): 00:04:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2): 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3): 00:02:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4): 00:07:00 •IFS Function - Exact Date Prepayments Amortisation: 00:04:00 •Data Validation Controls (Enhancing Data Input Controls with Protection): 00:10:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 1): 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 2): 00:09:00 •Additional Material: Resources: 00:00:00 •Power Query and Pivot Table Prepayment Summary Table Intro: 00:06:00 •What is Power Query and Some Awesome Resources for Power Query learning: 00:07:00 •Power Query and Pivot Table Summary - Deep Dive (Part 1): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 2): 00:04:00 •Power Query and Pivot Table Summary - Deep Dive (Part 3): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 4): 00:09:00 •Using Array Formulas to Add Formula Protection: 00:04:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1: 00:02:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2: 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version): 00:13:00 •Changing Macros Security in Excel: 00:05:00 •Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model: 00:06:00 •Bonus : New Version - Excel VBA Model for Prepayment Expenditure: 00:08:00 •Dynamic Dashboard Overview: 00:07:00 •Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets: 00:08:00 •Creating Dynamic Data Validation: 00:02:00 •Creating Named Ranges for Dynamic Table Arrays: 00:03:00 •Dynamic Date Column Headings for each Divisional PL Table: 00:02:00 •Dynamic Month and YTD Dashboard tables headings (PRO TIP): 00:03:00 •Dynamic VLOOKUP Formula - Preparing First section of the Dashboard: 00:04:00 •Creating Rolling Dashboard with Dynamic VLOOKUP Function: 00:08:00 •IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP): 00:03:00 •Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function): 00:05:00 •Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit: 00:05:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1): 00:03:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2): 00:06:00 •Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed: 00:05:00 •Understanding the data files before building dashboard: 00:02:00 •Consolidating Reports with Power Query (Get & Transform) , How to install PQ: 00:08:00 •Dynamic File Path Trick in Power Query with Parameters (Amazing trick): 00:06:00 •Conditional Cumulative totals with SUMIFS Function: 00:04:00 •Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code): 00:06:00 •Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise: 00:06:00 •Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast): 00:08:00 •Dashboard Creation - Line Charts: 00:08:00 •Update Dashboard with Additional Divisional Data with Few Click (Magical): 00:03:00 •Thank you: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00

Course Overview: Embark on an exhilarating journey into modern web designing with our captivating Counselling Course - Modern Web Designing - Level 2. This course presents an invaluable opportunity to explore the latest techniques and trends in web design, providing you with the skills to create visually stunning and user-friendly websites that captivate audiences.The Modern Web Designing - Level 2 course is meticulously designed to equip learners with a profound understanding of contemporary web design. It dives deep into essential components, ranging from the foundational pillars of HTML and CSS to the flexible utilities of Bootstrap, culminating in creating engaging landing pages and professional business sites. Enrol today and unlock your potential in the exciting world of modern web design. Key Features of the Course: CPD Certificate: Upon completing this course, you will receive a Continuing Professional Development (CPD) certificate, adding a valuable credential to your portfolio. 24/7 Learning Assistance: We will be available round the clock to provide comprehensive learning support, ensuring your success throughout the course. Who is This Course For? This course is tailored for individuals passionate about web design and those seeking to enhance their knowledge in this field. Whether you are a freelancer, entrepreneur, or aspiring web designer, this course will give you the essential skills and knowledge to excel in modern web design. What You Will Learn: In this comprehensive Counselling Course - Modern Web Designing - Level 2, you will undergo a transformative journey to become a skilled web designer. Starting with the fundamentals of HTML and CSS, you will learn to create and structure web pages, manipulate text and images, and create hyperlinks for seamless navigation. Building on this foundation, you will delve deeper into CSS, mastering the art of styling web pages with colours, borders, fonts, and backgrounds. You will also gain expertise in positioning, padding, and margin to achieve precise layout control. The course then introduces you to Bootstrap, a widely-used framework that enhances your design process. You will learn to install and utilise Bootstrap, harnessing its grid system to create responsive layouts adaptable to various screen sizes. Furthermore, you will incorporate interactive elements like images and buttons into your web pages using Bootstrap. As the course progresses, you will focus on creating specific types of websites. You will learn to design compelling landing pages that entice visitors and drive action. Techniques for showcasing key information, incorporating eye-catching images, and collecting user data through opt-in forms will be explored. Additionally, you will master the creation of business websites, implementing advanced techniques such as fancy fonts, dynamic carousels, Google Maps integration, and Font Awesome icons. Why Enrol in This Course: Top Reviewed Course: Our Counselling Course - Modern Web Designing - Level 2, has garnered rave reviews from learners worldwide, attesting to its effectiveness in delivering helpful and actionable knowledge. Recently Updated: This course has been meticulously updated to incorporate the latest trends, techniques, and best practices in modern web designing, ensuring you receive the most relevant and up-to-date training. Trending Skill: Web design is a highly sought-after skill in the digital era, with a growing demand for talented designers who can create captivating online experiences. By mastering this skill, you will be a valuable asset in the job market. Requirements: To enrol in this course, you only need a basic understanding of computer operations and access to a computer with an internet connection. No prior experience in web design is required. Career Path: Upon completing this course, you can pursue various rewarding careers in the field of web design, including: Web Designer - Average UK Salary: £30,000 to £45,000 Front-end Developer - Average UK Salary: £25,000 to £50,000 UI/UX Designer - Average UK Salary: £35,000 to £55,000 Freelance Web Designer - Average UK Salary: £200 to £400 Digital Agency Designer - Average UK Salary: £25,000 to £40,000 E-commerce Website Designer - Average UK Salary: £30,000 to £45,000 Graphic Designer - Average UK Salary: £20,000 to £35,000 Certification: Upon completing this course, you will receive a CPD certificate, demonstrating your proficiency in modern web design. This certificate will testify to your skills and enhance your credibility in the field. Don't miss out on this exciting opportunity to master the art of modern web design. Enrol in our Counselling Course - Modern Web Designing - Level 2 today and unlock your potential in the captivating world of web design. Course Curriculum 8 sections • 66 lectures • 08:06:00 total length •1.1 Intro: 00:03:00 •1.2 Install the Tools and Get Started: 00:05:00 •2.1 Intro to HTML: 00:01:00 •2.2 What is HTML: 00:11:00 •2.3 Start a New HTML File & Use Tags: 00:12:00 •2.4 Header Tags: 00:05:00 •2.5 Edit Text: 00:09:00 •2.6 Links: 00:09:00 •2.7 Images: 00:10:00 •2.8 Lists: 00:04:00 •2.9 Challenge 1: 00:16:00 •2.10 HTML Outro: 00:01:00 •3.1 CSS Intro: 00:04:00 •3.2 Add CSS Styles: 00:16:00 •3.3 Classes and IDs: 00:07:00 •3.4 Borders: 00:06:00 •3.5 Sizing: 00:04:00 •3.6 Padding and Margin: 00:07:00 •3.7 Text Styles: 00:04:00 •3.8 DIVs: 00:08:00 •3.9 Postioning: 00:08:00 •3.10 Hover: 00:03:00 •3.11 Easily Center Elements: 00:02:00 •3.12 Fonts: 00:06:00 •3.13 Challenge: 00:23:00 •3.14 CSS Outro: 00:01:00 •4.1 Intro to Bootstrap: 00:02:00 •4.2 Install Bootstrap: 00:10:00 •4.3 Indenting and Containers: 00:07:00 •4.4 The Grid System: 00:16:00 •4.5 Images: 00:07:00 •4.6 Buttons: 00:06:00 •4.7 Challenge 3: 00:11:00 •4.8 Bootstrap Outro: 00:01:00 •5.1 Landing Page Intro: 00:01:00 •5.2 Sketch Your Landing Page: 00:05:00 •5.3 The Top Section: 00:16:00 •5.4 Polish the Top Section: 00:06:00 •5.5 Adding Images: 00:11:00 •5.6 The Main Points Section: 00:14:00 •5.7 Collecting Emails With an Opt-In Form: 00:11:00 •5.8 Challenge 4: 00:03:00 •5.9 Landing Page Outro: 00:02:00 •6.1 Business Site Intro: 00:01:00 •6.2 Sketch Up: 00:03:00 •6.3 Using Fancy Font Logo: 00:07:00 •6.4 Carousel Basics: 00:10:00 •6.5 Carousel Extras: 00:09:00 •6.6 Text on Images: 00:15:00 •6.7 Phone Number Icon: 00:04:00 •6.8 Google Maps: 00:13:00 •6.9 Font Awesome: 00:09:00 •6.10 Challenge 4: 00:08:00 •6.11 Business Site Outro: 00:01:00 •7.1 Intro: 00:01:00 •7.2 Portfolio Sketch: 00:08:00 •7.3 Jumbotron: 00:10:00 •7.4 Nav Bar: 00:24:00 •7.5 Panels: 00:11:00 •7.6 Challenge 5: 00:13:00 •7.7 Portfolio Outre: 00:01:00 •8.1 Hosting: 00:01:00 •8.2 Bluehost: 00:06:00 •8.3 Uploading: 00:05:00 •8.4 Tips: 00:11:00 •8.5 Hosting Outro: 00:01:00

Overview This comprehensive course on Fitness Business - Sell Products, Training & Coaching Online will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This Fitness Business - Sell Products, Training & Coaching Online 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 Fitness Business - Sell Products, Training & Coaching Online. It is available to all students, of all academic backgrounds. Requirements Our Fitness Business - Sell Products, Training & Coaching Online 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 9 sections • 44 lectures • 03:08:00 total length •Who this course is for: 00:02:00 •What you will learn: 00:03:00 •Fitness Business Models Overview: 00:02:00 •The Coaching Business Model: 00:04:00 •Selling Products Business Model: 00:06:00 •Affiliate Marketing Business Model: 00:06:00 •Fitness Sponsorships: 00:02:00 •The First Steps: 00:03:00 •Finding The Right Fitness Niche: 00:04:00 •How To Identify The Ideal Coaching Client: 00:05:00 •How To Identify Your Clients Pain Points: 00:03:00 •How To Become An Expert: 00:04:00 •Understand What You Are Selling: 00:01:00 •Creating Your First Fitness Information Product: 00:07:00 •MVP - Minimal Viable Product: 00:03:00 •Creating Your First Workout Routine / Diet Plan: 00:04:00 •Writing Your First Fitness eBook: 00:06:00 •Recording Your First Fitness Video Course: 00:06:00 •Creating A Coaching Offer: 00:03:00 •Overview: 00:02:00 •Most Common Fitness Marketing Mistakes: 00:04:00 •Setting SMART Marketing Goals: 00:07:00 •Crafting A Stong Marketing Message: 00:06:00 •Choosing The Right Marketing Channel: 00:08:00 •Email Marketing For Your Product: 00:03:00 •How To Build An Email List: 00:03:00 •Your First Autoresponder Series: 00:10:00 •How To Build The Perfect Lead Magnet: 00:05:00 •How To Use WordPress For Your Fitness Business: 00:08:00 •Installing WordPress: 00:05:00 •Building A Landing Page: 00:06:00 •Building A Thank You Page: 00:03:00 •Starting A Niche Youtube Channel: 00:05:00 •Keyword Research For Youtube: 00:04:00 •My Youtube Content Strategy: 00:04:00 •How To Set Up Your First Lead Ad In Facebook: 00:06:00 •Affiliate Marketing Overview: 00:01:00 •Writing Blog Posts With Affiliate Links: 00:04:00 •Making Affiliate Sales With Youtube Videos: 00:03:00 •Motivation Intro: 00:01:00 •How To Deal With Difficult Customers / Clients: 00:03:00 •How To Deal With Email Overload: 00:04:00 •How To Develop The Mindset Of An Entrepreneur: 00:04:00 •How To Not Lose Track Of Your Business Goals: 00:05:00

Overview This comprehensive course on Electrical Machines for Electrical Engineering will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Electrical Machines for Electrical Engineering 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 Electrical Machines for Electrical Engineering. It is available to all students, of all academic backgrounds. Requirements Our Electrical Machines for Electrical Engineering 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 8 sections • 108 lectures • 14:20:00 total length •Module 1- Introduction to Electric Machines: 00:03:00 •Module 2- Types of Electric Machines and Principle of Electrical Generation: 00:09:00 •Module 1- Importance and Construction of DC Machines: 00:26:00 •Module 2- Armature Winding and EMF Equation: 00:40:00 •Module 3-Solved Example 1: 00:05:00 •Module 4-Solved Example 2: 00:04:00 •Module 5-Solved Example 3: 00:07:00 •Module 6-Solved Example 4: 00:06:00 •Module 7-Separately Excited DC Machine: 00:21:00 •Module 8-Shunt and Series DC Machines: 00:25:00 •Module 9-Solved Example 1 on Separately Excited DC Machine: 00:07:00 •Module 10-Solved Example 2 on Separately Excited DC Machine: 00:07:00 •Module 11-Solved Example 3 on Shunt Generator: 00:04:00 •Module 12-Solved Example 4 on Shunt Generator: 00:07:00 •Module 13-Solved Example 5 on Series DC Generator: 00:06:00 •Module 14-Types and Applications of Compound DC Motors: 00:07:00 •Module 15- Torque-Speed Characteristics and Speed Control of Separately Excited DC Motor: 00:33:00 •Module 16- Torque-Speed Characteristics of Series DC Motor: 00:08:00 •Module 17-Solved Example 1 on Speed Control: 00:08:00 •Module 18-Solved Example 2 on Speed Control: 00:06:00 •Module 19- Starting of DC Machine: 00:14:00 •Module 20- Armature Reaction in DC Machines: 00:10:00 •Module 21-Losses in DC Machines: 00:04:00 •Module 1- What is a Transformer: 00:02:00 •Module 2- Importance of Transformer: 00:04:00 •Module 3-Iron Core of Transformer: 00:04:00 •Module 4- Magnetic Circuit Inside Transformer: 00:05:00 •Module 5- Windings of Transformer: 00:03:00 •Module 6- Why are Windings Made of Copper: 00:01:00 •Module 7- Classification of Windings: 00:05:00 •Module 8- Insulating Material and Transformer Oil: 00:02:00 •Module 9- Conservator of Transformer: 00:03:00 •Module 10- Breather of Transformer: 00:04:00 •Module 11- Bushings of Transformer: 00:04:00 •Module 12- Tap Changer of Transformer: 00:03:00 •Module 13- Cooling Tubes of Transformer: 00:01:00 •Module 14- Buchholz Relay of Transformer: 00:02:00 •Module 15- Explosion Vent: 00:02:00 •Module 16- Methods of Cooling: 00:03:00 •Module 17-Types of Transformers: 00:03:00 •Module 18- Power Transformer and Distribution Transformer: 00:05:00 •Module 19- Single Phase Core Type Transformer: 00:04:00 •Module 20-Single Phase Shell Type Transformer: 00:05:00 •Module 21- 3 Phase Core Type: 00:02:00 •Module 22- 3 Phase Shell Type: 00:01:00 •Module 23- Comparison between Shell and Core CSA: 00:01:00 •Module 24- Comparison between Shell and Core Type: 00:01:00 •Module 25- Notes: 00:03:00 •Module 26-Video Explaining The Components in 3D and Real Life: 00:05:00 •Module 1- Introduction to Magnetic Circuits: 00:02:00 •Module 2- Induced Emf and Current: 00:04:00 •Module 3- Ampere Right Hand Rule: 00:04:00 •Module 4- Magnetic Circuit and Important Definitions: 00:06:00 •Module 5- Linear and Non Linear Materials: 00:03:00 •Module 6-Flux Linkage and Reluctance: 00:04:00 •Module 7- Analogy between Electric and Magnetic Circuits: 00:06:00 •Module 8- Fringing Effect: 00:02:00 •Module 9- Example 1 Magnetic Circuits: 00:07:00 •Module 10- Example 2: 00:03:00 •Module 11- Example 3: 00:06:00 •Module 12- Application on Magnetic Circuit - Transformers: 00:04:00 •Module 1- Introduction to Transformers: 00:02:00 •Module 2- Construction of Transformer: 00:02:00 •Module 3-Theory of Operation: 00:04:00 •Module 4- Ideal Transformer: 00:05:00 •Module 5-Non Ideal Transformer: 00:02:00 •Module 6- Effect of Loading on Transformer: 00:03:00 •Module 7- Transformer Regulation: 00:03:00 •Module 8- Transformer Losses: 00:03:00 •Module 9- Transformer Efficiency: 00:05:00 •Module 10- Transformer Rating: 00:02:00 •Module 11- Question 1: 00:01:00 •Module 12- Question 2: 00:02:00 •Module 13- Question 3: 00:01:00 •Module 14- Example 1: 00:01:00 •Module 15- Voltage Relation of Transformer: 00:04:00 •Module 16- Transformer Exact Equivalent Circuit: 00:06:00 •Module 17- Concept of Refereeing: 00:04:00 •Module 18- Approximate Equivalent Circuit: 00:02:00 •Module 1- Construction and Principle of Operation of Synchronous Generator: 00:29:00 •Module 2- Principle of Operation of Synchronous Motor: 00:24:00 •Module 3- Equivalent Circuit and Phasor Diagram of Non Salient Synchronous Machine: 00:29:00 •Module 4-Solved Example 1 on Non Salient Machine: 00:05:00 •Module 5-Solved Example 2 on Non Salient Machine: 00:11:00 •Module 6-Solved Example 3 on Non Salient Machine: 00:07:00 •Module 7- Solved Example 4 on Non Salient Machine: 00:04:00 •Module 8-Solved Example 5 on Non Salient Machine: 00:07:00 •Module 9-Solved Example 6 on Non Salient Machine: 00:03:00 •Module 10- Equivalent Circuit and Phasor Diagram of Salient Synchronous Machine: 00:39:00 •Module 11-Solved Example 1 on Salient Machine: 00:09:00 •Module 12- Solved Example 2 on Salient Machine: 00:05:00 •Module 13-Solved Example 3 on Salient Machine: 00:10:00 •Module 14- Parallel Operation of Two Generators: 00:17:00 •Module 15- Synchronization of Machine with Grid: 00:10:00 •Module 1- Construction and Theory of Operation of Induction Machines: 00:27:00 •Module 2- Equivalent Circuit and Power Flow in Induction Motor: 00:23:00 •Module 3- Torque-Speed Characteristics of Induction Motor: 00:20:00 •Module 4- Solved Example 1 on Induction Motor: 00:08:00 •Module 5-Solved Example 2 on Induction Motor: 00:06:00 •Module 6-Solved Example 3 on Induction Motor: 00:06:00 •Module 7-Solved Example 4 on Induction Motor: 00:18:00 •Module 8-Solved Example 5 on Induction Motor: 00:13:00 •Module 9- Methods of Speed Control of Induction Motor: 00:27:00 •Module 10- Methods of Starting of Induction Motor: 00:21:00 •Module 11-Solved Example on Motor Starter: 00:15:00 •Module 12- Principle of Operation of Doubly Fed Induction Generator: 00:11:00 •Module 13-Self Excited Induction Generator: 00:08:00 •Assignment - Electrical Machines for Electrical Engineering: 00:00:00

Course Overview: The demand for User Experience (UX) and User Interface (UI) designers is skyrocketing. Our Advanced Diploma in User Experience UI/UX Design is a comprehensive program that equips you with the knowledge and skills to craft seamless and user-centric designs that leave a lasting impact.Through a series of thoughtfully designed modules, learners will not only gain an understanding of UX/UI but also the dynamics of the Web Industry, Graphic Design implications, and the intricate details of UX Design, followed by an extensive dive into UI Design and Optimization techniques. Ultimately, the course incorporates a holistic understanding of the Careers in UX/UI, empowering students to venture confidently into this promising field.Enrol in this Advanced Diploma in User Experience UI/UX Design course today and start your journey to a successful career in UX or UI design! Key Features of the Course: CPD Certification 24/7 Learning Assistance Interesting Learning Materials Who is This Course For? This Advanced Diploma in User Experience UI/UX Design course is ideal for aspiring UX/UI designers, web developers, graphic designers, product managers, and professionals looking to enhance their design skills. Whether you are a beginner or have some experience in design, this course will help you develop a solid foundation and master the intricacies of UX/UI design. What You Will Learn: In the first part of the Advanced Diploma in User Experience UI/UX Design course, you will dive into the fundamentals, including the difference between UX and UI, the roles and responsibilities of designers in a team, and an overview of the web development process. You will also explore the psychology of colour, working with fonts and icons, and the essential tools and techniques used in graphic design. Moving forward, you will uncover the core principles of UX design, learn how to analyse user profiles, identify pain points, and create user personas. You will gain insights into customer journeys, sales funnels, and the principles of influence. Through hands-on projects, you will develop skills in creating storyboards, mood boards, and information architecture. In the latter part of the course, you will focus on wireframing, prototyping, and testing, ensuring your designs are user-friendly and intuitive. You will learn about usability reports, the "Above the Fold" rule, and optimisation using analytics and heat maps. The course also provides valuable guidance on launching a UX/UI design career, including freelancing, personal branding, and building a professional website. Why Enrol in This Course: Join thousands of satisfied learners who highly rated this Advanced Diploma in User Experience UI/UX Design course for its comprehensive curriculum and effective approach. Benefit from up-to-date industry insights and the latest design trends, ensuring you stay ahead of the curve. UX/UI design is one of the fastest-growing fields, offering abundant job opportunities and career growth potential. Develop your design thinking and problem-solving skills, unleashing your creative potential to craft extraordinary user experiences. Requirements: Enrolling in this Advanced Diploma in User Experience UI/UX Design course requires a basic understanding of design concepts and access to a computer with an internet connection. No prior coding or design experience is required. Career Path: Upon completing this Advanced Diploma in User Experience UI/UX Design course, you will be well-prepared for a range of exciting career opportunities, including: UX/UI Designer (£35,000 - £55,000 per annum) Web Developer (£30,000 - £45,000 per annum) Graphic Designer (£25,000 - £40,000 per annum) Product Manager (£40,000 - £70,000 per annum) UX Researcher (£35,000 - £50,000 per annum) Interaction Designer (£35,000 - £60,000 per annum) User Experience Architect (£45,000 - £75,000 per annum) Certification: Upon completing the Advanced Diploma in User Experience UI/UX Design course, you will receive a CPD certificate, widely recognised as a mark of excellence in the professional development of individuals. Enrol today and join the ranks of successful designers who have harnessed the power of user-centric design to create remarkable digital experiences. Course Curriculum 9 sections • 112 lectures • 12:52:00 total length •Learn UX/UI Course Overview: 00:05:00 •Section Overview: 00:04:00 •UX vs UI: 00:04:00 •UX/UI Designer Marketplace: 00:05:00 •Overview of UX Roles: 00:06:00 •Web Industry Section Overview: 00:03:00 •The Phases of Web Development: 00:13:00 •Designer Responsibilities (working in a team): 00:09:00 •Roles & Descriptions (working in a team): 00:05:00 •Agile Approach To Project Management: 00:12:00 •Scrum - Flexible Framework: 00:06:00 •Project Management Apps: 00:13:00 •XD Lesson - Introduction: 00:13:00 •Graphic Design Section Overview: 00:02:00 •The Psychology of Color: 00:13:00 •Color Wheel & Color Schemes: 00:06:00 •Working with Fonts: 00:10:00 •Working With Icons: 00:04:00 •XD Lesson - Tools, Object Manipulation and Components: 00:13:00 •XD Lesson - Font Styles and Artboard Settings: 00:07:00 •Graphic Design Software Tools: 00:03:00 •Adobe XD lesson 4 - Icons & Vector Graphics: 00:14:00 •UX Design Section Overview: 00:04:00 •What is User Experience Design? (UX): 00:09:00 •UX Design Process: 00:03:00 •The UX Analysis Process: 00:08:00 •Working with User Profiles: 00:03:00 •Understanding User Pain Points: 00:03:00 •XD Lesson 5 Class Project: Сompetitive Analysis: 00:10:00 •Developing a Persona Part 1: 00:05:00 •Developing a Persona Part 2: 00:05:00 •Customer Journey: 00:04:00 •Customer Journey vs Sales Funnel: 00:04:00 •3 Phases of a Sales Funnel: 00:07:00 •4 Stages of a Sales Funnel: 00:06:00 •Macro/Micro Conversions: 00:05:00 •Stages of Market Sophistication: 00:06:00 •Lead Generation Funnel: 00:06:00 •Digital Product Sales Funnel: 00:05:00 •7 Principles of Influence: 00:12:00 •Age Based Influence Triggers: 00:06:00 •Gender Influence Triggers: 00:06:00 •Interest Based Marketing: 00:04:00 •Understanding User Flow: 00:08:00 •XD Lesson 6 Class Project: Userflow - Your first UX deliverable: 00:07:00 •Working with Story Boards: 00:05:00 •XD Lesson 7 Class Project: Crafting a Story board: 00:09:00 •Working with Moodboards: 00:04:00 •XD Lesson 8 Class Project: Creating Moodboard: 00:11:00 •Sitemap & Information Architecture: 00:07:00 •XD Lesson - Class Project: App Architecture: 00:09:00 •Low and Hi Fidelity Wireframes: 00:03:00 •XD Lesson - Class Project: Login Screen Wireframe Using Material Design: 00:08:00 •Working with Prototypes: 00:04:00 •XD Lesson - Class Project: Home Screen Wireframe and Linking: 00:07:00 •XD Lesson - Class Project: Adding Interaction to Wireframes: 00:10:00 •Testing and Evaluating: 00:11:00 •UX Deliverables: 00:03:00 •UX Design Conclusion: 00:01:00 •UI Design Section Overview: 00:03:00 •UI Design Overview: 00:03:00 •Types of Interfaces: 00:10:00 •Landing Pages Overview: 00:10:00 •XD Lesson - Using Grids in XD: 00:08:00 •XD Lesson - Single Card design: 00:13:00 •UI Controls: 00:07:00 •UI Components: 00:12:00 •Navigational Components: 00:12:00 •Header Design Overview: 00:07:00 •XD Lesson - Mobile & Desktop: Header Design: 00:10:00 •XD Lesson - Mobile & Desktop: Dropdown Design: 00:06:00 •Common Layouts Overview: 00:08:00 •XD Lesson - Common Layouts: 00:07:00 •Mobile & Desktop Footer Design Overview: 00:07:00 •XD Lesson - Mobile & Desktop: Footer Design: 00:06:00 •Mobile & Desktop Button Design Overview: 00:05:00 •XD Lesson - Mobile & Desktop: Button Design: 00:10:00 •XD Lesson - Mobile & Desktop: Input Design: 00:07:00 •Mobile & Desktop Filter Search Bar Design Overview: 00:06:00 •Adobe XD Lesson - Mobile & Desktop: Filter Design: 00:07:00 •Adobe XD Lesson - Mobile & Desktop: Search Design: 00:03:00 •UI Kit Overview: 00:05:00 •Adobe XD Lesson - Desktop and Mobile: UI Kit: 00:06:00 •Microinteractions Overview: 00:05:00 •Adobe XD lesson - Microinteractions: 00:07:00 •Optimization Section Overview: 00:02:00 •Feedback Review & Getting Referrals: 00:04:00 •'Above the Fold' Rule: 00:04:00 •Adobe XD lesson - Designing a Powerful Above the Fold: 00:08:00 •Using Analytics For Optimization: 00:05:00 •Heat Maps & Element Placements: 00:04:00 •Crafting A Usability Report Overview: 00:08:00 •Adobe XD lesson - Crafting Reports in XD: 00:20:00 •Careers in UX/UI Section Overview: 00:06:00 •Your Daily Productivity Hub: 00:14:00 •How To Start Freelancing: 00:08:00 •Client Consulting: 00:04:00 •Building a Brand: 00:10:00 •Personal Branding: 00:06:00 •The Importance of Having a Website: 00:08:00 •Creating a Logo: 00:05:00 •Step by Step Website Setup: 00:17:00 •UI Templates: 00:06:00 •Logo Templates: 00:04:00 •Creating a Business Email: 00:06:00 •Networking Do's and Don'ts: 00:04:00 •Top Freelance Websites: 00:10:00 •UX/UI Project Scope Questions: 00:10:00 •Laser Focus & Productivity Tools: 00:06:00 •The Places to Find UX Jobs: 00:05:00 •Resources - Advanced Diploma in User Experience UI/UX Design: 00:00:00 •Assignment - Advanced Diploma in User Experience UI/UX Design: 00:00:00

The importance of social media marketing for businesses and organizations is no longer questioned. It has become a worldwide trend which helps businesses and organizations connect with their customers online. Now, every company needs a dynamic web presence. The Complete Online Course on Social Media for Business covers the concepts and application of social media marketing and will equip you with the skills to plan and implement a successful social media marketing strategy. You will understand the social media foundations, and how to plan goals and create a vision. You will learn how to meaningfully measure social media engagement using platforms such as Twitter, Facebook, blogs, LinkedIn, YouTube and their useful features. Who is this Course for? Complete Online Course on Social Media for Business is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. 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 the English language, numeracy and ICT are required to attend this course. 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 This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Social Media Marketing Introduction 00:30:00 Understanding the Value of Social Media Buzz and What It Can Do For Your Business 01:00:00 Developing a Winning Social Media Marketing Plan 01:00:00 Setup and Manage a Facebook Page That Works 01:00:00 Tweet Your Way to Online Prominence 01:00:00 Build Your Network with LinkedIn 01:00:00 Captivate Your Audience with YouTube 01:00:00 Conclusion 00:15:00 Social Media Management for Business Module One - Getting Started 00:30:00 Module Two - What is Social Media? 00:30:00 Module Three - Defining Your Social Media Policy (I) 00:15:00 Module Four - Defining Your Social Media Policy (II) 00:30:00 Module Five - Creating a Living Document 00:30:00 Module Six - Keeping an Eye on Security 00:30:00 Module Seven - Rules to Follow When Posting (I) 00:30:00 Module Eight - Rules to Follow When Posting (II) 00:30:00 Module Nine - Benefits of Social Media 00:30:00 Module Ten - The Pitfalls of Social Media 00:30:00 Module Eleven - Listen to Your Customers 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities 00:00:00 Facebook Marketing Basics Introduction to Facebook 00:15:00 Why You Should Care 00:15:00 Setting up a Facebook Page 00:30:00 How to Get More Likes for Your Facebook Page 00:30:00 Facebook Advertising 00:30:00 How Much Does Facebook Advertising Cost? 00:30:00 Marketing on Facebook 01:00:00 Create a Content Calendar 00:15:00 Understanding Edge Rank & the Art of Engagement 00:15:00 Twitter Marketing TWITTER FOR BUSINESS 00:15:00 TOP TWITTER TIPS 00:15:00 TWITTER IS 00:15:00 BUSINESS TERMS 00:15:00 WHY USE TWITTER FOR MARKETING 00:15:00 TWITTER MARKETING BASICS 01:00:00 TWITTER METRICS 00:30:00 YOUR BIO 00:15:00 WHEN TO TWEET 00:15:00 BUILDING YOUR COMMUNITY 00:15:00 GENERATING LEADS 00:15:00 REAL-TIME TWITTER MARKETING 00:15:00 ENGAGEMENT 00:15:00 TWETIQUETTE (TWEETING ETIQUETTE) 00:15:00 Social Bookmarking Introduction To Social Bookmarking 00:30:00 The Essential Benefits Of Social Bookmarking 00:30:00 Way To Use Social Bookmarking Correctly 00:30:00 Make Money Social Bookmarking 01:00:00 Identify The Social Bookmarking Competitors 00:15:00 Tips To Avoid Wrapping Traps 00:15:00 Recommended Reading Recommended Reading : Complete Online Course on Social Media for Business 00:00:00 Mock Exam Mock Exam- Complete Online Course on Social Media for Business 00:30:00 Final Exam Final Exam- Complete Online Course on Social Media for Business 00:30:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Intermediate is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Excel 2019 Intermediate is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. 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 This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Intro Introduction 00:01:00 Section 01 Linking Worksheets and Workbooks 00:07:00 Linking Worksheets with 3D References 00:05:00 Understanding the Consolidate Feature 00:06:00 Section 02 What are Range Names 00:06:00 Creating Range Names Using the Name Box and Define Name 00:06:00 Creating Range Names Using Create from Selection 00:03:00 Section 03 Understanding the Differences Between Sorting and Filtering 00:03:00 Sorting Lists 00:07:00 Filtering Lists 00:06:00 Creating Subtotals 00:05:00 Section 04 Creating Tables and Understanding the Benefits 00:06:00 Understanding the Elements of a Table 00:05:00 Formatting a Table 00:05:00 Sorting and Filtering Tables 00:04:00 Filtering with Slicers 00:07:00 Calculating with Tables 00:06:00 Removing Erroneous Table Data 00:05:00 Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 What is Conditional Formatting 00:03:00 Conditional Formatting-HIghlight Cells and Top Bottom Rules 00:06:00 Conditional Formatting-Data Bars, Icon Sets, and Color Scales 00:06:00 Using Custom Fonts and Colors 00:03:00 Using Custom Conditional Formatting 00:05:00 Modyfing or Removing Conditional Formatting 00:04:00 Section 06 What are Charts 00:06:00 Forecasting with Trendlines 00:05:00 Creating a Chart Template 00:04:00 Displaying Trends with Sparklines 00:08:00 Creating Charts 00:05:00 Understanding Chart Elements 00:05:00 Modifying Chart Elements 00:05:00 Changing and Moving Charts 00:03:00 Filtering a Chart 00:04:00 Formatting Charts 00:13:00 Adjusting Numbering 00:06:00 Creating Dual Axis Charts 00:05:00 Section 07 What is a PivotTable 00:05:00 Creating a PivotTable 00:07:00 Working with the PivotTable Fields Pane 00:10:00 Basic Data Organization and Analysis with PivotTables 00:08:00 Formatting PivotTables 00:05:00 Creating a PivotChart 00:04:00 Modifying and Formatting a PivotChart 00:04:00 Using Slicers and Timeline Slicers 00:08:00 Section 08 Using the PivotTable and PivotChart Wizard 00:03:00 Adding a Calculated Field 00:04:00 Adding a Calculated Item 00:04:00 Applying Conditional Formatting to a PivotTable 00:06:00 Creating Filter Pages for a PivotTable 00:04:00 Enabling the PowerPivot Add-in 00:11:00 Recap Recap 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview This comprehensive course on Life Coach Training - Guideline For The Startup will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Life Coach Training - Guideline For The Startup 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 Life Coach Training - Guideline For The Startup. It is available to all students, of all academic backgrounds. Requirements Our Life Coach Training - Guideline For The Startup 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 27 sections • 165 lectures • 10:06: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 •: 00:00:00 •: 00:00: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 •Assignment - Life Coach Training - Guideline For The Startup: 00:00:00