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
Practical Predictive Analytics
Make sense of your data and predict the unpredictable About This Book A unique book that …
book
Microsoft Excel Functions & Formulas
Easy to use and equipped with a variety of functions, Microsoft Excel is the tool of …
book
PHP Functions Essential Reference
The PHP Functions Essential Reference is a simple, clear and authoritative function reference that clarifies and …
book
Assessing Network Security
Help beat the hackers at their own game! Discover how to take charge of system assets …