Ben Chuanlong Du's Blog

It is never too late to learn.

Tips on Excel

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

About Statistics Functions

  1. Excel is not a reliable software for statistical analysis. It's not even capable for simple operations such as calculating mean and standard deviation when numbers are very big …

Convert Math Formula and Table To LaTeX

R

  1. xtable{xtable}

    • Good for converting table to LaTeX code.
  2. latex{Hmisc}

    • Convert R objects (not just tables) to LaTeX code.

Excel

MATLAB

Mathematica

  1. Type in the formula in Mathematica.

  2. Selected the formula.

  3. Right click on selection, and then select "Copy as" -> "LaTeX".

  4. You can also convert formulas to other …

Convert MS Office Document to Text

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

  1. xls2csv -f allow to parse also the lines with empty cell in first column xls2csv

  2. catdoc and xls2csv, catppt

  3. ssconvert file.csv file.xls (gnumeric)