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

excel

ResolvedVersion 2007

Harry has attended:
Excel Introduction course

Excel

What is advanced filtering?

Edited on Fri 11 Jul 2008, 16:22

RE: Excel

Hi Harry,

Thank you for your post and welcome to the forum, in reply to your question, I have attached a file to this response, please double-click to view it.

Advanced Filtering is covered in subsequent courses.

I hope the attachment helps, if so please click the resolved link. regards Pete

Attached files...

Custom Filtering.doc

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

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