Pivot tables

Resolved · Medium Priority · Version 2003

Pivot tables

Candice has attended:
Excel Advanced course

by - delegate Candice [1 post] (2008 Jun 11 Wed, 15:56) Reply

when creating pivot tables can you use data from external program-not included in Microsoft, but running of an SQL Server?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Pivot tables

by - trainer Mark gold contributer [244 posts] (2008 Jul 10 Thu, 16:29) Reply

Hi Candice

How are you doing, sorry not got back to you earlier

now it is very possible to get data from other programs that are not MS Office as long as the file type being used is a data file type when you save the you want to get externally as a data file from the save as type drop down list at the time you save

Hope this helps, feel free to reply for more calification

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the Reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.

Many Thanks

Mark East
MOUS Master Instructor
mark

· Microsoft Excel Training - Numerical excellence for all
· How Small Businesses Profit from Outside Excel Training
· Interesting Lifestyle Applications for Microsoft Excel
· Microsoft Excel Training Course
· Microsoft Excel's Best Kept Secret

Please browse our web site to find out more about
excel training course and other Microsoft training courses.

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips