Excel tools are now used more and more widely. After all, in the era of big data, a large amount of data needs us to filter and analyze, and it is more and more important to skillfully use Excel tools.

Sum up experience, practice and do more, and practice will make perfect. When we practice using Excel tools, we need a lot of data to support our practice. So, are you worried about where these data come from?

Share a little trick today, and you can generate a lot of values in one second.

Please select a series of cells before entering the formula? = rand between (1000,2000) formula? , generate a random number between two values, and then press Ctrl+ ENTER to see that a random number in the range of 1000~2000 is generated in the selected cell within one second. Generate a large value in one second.

Have you learned? Thank you for watching and look forward to your forwarding. See you next time.