* Combining nine books in one, this thorough desk reference delivers the know-how readers need to take full advantage of Excel
* Outlines the most practical and useful applications of Excel for the workplace
* Explains how to import data, build and edit worksheets, create formulas, generate pivot tables, and work with financial functions, what-if scenarios, database functions, and Web queries
* Explores more advanced topics such as worksheet sharing and auditing, error trapping, building and running macros, charting data, and using Excel in conjunction with Visual Basic and the Web
* Author is one of the bestselling technology authors of all time