The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Formulas

Resolved · Low Priority · Version 2007

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

Formulas

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

For upcoming training course dates see: Pricing & availability

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 articles

· So what's new in Excel 2007?
· Do You Really Need Excel VBA Training?
· Create Buttons To Navigate Between Worksheets
· A Hidden Gem In Excel - Formula Auditing
· Let Excel look after the pennies, and the pounds will take care of themselves

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

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips

I have a document which is all in portrait orientation, but there is 1 page I would like to make landscape. I have inserted section breaks before and after the page which solves my problem, but if I close the document down and re-open it, the changes do n..

» Forum post: Orientation of a page in a document

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions