Book description
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
Table of contents
- Dedication
- Special Upgrade Offer
- A Note Regarding Supplemental Files
- Introduction
- 1. Getting started with Excel 2013
- 2. Working with data and Excel tables
- 3. Performing calculations on data
- 4. Changing workbook appearance
- 5. Focusing on specific data by using filters
- 6. Reordering and summarizing data
- 7. Combining data from multiple sources
-
8. Analyzing data and alternative data sets
- Examining data by using the Quick Analysis Lens
- Defining an alternative data set
- Defining multiple alternative data sets
- Analyzing data by using data tables
- Varying your data to get a specific result by using Goal Seek
- Finding optimal solutions by using Solver
- Analyzing data by using descriptive statistics
- Key points
- 9. Creating charts and graphics
- 10. Using PivotTables and PivotCharts
- 11. Printing worksheets and charts
- 12. Working with macros and forms
- 13. Working with other Office programs
- 14. Collaborating with colleagues
- A. Glossary
- B. Keyboard shortcuts
- C. About the authors
- Index
- About the Author
- Special Upgrade Offer
- Copyright
Product information
- Title: Microsoft Excel 2013: Step by Step
- Author(s):
- Release date: March 2014
- Publisher(s): Microsoft Press
- ISBN: 9780735672048
You might also like
book
Microsoft Excel 2016 Step by Step
Now in full color! The quick way to learn Microsoft Excel 2016! This is learning made …
book
Excel 2013 Formulas
Maximize the power of Excel 2013 formulas with this must-have Excel reference John Walkenbach, known as …
book
Microsoft Excel 2019 Formulas and Functions, First Edition
Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more …
book
Excel 2016 Bible
The complete guide to Excel 2016, from Mr. Spreadsheet himself Whether you are just starting out …