Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables

Pivot tables

ResolvedVersion 2003

Wed 11 Jun 2008, 15:56 Delegate Candice said...

Candice has attended:
Excel Advanced course

Pivot tables

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

Thu 10 Jul 2008, 16:29 Trainer Mark said...

RE: Pivot tables

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

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Pivot tables

Pivot tables

RE: Pivot tables

Excel articles

Excel tip:

Create Equations in Excel 2010