ScholarU

Are you curious about the art of making your money work for you through investments, or perhaps contemplating how to shape your future retirement plan? If so, we invite you to delve into the world of finance with "Introduction to Finance using Spreadsheets." This course serves as your gateway to understanding the fundamental principles of finance and leveraging these concepts through the power of spreadsheets. In today's business landscape, the demand for professionals who can proficiently manage, analyze, and visually interpret financial data is soaring, making this course an invaluable first step for those aspiring to carve a career in business analysis.

Over the course's duration, you will acquire essential skills in investment strategies, encompassing both simple and compound interest. You'll grasp the distinctions between annual and sub-annual compounding, while delving into the intricate realms of annuities and perpetuities. Harness the art of utilizing formulas, functions, and chart creation to derive insightful outcomes using spreadsheets. Practical exercises and real-world case studies are woven into the curriculum, ensuring you can seamlessly apply your newfound knowledge to genuine financial scenarios, including the analysis of mortgages and crafting a comprehensive retirement plan.

Upon completing this course, you will possess the proficiency and comprehension to scrutinize financial models, extract meaningful insights, and elevate your financial analysis capabilities to the next level. Embark on this enlightening journey today!

Who should take this course?

This course caters to individuals eager to embark on a career in business analysis, including pre-MBA students. It also serves as a valuable resource for professionals seeking to augment their expertise in this field.

Course Duration:

The course is self-paced and it takes between 5-10 hours to complete including watching the videos, and working on the knowledge checks, exercises and case studies.  

Course Support:

There is a community page where you can ask questions, share your ideas and knowledge, and connect with other students and the staff.

Prerequisites: 

• Access to a spreadsheet tool like Excel or Google Sheets.
• Basic familiarity with spreadsheet functions (e.g., xlookup, pivot tables and if statements) and chart creation. Dominate the content in Excel for Beginners or Google Sheets for Beginners.
• A thirst for knowledge.

*Courses can be conducted live online or in person upon request. For more information send an email ([email protected])!