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