advanced+excel+courses - Excel

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

Resolved · Low Priority · Version Standard

Excel

Anne has attended:
Excel Introduction course
Access Introduction course
Excel Intermediate course
Access Intermediate course

by - delegate Anne [4 posts] (2007 Oct 25 Thu, 17:04) Reply

What is the best way to remember comma

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Excel

by - trainer Amanda diamond contributer [1297 posts] (2007 Oct 26 Fri, 17:15) Reply

Hi Anne

Thank you for your question.

Just to clarify, do you mean how to change a number to include a comma; or using a comma as part of a function?

Amanda

· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· From the Classroom to the Corporate World
· Microsoft Excel Features and Functions for Accountants
· How to Create Better Excel Spreadsheets: Part Two
· How Small Businesses Profit from Outside Excel Training

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips

Rate this page: