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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.