You are here:

Excel/Expert Profile

Amal

India

On Vacation
returns 12/02/2009

Expertise

Can answer basic worksheet related questions like formulae usage, connecting to RDBMS from server to extract rows from tables, basic macro construction, pivot table creation, dynamic updation of worksheet data from Server RDBMS..

Experience in the area

3 years

Average Ratings

Recent Reviews from Users

User	Date	K	C	T	P	Comments
Deepika	09/04/09	10	10	10	10	Problem is solved :) Thank you very .....
zulfiqar	02/03/09	7	9	10	8	thanks Amal, and I hope soon we .....
harish	10/05/08	7	6	6	8	it was good, but i have still .....
sekhar	06/03/07	10	10	10	10	thanks mr amal
vincent	03/02/07	10	10	10	10

Recent Answers from Amal

2009-09-03 Subtraction:

Hi Deepika, There should be absolutely no problems with a formula like =5-3. 1. Ensure that you did not type a space before the "=" sign 2. Ensure that the cell, where you are entering the formula

2009-02-03 excel:

Hi Zulfiqar, It is not possible to convert the date completely into words. However you can convert a date into the following format day-number,month-name, year-number For example you can format

2008-12-03 How do I learn practical VBA?:

Hi Maryam, Books are the best bet to learn VBA (or any topic for that matter). If you do not have the patience to learn page by page, suppose you are employed, you could try to think of automating small

2008-10-03 excel -vba- text file:

Hi Harish, For people that are familiar with Excel, this would not be a problem. Once you open the file in Excel, use File -> Save as and save this file as an .xls file. Regards, A Amal Raj

2008-08-04 Extract text from a cell:

Hi, The formula to get the date would be , =IF(B4="WorkInProgress",DATEVALUE(MID(D4,4,2)&"/"&MID(D4,1,2)&"/"&MID(D4,7,2)),"") The formula to get the time would be =IF(B4="WorkInProgress",TIMEVALUE(MID(E4

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Encyclopedia

Browse Answers: