The smart way to learn Excel 2013—one step at a time!
Experience learning made easy—and quickly teach yourself how to manage, analyze, and present data with Excel 2013. With Step by Step, you set the pace—building and practicing the skills you need, just when you them! Includes downloadable practice files and companion eBook.
Discover how to:
- Work with Excel 2013 in touch mode
- Write formulas, create macros, and organize data
- Present data visually and add images to worksheets
- Consolidate multiple sets of data into a single workbook
- Analyze data using the Quick Analysis Lens
- Collaborate with colleagues and present workbooks online
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
Introduction Chapter 1: Getting started with Excel 2013Chapter 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 data and alternative data setsChapter 9: Creating charts and graphicsChapter 10: Using PivotTables and PivotChartsChapter 11: Printing worksheets and chartsChapter 12: Working with macros and formsChapter 13: Working with other Office programsChapter 14: Collaborating with colleaguesGlossaryKeyboard shortcutsAbout the authors