Miguel Zapico - Excel - Business Software - Computing/Technology

About > AllExperts
	Search for

Main Menu

Login (Experts Only)

About Us · FAQ · Tell Friends About Us · Link To Us · Free Encyclopedia · Disclaimer · Tech Support

You are here: AllExperts > Computing/Technology > Business Software > Excel

Expert Profile: Miguel Zapico

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.

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

Organizations
NYPC (New York PC users group)

Education/Credentials
MCSE in Windows NT

	View Past Answers	View Detailed Ratings

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
Prestige Points: 21326
Knowledge	9.93 Best of the best
Clarity of Response	9.89 Best of the best
Timeliness	9.96 Best of the best
Politeness	10.0 Best of the best
Number Of Questions (in Past 24 Hours)		0
Max Questions to be Asked (in 24 Hour period)		7
Total Questions (since joining AllExperts)		2001

Recent Reviews from Users

Knowl	Clarity	Time	Politeness	Date
10	10	10	10	11/27/08
10	10	10	10	11/24/08
10	10	10	10	11/25/08
10	10	10	10	12/03/08
10	10	10	10	11/19/08

User Comments

Thank you very much! Lee
(Lee on 11/27/08)

Thanks Miguel! It worked out very well.
(Saurabh on 11/25/08)

Great service!
(tim on 12/03/08)

Thanks for quick responce, solved my problem in an instant...thanks
(Michael on 11/19/08)

View All Comments

	View Past Answers	View Detailed Ratings

Recent Answers from Miguel Zapico

2008-11-25 pin number in excel: One way would be to use a custom format for the cell (menu Format->Cells->Number tab->Custom) as: "*****" Quotes included. This will show 5 stars in place of the number, although the number is still...

2008-11-24 Microsoft Excel Help: I am assuming that the structure will not change, in the sense that the references are grouped together and the frequencies are continuous for each reference and starting at 1. With that, you may use...

2008-11-23 assigning number values to words: If it is a limited set of values, you could use an IF formula for this, something like: =IF(A1="agree",5,IF(A1="disagree",1,IF(A1="neutral",3,""))) If the value list starts to grow, you could craft...

2008-11-23 MS Excel help: You could use the VLOOKUP function for this. It search on the first column of a range of data, and returns an item from a column to the right of the found value. For example, if the daily data is on...

2008-11-21 Difficult problem: Are you sure that you are entering it as an array formula? The #VALUE! error will appear if the formula is entered as a standard one, but not if you enter it with Crtl+Shift+Enter. If you do that way...