Excel/Expert Profile


Ask A Question

Expertise

I will try to answer any question that I can replicate in my current environment (I use Excel 2003 with Windows XP). This may include formula related questions on other Excel versions. Due to time limitations, I am not writing custom code to answer questions any more. Sorry for the inconvenience.

Experience in the area

I have worked with Excel for the past 12 years, in various environments.

Organizations
NYPC (New York PC users group)

Organizations

NYPC (New York PC users group)

Education/Credentials

MCSE in Windows NT

What do you like about this subject?

Excel is an incredible tool for many things. I specially enjoy its flexibility as a Business Intelligence tool, much better that many of the commercial applications on this field

What do you still hope to achieve/learn in this field?

A little bit of everything, I love knowing that there are so much still to learn

Something interesting about this subject that others may not know:

Excel is fun!

Something controversial or provocative about this subject

Excel is fun!

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
Infant10/23/0910101010 
Sean10/21/0910101010Thank you so much!
Frank10/20/0910101010I would have given a rating of .....
sreenivas10/16/0910101010thanks, i got idea after your answer
Gavin10/14/0910101010Thanks a ton,

Recent Answers from Miguel Zapico

2009-11-06 Excel:

What do you need to do exactly? Link one cell at a time, or sum all of them? The procedure you describe would work for the first case, while for the second you could do something like: =SUM(Sheet1:Sheet5!A1)

2009-11-06 Cell color changes automatically:

The sheet may have conditional formatting on that cell. Select the cell and check it on the menu Format->Conditional formatting. If there are any conditions there, remove them. If that doesn't work

2009-11-04 Sorting an Excel Address List:

You are right, that shouldn't happen. The only explanation that I can think on is that some of the zip codes may have a quote before them, to signal them as literal text, and some other not. They will

2009-11-03 Excel:

You can use the menu Data->Text to columns. This will start a wizard, where you will be able to split the data in one column to several columns based on various criteria that you can define. The result

2009-10-29 Count IF (i think):

In Excel 2003, you can use the SUMPRODUCT formula for this, something like: =SUMPRODUCT(--(A2:A200="Customer Name"),--(G2:G200="closed")) You can add more conditions following the same schema. The formula

 

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.