Excels

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

Resolved · Low Priority · Version 2003

Excels

Sarah has attended:
Excel Introduction course

by - delegate Sarah [1 post] (2008 Jun 2 Mon, 15:59) Reply

What are marcos?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Excels

by - trainer Simon gold contributer [214 posts] (2008 Jun 3 Tue, 17:11) Reply

Hi Sarah,

Thank you for your question.

If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run at anytime.

So you could record a macro that stored the commands to autofit all the columns on every workbook you open or use.

I hope this give you an insight to macros.

Regards

Simon

· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Tips for Transitioning to Excel 2007
· Advanced Excel Training - takes you to the next level
· How Small Businesses Profit from Outside Excel Training
· Reporting and Analysis with Excel

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

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.