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

Chapter 3 - Problem solving using excel. In this chapter you will learn: Describe how to create and sort a list using excel, explain why you would use conditional formatting using excel, describe the use of autofilter using excel, explain how to use the subtotal command using excel, describe the use of a pivottable using excel. | TECHNOLOGY PLUG-IN T3 Problem Solving Using Excel LEARNING OUTCOMES Describe how to create and sort a list using Excel Explain why you would use conditional formatting using Excel Describe the use of AutoFilter using Excel Explain how to use the Subtotal command using Excel Describe the use of a PivotTable using Excel INTRODUCTION If you routinely track large amounts of information, such as customer mailing lists, phone lists, product inventories, sales transactions There are five areas in this plug-in: Lists Conditional Formatting AutoFilter Subtotals PivotTables LISTS A list is a collection of rows and columns of consistently formatted data adhering to somewhat stricter rules than an ordinary worksheet LISTS When you create a list, keep the following in mind: Maintain a fixed number of columns (or categories) of information Use each column to hold the same type of information Don’t leave blank rows or columns in the list area Make your list the only information in the worksheet so .

• Quản trị kinh doanh
• Business driven technology
• Lecture Business driven technology
• Technology plug in
• Business plug ins
• Creating conditional formatting
• Using autofilter
• 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
• Goal Seek Command
• Decision making using excel
• 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