This live online program pairs Microsoft Excel with the finance and business concepts it is used to model. It is built for high school and college students looking at finance, business, real estate, or entrepreneurship, and the skills carry directly into college applications and internships.
The second half turns to Python, starting from the fundamentals and building toward data science work with Pandas, Matplotlib, and scikit-learn for inputting, analyzing, and graphing data.
This course will be held live online over the course of five weeks in the summer (10am-1pm each day).
Become an advanced Microsoft Excel user in just three days. Begin with data entry, charts, and essential shortcuts in Excel Fundamentals. Go to the next level with Pivot Tables and VLOOKUP in Intermediate Excel. Automate your workflow by recording macros in Advanced Excel. You'll learn everything you need to know to become an Excel pro.
Learn what moves stock prices and how stocks are valued by investors. In this course, you will learn the essentials of valuation (such as P/E ratios and DCF analysis), financial statements, and fundamentals of stock investing. We will analyze recent earnings releases and valuation multiples of companies such as Google and Apple to provide a framework for fundamental investment research.
This course will cover the fundamentals of Python programming and its applications in data science and machine learning. Students will get up and running in Python quickly and be ready to use Python for data analysis projects. Throughout the program, you'll also dig into how AI fits into the bigger picture. Python is the backbone of most AI and machine learning development, meaning the data skills you pick up here translate directly into understanding how intelligent systems are built and trained.