Perhaps you have had hundreds of Excel to complete the financial expressions, maybe you have used Excel functions for complex operations a thousand times, maybe you meditation that Excel also many, or even nobody new. However, we continual countless times journal in handy to use all the capabilities in Excel is just one per penny. Excel in the heading from some little-known tips to start, get a glance on the Excel Different customs.
an, so namely another types of file using assorted colors
in the payroll, if you ambition more than equal to the total remuneration of 2,
建筑工程资料库100个(免费的)100000本,000 yuan to greater than alternatively equal apt 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. setup 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 list filled with items
name of the business we often want to enter into the chart,
pigalle christian louboutin, the name in order to preserve consistency, the use of
1. in Sheet2 in the name of the business by category (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 enterprise name and then select the column (eg column D), and then open the C1), OK to exit.
4. Select anyone compartment in col 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 species commerce name from the list, select the name of the corporation need to fill the cell.
Tip: When typography a report in the future, if you do not need to print the
Third, build a
1. the space in the toolbar right click, choose In the
Click
2. then in the (common document), and modeled it for the operation of the above named (such as
repeat the above operations, multi-document menu to add a few names.
3. Select the distribution Hyperlink By urgent the
repeat the above operation, the menu item and its corresponding workbook, the hyperlink documents attach.
4. After the need to open the
Tip: Although we ambition
four, making
1. the implementation of the Select the .
modeled on the above operation, one by one to log a special sign of the input of other good
2. Open the A work area in the toolbar.
switch to the How many buttons).
3. Select one of the
4. Right-click the button behind a name, in the following the shortcut menu, select exit.
Repeat this step, the button to correlate with the corresponding macro.
5. close the
five,
ebay mbt shoes, with
1. Open the worksheet to print, use the mouse without the need to print the row (or column) apparent drag, select them and then right click in the shortcut menu that appears, select , will not need to print the row (or column) hidden.
2. implementation
3. the secret rows (or columns) are exhibited, and repeat the operation,
4. After the need to print a manner, open the , issuing what, on the toolbar click the
six, so that sort of data on-demand hired
If you want to sort according to your ministry, the name of both of these departments is not according to the phonetic information almost the order, nor is it by stroke order, how do? can be self- defined sequence order.
1. perform The team, 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 portion of the contents of the cell do not want to enabling guests to access, had it hidden.
1. selected to hide 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 explicit the sky.
Tip:
eight, so in English and Chinese input method arose
smart editing table, some cells to enter the English, and some cells to enter the Chinese input method is not convenient to alternate afresh, why not set and let intelligent input method to adapt it?
selected range of cells to enter the Chinese, the implementation of tab, press the After the election
range of cells that need to input Chinese characters in any cell, Chinese input method (IME list, the first a Chinese input method) automatically open, elected in the other 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, although the wealthy
Excel function, merely it does not meet all our needs. We can customize a function to execute certain operations. Here, we define a reckoned from the trapezoid place function:
1. The implementation of the
2. In the window, execute
3. the right of the defined function to complete.
can later use the built-in function is the same as using a custom function.
Tip: Use the above means defined in the corresponding function is usually only used in the workbook.
XI header following pictures
lining additional to the backdrop sheet is lining in the all 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 picture underneath in the cell does not advocate printing.
second, with a hyphen obtain it (it is imagined 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 series, the implementation of , press the
4. the B, C, D, E column deleted, completion of the merger work.
Tip: Complete the steps from 1,2 combined achieve has been achieved, but at this time if you delete B, C, D series, the formula mistake. And thus ought be carried out step 3, the formula is converted to the same Performance of Students
article
friends often query, For this attention, I give here a uncomplicated method used to achieve the function.
cached in student achievement is hypothetical here Sheet1 worksheet range of cells A1 to G64,
asics gel cumulus 10 women 怎样去体内火, 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! 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 shape results section, the following simple modified see.
3. adjust the row altitude and column breadth, 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.
reception the What more suitable function. Excel box input requirements (such as related aid files, you can fast resolve the necessary function.
fifth, while outlooking a different worksheet in the multiple cells of data
Sometimes we edit a worksheet (Sheet1), it is essential View other work sheet (Sheet2, Sheet3 ... ...) the contents of a cell, you can use Excel's .
later, no stuff in which the worksheet, simply open the > In before editions of Excel 2002 because the operation of a range of cells is too many difficulty to add a siteline, Excel 2002 which functions a current evolution.
Click the pluck button,
christian louboutin prices, 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 tug and drop the frame, you can quickly draw the corresponding range of cells on the border.
Tip: ① If you draw the wrong border, does not matter, on the toolbar select Color >
XVII Enter the text in specific cells controlling the width of
Can you dream when you enter the four digits of the cell was filled with a number, or entering txt in the cell number you have entered time, Excel will automatically determine, instant analysis and pop-up warning, then be fine ah! To attain this function, the Excel, is also not laborious.
instance, we enroll the cursor to a the cell in array to enter the measurement of the unified and cozy, we wish that the Card advising annual. neatness time distance,
We know thateach time you open Excel, the software is always rotated on by default multiple sheets. Thus we can see that Excel has a strong addition to the processing power of unattached forms, more suitable for multiple interrelated coordination table . to coordinate the union, of course, 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 found that alteration the format of how to do? First, we must change the data format of the first table, and then click the time, Excel will popup up IX, change the text in the case of
in Excel for form processing and data computing support is not the most mighty formula, nor is the database, but the function. Do not think that Excel, the function only for mathematics, in fact, 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 at 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 motorcar will be will be the method save trouble, especially fknow next to nothing ofme of the information especially alike style, such as staff lists, place of origin and other information.
quickly if we want to extract the cells from A4 caption, it is best to use to extract the number of characters) grid, the number of characters extracted) words, only in the target cell to enter and 5 words.
the twenty-first, into the bottom ordinal digit words to English words into ordinal bottom is a more complicated problem. because it is not a quite nailed pattern: Most of the figures into ordinal number is used in the Moreover, function, fair jot a formula that can be accessible 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 digit is to cardinal and ordinal transition words so easy and fast implementation.
XXII, filled with special symbols and monetary dealings with the median
people know, when filling in the writing there is a conventional Safety Fill Law The elementary format is the formula to should be changed to REPT (head coupled with # # 0.00 worksheet consisting of plain text to create the histogram. It is also very simple principle,
mbt sport 2 shoes, that is, the smart use of special symbols repeated according to a specified cell showing the results of the relative effectiveness of different lengths.
example, we first Annual production of a poise canvas, and then The results have been ROUND (D3 * 100,0 )),> circular to calculate the total number of words in the cell
Sometimes, we may have the role of a cell in the number of amused need to calculate the total number of words in the cell. To solve this problem, in increase 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 skylight, the additional functions, we can set the money conversion mouse equality EU list of additional currencies. Of way, in order to display the euro is more professional, we can also click on the Excel toolbar, the p>
to redo the computer system, study their own, can cost less money, ha ha [chart]
one, ready to work:
how to reinstall the computer system
First, start the calculator when holding down the DELETE opener to enter BIOS, select Advanced BIOS Features adoption, and press the Enter key to enter setup. Select First Boot Device option, then reception the keyboard Page Up or Page Down key to set the CD-ROM, so you can start the system to the record.
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 supported from the start.
2. possible, ahead running the installer with all the hard disk to scan the hard disk error checking and fix, or install the program is running, such as checking that there is an error that will be hard very troublesome.
3. file with the paper records the product key to install (installation reg code number).
4. likely, 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 major hardware contractors, pre-download the driver for use.
5. If you want to format the C drive during the installation or the D drive (suggested format the C drive during installation), back up the C drive or D drive serviceable data.
Second, start the system with a CD-ROM:
(if you yet know the direction, go to the afterward 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 characteristic practices, please refer to the same with this -> how to get into pure DOS system:
CD-ROM from the start, if no event to see the installation screen will appear as shown in Figure 1
;
View Original
prompted entire Chinese, View elemental
authorize approval, there is no alternative, according to section, format the C pedal if you have select the C section, select a agreeable partition and press format, which become the document system format, or save one existing file system, a diversity of alternative, but memorandum that the NTFS format to save disk space, cultivate security and decrease disk fragmentation but there are many problems and MacOS 98/Me can not look the NTFS partition, here, choose Figure
warning format C drive, press the F key will be prepared to format the c drive, there is shown in Figure 6 under the original
view of the selected partition C space than 2048M ( or 2G),
mbt sirima dark 陪�_到永� [http 112697042.qzone.qq.com], 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 install XP Setup shoe floppy disks to invest during the installation process format the partition option; If you use MS-DOS boot disk into DOS, scamper i386 winnt to install XP, install the XP partition without formatting options. Format C partition is completed, there is shown in Figure 8 under the original
see Figure 8 to start copying file, copy the file after the installation program begins to initialize Windows configuration. and then the system will automatically restart in 15 seconds. restarts, there is shown in Figure 9 under the original
View 9
View Original
than 5 minutes later, when the prompt appears when needed 33 minutes following figure 10
View Original
local and language settings to use the default merit can be a straight point of the Next step this password, Administrator System Administrator has the highest authority in the system, commonly landing system does no require the account. Then click , select Beijing, click Original
allows you to choose the method used by the network installation, select a typical set point
View Original
continue the installation,
christian louboutin rollerball, 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 begin takes a long period, please be patient, emulated along the salute screen, set the system prompt, as shown 20
View Original
click the base right corner of the
View Original
here to create a broadband dial-up linkage, not dial-up linkage ashore the desktop shortcut, and dial-up linkage the default label Wizard to establish a broadband dial-up connection, dial-up connection on the desktop shortcut, and the default dial-up connection named button.
here I first create a broadband connection, select the first
View Original
Telecom or China Unicom are currently using (ADSL) Residential consumers have accounts and passwords, so I chose , as shown in Figure 23
View Original
Telecom or China Unicom to provide input account and password in the The name of the menu, and if left vacant the system will automatically create a file cried the dial-up connection, Microsoft surely want you to stimulate XP you, but even if there does not activate the 30-day trial time, why the hurry? choose Figure 25 shows
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 log a new user. landing desktop as below 27
View Original
six, and ascertain general icons
; on the desktop start -> interlock to -> broadband connection, as shown 32
View original
left point Office on the desktop can be seen more than a the open display the bottom left of the diagram click on the My Network Places
accidentally deleted data recovery
accidentally, delete the wrong, and also vacant the Recycle Bin, the conceived ah?
at a time three steps, you can delete and empty the Recycle Bin behind 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 on
, select: Recycle Bin .
mbt amusement 2 shoes Computer perception namely c
Linear Mode
