There are many things that you can do and not just encoding the necessary information in the Microsoft Excel. It is very easy to use the Microsoft Excel especially if you know a lot more of the shortcuts and tricks. Just make sure to click here to get started if you want to make use of all the shortcuts and tricks of Microsoft Excel. It will be for your benefit if you will use all the tips and shortcuts you may find in this article. If you want to impress your colleagues or make your work faster and easier, then using these tips and tricks are all going for your benefit. By knowing all the shortcuts in using Microsoft Excel, you will be able to impress your boss and your workmates.
Pivot Tables. Do you know that you can make a quick summary of all the information you have in your spreadsheet without the need for you to change any data or item in the tables by using pivot tables? To make it happen, just go to the Data tab then choose the option “Pivot Table”. After the spreadsheet populates itself after hitting the “Pivot Table”, 4 options will be available for you to use. If you want to use only particular rows in the spreadsheet, then choose “report filter”. By using “Column Labels” the headers can be easily chosen from the spreadsheet. “Row Labels” can help you look at rows in the set. Do you know that you can use this option, “Value” to give you an option to use max, min, sum, and average of numbers and data significant.
Transpose. You don’t need to copy and paste data from one row to a new set of columns because you can copy all data in the set using the “transpose” option. This is easily done by making sure to highlight the column that will be transposed, hit “Copy” after right-clicking. Hover over the cursor of your mouse to the next set of columns where you want to put the data, and then hit “Paste Special”.
Simple Calculations. The following are all the simple arithmetic options you can use in the Microsoft Excel:
o + sign for addition
o – sign for subtraction
o * sign for multiplication
o / sign for division
You can easily do multiple calculations by using parenthesis, for example, (95+88*5)/4. To average a set of numbers or to summarize column of numbers, you can use =Average (Cell Range) and =Sum (Cell Range) accordingly.
Other Shortcuts. Do this by going to the Data tab and hitting the “Filter” option. You can easily remove duplicates by choosing “Remove Duplicates” in the Data tab after highlighting a row or column.
These tips and tricks will surely make your using of Microsoft Excel easier.