Archive June 2019

How to Circle Invalid Data In Excel

doc-circle-data-4

Supposing you have a range of data you want to circle some values which don’t meet your condition, in Excel, you can use Data Validation feature to create rules for selected data range, and then apply Circle Invalid Data function to circle all the data beyond your criterion. Please read this article to know more

Read More

Tips for replacing text with images in Word

C:\Users\Administrator\Desktop\新建文件夹 (6)\0628\-- (15)\1561706999(1).jpg

  Tips for replacing text with images in Word Steps: 1. First open the document that needs to be replaced; 2. Then copy the required picture; 3. Ctrl+H quickly calls up the “Replace” dialog box, input the content as shown; 4. You can finish replacing the text with a picture.

How to know the number of characters in excel

word image 685 - How to know the number of characters  in excel

This article introduces how to know the number of characters in excel. Steps: 1.we can enter “=len(text)” to know the number 2.if you want to know more, you can drag it 3.if you want to know all numbers, you can click autosum 4.you can also enter the sum formula 5.you can also enter =SUMPRODUCT(LEN(number))  

Read More

How to draw clustered bar chart in excel

word image 628 - How to draw clustered bar chart in excel

This article introduces how to draw clustered bar chart in excel. Steps: 1.open the document 2.click insert 3.choose data 4.find chart 5.choose statistic chart 6.choose clustered bar chart 7.we can choose data 8.you can change data 9.then you will get it