You re beyond the basics so dive in & really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions troubleshooting tips & workarounds. It s all muscle & no fluff. Discover how the experts tackle Excel 2007 & challenge yourself to new levels of mastery! Learn expert techniques for designing powerful spreadsheets Apply built-in functions or write your own & carry out complex calculations Use rich charting capabilities & new Smart Art graphics to visually represent data Perform sophisticated data analysis: financial statistical & what-if Design Pivot Table reports to dynamically analyze data Share spreadsheets & collaborate with colleagues & control access to sensitive data Link & embed Excel data into other documents Create macros with Microsoft Visual Basic for Applications CD
Includes:: Fully searchable e Book Sample spreadsheets from inside the book Add-ins & other resources to help you extend Microsoft Office programs Links to demos user communities & product support References for finding Excel 2003 commands in Excel 2007 Windows Vista Product Guide e Reference & other e Books