|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ultimate-beginners-vba-finance-course-for-banking/
课程评论：没有评论
课程名称：银行业初学者的终极Excel VBA金融课程 课程概述：本课程将为您提供有关金融领域Excel的Visual Basic Applications (VBA)的基本知识。VBA是Excel的编程语言，是一种快速的编程语言。通过正确掌握它，几乎可以自动化银行和投资银行所需的每一项任务。参加本课程后，您将发现，获得投资银行工作并非只是运气问题，而是一项技术和前瞻性的思维。该课程最适合正在学习商业、金融、会计、经济学或其他相关金融专业的大学生。它同样适合任何对银行和金融领域感兴趣，并希望了解进入这些行业所需技能的人士。课程无需 prior 技术知识。 课程内容包括： - VBA基础知识：函数、子程序、变量、循环、条件 - 现实生活中银行使用的应用 - 选项和债券的定价器开发 - 创建用户表单和高端图表 - 将VBA应用程序与数据库连接 - 理解面向对象编程概念 为什么要参加此课程？ - 您是一名金融学生，正在努力寻找一份良好且具有挑战性的银行职位。 - 您希望在简历上增加一个有价值的资产，并且有动力实现这个目标。 - 您是一名银行员工，面临日常重复任务的问题，希望学习如何将所有任务自动化。 - 您已经在银行工作，但在不符合您抱负的部门，想要加入更具挑战性的前台部门，并希望在交易室的激动人心的环境中工作。为了做到这一点，您需要证明自己能为团队带来价值。 通过本课程，您将获得快速设计高效VBA应用程序所需的一切知识。
This course will provide you with essentials about Visual Basic Applications (VBA) Excel for Finance. VBA is the programming language of Excel and is a fast programming language. When correctly mastered, it can automate almost every task that is required in Banking and Investment Banking. By taking this class, you will see that getting a job in investment banking is not just a matter of luck, but of technique and forward thinking. This course is best suited for university students who are studying business, finance, accounting, economics or any other finance related programmes. This course is also for anyone who is interested in knowing more about the Banking and Finance world, and to know about necessary skills to acquire to get into these sectors. No prior technical knowledge is required. The course covers: Fundumentals of VBA: Functions, Sub, Variables, Loops, Conditions. Real life applications that are used in Banks today Build pricers for options and bond Create Userforms and top-notch charts Link your VBA application to a database Understand the concept of Object Oriented Programming Why should you take this course? You are a finance student. You are really struggling in finding a good and challenging position in Banking. You would like to start your career with a great asset on your resume and you are motivated to reach that goal. You are a banker facing issues with repetitive tasks to run on a daily basis and you want to learn how you could automate all of those tasks in a single process. You are already a banking employee, but you are working in a department that does not fit your ambitions, and you would like to join a more challenging department such as front-office, and work in the exciting environment of the trading room. In order to do that you need to prove that you can bring value to the team. With this course, you get everything you need to be able to quickly design performant VBA applications.
