4 Excel Tricks to Make Life Easier
Excel is an amazing tool that can do so much, from keeping basic lists to more complex data analysis and visualizations. In this article today you are going to learn 4 Excel tips that will make your life easier and you more efficient in Excel.
In this article we are going to look at
- Simple Steps to Transpose Data
- Lightning Speed Navigation with GOTO Special
- Easy Data Entry with Forms in Excel
- Analyse data with Quick Analysis
Trick 1: Simple Steps to Transpose Data in Excel
Sometimes it is necessary in Excel to change the data from the rows to the columns or from the columns to the rows. With large amounts of data, re-entering these values would be both time consuming and also prone to clerical error.Paste Special is a unique feature that allows you to perform operations that may be tedious to perform any other way. One of the functions available is Transpose
A worksheet has been set up with the month names listed down the rows. However this was done in error and we need the months going across the columns. How can we do this efficiently?
The first step is to copy the data that we wish to transpose. We can do this by selecting all of the cells and then pressing Ctrl+C or by right clicking and selecting copy. By doing this the data is now copied to Excels clip board.
Once the data is copied to the clip board in Excel, we can now select where we want to paste
Posted from my blog with SteemPress : http://theexcelclub.com/4-excel-tricks-to-make-life-easier/
Thank you for providing these tips. I do foresee making use of them.
I am familiar with tip #1 - transposing data amd I use it most often. I access this throigh keyboard shortcuts so that I don't have manually use the mouse to click. I use Alt E, E if my memory serves me right.
Yhe other three tips, I still habe to use. The least I think I will be using is #2 - GOTO, but I'm not sure what the future holds and I may use this often. Lol.
I am most intrigued by #3 - forms. I haven't used this, but based on a project management file I use that has headers and data, I foresee this coming in handy.
For #4, I still have to see if I can use this in my version of excel, or if the need to use this on my existing data (like adding a running total) will be beneficial to my analysis.
Overall, very effective tips! Thank you!
thank you for your feedback @eastmael. I am glad you find these tips to be of value
Congratulations @theexcelclub! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :
You can view your badges on your Steem Board and compare to others on the Steem Ranking
If you no longer want to receive notifications, reply to this comment with the word
STOPDo not miss the last post from @steemitboard:
Vote for @Steemitboard as a witness to get one more award and increased upvotes!