Little-known Excel skills
I don't know if you are patient .. Haha
Maybe you have already completed hundreds of financial statements in Excel. Maybe you have used the EXCEL function to perform thousands of complex operations. Maybe you think that
Maybe you have already completed hundreds of financial statements in Excel. Maybe you have used the EXCEL function to perform thousands of complex operations. Maybe you think that excel is just the same, or even nothing new. However, we repeatedly
Let different types of data be displayed in different colors
In the payroll, if you want to make the total wages greater than or equal to 2000 dollars to show "red", greater than
Wages equal to 1500 yuan in the "blue" show, less than 1000 of the
Maybe you have already completed hundreds of financial statements in Excel. Maybe you have used the EXCEL function to perform thousands of complex operations. Maybe you think that excel is just the same, or even nothing new. However, we repeatedly
1, Word How to use the emphasis number
In Word we can put the emphasis number on the toolbar. Open the Tools-Customize command option to open the Customize dialog box. Under the Commands tab, in the Categories column, select the All Commands option.
Let different types of data display in different colorsIn the payroll, if you want to let the total wages of more than or equal to 2000 yuan be displayed in "Red", the total wage of more than or equal to 1500 yuan is shown in "Blue", the total wages
In Excel tables, the number of digits is processed, and the number of digits you specify is often rounded as needed.
Numeric rounding can be done with the following functions:
Rounding =round (a1,0)
Truncate decimal rounding =rounddown (a1,0)
1. How to use a duplicate number in Word
In word, we can place a duplicate number on the toolbar. Open the "tool-custom" Command Option and open the "Custom" dialog box. Select "All commands" in the "category" column under the "command" tab.. All
35 tips for using workbooks (1)Friday, 19. May 2006, 19:49:23
35 tips for using workbooks (1)
1. Create a category drop-down list fill itemWe often need to enter the company name into the table, to maintain name consistency, use "Data
I. Deletion of data by mistake
Accidentally deleted the wrong, but also emptied the Recycle Bin, how to do ah? With just three steps, you can get back what you deleted and emptied the Recycle Bin.
Steps:
1. Click Start-Run, and then enter regedit
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.