Excel for Database

•  Ctrl + T        for     create table and filter

Excel Tips and Trick

 

Fast input date     

= Today( ) or Ctrl + ;  (Ctrl + Semicolon symbol)

Combine Text-Text or Text-Number

Sometimes we need to combine text with text or text with number from other cells, but we usually using excel for calculating money or number, and in below as your solution.

- Firstly, use equal = , then click the cell and use & not + 

But, the result look perfect, we need space using double comma " " with space, as picture in below