计算机学习资料（国外英文资料）.docVIP

计算机学习资料（国外英文资料） Excel is a recipe for 35 tricks Perhaps you have already completed in Excel hundreds of financial statements, maybe thousands of times you have to use the Excel function of complex operation, perhaps you think Excel so much, even the dull. But the number of repetitious USES we do on weekdays is just one percent of Excels overall skill. This topic starts with some lesser-known techniques in Excel, and has a taste of Excel. One, allow different types of data to be displayed in different colors In payroll, if you want greater than or equal to 2000 yuan, according to the total wages to red is greater than or equal to 1500 yuan of total wages in blue, according to less than 1000 yuan of total wages to brown, according to other displayed in black, we can set up. 1. Open the payroll workbook, selected in the column total wages, execute format - conditional formatting, open conditional formatting dialog box. Click the drop-down button on the right of the second box, select the greater than or equal option, and enter the value 2000 in the box in the back. Click the format button to open the cell format dialog box and set the color to red. 2. Press the add button, and modeled after the above operations set up other conditions (greater than or equal to 1500, the font is set to blue; less than 1000, the font is set to brown). When the Settings are complete, press the ok button. Take a look at the payroll, and the amount of payroll data is displayed in different colors according to your requirements. Second, establish the category drop-down list We often need to input the name of the enterprise into the table, in order to keep the name of the consistency, using the data validity built a classification function fill in the drop-down list. 1. In the Sheet2, name of the enterprise by category (such as industrial enterprise, business enterprise, individual businesses, etc.) input different column, to create a business name database. 2. Select A column (in column of i