You are here:

Excel/Expert Profile

Miguel Zapico

U.S.

Available

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

User	Date	K	C	T	P	Comments
Infant	10/23/09	10	10	10	10
Sean	10/21/09	10	10	10	10	Thank you so much!
Frank	10/20/09	10	10	10	10	I would have given a rating of .....
sreenivas	10/16/09	10	10	10	10	thanks, i got idea after your answer
Gavin	10/14/09	10	10	10	10	Thanks 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

Encyclopedia

Browse Answers: