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

dates

ResolvedVersion 2007

Helen has attended:
Excel Intermediate course

Dates

Looking at dates and years. specifically relating to long service

RE: Dates

Hi Helen, thanks for your query. There's a useful walkthrough of the use of dates in Excel right here:

http://www.bettersolutions.com/excel/EHK123/VM012916331.htm

Hope this helps,

Anthony

Wed 28 Dec 2011: Automatically marked as resolved.

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

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.