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
- 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
- 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 2013 Plain & Simple
Get the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book …
book
Microsoft Excel 2010 In Depth
Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their …
book
Excel 2013 For Dummies
The bestselling Excel book - completely updated for Excel 2013! As the world's leading spreadsheet application, …
book
Excel 2013 Simplified
A friendly, visual approach to learning the basics of Excel 2013 As the world's leading spreadsheet …