New Perspectives on Microsoft Office Excel 2007, Comprehensive, Premium Video Edition

This book provides thorough, hands-on coverage of Microsoft Office Excel 2007, and includes the following --- New with this Edition: A Video Companion offering a suite of videos that illustrate the most important and challenging Excel 2007 concepts and skills. --- Expanded and in-depth coverage of higher level skills, including working with Excel tables, PivotTables, and PivotCharts; managing multiple worksheets and workbooks; using Excel's financial tools; importing data into Excel; and expanding Excel with Visual Basic for Applications --- New with this Edition: An Appendix presenting the basics of the new Microsoft Windows 7 operating system --- A solid and thorough presentation of important spreadsheet concepts, including order data validation, data tables, arrays, scenarios, and object-oriented programming and certification requirements for the Microsoft Certified Application Specialist exam, "Using Microsoft (R) Office Excel (R) 2007" Complete instruction on Excel 2007 basics, including creating and formatting a work-book, working with formulas and functions, and creating charts and graphics