Debra Dalgleish's Tutorials

RSS  
Name a Range of Cells in Excel

Name a Range of Cells in Excel

1037 Views

http://www.contextures.com/xlNames01.html After you name cells, you can use that name in a formula, or to select the named cells.

Use Excel

Use Excel's MATCH Function With VLOOKUP

2294 Views

http://www.contextures.com/xlFunctions03.html Excel's MATCH function finds items in a list. Combine with VLOOKUP for flexible formulas.

Remove Duplicate Records in Excel 2003

Remove Duplicate Records in Excel 2003

710 Views

http://www.contextures.com/xladvfilter01.html#FilterUR Use an Advanced Filter in Excel to create a list with no duplicates.

Find Product Price in Excel with VLOOKUP

Find Product Price in Excel with VLOOKUP

1262 Views

http://www.contextures.com/xlFunctions02.html Use the VLookup formula to find the price for the selected product.

Drop Down List in Excel

Drop Down List in Excel

516 Views

http://www.contextures.com/xlDataVal01.html Select from a drop down list on the Excel worksheet. Makes data entry easier for users, and more accura...

Want to learn?

Sign up and browse through relevant courses.

Name:
Your Email:
Password:
Country:
Contact no:


Area code Number
Subjects you are interested in:
Word verification: (Enter the text as in image)


Sign Up Already a member? Sign In
I agree to WizIQ's User Agreement & Privacy Policy

About Debra Dalgleish

  • Debra Dalgleish
    Debra Dalgleish
  • 1 Follower
  • 5 Tutorials added
Give live classes, create & sell online courses

Try it free Plans & Pricing

Connect