Excel

Resolved · Medium Priority · Version 2007

Excel

Lucimer has attended:
Excel Introduction course

by - delegate Lucimer [1 post] (2008 Jun 18 Wed, 16:43) Reply

If I'm stock in a formula how can I get Help?
How long it will take?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel

by - trainer Amanda diamond contributer [1208 posts] (2008 Jun 20 Fri, 12:06) Reply

Hi Lucimer

Thank you for your question; and welcome to the forum.

If you want further information on how to create formulas in Excel, I can suggest having a look at a tutorial on the Microsoft web site for extra guidance:

http://office.microsoft.com/training/training.aspx?AssetID=RC100745681033

If you are stuck with using a function, you can always look up the function name in Excel Help for assistance. Normally these come with examples at the bottom of the explanation of the function which you can copy and paste into a spreadsheet to learn about how the function works.

You are welcome of course to submit questions to this forum as well. Our aim is to answer posts within 24 hours during business hours, particularly if you mark your question as Urgent.

I hope this helps.
Amanda

· Identifying Suitable Candidates For VBA For Excel Training
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Microsoft Excel Training: Essential for Today's Employees
· Tips for Transitioning to Excel 2007
· How Excel Training Can Improve Your Company's Sales Process

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

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips