excel

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

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

Excel

resolvedResolved · Low Priority · Version 2003

Thomas has attended:
Excel Intermediate course

Excel

what is the nested function?
how do i remember all this?

RE: excel

Hi Thomas

A nested function is uses the results of another function for its data. For example you might use one function (Round) to modify the results of a Sum function. It would look like this:

=ROUND(SUM(A1:A5),1)

The key to remembering features such as this is to keep applying them - plus you also now have access to our support forum for a year if you need any reminders.

Good luck with Excel and do let us know if you have any further questions.

Kind regards,
Andrew


 

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips


Server loaded in 0.11 secs.