Teach Yourself VISUALLY Complete Excel 2013

Get the basics of Excel and then go beyond with this new instructional visual guide

While many users need Excel just to create simple worksheets, many businesses and professionals rely on the advanced features of Excel to handle things like database creation and data analysis. Whatever project you have in mind, this visual guide takes you step by step through what each step should look like. Veteran author Paul McFedries first presents the basics and then gradually takes it further with his coverage of designing worksheets, collaborating between worksheets, working with visual data, database management and analysis, VBA, and more.

• Offers step-by-step instructions on a variety of tasks, some everyday and some more unique
• Shows you how to create basic spreadsheets, insert functions and formulas, work with pivot tables, and more
• Features a two-color interior features numerous screen shots to enhance your learning process for tasks such as creating and managing macros, generating and working with analytics, and using the advanced tools

Offering you a deep dive into Microsoft Excel, this book is the complete package for learning Excel with step-by-step, clear visual instructions.

Table of Contents

Chapter 1: Working with Excel
Chapter 2: Inputting and Editing Data
Chapter 3: Working with Ranges
Chapter 4: Working with Range Names
Chapter 5: Formatting Excel Ranges
Chapter 6: Maximizing Excel Customization
Chapter 7: Making Excel More Efficient
Chapter 8: Building Formulas and Functions
Chapter 9: Getting More Out of Formulas
Chapter 10: Manipulating Worksheets
Chapter 11: Dealing with Workbooks
Chapter 12: Managing Workbooks
Chapter 13: Formatting Workbooks
Chapter 14: Printing Workbooks
Chapter 15: Working with Tables
Chapter 16: Analyzing Data
Chapter 17: Analyzing Data with PivotTables
Chapter 18: Visualizing Data with Charts
Chapter 19: Working with Worksheet Graphics
Chapter 20: Importing Data into Excel
Chapter 21: Querying Data Sources
Chapter 22: Collaborating with Others
Chapter 23: Protecting Excel Data
Chapter 24: Maximizing Security
Chapter 25: Learning VBA Basics