What did I learn today: How to select background music

I am creating some videos. I needed background music. There are lots of free as well as paid libraries out there. I wanted to hear how the music blends into my voice narration – before downloading / purchasing the music. Any audio editing tool can be used for mixing two audio files. In this case, … Continue reading What did I learn today: How to select background music

What did I learn today: Repeat Header Rows across columns

Read this article first: Frustration = Feature Guarantee! (Table Row breaking across pages). Here we saw how to ask Word to manage repeating the header automatically across pages. What I learnt today is that the Repeat Header Rows feature works across columns as well. This is very useful when we have a narrow table shown … Continue reading What did I learn today: Repeat Header Rows across columns

What did I learn today: Pivot Table Transpose

Consider a pivot table which has many fields in row as well as column area. Now, for whatever reason, you have to transpose the pivot table. Whatever is in the rows has to go into columns and vice versa. We cannot use Paste Special Transpose with Pivots. The only choice seems to be manually dragging … Continue reading What did I learn today: Pivot Table Transpose

What did I learn today: Remove all hyperlinks

Excel provides a direct feature. Select multiple sheets and select the desired range. Home – Clear – Clear Hyperlinks. The default blue color and underline is NOT removed. Therefore, you may feel that nothing has happened. You have to remove formatting separately. There is no way to select only those cells which contain hyperlinks. DO … Continue reading What did I learn today: Remove all hyperlinks

What did I learn today: Clear Outlook Categories (For Demo Warriors)

This article is relevant for people who conduct demos or training on Outlook. During demos we create custom color Outlook Categories. These categories remain customized for the next demo as well. Ideally I would want the categories to have default names (Red Category, Blue Category and so on). How to clean all of them quickly … Continue reading What did I learn today: Clear Outlook Categories (For Demo Warriors)

What did I learn today: High lamp mode in Sony projector

One precaution you must take while presenting is to check if the projector lamp is set to maximum brightness. Usually all projectors have two settings: Standard (or Normal) and Eco. The Eco mode shows dimmer image and saves energy. Make sure you set it to Standard mode for audience size of 10 or above. While … Continue reading What did I learn today: High lamp mode in Sony projector

What did I learn today: Reorder taskbar icons as per work at hand

Read the previous article to understand how to Pin commonly used programs to taskbar. But recently, I went beyond this. I thought – the order in which these icons are pinned should also matter. You can easily drag them around to rearrange – that part is easy. But why would I want them in a … Continue reading What did I learn today: Reorder taskbar icons as per work at hand