Discuss how important it is to be able to import data from external sources such as online tables or MS Word documents into a workbook so that you can examine the data in Excel.

It is up to your data warehousing project group to decide whether or not to prototype a data warehouse before implementing it. When it comes to acquiring data warehousing skills before embarking on the implementation of the enterprise-wide data warehouse, the project group members are particularly worried. You know what I'm thinking. Provide details about your suggestions.

How the Use of the INDEX function to search for data in a sorted list, be useful and applicable in business and other transactions?

Explain at least one specific tool in Excel that can be considered “database manipulation” beyond mere data entry (via typing into a cell).