Building Codes

Resolved · Medium Priority · Version 2003

Building Codes

Grishma has attended:
Excel VBA course

by - delegate Grishma [2 posts] (2008 Aug 14 Thu, 16:58) Reply

Why do I need to create New Codes for Pivot Tables when the Excel can do that anyways

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 8 Mon	Bayswater	2	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
2002/XP	2008 Dec 16 Tue	Tooting	0	FULL
Full Schedule: See all 108 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Building Codes

by - trainer Carlos gold contributer [479 posts] (2008 Sep 4 Thu, 10:31) Reply

Hi Grishma

Sorry for the delay in answering this question.

In VBA we write code to create a Pivot Table so that we can take full control of the process.

If you only require 1 pivot table then it would be better and quicker to use the normal Excel steps.

By writing the code, as we did in the course, allows us to create multiple and diverse Pivot tables instantly at the touch of a button.

Hope this helps

Carlos

· Microsoft Excel Features and Functions for Accountants
· Tips to Facilitate Printing of Excel worksheets
· Microsoft Excel Training - Numerical excellence for all
· Interesting Lifestyle Applications for Microsoft Excel
· How to Create Better Excel Spreadsheets: Part Three

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

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function

View all Excel hints and tips

Rate this page: