Microsoft Excel 2013 Inside Out

05/14/2013 · No Responses

You’re beyond the basics—so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Learn how the experts tackle Excel 2013—and challenge yourself to new levels of mastery. Includes companion eBook and sample files.

Topics include:

Customizing the Excel workspace
Best practices for designing and managing worksheets
Creating formulas and functions
Performing statistical, what-if, and other data analysis
Core to advanced charting techniques
Using graphics and sparklines
Managing databases and tables
Automating Excel with macros and custom functions
Collaborating in Excel online, in the cloud, and more
Extending Excel

Table of Contents
Part I: Examining the Excel environment
Chapter 1. What’s new in Microsoft Excel 2013
Chapter 2. Exploring Excel fundamentals
Chapter 3. Custom-tailoring the Excel workspace
Chapter 4. Security and privacy

Part II: Building worksheets
Chapter 5. Planning your worksheet design
Chapter 6. How to work a worksheet
Chapter 7. How to work a workbook

Part III: Formatting and editing worksheets
Chapter 8. Worksheet editing techniques
Chapter 9. Worksheet formatting techniques

Part IV: Adding graphics and printing
Chapter 10. Creating and formatting graphics
Chapter 11. Printing and presenting

Part V: Creating formulas and performing data analysis
Chapter 12. Building formulas
Chapter 13. Using functions
Chapter 14. Everyday functions
Chapter 15. Formatting and calculating date and time
Chapter 16. Functions for financial analysis
Chapter 17. Functions for analyzing statistics
Chapter 18. Performing a what-if analysis

Part VI: Creating charts
Chapter 19. Designing charts
Chapter 20. Formatting charts
Chapter 21. Using sparklines

Part VII: Managing databases and tables
Chapter 22. Managing information in tables
Chapter 23. Analyzing data with PivotTable reports
Chapter 24. An introduction to PowerPivot
Chapter 25. Working with external data

Part VIII: Using Excel collaboratively
Chapter 26. Collaborating on a network or by email
Chapter 27. Working in the cloud

Part IX: Automating Excel
Chapter 28. Recording macros
Chapter 29. Creating custom functions
Chapter 30. Debugging macros and custom functions

Part X: Integrating and extending Excel
Chapter 31. Linking, hyperlinking, and embedding
Chapter 32. Using Excel data in Word documents

Part XI: Appendixes
Appendix A. Menu-to-ribbon command reference
Appendix B. Keyboard shortcuts
Appendix C. Function reference
Appendix D. Index to troubleshooting topics
Appendix E. About the authors