Creating a Supplier lookup database in Excel

In this Microsoft Excel lesson we illustrate a number of functions including:

  • The Autofilter function
  • Removing duplicates from Data
  • Quicksort
  • Using the Data Validation Feature with a List
  • Copying and Pasting Special for Column Widths
  • Using the FILTER Function
  • Removing Gridlines, Formula Bar and headings
  • Hiding Sheets
  • Unlocking Cells
  • Protecting Sheets and Worksheets

If you don’t fully understand all the functions covered in this video, please don’t be concerned.
Our Excel course starts off from the basics.
This is simply to illustrate a real life example of what you will be be able to do once you’ve completed the course.

Similar Posts

We'd love to know what you think.
Please leave a comment below

Your email address will not be published. Required fields are marked *