application development excel - V Look up

The UK's most regular instructor-led training courses.
Training information: application development excel · Excel advanced · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

V Look up

Ranjan has attended:
Excel Advanced course
Access Intermediate course

by - delegate Ranjan [2 posts] (2007 Feb 21 Wed, 10:04) Reply

Can somebody tell me how can I create a Pivot Table from scrach please. Thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: V Look up

by - trainer Amanda diamond contributer [1217 posts] (2007 Feb 21 Wed, 16:53) Reply

Hi Ranjan

Thanks for your question.

You must select a cell within the list you are creating your PivotTable from before creating the PivotTable.

Go to Data - PivotTable or Pivotchart report and follow through the 3 steps in the wizard to create your PivotTable.

thanks
Amanda

· Customized Financial Excel Courses in London
· How Excel Training Can Improve Your Company's Sales Process
· How Small Businesses Profit from Outside Excel Training
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Crazy Things People Have Done With Excel

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips