學門類別
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Snapchat’s Dilemma: Growth or Financial Sustainability
- Did I Just Cross the Line and Harass a Colleague?
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
- TNT Assignment: Financial Ratio Code Cracker
- Winsol: An Opportunity For Solar Expansion
Basic Mathematical Operations in Microsoft Excel
內容大綱
This teaching note provides step-by-step illustrations and practice problems to assist students in learning how to use basic mathematical functions in Microsoft Excel. These functions are the necessary building blocks for many spreadsheet models. This teaching note includes practice exercises, answers, and a supporting Excel workbook for students.
學習目標
This case is suitable for use in MBA and other business related courses that require students to develop spreadsheets using Excel. After completion, students will be able to: <ul><li>Perform basic mathematical operations in a spreadsheet using +, –, *, /, and ^. </li><li>Understand the structure of Excel’s built-in functions. </li><li>Use built-in functions to perform the mathematical operations SUM, PRODUCT, SQRT, EXP, LN, and SUMPRODUCT.</li><ul>