Summary post of useful tips for using Excel tables in computer resource versions
Thread Content
This post was last edited by hamiltontai on 2015-11-23 at 14:41. It compiles various useful tips for using Excel to make it easier for everyone to find them. At the same time, everyone is welcome to share their own tips~~~ —————————I’m the separator line-————————— Excel tips to improve work efficiency: Tip 01 – Reverse the order of text. Excel tips to improve work efficiency: Tip 02 – Create check boxes. Excel tips to improve work efficiency: Tip 03 – Add pinyin to Chinese characters. Excel tips to improve work efficiency: Tip 04 – Insert pinyin with tones. Excel tips to improve work efficiency: Tip 05 – Split a single cell using slashes. Excel tips to improve work efficiency: Tip 06 – Hide areas that don’t need to be displayed. Excel tips to improve work efficiency: Tip 07 – Display phone numbers in segments. Excel tips to improve work efficiency: Tip 08 – Show data in tens of thousands. Excel tips to improve work efficiency: Tip 09 – Sort percentages for individual cases. Excel tips to improve work efficiency: Tip 10 – Quickly fill in identical content. Excel tips to improve work efficiency: Tip 11 – Quickly copy from the cell above. Excel tips to improve work efficiency: Tip 12 – Quickly enter the system date and time. Excel tips to improve work efficiency: Tip 13 – Tips for entering fractions. Excel tips to improve work efficiency: Tip 14 – Tips for quickly inserting parameters. Excel tips to improve work efficiency: Tip 15 – Tips for quickly adding information. Excel tips to improve work efficiency: Tip 16 – Repeat formats. Excel tips to improve work efficiency: Tip 17 – Convert numbers to uppercase. Excel tips to improve work efficiency: Tip 18 – Quickly select cells containing links. Excel tips to improve work efficiency: Tip 19 – Show cells containing formulas. Excel tips to improve work efficiency: Tip 20 – Preserve formulas within cells. Excel tips to improve work efficiency: Tip 21 – Use mail merge to generate a separate information sheet for each person. Excel tips to improve work efficiency: Tip 22 – Use the VLOOKUP function to filter phone numbers. Excel tips to improve work efficiency: Tip 23 – Use formulas to calculate loans
2L reserved for building use~~~~~~~~~~
Thank you for sharing and organizing it. :victory:
Thank you to the original poster for sharing this; I really didn’t know that method for changing the phone number before. I was able to learn a lot this time; it seems that Excel has many functions, and I’ve only become familiar with a small portion of them.
Great stuff, thanks to the original poster for sharing it. I wanted to rate the post, but I couldn’t find a rating button after searching for a long time. Is it possible that ratings aren’t allowed in this section?
Sure. . Rating the 1st floor is different from rating the other floors. . . Click below the thumbs up. . . Oh, isn’t this a bit like trying to assign scores? . .
Below the like thumb button, there is no rating button; it’s available in other sections.
Then no need to rate it~~ I appreciate the thought~~~ I’ll keep updating this series~~
Could you create a guide for using the data table?
For example. . I don’t understand how to use the data table. . .