[Practical] Collection of Excel table skills，Double your work efficiency

[Practical] Collection of Excel table skills，Office software that doubles your work efficiency seems simple，In fact, there are many tricks，Especially Excel tables，Involving some relatively rare data processing。But in fact, as long as you practice hard and practice，It’s really not a problem to easily increase efficiency by ten or a hundred times!

Hurry up and learn together~

1. Reverse the text order and copy the normal order object → add @ before the font → click to rotate the text downward → click to wrap the text automatically
2. Create check box input”R”→Set the font to Wingdings
3. Mark Chinese characters with Pinyin. Mark Pinyin → Enter Chinese characters → Select Pinyin settings → Center → Edit Pinyin → Enter Pinyin → Display Pinyin characters
4. Insert the toned Pinyin to mark the toned Pinyin → Insert - symbol → Latin expansion - B → Enter the toned Pinyin (remarks：In the animation, "we" should be the second tone。

）

1. Use a diagonal line to divide a single cell and select the object → Insert shape (straight line) → ALT + mouse to quickly locate the corner of the cell → F4 to repeat the action，Add dividing line→Insert text box→Adjust font
2. Hide selected objects in areas that do not need to be displayed→Ctrl+1→Click Custom→Enter；；；
3. Display the mobile phone number in segments and select the number→Ctrl+1→Click Custom→Enter 000-. The data is displayed in units of thousands. Select the object→Ctrl+1→Click Custom→Enter 0!

.0,”Ten thousand”9.Sort Case Percentage Select Objects → Sort → Uncheck Data Include Titles → Select Series

About Hong Kong Xintong

Hong Kong Xintong focuses onGuangdong and Hong Kong license plates、Shenzhen Hazardous Chemicals Business License、Shenzhen labor dispatch licenseandShenzhen Charity Foundationapplication services，Assist customers to applyShenzhen travel agency business license、Shenzhen pawn shop business license、Shenzhen auction house license and other mainstream domestic financial licenses，Support enterprises to achieve compliance expansion of cross-border financial business。Also availableODI overseas investment registration、International travel agency registration and other services，Help enterprises expand their presence in international markets。Provide one-stop compliance solutions for enterprises。To learn more，Please contactHong Kong Information Communications Consultant。