內容介紹
線上閱讀本書Youre beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. Its all muscle and no fluff. Discover how the experts tackle Excel 2007and challenge yourself to new levels of mastery!Learn expert techniques for designing powerful spreadsheetsApply built-in functionsor write your ownand carry out complex calculationsUse rich charting capabilities and new SmartArt graphics to visually represent dataPerform sophisticated data analysis: financial, statistical, and what-ifDesign PivotTable reports to dynamically analyze dataShare spreadsheets and collaborate with colleaguesand control access to sensitive dataLink and embed Excel data into other documentsCreate macros with Microsoft Visual Basic for Applications CD includes:Fully searchable eBookSample spreadsheets from inside the bookAdd-ins and other resources to help you extend Microsoft Office programsLinks to demos, user communities, and product supportReferences for finding Excel 2003 commands in Excel 2007Windows Vista Product Guide eReference and other eBooks