Excel for Finance & Accounting | The Excel Hub

The Excel Hub

The Excel Hub

The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.. Subscribe for new videos every month!. For any enquiries, please contact:. [email protected].

Course Details

Course Lessons

  1. 1 | Create A Monthly Amortisation Table - Mortgage Repayment Calculator In Excel (Part 1 of 3) 00:06:13
  2. 2 | Make Amortisation Table Dynamic With VBA - Mortgage Repayment Calculator In Excel (Part 2 of 3) 00:06:26
  3. 3 | Insert Charts And Compare Mortgage Options - Mortgage Repayment Calculator In Excel (Part 3 of 3) 00:08:07
  4. 4 | Create A Personal Budget In Excel In Under 10 Minutes - Using RANDBETWEEN, SUM And COMBO Charts 00:08:02
  5. 5 | Calculate UK National Insurance Using VLOOKUP In Excel – Progressive System 00:05:45
  6. 6 | Calculate UK Income Tax Using VLOOKUP In Excel - Progressive Tax Rate 00:07:52
  7. 7 | Create A Live Currency Converter In Excel - Extract Currency Data Online 00:04:46
  8. 8 | Variable Rate Mortgage Repayment Calculator - Build An Amortisation Table In Excel 00:07:03
  9. 9 | Calculate UK Self-Employed National Insurance Contributions Using VLOOKUP In Excel (2020/21) 00:08:54
  10. 10 | Compound Interest Calculator In Excel - Calculate Savings Using FV Function 00:06:08
  11. 11 | How To Calculate CAGR In Excel (Compound Annual Growth Rate) 00:03:51
  12. 12 | Calculate Risk And Return Of A Two-Asset Portfolio In Excel (Expected Return And Standard Deviation) 00:04:33
  13. 13 | How To Graph The Efficient Frontier For A Two-Stock Portfolio In Excel 00:04:27
  14. 14 | Calculate The Minimum Risk Two Stock Portfolio Using SOLVER In Excel 00:03:55
  15. 15 | Calculate The Future Value Of An Investment With Variable Returns In Excel Using FVSCHEDULE 00:02:52
  16. 16 | Calculate Net Present Value To Decide Between Two Projects In Excel - NPV Function 00:03:52
  17. 17 | Calculate Net Present Value When Cash Flows Occur Irregularly - XNPV Function 00:03:50
  18. 18 | Calculate The Beta Of A Portfolio In Excel - The Excel Hub 00:04:00
  19. 19 | Calculate Scottish Income Tax 2021-22 Using VLOOKUP In Excel - Progressive Tax System 00:07:43
  20. 20 | How To Calculate Depreciation Using The Straight Line Method In Excel 00:04:54
  21. 21 | How To Calculate Depreciation Using The Reducing Balance Method In Excel 00:05:00
  22. 22 | How To Calculate The Price Of A Bond In Excel 00:03:43
  23. 23 | Calculate The Price Of A Bond With Semi Annual Coupon Payments In Excel 00:03:55
  24. 24 | Calculate The Yield To Maturity Of A Bond In Excel 00:03:58
  25. 25 | Calculate The YTM Of A Bond With Semi Annual Coupon Payments In Excel 00:04:42
  26. 26 | YouTube Earnings Calculator Calculate Earnings Using Daily Views And CPM In Excel 00:04:26
  27. 27 | Calculate The Macaulay Duration Of A Bond In Excel 00:03:25
  28. 28 | Calculate The Effective Annual Rate In Excel Using The EFFECT Function 00:02:18
  29. 29 | CFA Level 1 Revision Quantitative Methods The Time Value Of Money Reading 1 00:13:02
  30. 30 | Calculate 2021-22 UK National Insurance - Using VLOOKUP In Excel 00:06:12
  31. 31 | Calculate 2022-23 UK Income Tax - Using VLOOKUP In Excel 00:09:51
  32. 32 | Calculate Risk And Return Of A 3-Asset Portfolio In Excel (Expected Return And Standard Deviation) 00:06:34
  33. 33 | Calculate Risk And Return Of An N-Asset Portfolio In Excel (Expected Return And Standard Deviation) 00:10:13
  34. 34 | How To Graph Active Exposures Of A Fund In Excel - The Excel Hub 00:02:56
  35. 35 | Automate Investment Commentary - Dynamic Reporting On Stock Performance In Excel 00:13:50
  36. 36 | Mortgage Rate Change Calculator - Assess Impact Of Rising Interest Rates On Monthly Payments 00:04:19
  37. 37 | Calculate 2023-24 UK National Insurance In Excel - The Excel Hub 00:05:51
  38. 38 | Calculate CAGR (Compound Annual Growth Rate) For An Investment Period Over A Period Of Days In Excel 00:03:51
  39. 39 | Calculate 2023-24 UK Income Tax – Using VLOOKUP In Excel 00:10:24
  40. 40 | Create A Residual Income Model To Value A Stock In Excel - The Excel Hub 00:08:15
  41. 41 | Create A Dividend Discount Model To Value A Stock In Excel - The Excel Hub 00:06:18
  42. 42 | Estimating VaR Using The Parametric Method - Value At Risk In Excel 00:06:08
  43. 43 | Estimating VaR Using The Historical Simulation Method - Value At Risk In Excel 00:04:22
  44. 44 | How To Calculate And Plot Bollinger Bands In Excel - The Excel Hub 00:04:30
  45. 45 | Calculate 2024-25 UK Income Tax – Using VLOOKUP In Excel 00:07:58
  46. 46 | How To Create And Analyse A Basic Fixed Income Portfolio In Excel 00:06:07
    Student Reviews

    ( 5 Of 5 )

    1 review
    5 Stars
    100%
    4 Stars
    0%
    3 Stars
    0%
    2 Stars
    0%
    1 Star
    0%
    Y
    Youtube

    29-07-2024