You are here:

Excel/Expert Profile

Ask A Question

Edward H. Mori

U.S.

Available

Expertise

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

User	Date	K	C	P	Comments
Lauren	02/08/12	10	10	10	Amazing. Thank you so much. Worked like .....
John	09/02/11	10	10	10	Ed, Thanks for the thoughtful consideration and .....
Imad	01/13/11	1	10	10
Al	01/13/11	2	2	1
Heidi	11/05/10	10	10	10

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

Encyclopedia

Browse Answers: