It’s a great new tool from Microsoft that allows you to quickly and easily create questionnaires, surveys, quizzes and polls that you can share both internally or externally from your work. There is a wide variety of potential uses for these. You could use them to get customer feedback, collect reviews and testimonials or even use them as data entry forms. In this module, you'll find that with near endless cells of a spreadsheet, using a data form provides a convenient means to enter or display data on the screen, particularly, when you have to move from column to column with near endless cells and more columns of data to view.

Data duplicates in Excel table can cause a lot of inconveniences to you. Whether you import data from a database, get it from a colleague, or collate it yourself, data duplicate can always creep in. And if the data you are working with is huge, then it can become really difficult to locate and remove these duplicates. The focus of this tutorial is walk you through how to locate and remove duplicates from you data file.