tailieunhanh - 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 . | 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 that Excel can more easily recognize the data as a list Maintain your data’s integrity by entering identical information consistently LISTS To create a list in Excel, follow these steps: Open a new workbook or a new sheet in an existing workbook Create a column heading for each field in the list, format the headings in bold type, and adjust their alignment Format the cells below the column headings for the data that you plan to use Add new records (your data) below the column headings, taking care to be consistent in your use of words and titles so that you can organize related records into groups later LISTS Sorting Rows and Columns Once your records are organized into a list, you can sort the data for further analysis To sort a list based on one column, follow these steps: Select the SortData worksheet from the Click any cell in the Sales Rep column; you want to use this column as the basis for sorting the list Click the Data tab Click the Ascending radio .

• 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