You are here:

Excel/Expert Profile

Craig

U.S.

Available

Expertise

I can answer most general questions, including formatting, shortcuts, pivot tables etc. I have just started using macros, so vba is not my strong suit. I also enjoy explaining the solution at the questioners level of understanding. I am an accountant by trade, so that is my primary area of expertise, but I am willing to tackle just about anything.

Experience in the area

I've been working in excel for 15+ years

Education/Credentials

BA - Business '96, CPA '98

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
Dennis Smith	02/01/12	10	10	10
A.	01/23/12	1	1	1	Expert asked for money for what other .....
Gabor Nyitrai	12/05/11	10	10	10	Very helpful reply. Many thanks
Susie	11/17/11	10	10	10	Thanks Craig, I'll try that tomorrow with .....
Randy	11/15/11	10	10	10	Thank you so much! I was on .....

Recent Answers from Craig

2012-01-25 formual needed:

Hi Dennis, I hope this is not too simplified, but I think this should work: in C1, type =IF(A1=B1,"Y","N") If a1 is equal to b1, then leave a Y, if not then leave an N. You can then drag this

2011-12-13 alerts:

Hi Samantha, If you have Excel 2007 or 2010, this will be really easy. Highlight the pallet ID column in Sheet2 and then go to the Home tab and choose "Conditional Formatting", then Highlight Cell

2011-12-10 Rule:

Hi Sara, This should be a matter of changing your absolute references. Typically with conditional formatting, excel tries to guess what you are doing. I assume that your conditional format shows something

2011-12-07 Excel Chart Question:

Hi Mike, I've done something similar, but this is one of the better documented explanations of how to do what it looks like you are trying to do. Try one of these links: http://peltiertech.com/WordPress/clustered-stacked-column-bar-charts/

2011-11-23 Question on excel calculation with different prices for different quantities:

Hi Gabor, You could put all this into one formula, but I think it is easier to explain by having a column that determines your price and then another column that multiplies the price x quantity, so

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: