Making the Microsoft Excel Work for You - How to Use It Quickly and Effectively with Following Tips and Tricks
There are many things that you can do and not just encoding the necessary information in the Microsoft Excel. You can use it to calculate your savings, earnings, do math, and save your time by learning the tips and tricks available. If you want to know more a lot of these, you can always 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. 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. 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. You can easily do this by clicking the Data tab then hit the "Pivot Table" option. There are 4 options that will appear for you after you hit the "Pivot Table" option. You can either "report filter" which makes you only check particular rows in the spreadsheet. "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. "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. 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. 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. 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.
4 Lessons Learned: Programs
The Art of Mastering Guides
What I Can Teach You About Computers
Posted in: Financial