MS Excel Series: Anova

This article provides good ANOVA example performed using MS Excel.

One can extend the use of ANOVA with additional plug in (XL Toolbox) that capable of further analysis of ANOVA result with post hoc tests.

MS Excel Series: t-test

This article is an excellent guide of how to perform t-test using excel.

Another example here and here

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]

MS Excel Series: Secondary Axis

Good Job Microsoft for the explanation given here.