Excel/Expert Profile

Philip Buckley

U.S.
Maxed Out
Expertise

In Excel 2003 I can handle all basic questions such as how to copy and paste, all medium type questions such as pivot tables, and also am proficient in basic macros. I am also quickly learning 2007 where everything is pretty much the same but all in different places. Please be as detailed in writing your question as possible as that goes a long way in my ability to give the best answer possible.

Experience in the area

I have 20 years of business experience, mostly in the area of finance and business consulting. Currently I am a Senior Business Consultant with a small business consulting firm. As part of my daily activities, I regularly use Excel to help make small businesses more efficient.

Education/Credentials

MBA from the Crummer Graduate School of Business at Rollins College.

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
Ben10/13/09101010At first I was limited in the .....
Bobby09/16/091010To the point answer. Excellent
Wynneth09/07/0910101010Philip, Thank you so much for your .....
Issa07/06/0910101010 
Chris06/26/0910101010Thank you very much.

Recent Answers from Philip Buckley

2009-10-08 extraxt specified data from a sheet:

Nima, Take the following steps: 1. Add a column labeled "Counter" next to the two other columns you have already 2. Give each row of data a unique number in this new column starting with "1" and

2009-10-04 Excel:

1. For the column with the dates, make sure the column has a header labeled "Date" in cell "A1" with the data starting in cell "A2" 2. Label the next column over "Month" in cell "B1" 3. In cell "B2"

2009-09-25 If Then Statement in excel 2003 with more than 7 functions:

Ben, Assume that you want to put your solution in cell "A1". You can break up your if statement among several cells as follows: Cell Formula "A1" =IF(I5=1,0,IF(I5=2,0.05,IF(I5=3,0.1,IF(I5=4

2009-09-16 Formula:

Joseph, The best way to handle such data is using a PivotTable. To use this do the following: 1. Click somewhere on your raw data 2. Select "Data" 3. Select "PivotTable and PivotChart Report

2009-09-06 Excel 2007 version - backup workbook:

Wynneth, How to make a backup file. 1. Open the file you want to have a backup of. 2. Select "File" 3. Select "Save As" This will bring up the "Save As" popup menu. 4. In the upper right

 

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.