Excel Tips and Tricks To Ease Your Excel Work

Excel Tips and Tricks To Ease Your Excel Work


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.

Serial Number in Excel



Serial Number in Excel

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

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.

Current Date and Time


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. 

Move Data Without Copy Paste


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.

Copy Worksheet In Excel

Random Numbers

In excel, is is easy to generate random numbers, with the use of =rand() function.

Random Numbers In Microsoft Excel
© P4Pakao. All rights reserved. Distributed by ASThemesWorld