2006-08-23 21:40:11 · 5 answers · asked by B M 1 in Computers & Internet ➔ Programming & Design
I dont know if u r new in excel. But if u are so, VB is not good for you. Then you will use formulas to make simple but useful spreadsheets. First of all you must understand the cell-based format of excel. Each cell has a name that is derived from the name of column and line (A4 means the cell is in A column and 4th line). Then u should learn the basic formulas. for example this formula returns you the sum of two cells : =sum(a2;a3). whenever you change the A2 and A3 cells the cell in which this formula is written will change to give you the ultimate total. There are lots and lots of formula in excel. You should see them and use them gradually. the "fx" button on the left of the address bar of excel is the gate to formulas. But dont forget every formula must begin with " = ". Without this =, excel cannot see it as a formula. Good luck
2006-08-23 21:57:56 · answer #1 · answered by satiyagraha 4 · 0⤊ 0⤋
The Best place to start learning to automate things using Excel is use the excel help and loook for different functions and formulas .. it can do amazing little things very fast .. You can try Sum, Average, Macros, If condition usage, etc ... To acess help , press F1 while excel application is open.
2006-08-23 21:48:43 · answer #2 · answered by Ravi 3 · 0⤊ 0⤋
In Excel, press Alt + F11
this is Visual Basic editor (VBA), you should know some Visual Basic to work here
mail me any more info
XLMan
2006-08-25 22:21:06 · answer #3 · answered by Anonymous · 0⤊ 0⤋
Give me your email id..i can send you a sample excel sheet with macros......that will explain how we can program in excel
2006-08-23 21:48:57 · answer #4 · answered by Best Answer Expert 3 · 0⤊ 0⤋
You can write macros using VB. You will get enough help in MS-Office help.
2006-08-23 21:46:36 · answer #5 · answered by HEMANT S 1 · 0⤊ 0⤋