发帖
雷达卡
A Step-by-Step Guide
Authors: David Slager
Written by an Excel expert with many years of experience teaching people of all ages how to use Excel
Includes extensive workbooks and reader exercises with every chapter
Typical Excel users only use 10% of the functionality available in this software. Readers of this book will come away making much better use of the powerful tool at their fingertips
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
Table of contents (17 chapters)
Front Matter
Pages i-xxi
Becoming Acquainted with Excel
Pages 1-26
Navigating and Working with Worksheets
Pages 27-48
Best Ways to Enter and Edit Data
Pages 49-88
Formatting and Aligning Data
Pages 89-143
Different Ways of Viewing and Printing Your Workbook
Pages 145-172
Understanding Backstage
Pages 173-218
Creating and Using Formulas
Pages 219-264
Excel’s Pre-existing Functions
Pages 265-302
Auditing, Validating, and Protecting Your Data
Pages 303-341
Using Hyperlinks, Combining Text, and Working with the Status Bar
Pages 343-371
Transferring and Duplicating Data to Other Locations
Pages 373-409
Working with Tables
Pages 411-444
Working with Charts
Pages 445-501
Importing Data
Pages 503-539
Using PivotTables and PivotCharts
Pages 541-589
Enhancing Workbooks with Multimedia
Pages 591-641
Automating Task with Macros
Pages 643-664
Back Matter
Pages 665-673
下载地址：
京公网安备 11010802022788号
