327 Courses in Cardiff delivered On Demand

Description: Nowadays Excel has become very much more than just a simple spreadsheet. Although its roots are still in number management, today Excel's uses cover a wide gamut - from simple data entry to complicated financial models and analysis. This Microsoft Office 2016 Excel Advanced - Complete Video Course is designed to help you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. You will learn Visualize data with charts, how to use PivotTables and PivotCharts, working with powerful Functions you need to know, and more. So, if you have intermediate skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface. Then this advanced level will be very helpful for you. So, be an expert by joining us. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it 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. Requirements Our Microsoft Office 2016 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Venturing into the intricate labyrinth of risk and finance, our course, 'Actuary Certification: Navigating the Complex World of Risk and Finance' serves as your guiding beacon. Through this comprehensive journey, participants will unravel the multifaceted role of actuaries and their symbiotic relationship with their environment. Delve deep into the valuation of cash flows, deterministic models, and the life table's myriad intricacies. Embrace an in-depth understanding of life annuities, insurance structures, and the enthralling world of stochastic life contingencies. Furthermore, this course equips learners with the expertise to tackle taxation, inflation, and the nuances of premium calculation, ensuring a holistic approach to the actuarial realm. Learning Outcomes Understand the foundational principles and role of actuarial science in risk and finance. Analyse and interpret life tables, annuities, and insurance models. Apply stochastic methodologies to insurance and annuities. Evaluate the implications of taxation and inflation on financial models. Design and assess various risk models, focusing on uncertain payment and profit testing. Why buy this Actuary Certification: Navigating the Complex World of Risk and Finance? 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 Actuary Certification: Navigating the Complex World of Risk and Finance 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 Actuary Certification: Navigating the Complex World of Risk and Finance course for? This Actuary Certification: Navigating the Complex World of Risk and Finance does not require you to have any prior qualifications or experience. You can just enrol and start learning. Individuals keen to dive into the actuarial sector. Finance and risk management graduates aspiring for a deeper understanding. Professionals in the insurance sector aiming to upscale their knowledge. Mathematics enthusiasts wishing to channel their skills in a finance-oriented domain. Corporate strategists seeking to enhance risk management techniques. Prerequisites This Actuary Certification: Navigating the Complex World of Risk and Finance does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Actuary Certification: Navigating the Complex World of Risk and Finance 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 Actuarial Analyst: £30,000 - £50,000 Risk Management Specialist: £40,000 - £65,000 Insurance Underwriter: £25,000 - £50,000 Financial Planner: £35,000 - £60,000 Actuarial Consultant: £50,000 - £90,000 Portfolio Manager: £55,000 - £120,000 Course Curriculum Module 01: Introduction to Actuary Introduction to Actuary 00:12:00 Module 02: Actuaries and Their Environment Actuaries and Their Environment 00:14:00 Module 03: The Valuation of Cash Flows The Valuation of Cash Flows 00:12:00 Module 04: The Basic Deterministic Model The Basic Deterministic Model 00:11:00 Module 05: The Life Table The Life Table 00:11:00 Module 06: Life Annuities Life Annuities 00:14:00 Module 07: Life Insurance Life Insurance 00:12:00 Module 08: The Stochastic Life Contingencies Model The Stochastic Life Contingencies Model 00:11:00 Module 09: The Stochastic Approach to Insurance and Annuities The Stochastic Approach to Insurance and Annuities 00:11:00 Module 10: Taxation and Inflation Taxation and Inflation 00:08:00 Module 11: Probabilistic Models, Uncertain Payment and Profit Testing Probabilistic Models, Uncertain Payment and Profit Testing 00:08:00 Model 12: Individual Risk Models Individual Risk Models 00:07:00 Module 13: Principles of Premium Calculation Principles of Premium Calculation 00:10:00 Module 14: Multiple Decrement Theory Multiple Decrement Theory 00:09:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Banking and Finance Accounting Statements Financial Analysis Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Banking and Finance Accounting Statements Financial Analysis Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Banking and Finance Accounting Statements Financial Analysis Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Banking and Finance Accounting Statements Financial Analysis Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Banking and Finance Accounting Statements Financial Analysis? 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 Banking and Finance Accounting Statements Financial Analysis there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Banking and Finance Accounting Statements Financial Analysis course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Banking and Finance Accounting Statements Financial Analysis does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Banking and Finance Accounting Statements Financial Analysis was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Banking and Finance Accounting Statements Financial Analysis is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction and Welcome to the Course Introduction to Financial Statements and Analysis 00:05:00 Why are Financial Statements Important 00:07:00 Section 02: Introduction to Accounting What do we mean by Financial Accounting? 00:04:00 Accounting Standards and why they are important 00:06:00 The Concepts and Principles Underlying Accounting 00:06:00 Single Entry vs Double Entry Book Keeping 00:08:00 Understanding The Accounting Equation 00:06:00 The Accounting Cycle 00:05:00 Financial Statements 00:07:00 Section 03: Introduction to Financial Statements Section Introduction - Understanding Financial Statements 00:02:00 Overview of Financial Statements 00:03:00 GAAP: Accruals and Cash Accounting 00:06:00 Income Statement or Profit and Loss Account 00:08:00 Introduction to the Balance Sheet 00:11:00 Introduction to the Cash Flow Statement 00:06:00 Cash Flow Metrics Explained 00:09:00 Case Study- Apple Financial Statements 00:04:00 Section 04: Understanding Working Capital What is Working Capital 00:03:00 What is the Working Capital Cycle? 00:05:00 Why is working Capital Management important 00:05:00 Working Capital Analysis 00:05:00 Working Capital Ratios 00:07:00 Working Capital Policies 00:05:00 Working Capital Summary 00:03:00 Section 05: Introduction to Financial Analysis Section Introduction: Strategic Financial Analysis 00:01:00 What is Financial Analysis? 00:11:00 Measures of Profitability Financial Analysis 00:04:00 Balance Sheet Ratio Analysis 00:12:00 Cash Flow Statement Analysis 00:05:00 Valuation Ratios 00:04:00 Section 06: Financial Analysis - Case Study and Assignment Section Introduction: Financial Analysis - Case Study and Assignment 00:01:00 Case Study Assignments Apple Inc Financial Analysis 00:06:00 Apple Inc Financial Analysis - Solution 00:03:00 Discussion of Measurements of Growth Analysis 00:05:00 Discussion of Measures of Profitability Analysis 00:07:00 Discussion of Trading Performance Analysis 00:03:00 Discussion of Working Capital (Liquidity and Efficiency) Analysis 00:12:00 Section 07: Financial Ratio Analysis in Corporate Finance What do we mean by Corporate Finance? 00:06:00 Financial Ratios in Corporate Finance 00:03:00 Liquidity Ratios in Corporate Finance 00:08:00 Operational Risk Ratios in Corporate Finance 00:08:00 Profitability Ratios in Corporate Finance 00:08:00 Efficiency Ratios in Corporate Finance 00:07:00 Section 08: Financial Modelling for Mergers and Acquisitions Why is modelling so critical 00:03:00 Three Models You Will Need 00:08:00 Understanding The Integrated Financial Statements Model 00:06:00 The Integrated Financial Statements Model Example 00:07:00 Key Tips to Modelling the Integrated Financial Statements Model 00:02:00 The Discounted Cash Flow Model - DCF 00:07:00 Understanding the Discounted Cash Flow Formula 00:06:00 Understanding the Merger Model 00:08:00 Section 09: Course Summary and Wrap Up Course Summary and Wrap Up 00:03:00 Additional Resource Additional Materials 00:00:00

Certification After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

All in One Bundle Special Discount Offer A recent report by Grant Thornton shows that 72% of Finance Directors believe strong financial leadership is critical for business growth. The Finance Director plays a pivotal role in shaping a company's financial health and strategic direction. This comprehensive CPD-accredited Finance Director training equips you with the knowledge and skills to excel in this crucial position. CPD Accredited courses you will get: Course 01: Banking and Finance Accounting Statements Financial Analysis Course 02: Time Management Skills Course 03: Office Skills The Finance Director Training bundle is for those who want to be successful. In the Finance Director Training bundle, you will learn the essential knowledge needed to become well versed in Finance Director Training . Our Finance Director Training bundle starts with the basics of Finance Director Training and gradually progresses towards advanced topics. Therefore, each lesson of this Finance Director Training is intuitive and easy to understand. Why would you choose the Finance Director Training course: Lifetime access to Finance Director Training courses materials Full tutor support is available from Monday to Friday with the Finance Director Training course Learn Finance Director Training skills at your own pace from the comfort of your home Gain a complete understanding of Finance Director Training course Accessible, informative Finance Director Training learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Finance Director Training bundle Study Finance Director Training in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Finance Director Training course Course 01: Banking and Finance Accounting Statements Financial Analysis Section 01: Introduction and Welcome to the Course Section 02: Introduction to Accounting Section 03: Introduction to Financial Statements Section 04: Understanding Working Capital Section 05: Introduction to Financial Analysis Section 06: Financial Analysis - Case Study and Assignment Section 07: Financial Ratio Analysis in Corporate Finance Section 08: Financial Modelling for Mergers and Acquisitions Section 09: Course Summary and Wrap Up Course 02: Time Management Skills Module 01: Importance and Benefits of Time Management Module 02: Assess Your Current Work Practice Module 03: Identifying the Priorities Module 04: Say 'No' to Procrastination Module 05: Set Your Goals Module 06: Plan the Work Module 07: Work the Plan Module 08: Effective Time Management Techniques Module 09: Combat the Time Wasters Module 10: Time Management for Creative Work Module 11: The Art of Anticipating Module 12: Avoid Time Leaks Course 03: Office Skills Module 01: Core Office Skills Module 02: Self-Management Module 03: Organizing and Planning (i) Module 04: Organizing and Planning (ii) Module 05: Rapport Building CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Finance Director Training bundle is Ideal for: Finance professionals seeking to become Finance Directors and develop strategic leadership skills. Existing Finance Directors looking to strengthen their financial acumen and climb the corporate ladder. Business owners and managers who want to gain a deeper understanding of financial analysis for better decision-making. Individuals transitioning into finance roles that require a strong foundation in financial statements and analysis. Requirements To enrol in this Finance Director Training course, all you need is a basic understanding of the English Language and an internet connection. Career path The Finance Director role offers a rewarding career path with excellent earning potential. This Finance Director course positions you for success in various industries, including: Banking and Financial Services Manufacturing Technology Retail Healthcare Non-profit Organizations Government Agencies Certificates 3 CPD Accredited PDF Certificate Digital certificate - Included Each CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hardcopy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Are you planning to start a company or want to make a profit? Then, join our Financial Modelling course and take your business to the next level. You will gain the expertise and knowledge to evaluate your business, handle the finance and predict the market. In addition, you will learn to handle unwanted circumstances and make proper decisions under pressure. This Financial Modelling course includes easy-to-digest modules from which you can learn the most up-to-date knowledge about the current market condition. Also, you will learn the fundamental calculations required to forecast takings and values in the near future and receive a masterclass on the essentials of the financial market itself. You will be able to build financial models, conduct sensitivity analyses, research market opportunities, and arrive at exact valuations based on your correlated data. Sign up for our Financial Modelling course and enjoy your learning journey. Course Curriculum ✓ Module 01: Basic Financial Calculations ✓ Module 02: Overview of Financial Markets, Financial Assets, and Market Participants ✓ Module 03: Financial Statement Modelling ✓ Module 04: Types of Financial Models ✓ Module 05: Sensitivity Analysis ✓ Module 06: Sales and Revenue Model ✓ Module 07: Cost of Goods Sold and Inventory Model ✓ Module 08: Valuation Methods Learning Outcomes By the end of this course, you will: Study the maths and financial terms used in financial modelling. Understand the financial markets, financial assets, and market participants. Sort various financial model types according to their criteria Learn about sensitivity analysis in financial modelling Possess the ability to use tools to analyse multiple independent variables Use the valuation approach to determine your company’s or an asset’s fair market value Assessment and Certification At the end of the course, you will be required to sit for an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Eligibility Requirements There are no special requirements to join this course. Anyone with an interest in yoga or mindfulness can enrol. You just need an open mind and the desire to learn. Career Path This Financial Modelling Course will give you an in-depth understanding of the subject. On successful completion, you will have the skills, confidence and practical knowledge to fast-track a successful career in relevant sectors. Professions in this field include: Market Analyst Finance Administrator Finance Manager Finance Advisor Accountant (Learn more about this online course)

The Actuary Online Course offers a comprehensive exploration of these scientific foundations, delving into deterministic and stochastic models, life insurance, annuities, and the complex interplay between taxation, inflation, and risk.