financial excel course london - pivot table

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » financial excel course london - Pivot Table

financial excel course london - Pivot Table

resolvedResolved · Low Priority · Version Standard

Chitra has attended:
Excel Intermediate course
Excel Advanced course

Pivot Table

How to publish pivot table values on to the webpage?

RE: Pivot Table

Hi Chitra

Thank you for your question.

You can create a web page which contains a pivot table, with some pivot table functionality that the web page viewers can use if you wish.

Bring up the sheet containing your pivot table, then go to File - Save as web page. Give the file a name, and tick the Add interactivity box if you want functionality available on the web page. Click the Publish button. Then tick the box Add interactivity with and select Pivot table functionality if you want interactivity. Tick the Open Published web page in browser and click Publish to view your web page.

Amanda


 

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips


Server loaded in 0.12 secs.