Excel 2016基础教程：逐步指南

需积分: 13 109 浏览量更新于2024-07-19 收藏 49.06MB PDF 举报

“Essential Excel 2016 - A Step-by-Step Guide” 是一本由 David Slager 编写的教程，旨在帮助读者掌握 Microsoft Excel 2016 的核心功能和实用技巧。这本书通过逐步指导的方式，使用户能够更有效地管理和分析数据，无论是在商业环境中还是个人用途上。在Excel 2016中，有几个关键的知识点是值得深入学习的： 1. **基础操作**：包括创建、打开和保存工作簿，理解工作表、单元格和行/列的概念，以及如何进行基本的编辑，如输入数据、选择单元格和复制/粘贴内容。 2. **公式与函数**：Excel的核心功能之一是计算。学习如何使用基本公式（如加减乘除）和内置函数（如SUM、AVERAGE、COUNT等）对数据进行运算和分析至关重要。 3. **条件格式化**：此功能允许根据单元格中的值改变其显示样式，如颜色编码数据以快速识别模式或异常值。 4. **图表和图形**：Excel可以生成各种图表，如柱状图、折线图、饼图等，用于可视化数据并进行解释。学习如何选择合适的图表类型以及如何定制图表是提高数据分析能力的关键。 5. **数据排序与过滤**：通过排序和筛选功能，用户能快速整理大量数据，找出需要的信息。 6. **数据透视表**：这是Excel的一个强大工具，用于汇总、分析、探索和展示大量数据的摘要。学习创建和自定义数据透视表能帮助用户高效地挖掘数据背后的故事。 7. **公式错误检查**：理解并学会解决常见的Excel公式错误，如#NULL!, #DIV/0!, #VALUE!等，可以避免在处理复杂公式时遇到的问题。 8. **宏和VBA编程**：对于高级用户，学习如何录制和编写宏，或者使用Visual Basic for Applications (VBA) 进行自动化操作，可以极大地提高工作效率。 9. **保护和共享工作簿**：了解如何设置密码保护，防止他人修改，以及如何将工作簿共享给他人，进行协作编辑。 10. **数据验证**：通过设置数据验证规则，可以限制单元格中输入的数据类型或范围，确保数据的准确性和一致性。通过“Essential Excel 2016 - A Step-by-Step Guide”，读者将不仅学习到以上知识点，还能获得实际操作的练习和实例，从而逐步提升Excel技能，实现数据管理与分析的专业化。这本书适合初学者和有一定基础的用户，无论你是希望提升个人技能还是在工作中更好地利用Excel，都能从中受益。

■ CONTENTS

xvi

■Chapter 16: Enhancing Workbooks with Multimedia ........................................ 591

Adding Pictures to the Worksheet ................................................................................ 591

Using Screenshot ......................................................................................................... 599

Working with WordArt .................................................................................................. 603

Adding and Modifying Shapes ...................................................................................... 609

Using SmartArt ............................................................................................................. 625

Inserting Sound into a Worksheet ................................................................................ 631

Inserting Video into a Worksheet. ................................................................................. 633

Using Bing Maps .......................................................................................................... 634

Summary ..................................................................................................................... 641

■Chapter 17: Automating Task with Macros ....................................................... 643

Creating (Recording) a Macro ....................................................................................... 643

The Problem with Absolute Cell References ................................................................ 646

Saving a Macro-Enabled Workbook ............................................................................. 648

Creating a Macro Using Relative Cell References ........................................................ 650

Adding Macros to the Quick Access Toolbar and Other Objects ................................... 652

Sharing the Personal Workbook with Others ................................................................ 658

Looking at VBA Code .................................................................................................... 658

Creating Macros from Code.......................................................................................... 661

Summary ...................................................................................................................... 664

Index ..................................................................................................................... 665

D. Slager, Essential Excel 2016, DOI 10.1007/978-1-4842-2161-7_1

CHAPTER 1

Becoming Acquainted with Excel

Excel is a powerful and versatile spreadsheet program that can be used for both business and personal

needs. It has amazing capabilities that you can use to make any type of data you record more streamlined

and productive. In the first chapter, you’ll learn the basics of creating worksheets, and how to use the

Ribbon , a feature which drives the user-friendly resources in Excel.

After reading and working through this chapter you should be able to

• Know what Excel is and know some of its capabilities

• Create, save, and open a workbook

• Identify the current cell

• Use the Ribbon

• Use and customize the Quick Access Toolbar

• Enter data in a worksheet

• Get help by using Screen Tips and the Tell me what you want to do features

What Is Excel?

Excel is an electronic spreadsheet program. A spreadsheet is a grid of cells organized into rows and columns

in which you enter and store your data. Excel can meet both your personal and professional needs.

Using Excel, you can do all of the following:

• Create, edit, sort, analyze, summarize, and format data as well as graph it.

• Keep budgets and handle payroll

• Track investments, loans, sales, inventory, etc.

• Perform What-If Analysis to determine such things as “if the price of gas went up

20 cents per gallon” by how much would that decrease my profit, or “if I extend my

loan payments from 15 years to 20 years” by how much will that affect my monthly

payments, total payments, and total interest.

One can improve the appearance of a spreadsheet or better convey what you want a spreadsheet to say

by adding pictures, clip art, shapes, smart art, video, and audio.

Electronic supplementary material The online version of this chapter (doi: 10.1007/978-1-4842-2161-7_1 )

contains supplementary material, which is available to authorized users.

剩余683页未读，继续阅读

sgsfan3

粉丝: 6

Excel 2016基础教程：逐步指南

"Presonus SL-AVB-MIX 选件卡安装与连接指南：快速使用手册

"快速开始Infineon-DAVE编译环境任务指南"。

"Python py_gamma用户教程及安装指南

Essential Excel 2016: A Step-by-Step Guide

Step-By-Step-guide-for-starting-a-demo-on openwrt.pdf

英文原版-Essential Excel 2016 Computer Essentials 1st Edition

Microsoft - Microsoft Visual Basic 2010 Step by Step May 2010

The Essential Guide to Flex 2 with ActionScript 3.0-part 1

The Essential Guide to Flex 2 with ActionScript 3.0-part 2

The Essential Guide to HTML5

最新资源