You are here:

Excel/Expert Profile

Richard Rost

U.S.

Available

Expertise

I am happy to answer any questions about Microsoft Excel. If you have an Excel problem, let me help you with it. Also, please be sure to check the Microsoft Excel Tips & Tricks and Microsoft Excel Tutorials sections of my web site.

Experience in the area

I have been using Microsoft Excel since the very early Windows 3.1 versions. I have been teaching Microsoft Excel in the classroom since 1994, and online through computer tutorials since 2002.

Organizations

I have been volunteering on AllExperts in the categories of Microsoft Access, Visual Basic, and Weight Loss for years.

Publications

I have created a line of computer tutorials online at www.ExcelLearningZone.com and www.599CD.com/Excel.

Education/Credentials

Personally, I am self taught. I've learned everything I know from books and trial & error. If I don't know the answer, I know how to find it.

Past/Present Clients

I have over 20,000 happy clients worldwide.

Average Ratings

Recent Reviews from Users

User	Date	K	C	T	P	Comments
Marylin	11/18/09	10	10	10	10	Thanks for your help. I will have .....
Monica	11/16/09	10	10	10	10	Thanks!
HASSAN	11/16/09	10	10	7	10	Thanks so much. You are a star .....
Alan	11/15/09	10	10	8	10	"Concatenation", the magic word. I had conly .....
Richard	11/03/09	10	10	10	10	Thank you very much for your answer .....

Recent Answers from Richard Rost

2009-11-17 Conditional Formatting:

You need pretty tricky VBA code in order to sort by color in Excel 2003. I don't have such code handy. My advice: upgrade to Excel 2007. Here's a tutorial I recorded that goes the OTHER way: helps you

2009-11-16 fx function >:

Yes, you did phrase it very simply the first time. Garbage in = garbage out, right? :) You can probably do what you need to do with an IF function or two, and possibly and AND or OR in there if you

2009-11-12 If function:

Use the AND or OR functions. =IF(OR(A2=5,A2=8),X,Y) Easy enough? Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT

2009-11-12 USING "IF":

Try using the AND or OR functions, like: =IF(AND(A1>A2,B1>B2),"Yes","No") Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute

2009-11-12 fx function >:

=12-A1 Easy enough? Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT EXCEL VIDEO TUTORIAL. Go to http://www.599cd

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: