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

microsoft excel courses in london - link

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in london - Link

microsoft excel courses in london - Link

ResolvedVersion Standard

Sarah has attended:
Excel Introduction course

Link

how do i link a spreadsheet?

RE: link

Hi Sarah

Thanks for the post

Linking spreadsheets is simply where you press = in one cell and highlight another cell, so for example =B2 when you are in cell F2. This means there is a link that whatever value is in B2 appears in F2. This can be done across different worksheets as well.

Hope this helps

Tracy

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

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.