This course covers fundamental concepts in spreadsheet modeling with Microsoft Excel for business by Dr.Ramesh Sankaranarayanan, Associate Professor of Business at the University of Connecticut (UConn).
This course is designed to help Business School students (undergraduate and MBA) as well as practicing managers and executives become more effective users of excel spreadsheets. All concepts are explained using business examples demonstrated via short videos. Each video is classroom-tested and explains the main concepts as well as things to watch out for.
Each video lesson is designed to be self-contained: you can view the video and work on the spreadsheet without referring to other videos. Supplementary materials include one “before” and one “after” excel file. For best results, you should download the “before” file, follow along with the video, and compare your completed spreadsheet with the “after” file.
After completing this course you should have the fundamental concepts necessary to use Excel successfully in your workplace or school. While this course uses Excel 2010 to illustrate the concepts, you can apply these concepts in Excel 2007 or 2013 as well.
In this lecture you will learn about relative and absolute cell referencing in Excel. This will be useful when you have to apply an excel formula to multiple values. Understanding relative and absolute cell referencing will help you copy formulas correctly, and avoid having to repeatedly type in formulas.
Dr.Ramesh Sankaranarayanan is Associate Professor of Management Information Systems, School of Business, University of Connecticut at Storrs. He has over a decade of experience as an instructor teaching Microsoft Excel, Access, web programming, database design, SQL, e-commerce, online marketing, and business case analysis to undergraduate Business students and masters students, and teaches in the Executive MBA program at UConn, Hartford. He has a Ph.D. from New York University's Stern School of Business, in addition to a B.Tech. from IIT Madras, and MBA from IIM Ahmedabad, India. He has earned certificates in Business Case Discussion Leadership and Negotiation Leadership from Harvard Business School. He has consulted/worked for leading multinational corporations, including GE, Morgan Stanley, PricewaterhouseCoopers, Wipro and ICICI.