The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Pivot tables

Resolved · Medium Priority · Version 2003

ReplyThu 18 Mar 2010, 16:31Delegate Debbie said...

Pivot tables

Can you please offer me advanced support for Pivot tables?
Thanks

For upcoming training course dates see: Pricing & availability

ReplyFri 19 Mar 2010, 09:29Trainer Simon said...

RE: Pivot tables

Hi Debbie,

Thank you for your question.

Our Excel Advanced course covers Pivot Tables and includes the following elements:

Creating
Editing
Removing fields
Grouping Data
Adding Calculated Fields
Adding Calculated Items
Subtotals
Changing how you view the values
Creating Pivot Charts

I have included some links which will help you.

http://www.mrexcel.com/articles/pivot-table-tips.php
http://www.exceltip.com/excel_tips/Excel_Pivot_Tables/32.html

Regards

Simon

Thu 25 Mar 2010: Automatically marked as resolved.

Excel articles

· So what's new in Excel 2007?
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Never Lose It In Translation With Excel
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Where Are The Form Controls In Different Versions Of Excel

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

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

When I format my cells as a table it puts an additional row at the top of my cells and calls them column 1, column 2 etc. I have to put blanks in not to show them. How do I get rid of them, or set the settings for format as a table, with out getting t..

» Forum post: Format as table

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions