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

microsoft excel training courses london - how do i extract

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training courses london - How do I extract specific data

microsoft excel training courses london - How do I extract specific data

ResolvedVersion Standard

Tom has attended:
Excel Advanced course

How do I extract specific data

how do I extract specific data from a data download? e.g. I have imported a cash ledger for 12 month period and want to extract only those transactions with "interest" in the description field.

RE: How do I extract specific data

Hi Tom

You mention the "description" field. Could you let me know where this is located? is it a column heading or a comment, or something else. Once I am clear on that I should be able to assist you.

Thanks

Richard

Excel tip:

Shortcut for accessing recently opened files

To get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu.

Recently opened files are listed down the bottom of the File menu - type in the number next to the file you wish to open and it should appear on your screen.

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