microsoft excel course - pivot tables
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course - Pivot Tables

microsoft excel course - Pivot Tables

resolvedResolved · Low Priority · Version Standard

replyReply Fri 16 Mar 2007, 09:43Delegate Sab said...

Sab has attended:
Excel Advanced course

Pivot Tables

How do you create a pivot table?
What are the main functions of the pivot table?

For upcoming training course dates see: Pricing & availability

replyReply Tue 20 Mar 2007, 11:54Trainer Carlos said...

RE: Pivot Tables

Pivot tables allow you to look at data in several dimensions; for example, sales by region, sales by sales rep, sales by product.

To create a Pivot table:

Select a cell in the target table

Click Data / Pivot table and Pivot chart report

Follow the steps in the Wizard

 

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard