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

2012-02-08 Excel Help:

Chan    I am not sure what you mean by your first question.    Second question--If you make your list include more rows than what is needed your list, and leave the cells blank that you are not using then

2012-02-05 military time spread sheet:

Laura    Time is always tricky to work with because of the hours days, etc are not easy for us to convert mentally to what is needed for excel to do the calculation correctly.  It becomes easier if you

2012-02-04 Excel Problem:

Pravin    In your first question I am not sure if you want the numbers to be horizontal or verticle within the cell or horizontal from left to right within the same row, but in different cells, or--- verticle

2012-01-31 Excel timesheet question:

Joseph    You are correct, excel will recognize the  10:30-3:30 as text and won't calculate it as a number.  There are a couple of possibilities,  What I would do is create a time in and a time out column

2012-01-27 creating a formula?:

Zhesketh    Check the data in cells B1 and B10 and in your formula cell.    Excel is probably reading one of these as text and therefore can't do a calculation so it is giving you the VALUE error.  Also

 

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

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


©2012 About.com, a part of The New York Times Company. All rights reserved.