One of the fastest ways to learn excel is to learn some tips and tricks, be patient and if you learn tips from Excel in one day, you can learn 30 new things in one. a month.
But you should have a list that you can look at every day instead of looking around. Well, I can proudly say that this is the most complete list of all the basic ideas and innovations you can find on the Internet.
In this list, I’ve included a lot of Excel tips and tricks that you can learn to improve your Excel skills. Let’s start learning.
Serial Number
If you are working with large data, it is best to add image numbers to it. The more coinvent way to do this is to apply a spreadsheet to the data and then add 1 to the phone number above, as below.
To do this, you just need to add 1 to the first cell in a row, and then create a form 1 to add 1 to the maximum value of the cell.
When you use a table, every time you create a table entry, Excel automatically transfer the formula and you will get the serial number.
Current Date and Time
The more convenient way to set the current date and time in Microsoft excel is to use the NOW function (=now()) hit enter, which takes the date and time from your system and returns the value.
Move Data Without Copy Paste
How do I transfer data from one place to another? We sure you mentioned your copy paste idea, but you can also use this.
Just select the type of information you have, and click the Options button. If you save it, it runs where you want it to go.
Copy Worksheet
To copy a worksheet into one workbook of Microsoft Excel, click hold the sheet and press Ctrl (Ctrl + Click) move and release is the best way.
Random Numbers
In excel, is is easy to generate random numbers, with the use of =rand() function.