Digital currency Zhang Biao
Publish: 2021-04-23 08:01:51
1. Haste platform can give investors a brand new experience no matter from the whole business or the details of service. But I value trading more, so stability is more important to me.
2. First of all, you don't make it very clear, but you think it's OK for you to automatically sum. There's no need to explain to you
￥ if you use a small character, it's not as easy as typing. If you want to be automatic. Press the following steps:
1. Right click the summation cell and select "set cell format",
2. In the "number" tab, first select "currency"
3. Set the number of decimal places and currency symbol and confirm
if you have any questions, please ask me again
￥ if you use a small character, it's not as easy as typing. If you want to be automatic. Press the following steps:
1. Right click the summation cell and select "set cell format",
2. In the "number" tab, first select "currency"
3. Set the number of decimal places and currency symbol and confirm
if you have any questions, please ask me again
3. http://office.microsoft.com/zh-hk/excel-help/?CTT=97
the usage of all excel functions can be found on this website. Please refer to
all examples
the usage of all excel functions can be found on this website. Please refer to
all examples
4. 1、 Let different types of data be displayed in different colors
in the payroll, if you want the total amount of wages greater than or equal to 2000 yuan to be displayed in "red", the total amount of wages greater than or equal to 1500 yuan to be displayed in "blue", the total amount of wages less than 1000 yuan to be displayed in "Brown", and others to be displayed in "black", we can set this
1. Open the "payroll" workbook, select the column of "payroll", execute the "format → conditional format" command, and open the "conditional format" dialog box. Click the drop-down button on the right side of the second box, select the "greater than or equal to" option, and enter the value "2000" in the following box. Click format to open the cell Format dialog box, and set the color of font to red
2. Press the "add" button, and follow the above operation to set other conditions (greater than or equal to 1500, the font is set to "blue"); Less than 1000, the font is set to "Brown")
3. After setting, press the "OK" button
take a look at the payroll. Are the payroll data displayed in different colors according to your requirements<
Second, create a category drop-down list filling item
we often need to input the name of the enterprise into the table. In order to maintain the consistency of the name, we use the "data validity" function to create a category drop-down list filling item
1. In SHEET2, enter the enterprise names into different columns by category (such as "instrial enterprise", "commercial enterprise", "indivial enterprise" and so on) to establish a database of enterprise names
2. Select column a (the column of instrial enterprise name), enter the character "instrial enterprise" in the "name" column, and press enter to confirm
following the above operation, name columns B and C as "commercial enterprise" and "indivial enterprise"...
3. Switch to Sheet1, select the column (such as column C) that needs to input "enterprise category", execute the "data → validity" command, and open the "data validity" dialog box. In the "Settings" tab, click the drop-down button on the right side of "allow", select the "sequence" option, and in the "source" box below, enter "instrial enterprise", "commercial enterprise", "indivial enterprise"... Sequence (each element is separated by a comma in English), and confirm to exit
select the column (e.g. column d) where you want to enter the enterprise name, and then open the data validity dialog box. After selecting the sequence option, enter the formula in the source box: = indirect (C1), and confirm to exit
4. Select any cell in column C (such as C4), click the drop-down button on the right, and select the corresponding "enterprise category" to fill in the cell. Then select the D column cell (such as D4) corresponding to the cell, and click the drop-down button to select the required enterprise name from the enterprise name list of the corresponding category and fill in the cell
tip: if you do not need to print the "enterprise category" column in the future, you can select the column, right-click and select the "hide" option to hide it
3. Create a new menu of "common documents"
create a new menu of "common documents" on the menu bar to add common workbooks to it, which is convenient to call at any time
1. Right click the mouse in the blank space of the toolbar and select the "Customize" option to open the "Customize" dialog box. In the command tab, select new menu under category, and then drag new menu under command to the menu bar
press the "change selection" button and enter a name (such as "common documents") in the "naming" box of the pop-up menu
2. Select any item under "category" (such as "insert" option), select any item under "command" on the right (such as "hyperlink" option), drag it to the new menu (common documents), and name it after the above operation (such as "payroll", etc.) to create the first document list name of the workbook
repeat the above steps to add more document list names
3. Select a menu item (such as payroll) in the common documents menu, right-click the mouse, and select the "assign hyperlink → open" option in the pop-up shortcut menu to open the "assign hyperlink" dialog box. By pressing the drop-down button on the right side of "search range", locate the corresponding Workbook (such as "salary. XLS") folder, and select the workbook document
repeat the above steps to hyperlink the menu item with the corresponding workbook document
4. To open a workbook document in the common documents menu in the future, just expand the common documents menu and click the corresponding option
tip: Although we drag the "hyperlink" option to the "common documents" menu, it does not affect the function of the "hyperlink" menu item in the "insert" menu and the "insert hyperlink" button on the "common" toolbar
4. Making "professional symbol" toolbar
when editing professional forms, we often need to input some special professional symbols. In order to facilitate input, we can make our own "professional symbol" toolbar
1. Run "tools → macro → record new macro" command, open "record new macro" dialog box, input macro name? Such as "fuhao1"? Save the macro in your personal macro workbook, and then click OK to start recording. Select the "relative reference" button on the "record macro" toolbar, and then input the required special symbols into a cell, and then click the "stop" button on the "record macro" toolbar to complete the macro recording
the above operation and record the input "macro" of other special symbols one by one
2. Open the Customize dialog box, click New in the toolbar tab, and the new toolbar dialog box will pop up. Enter the name - "professional symbol". After confirmation, a toolbar will appear in the workspace
switch to the "command" tab, select "macro" under "category", and drag the "custom button" item under "command" to the "professional symbols" bar (drag as many buttons as there are special symbols)
3. Select one of the "custom buttons" and name them according to the first point of the second trick
4. Right click a named button, select the "specify macro" option in the pop-up shortcut menu, open the "specify macro" dialog box, select the corresponding macro (such as fuhao1, etc.) and confirm to exit
repeat this step to link the button with the corresponding macro
5. Close the "custom" dialog box, and you can use the "professional symbols" toolbar to quickly input professional symbols into the cells, just like the ordinary toolbar< 5. Use the view manager to save multiple printed pages.
some worksheets often need to print different areas. Use the view manager
1. Open the worksheet that needs to be printed, drag the mouse over the rows (or columns) that do not need to be printed, select them, and then right-click the mouse. In the shortcut menu that appears, select the "hide" option to hide the rows (or columns) that do not need to be printed
2. Execute the "view → view manager" command, open the "view manager" dialog box, and click the "add" button to open the "add view" dialog box. After entering a name (such as "previous report"), click the "OK" button
3. Display the hidden rows (or columns) and repeat the above operation to "add" other printing views
4. When you need to print a certain form in the future, open the view manager, select the name of the form to be printed, click the "display" button, and the worksheet will be displayed immediately according to the preset interface. After a simple setting and typesetting, press the "print" button on the toolbar, and everything will be OK< 6. Sort the data on demand
if you want to sort the employees by their departments, the information about these Department names is not in pinyin order or stroke order, what should you do? You can use a custom sequence to sort
1. Execute the "format → options" command, open the "options" dialog box, enter the "user defined sequence" tab, enter the sequence of department sorting (such as "organization, team, workshop 1, workshop 2, workshop 3" etc.) in the box under "input sequence", and click "add" and "OK" to exit
2. Select any cell in the "department" column, execute the "data → sort" command, open the "sort" dialog box, click the "options" button, and the "sort options" dialog box will pop up. Press the drop-down button, select the customized sequence, and press the "OK" button twice to return. All data will be sorted as required< 7. Hide the data completely
the contents in some cells of the worksheet don't want to be viewed by the browser, so they have to be hidden
1. Select the cell (range) that needs to be hidden, execute the "format → cell" command, open the "cell format" dialog box, select the "custom" option under "classification" in the "number" label, and then enter ";" in the box under "type" on the right Three semicolons in English
2. Switch to the "protection" tab, select the "hide" option, and press the "OK" button to exit
3. Execute the "tools → protection → protect worksheet" command, open the "protect worksheet" dialog box, and after setting the password, "OK" returns
after such a setting, the contents of the above cells will no longer be displayed. Even if you use the transparent function of Excel, you can't make them visible
tip: under the "protection" tab, please do not clear the "∨" in the check box in front of "lock", so as to prevent others from deleting your hidden data< 8. Let Chinese and English input methods appear intelligently
when editing tables, some cells need to input English, and some cells need to input Chinese. It's really inconvenient to switch input methods repeatedly. Why don't you set it to make input methods intelligently adjusted
select the cell range that needs to input Chinese, execute the command "data → validity", open the dialog box of "data validity", switch to the tab of "input mode", press the drop-down button on the right side of "mode", select the "open" option, and then click "OK" to exit
in the future, when any cell in the range of cells to input Chinese is selected, the Chinese input method (the first Chinese input method in the list of input methods) will be turned on automatically. When other cells are selected, the Chinese input method will be turned off automatically< 9. Let AutoCorrect input unified text
do you often worry about inputting some fixed text, such as computerdaily? Then look down
1. Execute the "tools → AutoCorrect" command to open the "AutoCorrect" dialog box
2. Enter "PCW" in the box under "replace" (it can also be other characters, "PCW" in lowercase), enter "Computer News" in the box under "replace with", and then click "add" and "OK"
in the payroll, if you want the total amount of wages greater than or equal to 2000 yuan to be displayed in "red", the total amount of wages greater than or equal to 1500 yuan to be displayed in "blue", the total amount of wages less than 1000 yuan to be displayed in "Brown", and others to be displayed in "black", we can set this
1. Open the "payroll" workbook, select the column of "payroll", execute the "format → conditional format" command, and open the "conditional format" dialog box. Click the drop-down button on the right side of the second box, select the "greater than or equal to" option, and enter the value "2000" in the following box. Click format to open the cell Format dialog box, and set the color of font to red
2. Press the "add" button, and follow the above operation to set other conditions (greater than or equal to 1500, the font is set to "blue"); Less than 1000, the font is set to "Brown")
3. After setting, press the "OK" button
take a look at the payroll. Are the payroll data displayed in different colors according to your requirements<
Second, create a category drop-down list filling item
we often need to input the name of the enterprise into the table. In order to maintain the consistency of the name, we use the "data validity" function to create a category drop-down list filling item
1. In SHEET2, enter the enterprise names into different columns by category (such as "instrial enterprise", "commercial enterprise", "indivial enterprise" and so on) to establish a database of enterprise names
2. Select column a (the column of instrial enterprise name), enter the character "instrial enterprise" in the "name" column, and press enter to confirm
following the above operation, name columns B and C as "commercial enterprise" and "indivial enterprise"...
3. Switch to Sheet1, select the column (such as column C) that needs to input "enterprise category", execute the "data → validity" command, and open the "data validity" dialog box. In the "Settings" tab, click the drop-down button on the right side of "allow", select the "sequence" option, and in the "source" box below, enter "instrial enterprise", "commercial enterprise", "indivial enterprise"... Sequence (each element is separated by a comma in English), and confirm to exit
select the column (e.g. column d) where you want to enter the enterprise name, and then open the data validity dialog box. After selecting the sequence option, enter the formula in the source box: = indirect (C1), and confirm to exit
4. Select any cell in column C (such as C4), click the drop-down button on the right, and select the corresponding "enterprise category" to fill in the cell. Then select the D column cell (such as D4) corresponding to the cell, and click the drop-down button to select the required enterprise name from the enterprise name list of the corresponding category and fill in the cell
tip: if you do not need to print the "enterprise category" column in the future, you can select the column, right-click and select the "hide" option to hide it
3. Create a new menu of "common documents"
create a new menu of "common documents" on the menu bar to add common workbooks to it, which is convenient to call at any time
1. Right click the mouse in the blank space of the toolbar and select the "Customize" option to open the "Customize" dialog box. In the command tab, select new menu under category, and then drag new menu under command to the menu bar
press the "change selection" button and enter a name (such as "common documents") in the "naming" box of the pop-up menu
2. Select any item under "category" (such as "insert" option), select any item under "command" on the right (such as "hyperlink" option), drag it to the new menu (common documents), and name it after the above operation (such as "payroll", etc.) to create the first document list name of the workbook
repeat the above steps to add more document list names
3. Select a menu item (such as payroll) in the common documents menu, right-click the mouse, and select the "assign hyperlink → open" option in the pop-up shortcut menu to open the "assign hyperlink" dialog box. By pressing the drop-down button on the right side of "search range", locate the corresponding Workbook (such as "salary. XLS") folder, and select the workbook document
repeat the above steps to hyperlink the menu item with the corresponding workbook document
4. To open a workbook document in the common documents menu in the future, just expand the common documents menu and click the corresponding option
tip: Although we drag the "hyperlink" option to the "common documents" menu, it does not affect the function of the "hyperlink" menu item in the "insert" menu and the "insert hyperlink" button on the "common" toolbar
4. Making "professional symbol" toolbar
when editing professional forms, we often need to input some special professional symbols. In order to facilitate input, we can make our own "professional symbol" toolbar
1. Run "tools → macro → record new macro" command, open "record new macro" dialog box, input macro name? Such as "fuhao1"? Save the macro in your personal macro workbook, and then click OK to start recording. Select the "relative reference" button on the "record macro" toolbar, and then input the required special symbols into a cell, and then click the "stop" button on the "record macro" toolbar to complete the macro recording
the above operation and record the input "macro" of other special symbols one by one
2. Open the Customize dialog box, click New in the toolbar tab, and the new toolbar dialog box will pop up. Enter the name - "professional symbol". After confirmation, a toolbar will appear in the workspace
switch to the "command" tab, select "macro" under "category", and drag the "custom button" item under "command" to the "professional symbols" bar (drag as many buttons as there are special symbols)
3. Select one of the "custom buttons" and name them according to the first point of the second trick
4. Right click a named button, select the "specify macro" option in the pop-up shortcut menu, open the "specify macro" dialog box, select the corresponding macro (such as fuhao1, etc.) and confirm to exit
repeat this step to link the button with the corresponding macro
5. Close the "custom" dialog box, and you can use the "professional symbols" toolbar to quickly input professional symbols into the cells, just like the ordinary toolbar< 5. Use the view manager to save multiple printed pages.
some worksheets often need to print different areas. Use the view manager
1. Open the worksheet that needs to be printed, drag the mouse over the rows (or columns) that do not need to be printed, select them, and then right-click the mouse. In the shortcut menu that appears, select the "hide" option to hide the rows (or columns) that do not need to be printed
2. Execute the "view → view manager" command, open the "view manager" dialog box, and click the "add" button to open the "add view" dialog box. After entering a name (such as "previous report"), click the "OK" button
3. Display the hidden rows (or columns) and repeat the above operation to "add" other printing views
4. When you need to print a certain form in the future, open the view manager, select the name of the form to be printed, click the "display" button, and the worksheet will be displayed immediately according to the preset interface. After a simple setting and typesetting, press the "print" button on the toolbar, and everything will be OK< 6. Sort the data on demand
if you want to sort the employees by their departments, the information about these Department names is not in pinyin order or stroke order, what should you do? You can use a custom sequence to sort
1. Execute the "format → options" command, open the "options" dialog box, enter the "user defined sequence" tab, enter the sequence of department sorting (such as "organization, team, workshop 1, workshop 2, workshop 3" etc.) in the box under "input sequence", and click "add" and "OK" to exit
2. Select any cell in the "department" column, execute the "data → sort" command, open the "sort" dialog box, click the "options" button, and the "sort options" dialog box will pop up. Press the drop-down button, select the customized sequence, and press the "OK" button twice to return. All data will be sorted as required< 7. Hide the data completely
the contents in some cells of the worksheet don't want to be viewed by the browser, so they have to be hidden
1. Select the cell (range) that needs to be hidden, execute the "format → cell" command, open the "cell format" dialog box, select the "custom" option under "classification" in the "number" label, and then enter ";" in the box under "type" on the right Three semicolons in English
2. Switch to the "protection" tab, select the "hide" option, and press the "OK" button to exit
3. Execute the "tools → protection → protect worksheet" command, open the "protect worksheet" dialog box, and after setting the password, "OK" returns
after such a setting, the contents of the above cells will no longer be displayed. Even if you use the transparent function of Excel, you can't make them visible
tip: under the "protection" tab, please do not clear the "∨" in the check box in front of "lock", so as to prevent others from deleting your hidden data< 8. Let Chinese and English input methods appear intelligently
when editing tables, some cells need to input English, and some cells need to input Chinese. It's really inconvenient to switch input methods repeatedly. Why don't you set it to make input methods intelligently adjusted
select the cell range that needs to input Chinese, execute the command "data → validity", open the dialog box of "data validity", switch to the tab of "input mode", press the drop-down button on the right side of "mode", select the "open" option, and then click "OK" to exit
in the future, when any cell in the range of cells to input Chinese is selected, the Chinese input method (the first Chinese input method in the list of input methods) will be turned on automatically. When other cells are selected, the Chinese input method will be turned off automatically< 9. Let AutoCorrect input unified text
do you often worry about inputting some fixed text, such as computerdaily? Then look down
1. Execute the "tools → AutoCorrect" command to open the "AutoCorrect" dialog box
2. Enter "PCW" in the box under "replace" (it can also be other characters, "PCW" in lowercase), enter "Computer News" in the box under "replace with", and then click "add" and "OK"
5. Can't see your table, total is to click on the top of the table, there is a symbol of "m" lying down, sheep's head refers to the currency symbol, click the grid that needs sheep's head, right-hand key, select set cell format, number column midpoint currency, and then confirm, OK, sheep's head appears!!
6. No matter how small a company is, just like a sparrow, its internal organs should be complete.
first of all, there must be bank income and expenditure, that is, bank journal and cash journal. Second, there are two statements for tax return, balance sheet and profit statement. In some places, detailed declaration of personal income tax and statement of invoice usage are also needed, Other reports are prepared according to the company's needs
first of all, there must be bank income and expenditure, that is, bank journal and cash journal. Second, there are two statements for tax return, balance sheet and profit statement. In some places, detailed declaration of personal income tax and statement of invoice usage are also needed, Other reports are prepared according to the company's needs
Hot content