Functions in This Chapter

The database functions and a sample of each are described in the rest of this chapter.

The following scenario is used: You are a wholesaler selling 76 different products to a variety of countries. The database records sales orders showing the date of the order, customer, city and country/region, product sold, and order value. You can use the database functions to analyze your sales.

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.