[MicrosoftPress]MOS2013StudyGuideforMicrosoftExcelExpert.pdf资源-CSDN文库

2013

3星 · 超过75%的资源需积分: 10 106 浏览量 2015-05-25 22:16:28 上传评论 2 收藏 5.04MB PDF 举报

根据提供的文件信息，可以看出这本书是专门为了准备Microsoft Office Specialist (MOS) 2013 Excel Expert 认证考试而编写的。此书主要针对两个考试：77-427 和 77-428。以下是基于该书籍标题、描述及部分内容的关键知识点概述。 ### 关键知识点 #### 1. **Microsoft Excel 2013** - **功能与特性**：本书主要介绍了Excel 2013 的各项功能和特性，包括基本操作、数据管理和分析、图表制作等。 - **高级工具**：深入探讨了Excel 2013 中的高级工具，如Power Pivot、Power Query 和 Power View 等，帮助读者掌握更高效的数据处理方法。 - **工作簿管理**：涵盖了如何创建、编辑、保护和共享Excel 工作簿的基础知识。 #### 2. **MOS 2013 Excel Expert 认证考试** - **考试代码**：书中明确指出了准备的是77-427 和 77-428 两个认证考试。 - **考试范围**：详细介绍了每个考试的具体内容范围，包括但不限于表格格式化、公式函数应用、数据验证、图表制作等。 - **备考策略**：提供了有效的备考建议和技巧，帮助考生更好地准备考试。 #### 3. **作者与出版信息** - **作者**：Mark Dodge，拥有丰富的Excel 使用经验和教学经验，为读者提供了权威的指导。 - **出版商**：由Microsoft Press 出版，确保了内容的专业性和准确性。 - **版权信息**：明确了书籍的版权归属，并强调了版权保护的重要性。 #### 4. **学习资源与支持** - **在线资源**：提供了访问额外学习资源的途径，包括官方的在线调查链接，鼓励读者反馈意见以改进未来的版本。 - **技术支持**：指出了获取技术支持的方式，例如通过电子邮件联系Microsoft Press Book Support。 #### 5. **组织结构与内容概览** - **章节安排**：虽然具体内容未给出，但可以推测本书按主题分章，每一章都会围绕特定的主题进行深入讲解，如基础操作、高级功能、数据处理等。 - **实践案例**：书中可能包含了大量的实践案例，帮助读者通过实际操作来加深理解。 - **练习与测试**：提供了一系列的练习题和模拟测试，帮助读者检验学习成果，更好地准备考试。《[Microsoft Press] MOS 2013 Study Guide for Microsoft Excel Expert》是一本全面覆盖Microsoft Excel 2013 功能及MOS 2013 Excel Expert 认证考试内容的学习指南。通过系统学习本书中的知识点，不仅可以提高Excel 技能水平，还能够有效准备并通过相应的认证考试。

资源详情

资源评论

MOS 2013 Study Guide Microsoft Word Exam 77-418

Advance your everyday skills with Word 2013.

And earn the credential that proves it!

Demonstrate your expertise with Microsoft Word! Designed to

help you practice and prepare for Microsoft Ofce Specialist (MOS):

Word 2013 certication, this ofcial Study Guide delivers:

•

In-depth preparation for each MOS objective

•

Detailed procedures to help build the skills measured by the exam

•

Hands-on tasks to practice what you’ve learned

•

Ready-made practice les

Sharpen the skills measured by these MOS exam

objectives:

•

Create and Manage Documents

•

Format Text, Paragraphs, and Sections

•

Create Tables and Lists

•

Apply References

•

Insert and Format Objects

Lambert

EXAM 77-418

About MOS

A Microsoft Ofce Specialist (MOS)

certication validates your prociency

with Microsoft Ofce programs,

demonstrating you can meet globally

recognized performance standards.

Hands-on experience with the tech-

nology is required to successfully pass

Microsoft Certication exams.

See full details at:

microsoft.com/learning/certication

Practice Files

Available at:

http://aka.ms/mosWord2013/les

MOS: Word 2013

microsoft.com/mspress

Certication/Microsoft Word

ISBN: 978-0-7356-6921-5

U.S.A. $19.99

Canada $20.99

[Recommended]

Microsoft

Excel Expert

EXAMS

77-427 & 77-428

Mark Dodge

MOS 2013

Study Guide

Celebrating 30 Years!

spine = .39”

iii

What do you think of this book? We want to hear from you!

Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for

you. To participate in a brief online survey, please visit:

microsoft.com/learning/booksurvey

Contents

Introduction ...............................................................vii

Who this book is for ......................................................vii

How this book is organized ................................................viii

Download the practice les ................................................viii

Sidebar: Adapting exercise steps........................................x

Ebook edition.............................................................xi

Get support and give feedback..............................................xi

Errata . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xi

We want to hear from you............................................xii

Stay in touch........................................................xii

Taking a Microsoft Ofce Specialist exam .....................................xiii

Microsoft Ofce Specialist certication ......................................xiii

Selecting a certication path...............................................xiii

Test-taking tips...........................................................xiv

Certication benets..................................................... xvi

For more information .................................................... xvi

Exams 77-427 and 77-428 Microsoft Excel 2013 Expert

Prerequisites..............................................................1

1 Manage and share workbooks 3

1.1 Manage multiple workbooks ............................................3

Modifying workbook templates ........................................4

Managing workbook versions ..........................................6

Copying styles between templates......................................7

Sidebar: Merging styles that have the same name ........................8

Copying macros between workbooks ...................................9

iv Contents

Connecting to external data ..........................................10

Sidebar: About the Excel Data Model...................................11

Sidebar: Editing formula links .........................................12

Practice tasks .......................................................15

1.2 Prepare workbooks for review..........................................16

Tracking changes ....................................................16

Sidebar: Setting tracking options ......................................16

Protecting workbooks for sharing .....................................19

Sidebar: Properties vs. metadata.......................................24

Practice tasks .......................................................29

1.3 Manage workbook changes............................................30

Displaying all changes................................................30

Reviewing changes ..................................................31

Managing comments ................................................32

Merging workbooks .................................................33

Identifying errors....................................................35

Troubleshooting by using tracing......................................37

Sidebar: Tracing formulas in separate worksheets ........................39

Practice tasks .......................................................40

Objective review .........................................................40

2 Apply custom formats and layouts 41

2.1 Apply custom data formats ............................................41

Creating custom formats (number, time, date)...........................42

Using advanced Fill Series options .....................................51

Practice tasks .......................................................54

2.2 Apply advanced conditional formatting and ltering ......................55

Creating custom conditional formats ..................................56

Using functions to format cells ........................................58

Creating advanced lters .............................................60

Sidebar: Managing conditional formatting rules .........................61

Practice tasks .......................................................63

2.3 Apply custom styles and templates .....................................63

Creating custom templates ...........................................63

Creating and modifying cell styles ....................................65

Creating custom color and font formats ...............................66

Creating themes.....................................................68

Contents v

Creating form elds..................................................70

Sidebar: Controlling the tab order of objects ............................73

Practice tasks .......................................................75

2.4 Prepare workbooks for internationalization and accessibility ...............76

Modifying worksheets for use with accessibility tools ....................76

Displaying data in multiple international formats ........................79

Sidebar: Proong in other languages ...................................80

Sidebar: Managing multiple options for body and heading fonts ..........83

Practice tasks .......................................................83

Objective review .........................................................84

3 Create advanced formulas 85

3.1 Apply functions in formulas ...........................................85

Using nested functions ..............................................87

Using the IF, AND, and OR functions ...................................87

Using the SUMIFS, AVERAGEIFS, and COUNTIFS functions ................88

Using nancial functions .............................................90

Practice tasks .......................................................95

3.2 Look up data by using functions .......................................96

Using the VLOOKUP and HLOOKUP functions ..........................96

Using the LOOKUP function ..........................................98

Using the TRANSPOSE function .......................................98

Practice tasks ......................................................100

3.3 Apply advanced date and time functions ...............................100

Using the NOW and TODAY functions ................................101

Using functions to serialize dates and times ...........................102

Sidebar: Concatenating text in formulas ...............................103

Practice tasks ......................................................105

3.4 Create scenarios .....................................................105

Using what-if analysis tools ..........................................106

Sidebar: Enabling iterative calculations ................................107

Sidebar: Using the watch window .....................................110

Using the Scenario Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .111

Sidebar: Merging scenarios ..........................................112

Consolidating data .................................................113

Practice tasks ......................................................117

Objective review ........................................................117

剩余183页未读，继续阅读

评论收藏

内容反馈

suggest147

2016-11-10

全英文版本，对于考取中文版本 MOS的朋友可能不太适用，作为参考补充还可以

[Microsoft Press] MOS 2013 Study Guide for Microsoft Excel Exper...

评论1

最新资源

[Microsoft Press] MOS 2013 Study Guide for Microsoft Excel Exper...

评论1

最新资源

相关推荐

MOS管资料汇编.pdf

MicrosoftExcel2013Tutorial.pdf 英文原版

MOS管全解析.pdf

[Excel] MOS 2013 Study Guide for Microsoft Excel Expert (英文版)

excel培训课件2013

Bernard Liengme A Guide to Microsoft Excel 2013 for Scientists and Engineers.pdf

《Microsoft Excel教程学习宝典》

Mos选型总结与归纳.pdf

Mos2013StudyGuideForMicrosoftPowerpoint.pdf 英文原版

Excel 2013教程光盘文件

Microsoft.Press.Microsoft.Excel.Data.Analysis.and.Business.Modeling.5th.pdf

Microsoft.Press.Microsoft.Visual.CSharp.2010.Step.by.Step.Mar.2010.pdf

Microsoft_Press_eBook_NET_Technology_Guide_for_Business_Applications.pdf

MOS管选型指南

MOS场效应管基本知识.pdf

Microsoft.Press.Developer's.Guide.to.Microsoft.Prism.4

IBM.Press.A.Practical.Guide.to.Trusted.Computing.pdf

Microsoft.Press.Microsoft.Excel.2010.Plain.and.Simple.Jun.2010.rar

Microsoft.Press.Developers.Guide.to.Microsoft.Enterprise.Library.5.CSharp.Edition.Aug.2010.rar

Microsoft.Press.Inside.Microsoft.SQL.Server.2008.T-SQL.Programming

Cisco.Press.CCNP.BCMSN.Official.Exam.Certification.Guide.4th.Edition.pdf

Cisco.Press.CCNP.ISCW.Official.Exam.Certification.Guide.1st.Edition.pdf

Cisco.Press.CCNP.ONT.Official.Exam.Certification.Guide.1st.Edition.pdf

Cisco.Press.Cisco.QOS.Exam.Certification.Guide.IP.Telephony.Self.Study

AZ-900 认证考试 422题

微软AZ-104认证习题修正版(含六月份新题)