Excel and economics are made for each other. The material on this page represents the teaching materials for ECON2050 Economic Analytics Using Computer Methods. The text includes links to videos that explain techniques and procedures in more detail. The material here excludes practice problems and answers and tests with answers, all of which are essential for completing this course.
Several caveats exist for this course:
- The course presumes no knowledge in Excel, but the reader will be served well by remembering basic math and first year micro and macro economics.
- Excel often has more than one way to solve a problem and the course starts with simple approaches that will strike the experienced Excel user as simplistic. As the course proceeds, more advanced methods come into play.
- The course materials rely on Microsoft 365, but many videos still refer to Office 2019; the functionality is essentially the same for problems addressed. I will update these videos in due course.
- This is not a course in Excel. It is a course in economic analytics that uses Excel to explain economic and business processes. Therefore, it focuses on the financial and statistical formulas and does not really treat the data management tools available in Excel.
This is an orientation to Excel for the uninitiated and those who need a refresher.