Microsoft is one of the most powerful companies in the field of computer software. OfficeSuite is one of the most complete suite of software created to date. This set, as the name implies, provides everything a person needs for their office desk. One of the most widely used software in the Office suite is Excel software. Excel is software for data management, simple and complex calculations, dashboard building, data classification and more. There are very few people on earth who can claim to know all Excel techniques. This software is much more powerful than similar software and has been known as a standard software in offices and companies for more than three decades.
Everyone among Excel users knows one thing: that they do not know everything! There are many ways to work with numbers and display statistics in a beautiful format. In general, we often know how to work with Excel Rella, but the key points of Excel are things that can not be easily found and mastered! These are the things that are taught to students in advanced Excel classes. Those who want to work professionally in this software, should include learning Excel professional tricks in their Excel training program. In this story, we are going to teach you some interesting Excel tricks. You will definitely not become a master of Excel with the following, but you will know Excel techniques that not everyone knows!
Break lines and place text in a cell
One of the key points of Excel is to fit a long text in a cell. If you normally start typing long in a cell, a large amount of text will pop out of your cell, and when the cell is not highlighted, part of your text will not be displayed. But this part can be changed. If you are typing in a cell, use the Alt + Enter key combination to open a space and a new line (pressing Enter will take you to the next cell!). You can also select the Wrap Text option under the Home tab and apply your changes.
Use Ctrl + Shift to select multiple cells
Instead of using the mouse pointer and selecting a bunch of cells, there is another faster way. Select the first cell in the row or column whose cells you want to select. You can now select all the data on the left, top, bottom and right of the cell using the Ctrl + Shift key combination and using the selection direction (on all four sides of the keyboard). Note that by doing this, Excel will select the last column of data for you (even the data that is not displayed). So if you have 20 columns of data, you have selected all the data in that column by selecting the first cell and hitting Ctrl + Shift with the arrow keys at the bottom of the keyboard. Now you can select all the row data by hitting the right or left key of the keyboard.
Use AutoFill
Sometimes Excel uses its intelligence to surprise you. If you type a series of recurring and repetitive data in consecutive cells, Excel is able to detect their continuation after a few data. For example, if you want to type the date of the days like 5/8/18, 6/8/18, 7/8/18, Excel can guess the data after a few cells and type it for you. To do this, select the typed cells and click on the last cell from the bottom right corner (you will see a small, full shape) and drag as many cells as you need to the bottom cells. Duplicate data is typed in all of your selected cells. You can do this in both rows and columns.
It could be even better! You can define arrangements for Excel and spend less time typing your own lists (because Excel does not know their order!). To do this, after the above steps, instead of grabbing and dragging in the last step, right-click and select Fill Series, and then apply your own settings.
Use the Text to Columns tool
Imagine a number of texts written in each of your Excel cells. For example, written: book / office / pencil. You want to write all three of these words separately. There are various Excel techniques for this, one of which is the Text to Columns tool. From the Data tab, you can select the column you want and use the Text to Columns option to separate the data you want by applying restrictions such as selecting the first few letters or…
Use “Paste Special” to move rows and columns
Paste Special is one of the Excel tricks with which you can replace the rows and columns of your data set. To use this Excel trick, just copy your data set and right-click and click Paste Special. This Excel trick is also used to obtain the transcript of a matrix.
Type a text in several cells
There are several reasons why you have to type a phrase continuously in several cells. Typing this text several times in a row can be tedious for you! Especially if it is long. There is an easy Excel trick to do this. Highlight your desired cells by holding down the control key and clicking, and in the last selected cell, type the phrase you want, and then press Ctrl + Enter. All highlighted cells will contain the phrase you typed.
Use “Paste Special” for formula writing
Imagine you have a lot of decimal numbers that you have to show as a percentage (%). The problem you face here is that the number 1 is shown 100% which should not be the case. You want to show 1 to 1%, but you can not! So you have to divide 1 by 100. This is where the Paste Special Excel trick comes in handy. First write 100 in a cell and copy it. Then select all the numbers you want to divide by 100 and then right click on them and select Paste Special and check the divide. You can also use this Excel trick to add, subtract and multiply quickly.
Use Flash Fill
Flash Fill is one of the most exciting applications of Excel. Flash Fill can modify other cells according to a pattern in a set of other cells (which you enter). For example, suppose that in a cell set, a thousand telephone numbers are written, one of which is 3337858963. You can dial (333) -785–8963. Do you have to change all the thousands of phone numbers one by one ?! The answer is no; If you change one, Flash Fill will do the other 999 for you. Just make the changes you want in one or two cells and then apply all the changes at once using the Flash Fill option. Excel itself guesses this pattern and suggests it to you.
This story continues. In the next posts, I will put the next Excel tricks. wait. thank you.
