Do you know that you can do a lot of things than just entering a formula in Microsoft Excel? You can use it to calculate your savings, earnings, do math, and save your time by learning the tips and tricks available. Just make sure to click here to get started if you want to make use of all the shortcuts and tricks of Microsoft Excel. Do you know that you don’t need to copy and paste data on all the cells by just following the tips and tricks here mentioned. You can’t imagine the advantage of having all these tips and tricks once you were able to apply it for yourself. Your boss will be one of your fans if you learn them all.
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”. It will populate automatically the spreadsheet, and then you can do 4 things before completing the task. Use the “report filter” to allow you to only choose the particular row in a spreadsheet or table. “Column Labels” can allow you to look at headers only of the data set. “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. Make sure to choose the option “Copy” after highlighting the columns or rows to be transposed then right-clicking it. Choose the set of tables where you want to add the new set of data copied by clicking the “Paste Special” option.
Simple Calculations. You can use the simple ways of calculations in Excel by doing the following:
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. Do you know that you can use =Average (Cell Range) to average any set of numbers and you can use =Sum (Cell Range) to summarize a column of numbers?
Other Shortcuts. Add a new row or column by highlighting the rows then selecting “Insert” after doing right-click. You can highlight a column or row then remove the duplicates using the “Remove Duplicates” option in the Data tab.
These tips and tricks will surely make your using of Microsoft Excel easier.