Synopses & Reviews
Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.
About the Author
Curtis Frye is the author of numerous books on Excel and other Office products, most recently Microsoft Excel 2010 Step by Step. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.
Table of Contents
AcknowledgmentsIntroducing Microsoft Excel 2010Modifying the Display of the RibbonFeatures and Conventions of This BookUsing the Practice FilesGetting HelpChapter 1: Setting Up a WorkbookChapter 2: Working with Data and Excel TablesChapter 3: Performing Calculations on DataChapter 4: Changing Workbook AppearanceChapter 5: Focusing on Specific Data by Using FiltersChapter 6: Reordering and Summarizing DataChapter 7: Combining Data from Multiple SourcesChapter 8: Analyzing Alternative Data SetsChapter 9: Creating Dynamic Worksheets by Using PivotTablesChapter 10: Creating Charts and GraphicsChapter 11: PrintingChapter 12: Automating Repetitive Tasks by Using MacrosChapter 13: Working with Other Microsoft Office ProgramsChapter 14: Collaborating with ColleaguesGlossaryKeyboard ShortcutsAbout the Author