TAILIEUCHUNG - Lecture Business driven technology (Technology plug-in): Chapter 4 - Paige Baltzan, Amy Phillips

Chapter 4 - Decision making using excel. After studying this chapter you will be able to understand: Describe the use of the IF function, compare the functions of goal seek and solver, list the advantages of using the scenario manager. | TECHNOLOGY PLUG-IN T4 Decision Making Using Excel LEARNING OUTCOMES Describe the use of the IF Function Compare the functions of Goal Seek and Solver List the advantages of using the Scenario Manager Introduction There are four topic areas in this plug-in: The IF function is used to conduct conditional tests on values and formulas The Goal Seek function is used to find an unknown value that produces a desired result The Solver function is used to calculate an optimum solution based on several variables and constraints The Scenario Manager function is used to create and evaluate a collection of “what-if” scenarios containing multiple input values CREATING FORMULAS USING THE IF FUNCTION The IF logical function will return one value if a condition is TRUE and another value if the condition is FALSE Use the IF function when you want to compare two items in your workbook The IF function looks like this: =IF(logical_test,value_if_true, value_if_false) CREATING FORMULAS USING THE IF

• Quản trị kinh doanh
• Business driven technology
• Lecture Business driven technology
• Technology plug in
• Business plug ins
• Goal Seek Command
• Decision making using excel
• Business process
• Business process improvement
• Mobile technology
• Personal digital assistants
• Business basics
• Financial statement
• Business intelligence
• Data mining
• Global information systems
• Cultural business challenges
• Creating strong passwords
• Monitor your accounts
• Creating conditional formatting
• Using autofilter
• Designing database applications
• Database management system
• Microsoft Access
• New blank database
• Simple query wizard
• Advanced queries
• Form wizard in access
• Report wizard
• Designing web pages
• World wide web
• Hypertext Markup Language
• Improving readability
• Navigating in dreamweaver
• Dreamweaver setup
• Gantt chart
• Creating gantt charts with excel
• Central processing unit
• Primary storage
• Enterprise architectures
• Disaster recovery
• Network basics
• Server network
• Information security
• Information security policies
• Information privacy policy
• Ethical computer use policy
• Supply chain management
• Supply chain drivers
• Customer relationship management
• Operational CRM
• Enterprise resource management
• Core ERP component
• Ebusiness model
• Accessing internet information