Sunday, January 13, 2008

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 

Friday, January 4, 2008

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);