Table of Contents
Excel Text Generating Format
Excel formulas
Excel shortcuts
Excel Data Creation
excel to xml
Excel Text Generating Format
text cell combine:
="preText"&A1&B1&C1&"endText"
Excel formulas
Date minus Date gets days (A1 as fixed date; A2 as date to compare)
=DATEDIF(A2,$A$1,"d")
today's date
=TODAY()
Excel shortcuts
Data insert
ctrl+;
insert date
ctrl+shift+;
insert time
Excel Data Creation
excel to xml