You are here:
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.
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.
MBA from the Crummer Graduate School of Business at Rollins College.
| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| Bernard | 08/01/10 | 10 | 10 | 10 | I asked a question The Answer came ..... |
| ammar | 04/27/10 | 10 | 10 | 10 | hi this can never work. try it ..... |
| jose | 04/18/10 | 10 | 10 | 10 | wonderful. Many thanks |
| Ben | 10/13/09 | 10 | 8 | 10 | At first I was limited in the ..... |
| nima | 10/10/09 | 5 | 7 | 7 | thanks. your answer was good. |
Bernard, Excel has an excellent way of dealing with this. Take the following steps: 1. Make sure the data is all in one area with no empty columns between. 2. On the top row give each column a
Eric, Highlighting an area is the first step. You must then select that area as the print area. In Excel versions before 2007 You must do the following. 1. File 2. Print Area 3. Select Print
If the join date is in cell A1 and end date is in cell A2 then the formula is: =A2-A1 You must change the format in the cell with the formula to "General." To do this, click on this cell with the
Pivot tables are used to work with large bodies of data (count, sum, average). To start a pivot table: 1. Select "Data" from the main menu 2. Select "Pivot table and Pivot Chart Report..." from
Zachery, The solution is to merge the two workbooks together. 1. Open up both workbooks 2. Display both workbooks on the screen at the same time 3. Click on the workbook with the raw data 4. Click
Answers by Expert:

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