Microsoft Excel is meant to help you in making encoding of info, calculations, and conditional formatting easier. You can use it to calculate your savings, earnings, do math, and save your time by learning the tips and tricks available. You can click here to get started. 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. By knowing all the shortcuts in using Microsoft Excel, you will be able to impress your boss and your workmates.
Pivot Tables. It will be easier for you to reorganize all the info in the spreadsheet and easily summarizing the value without the need for you to set or change the data by using pivot tables? To do this, you have to go to Data > Pivot Table. After the spreadsheet populates itself after hitting the “Pivot Table”, 4 options will be available for you to use. You can either “report filter” which makes you only check particular rows in the spreadsheet. By using “Column Labels” the headers can be easily chosen from the spreadsheet. “Row Labels” can help you look at rows in the set. You can use the following results to the set of numbers in a dataset, max, min, sum, and average, by allowing you to choose these info using “Value”.
Transpose. To avoid copying and pasting the data from one of the few rows and moving them to a new set of columns, you can use the transpose capability. 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
Using parenthesis it is easy to make several calculations using just one formula, for example, (56/98*8)+4-2. 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.
To use your Microsoft Excel better and easier, these tips and shortcuts are going to be significant.