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

filtering

ResolvedVersion 2007

Sid has attended:
Excel Introduction course
Excel Intermediate course

Filtering

how does filtering work when importing data fromyour company DMS ?

RE: filtering

Hi Sid

Thank you for your question. Can you let me know a little more about the data you import and how you bring it into Excel so I can give you the right advice.

Kind regards,
Andrew

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

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.11 secs.