Excel2010Advanced.pptVIP

Select the range that includes data table values, the formula, and the area where Excel will display the results. Select the Data tab from the Ribbon. Select What If Analysis. Select Data Table. Select the Row input cell in the formula. Select the Column input cell in the formula. Select OK. Module Ten: Managing Your Data In this module, you’ll learn how to transpose data from rows to columns. You’ll also learn about the Text to Columns feature. This module explains how to check for duplicates and create data validation rules. You’ll also learn how to consolidate data. Data is not information, information is not knowledge, knowledge is not understanding, understanding is not wisdom. Clifford Stoll Transposing Data from Rows to Columns Place your cursor in the new location and right-click. Select Transpose from the Paste Options on the context menu. Using the Text to Columns Feature Select the text. Select the Data tab from the Ribbon. Select Text to Columns. In the Convert Text to Columns Wizard, choose the file type that best describes your data. Select Next. In the next screen, select the type of divider. Select Next. In the next screen, you see a preview of the data converted to columns. Using the Advanced button, you can also choose your settings for numeric data. When you have finished, select Finish. Checking for Duplicates Highlight the area from which you want to remove duplicates. Select the Data tab from the Ribbon. Select Remove Duplicates. Select the columns you want to check for duplicates. The Select All and Unselect All tools can help you manage a large list of columns. Select OK. Creating Data Validation Rules Select the cells where you want to apply the data validation rule. Select the Data tab from the Ribbon. Select Data Validation. Select Data Validation. On the Settings tab of the Data Validation dialog box, set up the Validation Criteria. Use the drop down lists to help you build your criteria. Select the Input Message tab. Enter a Tit