Do you know that you can do a lot of things than just entering a formula in 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. Your boss will be one of your fans if you learn them all.
Pivot Tables. The Excel can easily summarize all the information in your spreadsheet and all its values without changing the data by reorganizing it 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. 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. 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. 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. 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 make several calculations to make it easier for you just by using the parenthesis like this example, (9*8+6/4)-9. 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. 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 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.