Excel/Expert Profile

Richard Roberts

U.S.
Maxed Out
Expertise

Can assist you in most areas of Excel, have been working with it for about 15 years in many types of applications, but primarily in financial and accounting applications. I am a CPA and many client or client problems have necessitated the use of excel. I am not an expert in charting, macros, or pivot tables.

Experience in the area

Have been working with Excel for about 15 years primarily in accounting and financial areas.

Education/Credentials

BA, CPA

Average Ratings

Recent Answers from Richard Roberts

2009-11-23 Looping in Macro:

Khaled I am definatly not a expert in macros--but I do believe you can do what you want--I suggest you reask the question of another allexperts person and check the resumes for one with macro expertise

2009-11-22 Count/Countif:

Matthew It sounds as though you need the countif() formula, where the formula only counts the cells that are greater than zero--something like this =COUNTIF(A1:A100,">0") YOu may want to couple

2009-11-20 Linking cells or mirroring worksheets:

Arturo Place your cursor at the bottom of the worksheet where the sheet tabs are and right click--in the drop down box click "select all sheets" this makes all sheets active. When you add a column

2009-11-18 Multiple Y axis:

Shimjith I am pretty sure you can have more Y axis, but I do not know if you can have different scaling. However I am not an expert in charting so I suggest that you reask the question of another allexperts

2009-11-17 Excel:

Bhuvana I'm not totally sure of your criteria for putting in T or R, because the 5th row says Teaching and you have indicated that the result should be R for that row. I am going to assume that was

 

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.