Perhaps you have had hundreds of Excel to complete the financial expressions, maybe you have used Excel functions for complicated operations a thousand times, possibly you think that Excel also much, or even nobody new. However, we reiterated innumerable times daily in nearby to use all the capabilities in Excel is fair one per cent. Excel in the heading from some little-known tips to start, obtain a peep on the Excel Different customs.
1, so namely another types of data using assorted colors
in the payroll, if you want more than equal to the total wage of 2,000 yuan to greater than or equal to the total wages of 1,500 yuan,
1. Open the Click the second drop-down box on the right button, select the Click the
2. Click
3. install is complete, press the
see it payroll, payroll data is not according to your request that come in different colors.
Second, a category drop-down account filled with items
name of the affair we often want to enter into the table, the name in array to nourish consistency, the use of
1. in Sheet2 in the name of the business at classification (such as
2. Select A column (
modeled on the above operation, the B, C ... ... column named such as the C column), the implementation of In the Enterprise
need to enter the company name and then select the column (eg column D), and then open the C1), OKAY to exit.
4. Select any cell in column C (eg, C4), click the right side of the drop-down button, select the appropriate Then select the cell corresponding to the D column cell (eg D4), click the drop-down button to the appropriate category business name from the list, select the name of the enterprise need to fill the cell.
Tip: When printing a report in the future, if you do not need to print the
Third, establish a
1. the space in the toolbar right click, choose In the
Click
2. then in the (mutual document), and modeled it for the operation of the above named (such as
repeat the above operations, multi-document list to add a few names.
3. Select the distribution Hyperlink By pressing the
repeat the above operation, the menu item and its corresponding workbook, the hyperlink documents together.
4. After the need to open the
Tip: Although we will
four, making
1. the implementation of the Select the .
modeled on the above operation, one by one to record a special sign of the input of other good
2. Open the A go zone in the toolbar.
switch to the How numerous buttons).
3. Select one of the
4. Right-click the button after a name, in the following the shortcut menu, select exit.
Repeat this step, the button to link with the corresponding macro.
5. close the
five, with
1. Open the worksheet to publish, use the mouse without the need to print the row (or column) marked shuffle, select them and then right click in the shortcut menu that appears, select , will not need to print the row (or column) invisible.
2. implementation
3. the hidden rows (or columns) are displayed, and repeat the operation,
4. After the need to print a form, open the , publishing what, on the toolbar click the
six, so that data on demand if you want to sort
divisions where workers are sorted according to these sectors is not the name of the pertinent information by either the Pinyin order, not by stroke order, how do? can be self- defined sequence order.
1. perform The group, a workshop, 2 workshops, three workshops,
2. Select the one of the drop-down button, select the just-defined sequence, by two
seven
the data sheet completely hidden part of the contents of the cell do not want to enabling observers to way, had it hidden.
1. selected to conceal the contents of the cell (area), the implementation of
2. and then switch to the
3. the implementation of the
after this set after the contents of the cell is no longer shown, is to use Excel's features can not be allowed to remove the sky.
Tip:
eight, so in English and Chinese input method appeared
smart amending table, some cells to enter the English, and some cells to enter the Chinese input method is not convenient to switch another, why not set and let intelligent input method to adapt it?
selected scope of cells to enter the Chinese, the implementation of tab, reception the Elected in the hereafter
range of cells need to enter anyone one of the Chinese cell, Chinese input method (premier in the list input method Chinese input method 1) automatically open, was selected the additional cell, Chinese input method automatically closed.
nine, so that
1. the implementation of the
2. In the then click
3. If you need to enter this text in the future, simply enter
ten, a custom function in Excel, though the rich
Excel function, but it does not encounter entire our absences. We can customize a function to act decisive operations. Here,
tods shoes, we define a enumerated from the trapezoid area function:
1. The implementation of the
2. In the window, execute
3. the right of the defined function to complete.
tin later use the built-in function is the same for using a custom function.
Tip: Use the above methods defined in the corresponding function is routinely only used in the workbook.
XI header following pictures
lining additional to the backdrop of the worksheet is the lining in the plenary worksheet below, can not only lined the first in the table below it?
1. execute → Background Worksheet
2. while holding down the Ctrl key, right in the picture without lining cells (area) in drag, and select those cells (area).
3. Click After this setting later, leaving the cell lining on the picture below, and the selected cell (area) not lining the picture below (in fact, is the picture to be
Tip? lining the image beneath in the cell does not support publishing.
second, with a hyphen get it (it is pretended that the B, C, D columns into one column.)
1. in the D column, insert two empty columns (E, F series), and then enter the formula in cell D1: = B1 & C1 & D1.
2. D1 cells again selected, use the
3. Select the E array, the implementation of , press the
4. the B, C,
supra 2010, D, E col deleted, achievement of the merger work.
Tip: Complete the steps from 1,
vibram classic,2 combined efficacy has been achieved, but at this time if you delete B, C, D series, the formula error. And thus should be carried out step 3, the formula is converted to the same Performance of Students
article
friends often inquire, For this attention, I am here gives a simple way to use the function implementation.
cached in student fulfilment is presumed here Sheet1 worksheet range of cells A1 to G64, which perform title 1, 2 acts subject name.
1. Switch to Sheet2 worksheet, select cell A1, enter the formula: = IF (MOD (ROW (), 3) = 0, , sheet1,
tods shoes 2011! Aū, INDEX (sheet1! $ A: $ G, INT (((ROW () +4) / 3) +1), COLUMN ())))。
2. once again select the cell A1 , with the > At this point, the basic fashion results section, the following simple modified see.
3. adjust the row altitude and column width, the same selected range of cells A1 to G2 (No. 1 student achievement bar area), according to The following operation).
4. also selected range of cells A1 to G3, click on the To add a border all the results segment.
press the What more applicable function. Excel box input requirements (such as related assist files, you can immediately determine the required function.
fifth, while viewing a different worksheet in the multiple cells of data
Sometimes we edit a worksheet (Sheet1), it is necessary View other work sheet (Sheet2,
asics gel, Sheet3 ... ...) the contents of a cell, you can use Excel's .
later, not matter in which the worksheet, simply open the > In before versions of Excel 2002 because the operation of a range of cells is too much difficulty to join a border, Excel 2002 which features a current development.
Click the pull button, pop-up in the subsequent drop-down list, choose drop-down button, select a border style, and then in the range of cells you need to add drag and drip the frame, you can quickly draw the corresponding range of cells on the border.
Tip: ① If you draw the wrong skeleton, does not matter, on the toolbar select Color >
XVII Enter the text in specific cells controlling the length of
Can you imagine when you enter the four digits of the cell was filled with a numeral, or entering txt in the cell number you have entered time, Excel will automatically determine, immediate analysis and pop-up warning, then be nice ah! To attain this function, the Excel, is also not tough.
instance, we enroll the cursor to a the cell in order to enter the calculation of the unified and cozy, we hope that the Card alarm annual. style period distance,
We know thateach time you open Excel, the software is always turned on by default multiple sheets. Thus we can see that Excel has a mighty addition to the processing power of unattached forms, more appropriate for multiple interrelated coordination table . to coordinate the federation, of lesson, first need to sync input. Therefore, in many cases, will need more than one table simultaneously in the same cell type the same content.
So how do you edit a team of tables? First We click the first worksheet tab name ). At this point, we see the name of the title bar of Excel, a What, we base that change the format of how to do? First, we have to change the data format of the first table, and then click the time, Excel will pop up IX, change the text in the case of
in Excel for form processing and data computing support is not the maximum mighty formula, neither is the database, but the function. Do not think that Excel, the function only for mathematics, in truth, at a time written into the contents of the table, Excel has a special function to edit it. such as changing the text of the case.
in Excel 2002, provide by least three of the text case conversion function. They are: UPPER (source data grid), case, such as getting the first letter of each word is capitalized. For example, we have a form of cell A1 enter the lowercase the outcome the automobile will be will be the method save trouble, especially fknow next to nothing ofme of the message especially alike style, such as staff lists, location of origin and other information.
quickly if we want to extract the cells from A4 caption, it is best to use to extract the digit of roles) grid, the number of symbols extracted) words, only in the target cell to enter and 5 words.
the twenty-first, into the pedestal ordinal number words to English words into ordinal base is a more complex problem. for it is not a quite fixed pattern: Most of the figures into ordinal number is used in the Moreover, function, just write a formula that can be easily converted. do not believe, see: IF (OR (VALUE (RIGHT (A2)) = 1,2,3,, CHOOSE (RIGHT (A2), Despite the long list, but the meaning is very clear: ① If the number is to main and ordinal conversion words so easy and hasty implementation.
XXII, filled with special characters and fiscal dealings with the median
folk know, when filling in the paperback there is a conventional Safety Fill Law The elementary format is the formula to should be changed to REPT (pate paired with # # 0.00 worksheet consisting of plain text to create the histogram. It is also very simple rule, that is, the beautiful use of special symbols repeated according to a specified cell showing the results of the comparable effectiveness of different widths.
example, we first Annual production of a balance sheet, and then The results have been ROUND (D3 * 100,0 )),> round to calculate the total number of words in the cell
Sometimes, we may have the character of a cell in the number of amused need to calculate the aggregate number of words in the cell. To solve this problem, in adding to using the SUBSTITUTE > is to use Finally, the number of spaces +1 to draw the number of characters in the cell was.
XXV, the euro conversion
This is a new tool in Excel 2002. If you choose to install the Excel 2002 is the default, then it may not be in the . with the Excel window, the other functions, we can set the money conversion mouse equality EU list of other currencies. Of course, in order to exhibit the euro is more vocational, we can also click on the Excel toolbar, the p>
accidentally deleted data revitalization
accidentally, delete the wrong, and also empty the Recycle Bin, the assumed ah?
by the time three steps, you can delete and vacant the Recycle Bin back your stuff
steps:
1, click the Enter regedit (open registry)
2, expand: HEKEY--LOCAL--MACHIME/SOFTWARE/microsoft/WINDOWS / CURRENTVERSION / EXPLORER / DESKTOP / NAMESPACE outside the left margin click aboard
, select: Recycle Bin .
to redo the microprocessor system, learn their own, can spend less money, ha ha [chart]
one, ready to work:
how to reinstall the computer system
First, start the computer while holding down the DELETE key to enter BIOS, select Advanced BIOS Features option, and press the Enter key to enter setup. Select First Boot Device option, then press the keyboard Page Up or Page Down key to set the CD-ROM, so you can start the system to the disc.
Second, the return to the main menu, save the BIOS settings. (Preservation method is to press F10, then press Y button)
1. Prepared to simplified Chinese version of Windows XP Professional installation CD, and check the drive is aided from the begin.
2. possible, ahead running the installer with all the hard disk to scan the hard disk peccadillo checking and repair, or install the program is running, such as checking that there is an error that will be hard very troublesome.
3. file with the periodical records the production key to install (installation serial number).
4. possible, with the driver export tool (such as: Driver Genius 2004 V1.9 Beta.exe) all under the original Windows XP driver backup to disk ( such as: F: Drive). Best to note the motherboard, network card, video card type and other important hardware manufacturers, pre-download the driver for use.
5. If you want to format the C drive during the installation or the D drive (recommended format the C drive during installation), behind up the C drive or D drive profitable data.
Second, start the system with a CD-ROM:
(if you already know the way, work to the next step), reboot the system and the CD-ROM set First boot disk, save the settings and reboot. The XP installation CD into the drive, restart the computer. Just started, as shown when there is press the Enter key when the fast, otherwise the system can not boot XP CD. If you do not know the specific practices, please refer to the same with this -> how to get into pure DOS system:
CD-ROM from the start, if no event to look the installation shade will appear as shown in Figure 1
;
View Original
prompted all Chinese, View original
authorize accord, there is no alternative, according to partition, format the C drive if you have select the C partition, select a nice partition and press format, which become the file system format, or save an existing file system, a diversity of choice, but memorandum that the NTFS format to save disk space, amend security and depress disk fragmentation but there are many problems and MacOS 98/Me can not see the NTFS partition, here, choose Figure
formatted C steer warning, reception F key ambition be ready apt format the c drive, there is shown in Figure 6 below the aboriginal
view of the selected section C space than 2048M ( or 2G), FAT file system does not support more than 2048M of the disk partition, so the installer will use the FAT32 file system format to format C drive, press the br> View original image in Figure 7 is formatted C partition; only start with the CD or setup XP Setup boot floppy disks to cater during the installation process format the partition option; If you use MS-DOS shoe disk into DOS, escape i386 winnt to install XP, install the XP partition without formatting options. Format C partition is completed, there was under the percolate shown in Figure 8
ad
View Original
Figure 8 to start copying files, duplicate the document behind the installation process initializes Windows configuration. and then the system will automatically restart in 15 seconds. restarts, there is shown in Figure 9 under
View Original
9
View Original
than 5 minutes afterward, while the hint appears when needed 33 minutes emulating diagram 10
View Original
choose regional and language settings The default value can be a straight point of the , click point Please memorize this password, Administrator System Administrator has the highest authority in the system, usually landing system does not require the account. Then click set do not say the plebiscite GMT, click br> View original
allows you to choose the manner used by the web installation, select a typical set point
View Original
continue the installation, here after do not you partake in, the installation program will automatically complete the whole process. automatically restart after the installation is complete, the splash screen appears, as Figure 19
View original
first start takes a long time, amuse be patient, followed by the welcome screen, set the system prompt, as shown 20
View Original
click the base right edge
View Original
here to create a broadband dial-up connection, not dial-up connection on the desktop shortcut, and dial-up connection the default name Connection Wizard after the establishment of broadband via dial-up connection, the dial-up connection on the desktop shortcut, and the default dial-up connection named Skip 22 shows
View Original
Telecom or China Unicom are currently using (ADSL) Residential consumers have accounts and passwords, so I chose step dial-up linkage the name of the shortcut menu, and if left blank the system will automatically build a file phoned > dial-up articulation has been established, Microsoft certainly ambition you to stimulate XP you, but even if there does no stimulate the 30-day trial duration, why the hurry? select button, as shown in Figure 25
View Original
you usually enter a user name to login the computer, click the Next button appears as shown below 26
View Original
Click Finish to complete the installation. the system will record off and record a new user. landing desktop as below 27
View Original
6, and find common icons
On the desktop, point to Start -> Connect to -> broadband connection, as Figure 32
View original
left point to the desktop space, you can see the desktop more than a property
the bottom left of the diagram click on the
开心一下：
1.我不小心把“我爱你”误发给你了。如果你接受那就储存起来，如果你不接受，就把这三个字返发给我。
2.我觉得你真的不是个合格的朋友，你还是改行做我老婆吧！
3.玫瑰，你的；巧克力，你的；钻戒
abercrombie & fitch ，你的；你，我的。
4.不是每一朵花都能代表爱情，但是玫瑰做到了；不是每一种树都能耐得住干涸，但是白杨做到了；不是每一头猪
tods online 都能收到短信，但是你做到了;也不是每个人都喜欢猪 ,但是我做到了
