Quickly teach yourself how to organize, analyze, and format data in Excel 2010 with Microsoft Excel 2010 Step by Step. Follow the task-based procedures, exercises, and screenshots and learn how to create formulas; calculate values; analyze data; present information using graphics, charts, and diagrams; build PivotTables using the new Excel Web App; reuse information from databases and other documents; create macros that automate repetitive tasks; and much more.
These sample chapters are from Microsoft Excel 2010 Step by Step, written by Curtis D. Frye. This material is Copyright by Curtis D. Frye and is used with permission. You can buy Microsoft Excel 2010 Step by Step at Amazon.com.
Chapter 4: Changing Workbook Appearance
Learn how to change the default settings for both your workbooks and data to make them easier to read and more dynamic. Sections in this chapter include cell formatting, using styles, document themes, and adding images to worksheets.
Chapter 9: Creating Dynamic Worksheets by Using PivotTables
How can you use PivotTables to present your data? This chapter shows you how to dynamically analyze, format, style, and emphasize your data using a PivotTable. You’ll also learn about the new PivotTable filters in Excel 2010 and how to import data from compatible files, such as text files.
About the Author
Curtis D. Frye is the author of several books on Microsoft Access and Excel, including Microsoft Office Excel 2007 Step by Step and Microsoft Office Excel 2003 Step by Step, along with numerous online training courses.