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 » What if

	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:

What if

Resolved · Medium Priority · Version 2007

ReplyMon 7 Sep 2009, 16:41Delegate Lin said...

What if

why use goal seek or solver?it seems I didn't come cross any of those at work.

For upcoming training course dates see: Pricing & availability

ReplyTue 8 Sep 2009, 09:53Trainer Amanda said...

RE: what if

Hello Lin

Thank you for your question and welcome to the forum.

There will be certain parts of Excel that are relevant to the job that you do, so there are probably a lot of Excel features that people don't use because their roles don't require them to.

Goal seek and Solver both belong to the 'what-if' analysis tools within Excel. These tools are often used to try and ascertain what might happen in future, therefore can be used when looking at future budgets, and for modelling and forecasting.

There is a general introduction to the different 'what-if' analysis tools on the following page:
http://office.microsoft.com/en-us/excel/HA102431641033.aspx

Kind regards
Amanda

Mon 14 Sep 2009: Automatically marked as resolved.

Excel articles

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· How Excel Training Can Improve Your Company's Sales Process
· How To Print Worksheets In Excel
· Why Printing Needn't Be A Grey Area In Excel
· Create An Improvised Bar Chart In Excel

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

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips

Hello,

I have the following problem:

Query 1 with criteria - editable data
Query 2 - editable data

but when I then add a field from Query 1 to Query 2, the data ceases to be editable. Do you think this is a relationship issue?

» Forum post: Query with criteria using in another query

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