Formulas in MS Excel

------ Formulas

1. Click the cell you want the product of the multiplication formula to go in.

2. Type: =(cellname1*cellname2). Substitute "cellname1" and "cellname2" with the names of the cells you would like to multiply.

Also, to mask some of the columns: "Accueuil/Cellules/Format"

------- SUM a column

  . Type =SUM(  in the cell and then select the cells in the column, press enter

------ open a csv with specific separators in Excel

To open these “|” separated files:
Open Excel / Données/ A partir du texte / importer / Suivant / Séparateurs :autres : « | »

------- to change source cells in a pie graph

   select the cells in the column, drag and drop the cell group on the pie chart 

-------- copy a cell on different lines selected in a column:

    . select the cells, enter the string in the top cell, type "ctrl" + enter

Disable C$, D$ drives sharing

For NT 4.0/W2K/Windows Server 2003s, the change is: (if the key does not exists, create it)

Hive: HKEY_LOCAL_MACHINE
Key: SYSTEM\CurrentControlSet\Services\LanManServer\Parameters
Name: AutoShareServer
Data Type: REG_DWORD
Value: 0

Do a wait with the Windows API

HANDLE handle = CreateEvent(NULL, TRUE, FALSE, NULL);
WaitForSingleObject(handle,4000);