TY - BOOK AU - McFedries,Paul TI - Teach yourself visually complete Excel 2013 SN - 9781118653746 U1 - 005.369 PY - 2013/// CY - Indianapolis, IN PB - Visual, a Wiley Brand KW - Business KW - Computer programs KW - Electronic spreadsheets KW - Microsoft Excel (Computer file) N1 - Includes index; Cover; Title Page; About the Author; How to Use This Book; 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 TablesChapter 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 N2 - 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 UR - https://uowd.box.com/s/iz687qqqt8tvuls9tns2zzn54cm4o8us ER -