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.
