Some tips on You Tube

Some tips on You Tube

 1) Press the space bar or the 'k' key on your keyboard to play and pause a video. 

2) Pressing the 0 (zero) key on your keyboard will jump to the beginning of a video. The home key also works for jumping to the start of a video. 

3) Pressing the end key on your keyboard will go to the end of the video. If you are playing a playlist, it goes to the next video in the playlist. 

4) Pressing the up or down arrow keys turns up and down the volume of the video. If you are turning down the volume and continue to hold the down arrow key, it will eventually mute the volume. 

5) Pressing 'm' on the keyboard also mutes and unmutes the volume.

 

Thanks

Sanjay Bakshi

mesanjaybakshi@gmail.com

Copy Pivot Table Data as Text

Most of the time we can come into a situation where we need to send a Pivot Table summary report but we do not want to include or send original data.

Here is the SOLUTION

Excel doesn't have a command to unlink a pivot table, but it does have a flexible Paste Special command. Using that command, with the Value option, should do the job:

1.        Select the pivot table cells and press Ctrl+C to copy the range.

2.        Display the Paste Special dialog box. Pressing Alt+ES

3.        In the Paste Special dialog box, choose the Values option, and click OK.

The pivot table is unlinked.

Keep Reading keep Learning

Sanjay Bakshi

mesanjaybakshi@gmail.com

Excel - Using Add Ins

Add-in programs are small modules that extend the power of Excel by giving us a access to a wide array of features and calculating functions.

• Click the Office button and then click the Excel Options button
• Click the Add-Ins tab.
• Select the options which you wanted to add
• Click Ok