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

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
Deepika09/04/0910101010Problem is solved :) Thank you very .....
zulfiqar02/03/0910thanks Amal, and I hope soon we .....
harish10/05/08it was good, but i have still .....
sekhar06/03/0710101010thanks mr amal
vincent03/02/0710101010 

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

All Answers

Answers by Expert:


Ask Experts

Volunteer


©2009 About.com, a part of The New York Times Company. All rights reserved.