Normal view MARC view ISBD view

Teach yourself visually complete Excel 2013 /

By: McFedries, Paul
Material type: BookPublisher: Indianapolis, IN : Visual, a Wiley Brand, 2013; ©2013.Description: 581 p. : ill. ; 24 cm.ISBN: 9781118653746; 1118653742 (paperback)Other title: Microsoft Excel 2013 | Excel 2013.Subject(s): Business -- Computer programs | Electronic spreadsheets | Microsoft Excel (Computer file)DDC classification: 005.369 Online resources: Location Map
Summary:
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.
Tags from this library: No tags from this library for this title. Log in to add tags.
    average rating: 0.0 (0 votes)
Item type Home library Call number Status Date due Barcode Item holds
REGULAR University of Wollongong in Dubai
Main Collection
005.369 MC TE (Browse shelf) Available T0015118
Total holds: 0

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

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.

Powered by Koha