data

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data

Data

resolvedResolved · Low Priority · Version 2003

Debbie has attended:
Excel Introduction course

Data

how do we extract data from the list

RE: Extracting data

Hi Debbie,

Thank you for your question.

If you want to extract data from an Excel list, you can use Autofilter which can be found under the Data menu and the filter option.

I hope this answers your question.

Regards

Simon


 

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips


Server loaded in 0.08 secs.