Office Tips

How to use OneNote to make notes with Office Word

Office 2010 Word One Note Link

While reviewing or reading a Microsoft Office Word File, we often have doubts or some extra notes to add which is helpful for our reference. If you are totally into digital note taking mood, One Note and Word Integration in Office 2010 just got better for you, Linked Notes. Using Linked Notes you can add your points into OneNote and keep ...

Read More »

How to Remove background from images using Office 2010

Remove Background Images

Office 2010 has this new Background Removal tool which helps you in getting rid of background by using new capabilities and algorithms from the Microsoft Research.  It allows you to select parts of images which can be cropped or just select what to include and you are done. Steps to remove background image : Select any image and click on Picture ...

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 »

How to directly add contacts from Office Outlook to Windows Live Messenger

Add to WLM from Outlook

Once you are signed into Windows Live Messenger, Office Outlook 2010 becomes presence aware which means anybody online in your Windows Live Messenger will have a green icon displayed when seen in outlook. Here is how it looks like : Now with Windows Live Messenger Beta it has become possible to add contacts directly from Outlook to Live Messenger. Hover over the ...

Read More »

Auto Change Font Colour when replying / forward in Outlook

Reply forward colour in Outlook

When replying to somebody on email it is always a good idea that you change the font colour or even type so that the person who receives email can distinguish between his and your comment. In Outlook this can be achieved by going to Signature > Personal Stationery > Font You will need to select the check box which says Pick  a new ...

Read More »

How to search within Audio and Video in OneNote

Audio Video Search in OneNote

Office OneNote allows you to embed audio and video inside the document which is good if you are recoding some meeting or when you want to leave a note to the people with whom you share this.  What is interesting is that OneNote also allows you to make a search withing the audio and video which makes it lot easier for users ...

Read More »

Insert Maths formula in OneNote using Ink to Math

OneNote Maths

If you are a maths student and use a Digital Pen to write down everything on OneNote, Ink To Math is a great feature in OneNote which allows you to write down the mats formula by hand and then insert it into OneNote. This is useful for complex forumals and is defibetly faster. However you should practice it so that ...

Read More »

How to Backup and Version Online OneNote Files Across Network

OneNote Dropbox

Online Office does not have any feature of backing up your data or have version support but using the Desktop Office and few features inbuilt you can make do both backup and version your files on your computer. Facts : It is possible to edit the online document in your desktop  and sync with Online Document. Office OneNote App has an ...

Read More »

How to remove syncing between Online and Desktop OneNote

OneNote Web App Sync Break

Office OneNote is now on the web which you can see as soon as you login to your Skydrive account. Getting it online has one big advantage that you can sync it online as you edit it on your desktop but what if you want to stop syncing or completely break the relationship with the online file ? There are two ways ...

Read More »

Change advance Outlook settings and data folders tool with Outlook Tool

Outlook Tools General

Outlook tool is an advanced tool which allows you to change lot of settings in Outlook and associated data folders settings which generally are not availble directly to the users. Though you can change the settings from registry but this tool does that for you. Before going ahead I would recommend this tool for Advanced users who understand the effect ...

Read More »