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. You can click here to get started. It will be easier for you to make things in the Excel without using a lot of your time and effort copying and pasting data. The following tips, tricks, and shortcuts that will be mention are designed to make you an expert. 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 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”. If you just want to check only the headers of a set of tables then you have the option to choose “Column Labels”. Do you know that you can choose the rows and use it from the spreadsheet by choosing the “Row Labels” option. “Value” will allow you to use not just numeric value but also using max, average, sum of numbers or other data.
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. 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 make several calculations to make it easier for you just by using the parenthesis like this example, (9*8+6/4)-9. Another tip is you can both =Average (Cell Range) to average the set of numbers or use =Sum (Cell Range) to summarize column of numbers.
Other Shortcuts. When you want to just look at a particular set of data especially if you are looking for one in a pool of thousands of data, use “Filters”. 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.