Essential Excel 2016

A Step-by-Step Guide

David Slager (Autor)

Buch | Softcover

673 Seiten

2016 | 1st ed.
Apress (Verlag)
978-1-4842-2160-0 (ISBN)

Infos

This book shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it. Loaded with screen shots, step-by-step instructions, and reader exercises, Essential Excel 2016 makes it easy for you to get to grips with this powerful software and what it can do.
What You’ll Learn

How to create amazing visualizations of your data

Easy and accurate methods for entering data

How to extract just the information you want from imported data, and manipulate it and format it the way you want

Export your results to other programs or share with others in the cloud

Organize, Summarize, Filter, and Consolidate your Data in almost any way imaginable

Audit, Validate and Protect your Data

Who This Book Is For
Anyone new to Excel, or looking to take better advantage of the platform and find out its latest features

Autor

David Slager has been a computer programmer for over 40 years and has taught Excel for 18 years. He has been working with spreadsheets since their introduction on the PC and has taught people of all ages from 1st graders to senior citizens. 

Inhalt

Chapter 1: Becoming Acquainted with Excel

Chapter 2: Moving Around the Worksheet

Chapter 3: Best Ways to Enter Data

Chapter 4: Formatting and Aligning Data

Chapter 5: Different Ways of Viewing and Printing your Workbook

Chapter 6: Understanding Backstage

Chapter 7: Creating and Using FormulasChapter 8: Excel’s Pre-existing Functions

Chapter 9: Auditing, Validating and Protecting your Data

Chapter 10: Using Hyperlinks, Combining Text, and Working with the Status Bar

Chapter 11: Transferring and Duplicating Data to Other Locations

Chapter 12: Working with Tables

Chapter 13: Working with ChartsChapter 14: Importing Data

Chapter 15: Using PivotTables and PivotCharts

Chapter 16: Enhancing Workbooks with Multimedia

Chapter 17: Automating Tasks with Macros

Produkt-Details

• Erscheinungsdatum: 19.12.2016
• Zusatzinfo: 889 Illustrations, color; 211 Illustrations, black and white; XXI, 673 p. 1100 illus., 889 illus. in color.
• Verlagsort: Berkley
• Sprache: englisch
• Maße: 178 x 254 mm
• Themenwelt: Informatik ► Office Programme ► Excel
• Themenwelt: Mathematik / Informatik ► Informatik ► Software Entwicklung
• Themenwelt: Sozialwissenschaften ► Politik / Verwaltung ► Staat / Verwaltung
• Schlagworte: 2016 • Beginner • Beginning • Data • data entry • Excel • Excel 2016; Einführung • Microsoft • Office • spreadsheet • User Guide
• ISBN-10: 1-4842-2160-5 / 1484221605
• ISBN-13: 978-1-4842-2160-0 / 9781484221600
• Zustand: Neuware