Microsoft Excel 2010 tips for advanced users
To most people Microsoft Excel 2010 is like an alien. They don’t understand anything about it. And for people who have used this application before, this is a great productivity application. Possibly one of the best productivity applications ever made. Master this application and you can achieve a lot. But in order to master this application, you need to know every aspect of it. Here are a few Microsoft Excel 2010 tips for the advanced users. These tips are for those users who are looking master this application.
Some of the users face this trouble of transposing a table. Most of the beginners would manually update the table manually, maybe. But there’s an easy option to transpose a whole table. And it’s a simple process that can be completed in two clicks. That’s it, just two mouse clicks and your table is copy pasted wherever you want it to be, transposed. You can find the ‘Transpose’ option in ‘Paste Special’. You can find that option on the ‘Home’ tab where the first option is ‘Paste’. If you click that, there would be a dropdown menu which has the option ‘Paste Special’. Once you select that option, a small window would be displayed to you, where you would have to check the option ‘Transpose’ to transpose the table.
We have spoken about Sparklines before. This is a great feature that allows you to say so much some with the data. You can call these Sparklines as mini charts. These Sparklines fit inside a single cell unlike graphs which take space. Sparklines can be used to display the trend of the values for data. When you have values in multiple columns, let say sales figures for a product, you can display the trend for the sales of that particular product in one single cell. So let’s see how you can use this feature. In the ’Insert’ tab, you’d find option to insert Sparklines to your data. There are three kinds of Sparklines that are available to you, namely Lines, Column, and Win/Loss.
When you have data in multiple sheets and you need to work on the data present in more than one sheets, you can group the sheets and get the work done quickly. You can apply formatting to data present on different sheets by grouping them together. Let us see how this can be done. Right click on any sheet and a drop down menu would be displayed on the screen which will have the option ‘Select all Sheets’. If you want to select only two or three or a fixed number of sheets instead of selecting all the sheets, press ‘Ctrl’ and select the required sheets to group them. After selecting the sheets, you can make the formatting changes on the open sheet and that formatting would be applied to all the selected sheets. As simple as that!
So these are a few tips for the advanced users of Microsoft Excel 2010. Go ahead and familiarize yourself with these features and tips to become much more advanced user.