Category Archives for "Excel Tips"

1 How to Insert a Picture in Excel Comment

Watch Video – Insert Picture in Excel Comment In some cases, you may want to insert a picture in Excel comment boxes. For example, if you have a list of products, then inserting product images in the comment box could make your Excel sheet easy to use. As soon as the user would hover the mouse over […]

Continue reading >>

4 Dynamic Search In Excel Using Conditional Formatting

Video – Dynamic Search in Excel Using Conditional Formatting A couple of days ago I wrote about searching and highlighting data in Excel using Conditional Formatting. While it’s an amazing use of conditional formatting in Excel, I thought it would be even better if it could somehow be made dynamic to search in Excel. Something as shown below […]

Continue reading >>

10 Search and Highlight Data Using Conditional Formatting

Video – Search and Highlight Data Using Conditional Formatting Conditional Formatting could be a great way to create a search mechanism where it highlights cells or range of cells that contain the keyword/string that is being searched. For example, suppose we have a data set as shown below (in the image). It has different Product […]

Continue reading >>

Excel Text to Speech – Learn All About It!

Excel Text to Speech feature was introduced in the 2003 version and has been retained in Excel 2013. While I believe the utility of this feature is high in Word, PowerPoint, and Outlook, it may sometimes be the tool you need in Excel as well. As the name suggests, it converts text into speech and […]

Continue reading >>

What is Excel Camera Tool and How to Use It?

For all those who think working with Excel is boring, here is your answer to them – Excel Camera Tool. Now, don’t get all excited. It’s is not about a fancy DSLR and lens. It’s just another feature with a cool name. To begin with, Excel Camera Tool is not even available by default in […]

Continue reading >>