MS PPT Series: Presenter View Without Extra Monitor

Valid for Win7 only

• Press Win + P
• Select "Extend"
• Done!!! Enjoy your presenter view!!!

MS PPT Series: Export PPT background as a PPT background image

The easiest way is that you open a slide in PowerPoint and remove all the text or image content, so just leave the background in the slide. 

Then, go to Save As and choose JPG or PNG (or any other image format). Then, specify an output directory and save. 

You’ll be asked to choose to save a single slide or the entire document. Just choose Single Slide and then confirm.

Then use the output as a background image of your PPT slides. The steps are listed as follows:

1. On the Design tab, in the Background group, click Background Styles, and then click Format Background.
2. Click Fill, and then click Picture or texture fill.
3. click File, and then locate and double-click the picture that you want to insert.

Done!!

via [fppt.com, msofficesupport]

Qiqqa Series: Small tweak in bibliography line break

Fine tune the look in the bibliography section will waste some of your precious time due to line break.. Here is a solution that worked for me...

A better solution that may work for some styles is to find the tag in your CSL file and add the two terms: 

entry-spacing="0" line-spacing="0" 

via [source]

MS Excel Series: Subscript & Superscript

If can only copy-paste following characters (including letters) in superscript and subscript. Do it in your Excel file. Remember to use Unicode fonts (you can use mentioned fonts above / this text was copied from Wikipedia and StackOverflow and edited):

Consolidated for cut-and-pasting purposes, the Unicode standard defines complete sub- and super-scripts for:

• numbers and common mathematical symbols 
• ( ⁰ ¹ ² ³ ⁴ ⁵ ⁶ ⁷ ⁸ ⁹ ⁺ ⁻ ⁼ ⁽ ⁾ ₀ ₁ ₂ ₃ ₄ ₅ ₆ ₇ ₈ ₉ ₊ ₋ ₌ ₍ ₎ )
• a full superscript Latin lowercase alphabet except q 
• ( ᵃ ᵇ ᶜ ᵈ ᵉ ᶠ ᵍ ʰ ⁱ ʲ ᵏ ˡ ᵐ ⁿ ᵒ ᵖ ʳ ˢ ᵗ ᵘ ᵛ ʷ ˣ ʸ ᶻ )
• a limited uppercase Latin alphabet 
• ( ᴬ ᴮ ᴰ ᴱ ᴳ ᴴ ᴵ ᴶ ᴷ ᴸ ᴹ ᴺ ᴼ ᴾ ᴿ ᵀ ᵁ ⱽ ᵂ ) - no C, F, Q, S, X, Y, Z
• and some Greek letters 
• ( ᵅ ᵝ ᵞ ᵟ ᵋ ᶿ ᶥ ᶲ ᵠ ᵡ ᵦ ᵧ ᵨ ᵩ ᵪ ).

Note that since these glyphs come from different ranges, they may not be of the same size and position, depending on the typeface.

via [source]