Microsoft Excel 2013 Inside Out

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

Book Details

  • Paperback: 1168 pages
  • Publisher: Microsoft Press (April 2013)
  • Language: English
  • ISBN-10: 0735669058
  • ISBN-13: 978-0735669055
Download [71.9 MiB]

You may also like...

Leave a Reply