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