Excel/Expert Profile

Ask A Question


Expert with pivot tables, very good with many functions, excellent in report formatting. I don't do charts.

Experience in the area

Heavy Excel user & SAS programmer since 1994. I don't do VBA code, but would like to learn.

What do you like about this subject?

Very user friendly software & simple to use.

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
AAMIR02/28/17101010tried it the first row now becomes .....
Debbie 10/02/14101010Thanks for getting back with me so .....
Karen03/20/12101010I tried to get answers from several .....
Karen03/13/12101010It's on my original thread: 6 column .....

Recent Answers from Edward H. Mori

2012-01-26 Pivot table Recalculate:

By changes if you mean you have the same number of columns, all you will need to do is refresh the table after you repopulate your data sheet.  If your number columns change, you will need to reset the

2009-05-12 How to get data from web in Excel:

It sounds like the log in screen is a form of security for the web page.  There might be a VBA script you could use to entert the login on the web site, but I am not that well versed on VBA.  Contact Aidan

2008-03-19 Pivot Table Dates:

Here's the table I got    Count of SSN Date  Name 5/15/2005 5/31/2005 6/15/2005 12/31/2005 1/15/2006 1/31/2006 2/15/2006 Grand Total  John 1 1 1 1 4  Tim 1 1 1 3  Grand Total 1 1 1 1 1 1

2008-03-19 Pivot Table Dates:

Did you format the pivot table?

2008-03-17 excel questions:

1. That would be a format.  In the Format pull down menu select Format Cell.  There are a variety of time formats you can chose.    2. To separate data in a cell you Text to Columns located in the Data


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


©2017 About.com. All rights reserved.