pivot tables

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Pivot tables

resolvedResolved · Medium Priority · Version 2003

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?

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:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips


Server loaded in 0.07 secs.