没有合适的资源？快使用搜索试试~ 我知道了~

文库首页课程资源专业指导Excel2010 英文版教程

Excel2010 英文版教程

Excel2010

4星 · 超过85%的资源需积分: 25 144 下载量 50 浏览量 2012-07-20 14:50:06 上传评论 9 收藏 24.78MB PDF 举报

温馨提示

试读

204页

在这边找Excel2010教程，没有找到，上传一个英文版的，谁有好的也推荐给我，谢谢了！！

资源推荐

资源详情

资源评论

CHAPTER 1

Working with the Excel User Interface ................................ Pg. 2

CHAPTER 2

Managing Workbooks and Worksheets .............................. Pg. 12

CHAPTER 3

Entering and Managing Data ................................................ Pg. 28

CHAPTER 4

Formatting Worksheet Data ................................................Pg. 50

CHAPTER 5

Working with Formulas and Functions ...............................Pg. 80

CHAPTER 6

Working with Charts .............................................................. Pg. 112

CHAPTER 7

Working with Graphics .........................................................Pg. 126

CHAPTER 8

Printing in Excel ..................................................................... Pg. 142

CHAPTER 9

Working with Excel Pivot Tables ........................................Pg. 164

APPENDIX

Excel Shortcut Keys ............................................................. Pg. 180

INDEX ...............................................................................Pg. 184

easy

Microsoft

Excel

2010

800 East 96th Street

Indianapolis, Indiana 46240

Michael Alexander

CONTENTS

CHAPTER 1 WORKING WITH THE EXCEL USER

INTERFACE

.......................................................... 2

The Ribbon User Interface ..................................... 2

The Anatomy of the Ribbon Interface

.................... 3

Familiarizing Yourself with the Ribbon Tabs

........... 4

Understanding Contextual Tabs

............................. 6

Understanding Workbooks and Worksheets

........... 7

Customizing the Quick Access Toolbar

.................. 8

Adding Commands to the Quick Access Toolbar

.... 9

Adding Hidden Commands to the Quick

Access Toolbar

....................................................... 10

CHAPTER 2 MANAGING WORKBOOKS AND

WORKSHEETS

....................................................12

Opening an Excel Workbook ................................. 14

Closing an Excel Workbook

................................... 15

Saving a Workbook

................................................ 16

Switching Between Open Workbooks

.................... 17

Switching Between Worksheets

............................ 18

Viewing Multiple Workbooks

................................. 19

Inserting and Deleting Worksheets

...................... 20

Renaming Worksheets

........................................... 21

Coloring Worksheet Tabs

......................................22

Moving Worksheets Within a Workbook

................23

Copying Worksheets Between Workbooks

........... 24

Password Protect a Workbook

..............................25

Protecting a Worksheet

.........................................26

iii

CHAPTER 3 ENTERING AND MANAGING DATA ...............28

Entering Data ....................................................... 30

Editing and Deleting Existing Data

........................ 31

Zooming Into Your Data

.........................................32

Undoing and Redoing Changes

............................. 33

Copying and Pasting Data

..................................... 34

Freezing Rows and Columns

................................. 36

Splitting a Worksheet

............................................37

Inserting Cells

...................................................... 38

Deleting Cells

....................................................... 39

Inserting and Deleting Rows

................................. 40

Inserting and Deleting Columns

............................ 41

Moving Data

.......................................................... 42

Finding Data

......................................................... 43

Replacing Data

...................................................... 44

Applying a Data Filter

........................................... 45

Sorting Data

......................................................... 46

Adding and Managing Cell Comments

.................. 48

page

CHAPTER 4 FORMATTING WORKSHEET DATA ............... 50

Changing the Font and Font Size ...........................52

Changing Column Width

....................................... 53

Changing the Color of the Cell Background

and Cell Text

......................................................... 54

Formatting the Display of Numeric Data

...............55

Using a General Format

........................................ 56

Using a Number Format

......................................... 57

Using a Currency Format

...................................... 58

Using a Date Format

............................................. 59

Using a Text Format

.............................................. 60

Applying Bold, Italic, and Underline

...................... 61

Using Merge and Center on Cells

..........................62

Changing Horizontal Data Alignment

................... 63

Changing Row Height

........................................... 64

Changing Vertical Data Alignment

........................ 65

Changing Cell Orientation

................................... 66

Wrapping Data in a Cell

.........................................67

Changing Borders

................................................. 68

Indenting Entries in a Cell

.................................... 69

Clearing Formatting

............................................. 70

Hiding and Unhiding Rows

..................................... 71

Hiding and Unhiding Columns

................................72

Hiding and Unhiding a Worksheet

..........................73

Using Format As Table

...........................................74

Copying Formatting

............................................... 75

Creating and Applying a Formatting Style

............. 76

Using Conditional Formatting

................................78

剩余203页未读，继续阅读

评论收藏

内容反馈

资源评论

资源反馈

评论星级较低，若资源使用遇到问题可联系上传者，3个工作日内问题未解决可申请退款~

sanguineous

2014-01-29

还可以，跟微软官方的差不多
gjtjg

2015-07-06

正是我要找的资源，太感谢了。
csc_1

2015-10-14

英文比较详细，感谢

wunpeyan

粉丝: 0
资源: 1

上传资源快速赚钱

我的内容管理展开

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

前往需求广场，查看用户热搜

Excel2010 英文版教程

excel 2010高级教程-英文版

excel2010教程 超实用 很全

Excel2010Advanced.pdf 英文原版

Excel VBA英文教程

2010版Word-&-Excel-菜单栏中英文对照表

中文版Excel教程

第五章_Excel(1)2003英文版教程

Excel2010培训教程.ppt

Excel2010教程

Excel2010培训教程-.ppt

Power Query教程英文版.pdf

Excel2010培训教程(入门)

Excel2010培训教程(入门).ppt

EXCEL2010 教程 全

Excel2010培训教程入门级.ppt

Excel2010培训教程(入门)(1).ppt

Office Excel 2003（24小时） (英文版)

专业Excel开发（第二版）》（英文版）

Excel学习教程

英文原版-Excel 2016 for Human Resource Management Statistics 1st Edition

仿真电路以及操作方法

python大作业 含爬虫、数据可视化、地图、报告、及源码（整和为一个文件）（2014-2020全国各地区原油加工量）.rar

【纯干货啊】华为IPD流程管理(完整版).pptx

信号与系统——保研复习资料.pdf

可编程语言标准IEC61131-3中文版.pdf

最新资源

excel2010教程超实用很全

EXCEL2010 教程全

python大作业含爬虫、数据可视化、地图、报告、及源码（整和为一个文件）（2014-2020全国各地区原油加工量）.rar