Tag Archives: Excel Tools and Tips

What is Show or Hide Ink in Excel, Word, PowerPoint (Office 365)

What is Show or Hide Ink in Excel/Word/PowerPoint (Office 365)

If you have a computer with a touch display, you can make use of the Ink feature or Ink Annotation which is available in Excel, Word, PowerPoint or any product of Office 365 which supports the Ink feature. It allows anybody to use touch to mark mistakes, naturally suggest new features. In this post, we will show how you can ...

Read More »

Cleanest way to Export Google Contacts to Excel

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 an email address or at the max phone number of such contacts rest of ...

Read More »

Whats new in Conditional Formatting in Excel 2010

Solid Bars 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 had reducing gradient. It also has Axis support when you have ...

Read More »

What and How of Slicers in Excel 2010

How to create Slicer

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 with data, filters multiple pivot tables etc. To create a slicer ...

Read More »

What are Sparklines in Excel 2010

Sparklines Tool

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 you see under column “Total Post Completed” is how sparklines ...

Read More »

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 Charting Online. Apart from several tips and tricks, Pointy Haired Dilbert ...

Read More »

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 Excel pretty often. Print and Preview Documents using shortcut keys – ...

Read More »

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 the shortcuts is required. Here is another resource for searching keyboard ...

Read More »

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 do a save as to some other name and then edit ...

Read More »

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 unhide the Rows or Columns. Move around the Spreadsheet, using your ...

Read More »

Excel Shortcuts and Tips you should know

I am not very good at using MS Excel, recently when I was working on an Excel sheet, I learnt a couple of keyboard shortcuts with the help of a friend, I though sharing it with you all, I have tried to put together the ones which I thought are not very usual, hope you find them useful. General Shortcuts ...

Read More »

Chart Advisor : Suggests you which chart represents your data better

Creating charts is always tough when it comes which type need to be selected to give an exact idea out of the data you have. Micrsoft Office Labs has one project running, Chart Advisor,  which helps you to generate charts depending on your data. Its an auto analysis engine which sits in Microsoft office excel after installed. This app works ...

Read More »