This course is designed for students and workers majoring in financial related subjects such as actuarial science, accounting, finance, Banking, taxation, business administration, mathematics, statistics, economics, insurance, risk management, social protection and anyone interested in learning and applying advanced excel & R in their work or studies.
1. Understand the key functionalities of advanced excel & R;
2. Be able to apply advanced excel & R in solving complex issues at work or school;
3. Be familiar with various business processes in the financial sector and how to employ excel and R for efficiency purposes;
4. Understand how excel and R can be used in data analytics and modelling.
5. Understand how to create excel templates, graphs and formatting of worksheets.
6. Get familiar with advanced formulas in R and Excel
7. Get familiar with a basic VBA knowledge