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 VBA Training and help » Pivot Tables

Pivot Tables

resolvedResolved · Low Priority · Version 2003

replyReply Thu 19 Feb 2009, 16:36Delegate Steve said...

Steve has attended:
Excel VBA Intro Intermediate course

Pivot Tables

How to publish pivot tables online - from excel.

For upcoming training course dates see: Pricing & availability

replyReply Fri 27 Feb 2009, 16:24Trainer Carlos said...

RE: Pivot Tables

Hi Steve

To publish a pivot table online from Excel you do the following:

1. Open the workbook on the Pivot table sheet

2. Select the File menu and click Save As Web Page

3. Select the option Selection:Sheet to publish just the selected Pivot table sheet

4. Click the Publish button

5. In the Publish As Web page dialog box select the folder where the new file will be saved

6. Add Interactivity if needed

7. Click the Publish button

Hope this helps

Carlos

Thu 5 Mar 2009: Automatically marked as resolved.

 

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

Excel tip:

Use the Ctrl-key for quick navigation in Excel 2010

If you want to move quickly to the right, left, top or bottom of your spreadsheet, just press Ctrl and one of the arrow keys. If you want to then select all the data in that particular row or column, hold down the Shift key and press Ctrl and an arrow key.

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