• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

4307 Analyst courses

Advanced Excel Models using Formulas, VBA & Power Query

4.3(43)

By John Academy

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses 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 Excel Formulas Detailed: Introduction to three Excel Models 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 Formula Based Prepaid Expenses Model 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 Calculate Prepaid Expenses Amortisation from Exact Start Date 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 Prepaid Expenses Summary with Power Query and Pivot Table 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 Advanced VBA Prepaid Expenses Amortisation Model 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 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way 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 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic 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 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Excel Models using Formulas, VBA & Power Query
Delivered Online On Demand6 hours 8 minutes
£18

Corporate Finance: Profitability in a Financial Downturn

4.5(3)

By Studyhub UK

Navigate the complexities of financial resilience with our course, 'Corporate Finance: Profitability in a Financial Downturn'. This curriculum, thoughtfully structured into nine modules, offers an enriching learning experience focused on maintaining and enhancing corporate financial health during challenging economic times. Starting with an introduction to the principles of corporate finance, the course sets a strong foundation, preparing learners for more intricate topics. Advancing through the modules, participants are guided through long-term financial planning and growth strategies, crucial for sustaining business operations. The course delves into detailed financial statement analysis, capital budgeting techniques, and the balancing act of financial risk and return. Special attention is given to navigating periods of financial downturn, with two dedicated modules on sustaining and managing profitability during such challenging times. Learning Outcomes Gain a comprehensive understanding of corporate finance fundamentals. Develop strategic insights into long-term financial planning and growth. Master the skill of thorough financial statement analysis. Learn capital budgeting techniques and understand the risk-return tradeoff. Acquire strategies for managing and sustaining profitability during financial downturns. Why choose this Corporate Finance: Profitability in a Financial Downturn course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Corporate Finance: Profitability in a Financial Downturn course for? Business executives and managers aiming to fortify their financial decision-making skills. Financial analysts and advisors seeking advanced knowledge in corporate finance. Entrepreneurs and business owners desiring to navigate financial downturns effectively. Students and professionals aspiring to build a career in corporate finance. Corporate finance regulators and policy makers looking to deepen their industry understanding. Career path Financial Manager: £40,000 - £80,000 Investment Analyst: £35,000 - £70,000 Corporate Finance Advisor: £45,000 - £90,000 Chief Financial Officer (CFO): £60,000 - £120,000 Risk Management Specialist: £30,000 - £60,000 Financial Planner: £28,000 - £55,000 Prerequisites This Corporate Finance: Profitability in a Financial Downturn does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Corporate Finance: Profitability in a Financial Downturn Module 1 - Introduction to Corporate Finance 00:10:00 Module 2 - Long Term Financial Planning and Growth 00:28:00 Module 3 - Analysis of the Financial Statement 00:28:00 Module 4 - Capital Budgeting 00:26:00 Module 5 - Financial Risk-Return Tradeoff 00:18:00 Module 6 - Profitability During Financial Downturn 00:13:00 Module 7 - Managing Profitability in Financial Downturn 00:13:00 Module 8 - Corporate Finance Regulations 00:14:00 Module 9 - Career Path in Corporate Finance 00:12:00 Assignment Assignment - Corporate Finance: Profitability in a Financial Downturn 00:00:00

Corporate Finance: Profitability in a Financial Downturn
Delivered Online On Demand2 hours 42 minutes
£10.99

Product Testing Protocols for Quality Assurance

4.5(3)

By Studyhub UK

In the ever-evolving world of production, ensuring impeccable quality is paramount. 'Product Testing Protocols for Quality Assurance' offers a comprehensive dive into the methodologies and strategies vital for ensuring stellar product quality. Starting with the rudiments of product testing, the course delves deep into varied test types, utilising tools effectively, deciphering results, and the significance of adhering to global standards. With a robust curriculum encompassing everything from failure prevention to continuous improvement, this course is a passport to mastering the nuances of quality assurance in product testing. Learning Outcomes Understand the foundational principles of product testing. Identify and differentiate between various types of product tests. Master the art of designing and conducting product tests efficiently. Analyse and interpret testing outcomes to drive product quality. Recognise the importance of compliance, and adopt strategies for ongoing enhancement in product testing. Why buy this Product Testing Protocols for Quality Assurance? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Product Testing Protocols for Quality Assurance for? Quality assurance analysts and enthusiasts. Manufacturers keen on refining their product quality. Product developers aiming for benchmark quality standards. Team leaders responsible for product validation. Start-up founders launching new products and wishing to ensure top-notch quality. Career path Quality Assurance Analyst: £25,000 - £40,000 Product Testing Engineer: £30,000 - £50,000 Compliance Officer: £28,000 - £45,000 Quality Control Manager: £35,000 - £60,000 Product Development Specialist: £32,000 - £55,000 Continuous Improvement Manager: £40,000 - £70,000 Prerequisites This Product Testing Protocols for Quality Assurance does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 1: Introduction to Product Testing Introduction to Product Testing 00:11:00 Module 2: Types of Product Tests Types of Product Tests 00:16:00 Module 3: Planning and Executing Product Tests Planning and Executing Product Tests 00:15:00 Module 4: Testing Tools and Equipment Testing Tools and Equipment 00:10:00 Module 5: Interpreting Test Results Interpreting Test Results 00:11:00 Module 6: Compliance and Standards Compliance and Standards 00:09:00 Module 7: Preventing Failure and Surprises Preventing Failure and Surprises 00:14:00 Module 8: Communicating Test Results Communicating Test Results 00:18:00 Module 9: Continuous Improvement Through Testing Continuous Improvement Through Testing 00:10:00

Product Testing Protocols for Quality Assurance
Delivered Online On Demand1 hour 54 minutes
£10.99

Stock and Bond Investment Fundamentals: Building a Diverse Portfolio

4.5(3)

By Studyhub UK

In an age where financial stability is often the cornerstone of one's peace of mind, understanding the principles of investments becomes paramount. The course 'Stock and Bond Investment Fundamentals: Building a Diverse Portfolio' serves as a gateway to the intricate realm of investments. Dive deep into the world of stocks, bonds, and discover the nuances of the finance sector. Through meticulously designed modules, you'll grasp the core techniques and strategies required to build a robust and diverse investment portfolio. This is not just a course; it's your roadmap to achieving financial growth and stability. Learning Outcomes Grasp the foundational principles of investment. Understand the distinct characteristics of stock and bond markets. Gain insights into the finance world, underpinning successful investments. Acquire the knowledge to strategically trade stocks while managing risks. Develop expertise in curating a diverse investment portfolio for optimal returns. Why buy this Stock and Bond Investment Fundamentals: Building a Diverse Portfolio? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Stock and Bond Investment Fundamentals: Building a Diverse Portfolio there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Stock and Bond Investment Fundamentals: Building a Diverse Portfolio for? Beginners eager to delve into the world of investments. Financial enthusiasts looking to solidify their understanding of stocks and bonds. Those aiming to craft a diversified investment portfolio. Individuals looking to enhance their financial decision-making skills. Aspiring financial analysts and portfolio managers. Prerequisites This Stock and Bond Investment Fundamentals: Building a Diverse Portfolio does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Stock and Bond Investment Fundamentals: Building a Diverse Portfolio was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Investment Analyst: Average salary £50,000 - £60,000 Stock Broker: Average salary £40,000 - £55,000 Bond Trader: Average salary £60,000 - £70,000 Financial Planner: Average salary £45,000 - £55,000 Portfolio Manager: Average salary £70,000 - £90,000 Risk Management Specialist: Average salary £50,000 - £65,000. Course Curriculum Module 01: Introduction to Investment Introduction to Investment 00:07:00 Module 02: Types and Techniques Types and Techniques 00:10:00 Module 03: Key Concepts in Investment Key Concepts in Investment 00:09:00 Module 04: Understanding the Finance Understanding the Finance 00:10:00 Module 05: Stock Trading Basics Stock Trading Basics 00:18:00 Module 06: Investing in Bond Market Investing in Bond Market 00:08:00 Module 07: Investing in Stock Market Investing in Stock Market 00:10:00 Module 08: Risk and Portfolio Management Risk and Portfolio Management 00:10:00

Stock and Bond Investment Fundamentals: Building a Diverse Portfolio
Delivered Online On Demand1 hour 22 minutes
£10.99

Comparative Politics: UK and USA

4.5(3)

By Studyhub UK

Explore the intricacies of Comparative Politics, focusing on the United Kingdom (UK) and the United States (USA). Delve into the political systems, institutions, and processes of these two influential nations. Gain a comprehensive understanding of their governments, legislative bodies, executives, and judicial systems, as well as their electoral processes and democratic practices. Analyze comparative approaches to discern the similarities and differences in their political landscapes. Learning Outcomes: Understand the foundations of political systems in the UK and USA. Explore the US Constitution and its role in shaping American governance. Examine the workings of the US Congress as a vital legislative branch. Analyze the powers and responsibilities of the US President in the executive branch. Investigate the role of the Supreme Court in the US judicial system. Gain insights into the electoral processes and direct democracy mechanisms in both countries. Develop comparative analytical skills to assess political systems. Appreciate the complexities of global politics through a UK and USA lens. Why buy this Comparative Politics: UK and USA?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Comparative Politics: UK and USA you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Comparative Politics: UK and USA course is ideal for Students interested in political science and comparative politics. Aspiring political analysts and researchers. Professionals seeking to understand the political dynamics of the UK and USA. Individuals aiming to enhance their global political awareness. Prerequisites This Comparative Politics: UK and USA was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Political Analyst - Average Earnings: £25,000 - £60,000 per year. Researcher in Political Science - Average Earnings: £30,000 - £55,000 per year. International Relations Specialist - Average Earnings: £30,000 - £60,000 per year. Political Consultant - Average Earnings: £25,000 - £50,000 per year. Diplomat or Foreign Service Officer - Average Earnings: £25,000 - £60,000 per year. Course Curriculum Module 01: Introduction to Politics Introduction to Politics 00:18:00 Module 02: US Government Constitution US Government Constitution 00:12:00 Module 03: Congress - The Legislative Branch Congress - The Legislative Branch 00:09:00 Module 04: President - The Executive Branch President - The Executive Branch 00:13:00 Module 05: Supreme Court - The Judicial Branch Supreme Court - The Judicial Branch 00:11:00 Module 06: Electoral Process and Direct Democracy Electoral Process and Direct Democracy 00:16:00 Module 07: Comparative Approaches Comparative Approaches 00:12:00

Comparative Politics: UK and USA
Delivered Online On Demand1 hour 31 minutes
£10.99

Fundraising and Development Training Program

By Study Plex

Highlights of the Course Course Type: Online Learning Duration: 14 hours 49 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about investment banking and finance or capital fundraising Understand the core competencies and principles of investment banking and finance or capital fundraising Explore the various areas of investment banking and finance or capital fundraising Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert investment analyst or capital accountant Fundraising and Development Training: Investment Banking and Finance Program Course Master the skills you need to propel your career forward in investment banking and finance or capital fundraising. This course will equip you with the essential knowledge and skillset that will make you a confident investment analyst or capital accountant and take your career to the next level. This comprehensive fundraising and development training course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this fundraising and development training course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective investment banking and finance or capital fundraising practice and equip you with the essential skills, confidence and competence to assist you in the investment banking and finance or capital fundraising industry. You'll gain a solid understanding of the core competencies required to drive a successful career in investment banking and finance or capital fundraising. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for investment analyst or capital accountant or for people who are aspiring to specialise in investment banking and finance or capital fundraising. Enrol in this fundraising and development training course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive fundraising and development training course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this investment banking and finance or capital fundraising can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This fundraising and development training course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This fundraising and development training course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This fundraising and development training course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Supplementary Resources Supplementary Resources - Investment Banking and Finance: Venture Capital Fundraising 00:00:00 Welcome To The Course Welcome to This Course on Capital Raising for Entrepreneurs 00:05:00 Lets Get Started Right Away What Type of Investors are There Out There 00:05:00 What is the Difference between Venture Capital And Private Equity 00:05:00 What Stage is Your Business at 00:04:00 How Much Money Should Your Raise 00:04:00 What is the difference between Pre-Money and Post Money Valuation 00:01:00 An Introduction to Startups Startup Essentials - Markets 00:05:00 Startup Essentials - Profits 00:06:00 Startup Essentials - Business Plan 00:05:00 Startup Essentials - Capital 00:05:00 Startup Essentials - Value 00:06:00 Startup Essentials - Investors 00:05:00 Do You Really Understand Venture Capitalists Do You Really Understand Venture Capitalists 00:09:00 Do You Match Their Criteria 00:09:00 Four Key Questions to Ask 00:03:00 Understanding the Investment Process 00:07:00 How to Understand if you are Talking to The Right Investor Introduction: Understanding Your VCs; A Case Study 00:02:00 What Type of Investor are You Talking to 00:07:00 What is their Ideal Investment Size 00:05:00 What Stage Do They Invest At 00:03:00 Stage of Business Financing from a VC Perspective 00:05:00 How Can You Define Venture Capitalists' Sector Interest 00:03:00 What Part Does Geography Play 00:04:00 What is Meant by Style and Structure 00:04:00 What is Meant by Key Investment Criteria 00:03:00 Section Summary: Do You Understand VCs 00:04:00 Looking at Things From The VC Point of View Thinking Like a VC - How to Evaluate Deals Like a VC 00:04:00 What Factors are important to VCs 00:06:00 Considering Valuation from the VC Perspective 00:06:00 How do Investors Value Startups 00:07:00 How do Investors Value a Series A Investment 00:04:00 How do VCs look at your Market 00:04:00 What do VCs think about your Product or Service 00:05:00 How do VCs evaluate You and your Management Team 00:06:00 Why is Exit Strategy important to VCs 00:06:00 Why are Barriers to Entry important 00:06:00 How do VCs consider your Competition 00:04:00 What Financial Information is Important to VCs 00:03:00 What is the Typical VC Decision Making Process 00:04:00 Project: Evaluate Your Own Startup 00:02:00 What Questions Should You Ask Venture Capital 36 Questions to Ask a VC Overview 00:02:00 36 Questions to Ask a VC Part 1 - Fund Profile 00:03:00 36 Questions to Ask a VC Part 2 - Investment Style 00:02:00 36 Questions to Ask a VC Part 3 - Deal Flow 00:03:00 36 Questions to Ask a VC Part 4 - Process 00:03:00 36 Questions to Ask a VC Part 5 - Structure 00:03:00 36 Questions to Ask a VC Part 6 - Value Added 00:03:00 How to Email Venture Capital and Angel Investors How to Write an Introductory Email to an Investor 00:05:00 The Power of Forwardable Emails 00:02:00 How NOT to email investors 00:04:00 How to Find an Investors Email Address (If you Don't Have it) 00:05:00 What You to Know to Present Your Business to Investors How to Deliver a 60 Second Pitch 00:05:00 The Sixteen Magic Words Investors Want to Hear from You 00:09:00 How to Write a One Pager For a VC 00:08:00 Top Tips on Preparing to Pitch Investors 00:08:00 How to prepare a Pitch Deck for an Investor 00:08:00 How to Prepare a Financing Strategy 00:02:00 Key Elements of the Financial Plan 00:05:00 Startup Fundraising and Pitching Startup Fundraising - Getting Started 00:08:00 19 Reasons VCs May Say No 00:09:00 Communicating Your Vision 00:03:00 The Business Plan; Overview and Communication 00:07:00 Business Plan Core Contents 00:08:00 The Financial Plan 00:11:00 Pitching Your Business 00:11:00 The Pitching Process and Investor Returns 00:08:00 Pitching Dos and Don'ts 00:10:00 Post Mortems 00:07:00 What are Investors Looking For 00:07:00 How to Deliver Winning Presentation to Investors What do Investors Want 00:07:00 Bonus: Keys to a Successful VC Pitch 00:10:00 Outline Presentation Checklist 00:12:00 What is TAM, SAM and SOM and Why are They Important 00:05:00 AIDA - Why Pitching VCs is Like Buying a Car! 00:05:00 Selling Your Pitch 00:11:00 Pitching to Win. 00:10:00 How to Run the Meeting 00:08:00 Outline Management Presentation 00:13:00 Defending Your Plan 00:09:00 ACTIVITY: Create Your Own Presentation 00:01:00 Managing The Fundraising Process Can You Find Me The Right Investor. An Overview of the Process 00:15:00 How do Venture Capitalists Source Deals 00:03:00 How TO Find Angel Investors 00:04:00 How to Find Venture Capital Investors 00:02:00 BONUS: How to Find a Venture Capital Investor for Your Tech Company 00:10:00 What Happens Next The Investment Process 00:05:00 How to Manage The Investment Process 00:04:00 Venture Capital Term Sheets What is a Term Sheet Part 1 00:08:00 What is a Term Sheet Part 2 00:11:00 Key Concepts in Term Sheets 00:10:00 What is a Term Sheet Trying to Achieve 00:10:00 26 Key Components in VC Term Sheets 1 -5 00:04:00 26 Key Components in VC Term Sheets 6 - 10 00:04:00 26 Key Components in VC Term Sheets 11 - 15 00:04:00 26 Key Components in VC Term Sheets 16 - 20 00:04:00 26 Key Components in VC Term Sheets 21 - 26 00:06:00 Negotiating Term Sheets: Entrepreneurs Perspective 00:04:00 Negotiating Term Sheets: VC Perspective 00:06:00 Negotiating Term Sheets: Mutual Issues of Concern 00:02:00 Equity Crowdfunding for Entrepreneurs What is Crowdfunding 00:03:00 The Advantages of Equity Crowdfunding for the Investor 00:05:00 The Disadvantages of Crowdfunding for the Investor 00:04:00 How to Evaluate A Crowdfunding Opportunity? Introduction to How to Evaluate A Crowdfunding Opportunity 00:01:00 The Key Data You Need To Know For Any Opportunity 00:03:00 Evaluating the Business Summary 00:05:00 Evaluating the Financial Summary 00:04:00 Lets Take a look Now at Management Skills 00:03:00 Management Experience is Important as Well… 00:02:00 You must take a look at the Management's Commitment. 00:03:00 Lets Consider the Product Now and Start With The Market… 00:03:00 So, How Unique is This Product 00:03:00 What is the Competition like 00:03:00 Does The Product Have (All Important) Traction 00:03:00 How Profitable is the Product and Therefore the Investment 00:03:00 Lets Take a Look at the Most Critical Factor, Cash Flow 00:03:00 Finally, lets See What this all Means for your Investment Returns 00:03:00 Discover how you can turn this information into a Methodology. 00:02:00 Lets Summarise this Section With the 10 Most Important Factors 00:02:00 Introduction With Andrew Monk, CEO iolight About his Crowdfunding Experience Introduction 00:02:00 Why Did you Go For Equity Crowdfunding 00:04:00 What Did You Do Early On To Ensure Success 00:03:00 How Did You Go About Lining Up Your 25% 00:02:00 Did You Set About Trying To Collect Email Addresses 00:03:00 Lets Have The Investor Conversation 00:06:00 Are There Any Mistakes Looking Back You May Have Made 00:08:00 So What Is It Like By The End Of Week Three 00:07:00 How Does Crowdcube Get The Money To You 00:09:00 Are There Any Other Tools You Used That You Can Recommend 00:04:00 Bonus: Discussion About Campaign Videos 00:04:00 Summary and Wrap Up Course Summary And Wrap Up 00:03:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Fundraising and Development Training Program
Delivered Online On Demand
£19

Awareness of Tuberculosis Course

5.0(2)

By Training Express

Let’s face it—Tuberculosis isn’t just something from the history books. It’s very much a present-day issue, and the numbers are louder than ever. This Awareness of Tuberculosis Course cuts through the noise and brings clear, well-organised information to help learners understand how TB spreads, who’s at risk, and what steps can be taken to limit its impact. You won’t find fluff here—just the straight facts, smartly presented and easy to follow. Whether you’re looking to improve your knowledge for work or personal interest, this course keeps things simple, sharp, and relevant. You’ll explore the causes, symptoms, stages, and treatment approaches without needing to be a medical professional. From how TB behaves in different environments to the precautions people can take, this course keeps the science understandable and the content accessible. With each module, your awareness of TB becomes clearer, making you more confident in recognising and responding to this global health challenge. No lab coats or long lectures—just clear, accessible learning delivered online at your own pace. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01 : Introduction to Tuberculosis Module 02 : Epidemiology and Drug Resistance Module 03 : Diagnostic Methods for Tuberculosis Module 04 : Treatment of Tuberculosis Module 05 : TB Management and Control Strategies Module 06 : Prevention and Control of Tuberculosis Learning Outcomes: Understand the global impact of tuberculosis. Identify diagnostic methods for TB detection. Explore effective treatment approaches. Develop TB management and control strategies. Master prevention techniques for TB transmission. Acquire knowledge to contribute to TB awareness and control efforts. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Healthcare professionals Public health workers Medical students Researchers NGO staff Policymakers Community health educators Career path Epidemiologist Clinical Researcher Public Health Analyst Medical Doctor Nonprofit Health Worker Health Policy Advisor Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Awareness of Tuberculosis Course
Delivered Online On Demand1 hour
£12

Diploma in Operations Management Online

By Training Tale

Are you ready to advance your career in business management? With this exclusive Diploma in Operations Management, you can improve your business management skills and build a successful career for life! Discover why operations management is relevant in all industries and sectors! Diploma in Operations Management is a dynamic field with a straightforward goal. The goal for those in operations management is to maximise profits by balancing costs and revenues. Diploma in Operations Management aims to administer business practices in a way that drives efficiency and superior net profits by incorporating human resources, raw materials, technology, and equipment across the board. While the specific responsibilities of OM team members vary depending on the size and nature of the organisation, their efforts have an impact on all aspects of a company's operations. The purpose of this Diploma in Operations Management qualification is to provide learners with important information about the application and skills required in the Operations Management Sector. This prepares students to succeed in their professional life by teaching them the concepts of Supply Chain Management and its fundamentals, Risk Management, Talent Management, Project Management, Procurement Operations, Planning & Sourcing Operations, Maintenance Management, Conflict Management, Change Management, Stress Management, Negotiation skills and much more. Learning Outcomes After completing this Diploma in Operations Management course, the learner will be able to: Gain a thorough understanding of the functions and objectives of operations management. Understand the role of the OM in inventory and supply chain management. Understand project management and risk management. Gain in-depth knowledge about stock control and procurement operations. Understand product manufacturing and shipping. Understand contingency management and succession planning. Understand the importance of business etiquette. Why Choose This Diploma in Operations Management Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Diploma in Operations Management Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. >> Courses are included in this Bundle Course << Course 01: Diploma in Operations Management Course 02: Level 7 Diploma in Leadership and Management Course 03: Level 2 Diploma in Business Administration Course 04: Level 2 Certificate in Business Management Course 05: Level 5 Diploma in Business Analysis Course 06: Level 7 Diploma in Facilities Management Course Course 07: Level 7 Business Management Course Course 08: Minute Taking Course Course 09: Level 3 Business Administration Course 10: Level 5 Diploma in Risk Management Course Course 11: Level 5 Report Writing Course >> Other Benefits of Diploma in Operations Management Bundle Course << Free 11 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Diploma in Operations Management course] Course curriculum of Diploma in Operations Management Module 01: Understanding Operations Management Module 02: Understanding Process Management Module 03: Understanding Supply Chain Management Module 04: Understanding Planning & Sourcing Operations Module 05: Understanding Talent Management Module 06: Understanding Procurement Operations Module 07: Understanding Manufacturing and Service Operations Module 08: Understanding Succession Planning Module 09: Understanding Project Management Module 10: Understanding Quality Control Module 11: Understanding Product and Service Innovation Module 12: Understanding Communication Skills Module 13: Understanding Negotiation Techniques Module 14: Understanding Change Management Module 15: Understanding Maintenance Management Module 16: Understanding Conflict Management Module 17: Understanding Stress Management Module 18: Understanding Business Ethics for the Office Module 19: Understanding Business Etiquette Module 20: Understanding Risk Management ---------------------------------- Assessment Method After completing each module of the Diploma in Operations Management Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Diploma in Operations Management course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Diploma in Operations Management course is ideal for anyone passionate and ambitious about Operations Management. Learners can take this course even if they have no prior knowledge of Operations Management, and there are no age restrictions. Requirements There are no specific requirements for this Diploma in Operations Management course because it does not require any advanced knowledge or skills. Career path This Diploma in Operations Management could be extremely beneficial to business owners and aspiring entrepreneurs to pursue their goals. The following are more formal positions in the field of operations management: Operations Manager, Analyst & Officer S.C Manager Inventory Manager Supply Services Representative Inventory Controller & Planner Certificates Certificate of completion Digital certificate - Included

Diploma in Operations Management Online
Delivered Online On Demand4 days
£34

Level 7 Diploma in Operations Management Course

By Training Tale

Are you ready to advance your career in business management? With this exclusive Level 7 Diploma in Operations Management, you can improve your business management skills and build a successful career for life! Discover why operations management is relevant in all industries and sectors! Level 7 Diploma in Operations Management is a dynamic field with a straightforward goal. The goal for those in operations management is to maximise profits by balancing costs and revenues. Level 7 Diploma in Operations Management aims to administer business practices in a way that drives efficiency and superior net profits by incorporating human resources, raw materials, technology, and equipment across the board. While the specific responsibilities of OM team members vary depending on the size and nature of the organisation, their efforts have an impact on all aspects of a company's operations. The purpose of this Level 7 Diploma in Operations Management qualification is to provide learners with important information about the application and skills required in the Operations Management Sector. This Level 7 Diploma in Operations Management prepares students to succeed in their professional life by teaching them the concepts of Supply Chain Management and its fundamentals, Risk Management, Talent Management, Project Management, Procurement Operations, Planning & Sourcing Operations, Maintenance Management, Conflict Management, Change Management, Stress Management, Negotiation skills and much more. Learning Outcomes After completing this Level 7 Diploma in Operations Management course, the learner will be able to: Gain a thorough understanding of the functions and objectives of operations management. Understand the role of the OM in inventory and supply chain management. Understand project management and risk management. Gain in-depth knowledge about stock control and procurement operations. Understand product manufacturing and shipping. Understand contingency management and succession planning. Understand the importance of business etiquette. Why Choose This Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Level 7 Diploma in Operations Management Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing This course. >> Courses are included in this Level 7 Diploma in Operations Management Bundle Course << Course 01: Level 7 Diploma in Operations Management Course 02: Level 7 Diploma in Leadership and Management Course 03: Level 2 Diploma in Business Administration Course 04: Level 2 Certificate in Business Management Course 05: Level 5 Diploma in Business Analysis Course 06: Level 7 Diploma in Facilities Management Course Course 07: Level 7 Business Management Course Course 08: Minute Taking Course Course 09: Level 3 Business Administration Course 10: Level 5 Diploma in Risk Management Course Course 11: Level 1 Business Management >> Other Benefits of Level 7 Diploma in Operations Management Bundle Course << Free 11 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Level 7 Diploma in Operations Management course] Course curriculum Module 01: Understanding Operations Management Module 02: Understanding Process Management Module 03: Understanding Supply Chain Management Module 04: Understanding Planning & Sourcing Operations Module 05: Understanding Talent Management Module 06: Understanding Procurement Operations Module 07: Understanding Manufacturing and Service Operations Module 08: Understanding Succession Planning Module 09: Understanding Project Management Module 10: Understanding Quality Control Module 11: Understanding Product and Service Innovation Module 12: Understanding Communication Skills Module 13: Understanding Negotiation Techniques Module 14: Understanding Change Management Module 15: Understanding Maintenance Management Module 16: Understanding Conflict Management Module 17: Understanding Stress Management Module 18: Understanding Business Ethics for the Office Module 19: Understanding Business Etiquette Module 20: Understanding Risk Management ---------------------------------- Assessment Method After completing each module of the Level 7 Diploma in Operations Management Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Level 7 Diploma in Operations Management course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Level 7 Diploma in Operations Management course is ideal for anyone passionate and ambitious about Operations Management. Learners can take this course even if they have no prior knowledge of Operations Management, and there are no age restrictions. Requirements There are no specific requirements for this Level 7 Diploma in Operations Management course because it does not require any advanced knowledge or skills. Career path This Level 7 Diploma in Operations Management could be extremely beneficial to business owners and aspiring entrepreneurs to pursue their goals. The following are more formal positions in the field of operations management: Operations Manager, Analyst & Officer S.C Manager Inventory Manager Supply Services Representative Inventory Controller & Planner Certificates Certificate of completion Digital certificate - Included

Level 7 Diploma in Operations Management Course
Delivered Online On Demand4 days
£34

Computer Networks Security: CompTIA Network+ Certification - CPD Certified

4.8(9)

By Skill Up

CPD Certified Diploma | 17-in-1 Premium Bundle | +Gifts: 17 Free PDF+ Transcript Certificate | 24/7 Learner Support

Computer Networks Security: CompTIA Network+ Certification - CPD Certified
Delivered Online On Demand6 days
£100