Excel/Expert Profile

Edward H. Mori

U.S.
On Vacation
returns 12/31/2009
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

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
Jessica06/02/0910101010You rock! Next time I'll remember to .....
Tom05/11/0910101010It's all in the same field there .....
Michael04/29/0910 
tony10/22/0810101010thanks I will try this.. I do .....
Brian08/22/0810101010 

Recent Answers from Edward H. Mori

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-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

2008-03-14 Multiple Selections from Pull down Menus:

Glad that worked. I have done that for some forms I use here. If it says Unfreeze panes Freeze is already on. Click Unfreeze. Place your cursor where you want to freeze the column & row then go back

2008-03-14 Multiple Selections from Pull down Menus:

OK Example You drop down is in A1. You select value A. In B1 the VLOOKUP would return the value you want for the value of A in A1. If you select B for A1, B1 will change to return the value you want

 

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.