the basic concepts and then introducing functions and features that allow you to organize and manage vast amounts of information. It covers the Excel Table data list structures, advanced functions and Excel add-ins, and shows you how to present your worksheet data in chart formats. The book helps you to create macros, recorded or via Visual Basic. You learn how to use templates, tools, and other resources to help you apply Excel to various tasks. You link your worksheets to other workbooks and to data sources on the Internet to get automatic updates. Learn how to use the new Sparklines to create small charts in a single cell to quickly discover patterns in your data. Save time by using the Slicer feature to see just the parts of pivot tables you need for your purpose. Written concisely yet comprehensively, this is an ideal book to help you grasp the essentials of Excel 2010 quickly and easily, even if you are new to the spreadsheet concept.

Hide more