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

excel

ResolvedVersion 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:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.