Formulas

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

Resolved · Low Priority · Version 2007

1 post

ReplyWed 1 Jul 2009, 16:00Delegate Michael said...

Michael has attended:
Excel Intermediate course

Formulas

Making best use out of extensive formula possibilities of new additons to 2007

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Mon 22 Mar 2010	Limehouse	3		£224	£225
2003	Tue 23 Mar 2010	Southwark	4		£207	£212
2007	Thu 25 Mar 2010	Rochester (Hoo)	0	FULL
2003	Fri 26 Mar 2010	Limehouse	4		£224	£225
2007	Tue 30 Mar 2010	Southwark	4		£207	£212
2003	Thu 1 Apr 2010	Bloomsbury	4		£207	£212
Full Schedule: See all 77 Excel Intermediate course dates. Bookings currently available until 23rd December 2010.

1,056 posts

ReplyThu 2 Jul 2009, 16:56Trainer Andrew said...

RE: Formulas

Hi Michael

Thank you for posting into the forum. A quick way to find out more about the functions built into Excel 2007 is to click on the formulas tab. You will see the Function library contains groups of functions. Click on any of them then hover your mouse over an items in the drop down list. Excel will offer a description of what each function can do.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Thu 9 Jul 2009: Automatically marked as resolved.

· Excel Macros for the Non-Programmer
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Correcting Numerical Glitches In Excel
· Which Is Better, Excel Or Access?
· Identifying Suitable Candidates For VBA For Excel Training

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

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips