ADM 1370 Lecture Notes - Microsoft Excel, Emor, Sensitivity Analysis
Document Summary
Introduction to microsoft excel: a computer program used to enter, analyze and present data, a spreadsheet program. Collection of text and numbers laid in a rectangular grid: mainly used for accounting, budgeting, financial analysis, inventory etc, provides presentation tools, automatic calculation functions, and data management features, allowing for problem-solving and decision-making. Worksheets and workbooks: excel uses worksheets and workbooks, worksheet a spreadsheet containing data such as text, numbers, formulas, charts etc, workbook a collection of related worksheets. Problem solving and modeling process: phases in the ps&m process, formulation transform real life problem to math model. Develop model: solution solve the model to obtain the optimal solution. Develop another model: interpretation analyze results and implement solution. Logical functions result of these functions is a logical value (true or false: and, or, not, conditional functions result is a specified or calculated value, if, countif, sumif, averageif.