98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Advanced
Excel Advanced
Resolved · High Priority · Version 2003
Thu 19 Mar 2009, 19:02Delegate Stefania said...
Stefania has attended:
Excel Introduction course
Outlook Advanced course
Outlook Introduction course
Excel Intermediate course
Excel Advanced course
Word Introduction course
Word Intermediate course
Word Advanced course
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Dreamweaver Introduction (2 days) course
Excel Advanced
Hi,
I am working with creating data table on page 16 of the Excel 2003 Advanced documentation.
I can`t seem to get the example to work and I don`t know what I am doing wrong.
Can anyone please help me?
Thank you
Best regards
Stefania
Fri 27 Mar 2009, 16:47Trainer Amanda said...
RE: Excel Advanced
Hello Stefenia
Thank you for your question and apologies for the delay in response.
I am assuming that you are referring to the practice activity that uses the file called Lookup practice, on the 1v data table sheet.
First you will need to select cell G6 to put your formula into.
Then enter the formula:
=PMT(10%/12,C6,B6)
Then select from F6 down to G21.
Go to Data - Table.
click next to Column input cell and select cell C6.
Click OK.
The table should fill with all the results.
I hope this helps.
Kind regards
Amanda
Sat 28 Mar 2009, 12:28Delegate Stefania said...
RE: Excel Advanced
Hi Amanda,
Unfortunately this is not the item I am talking about.
In the documentation "MS Excel 2003 Advanced, Reference Manual" that we are able to take away with us from the course, on page 16 and 17 there begins the section about Creating Data Tables.
Anyway, I tried to recreate the examples that are there and they are not working, so I am confused and want to know where I am going wrong, I follow the examples to the letter but then nothing happens or works like it says it is supposed to.
Can you help me with this please?
Thank you.
Stefania
Wed 1 Apr 2009, 15:44Trainer Amanda said...
RE: Excel Advanced
Hello Stefania
I found the example you are referring to, and the book doesn't explain how to set it up correctly.
I've attached a file for you with the example, and a few instructions - hopefully it will work for you.
Kind regards
Amanda
Attached files...
data tables.xls
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding date and timeHere are two quick ways to add the date and time to your spreadsheet: |
