"Brilliant Excel 2010 guides you through the essential tasks step-by-step, showing you how to: Create workbooks more efficiently using the improved Ribbon interface; Use data-analysis tools and techniques for better decision making; Use organising, processing, and presenting tools to create and analyse data; Integrate data from external sources and add hyperlinks; Use conditional formatting and sparklines to visualise results; Add impact to your data with PivotTable and PivotChart reports; Organise information and add impact with clip art, SmartArt diagrams, tables, and charts; Use SharePoint to collaborate and share documents; Use the Excel Web App to view and edit documents in a browser; Prepare for the Microsoft Certified Application Specialist (MCAS) exam. Brilliant books provide quick and easy-to-access information. Features include: Detailed index & contents page; Numbered step-by-step tasks; Visual full colour screenshots; Expert tips, tricks & advice; Practical troubleshooting guide."--Back cover.