pivet 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 » Pivet Tables

Pivet Tables

resolvedResolved · Low Priority · Version 2003

Ron has attended:
Excel Intermediate course
Access Intermediate course
Access Advanced course

Pivet Tables

Having had a brief outline of how to create them, is it possible to draw in information from outher software applications?

RE: Pivet Tables

Hi Ron

Hope you enjoyed your course yesterday, you can quite easily
use other data sources for your pivot table when you to the data menu and pivot table, the first step is where you can choose other data sources

all you need to make sure of is that the file you are going to use is saved as a data source, the most common ones are access, and word data files like the ones you would use in a mail merge source document

Hope this help you out


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:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips


Server loaded in 0.07 secs.