Excel Tools and Tips Archive
Cleanest way to Export Google Contacts to Excel
Gmail / Google Contacts come with an inbuilt option to export contacts and groups but the problem is that it adds a lot of fields or labels like Address 1, Address 2, Organization 1 and so on for all of them. Now if you only need email address or
Whats new in Conditional Formatting in Excel 2010
Conditional formatting ( CF) is one tool in Excel which helps you in mastering analyzing the data. CF was introduced in Office 2007 which has improved in Office 2010. The Bars can be solid now. Office 2007 bars had gradient effect which was confusing because of the visual appearance. e.g. A bar for 5
What and How of Slicers in Excel 2010
In simple words they are much simpler and understandable version of Filters in Excel. The major disadvantage of the filters or even the Pivot controls was not so user-friendly interface when you go for data mining. Slicers are just opposite, they let you see what you are doing, helps you easily interact
What are Sparklines in Excel 2010
In very simple words they are small graphs or charts embedded withing a cell of an excel column but still gives you an overall idea of the data you are looking at. Yes exactly your Manager might just start hating to look at those big excel charts on your slides!!.
What is Show Ink in Excel
In Microsoft Excel under Reviews > Comments there is button which says “Show Ink”. This basically is used to display hand written notes on excel file using stylus or any other device created on Tablet PC. So when a user reviewing an excel document want to add a hand written comments he can
Free download various Excel Templates
We have posted about budgeting templates in Microsoft Excel, here is another resource which has several Excel templates and are available for free download. I recently came across this awesome blog, Pointy Haired Dilbert, which could be your one stop solution if you are interested in Learning Excel and
Basic MS Excel Shortcuts every user should know
We have been posting about Microsoft Office Excel tips, we also posted about several Excel Shortcuts, and some of these shortcuts were quite uncommon as well. Here is another list of Shortcuts; most of them are basic shortcuts which could be quite helpful to you, if you work with
Shortcut world: Find keyboard shortcuts for common applications
We have discussed about keyboard shortcuts in several posts, and the list consists of some Uncommon Windows Keyboard shortcuts, and a Search Engine for searching keyboard shortcuts. The above said keyboard search engine, KeyXL allows you to search keyboard shortcuts by entering the name of the application for which
How to open Office Documents as new copy
Many a times you need to make changes in a Microsoft office document but you dont want to touch the original copy. The most popular approaches which I have seen are : Create a copy of it by using Windows Copy and then edit it. Open the document and
Nine uncommon Excel Tips
We have talked about Excel shortcuts here are some more tips which will help you to be more productive with Excel. How to Hide/Unhide a particular Row or Column Select the rows or columns to be hidden; now under the ‘Format’, you can get the option to hide or