what if analysis tools

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 'what if' analysis tools

'what if' analysis tools

resolvedResolved · Low Priority · Version 2007

Khaleda has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course

'what if' analysis tools

how do I use goal seek?

RE: 'what if' analysis tools

Hi Khaleda

The Goal Seek is used when you know the desired result of a single formula but not the input value the formula needs to determine the result.

So using a function like PMT if you know that by borrowing

Thu 27 Nov 2008: Automatically marked as resolved.


 

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips


Server loaded in 0.08 secs.