MOS 2013 study guide for Microsoft Excel Expert: [Exams 77-427 & 77-428]
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Redmond, Wash.
Microsoft Press
2013
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis Klappentext |
| Beschreibung: | XVI, 165 S. Ill., graph. Darst. |
| ISBN: | 9780735669215 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV041822555 | ||
| 003 | DE-604 | ||
| 005 | 20150528 | ||
| 007 | t | ||
| 008 | 140430s2013 ad|| |||| 00||| eng d | ||
| 020 | |a 9780735669215 |c Print |9 978-0-7356-6921-5 | ||
| 035 | |a (OCoLC)892972572 | ||
| 035 | |a (DE-599)BVBBV041822555 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-703 |a DE-859 | ||
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 100 | 1 | |a Dodge, Mark |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a MOS 2013 study guide for Microsoft Excel Expert |b [Exams 77-427 & 77-428] |c Mark Dodge |
| 246 | 1 | 3 | |a Microsoft Excel Expert |
| 246 | 1 | 3 | |a Microsoft Office Specialist 2013 study guide for Microsoft Excel Expert |
| 264 | 1 | |a Redmond, Wash. |b Microsoft Press |c 2013 | |
| 300 | |a XVI, 165 S. |b Ill., graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) / Examinations / Study guides |
| 650 | 4 | |a Wirtschaft | |
| 650 | 4 | |a Microsoft software / Examinations / Study guides | |
| 650 | 4 | |a Business / Computer programs / Examinations / Study guides | |
| 650 | 0 | 7 | |a Excel 2013 |0 (DE-588)1031919325 |2 gnd |9 rswk-swf |
| 653 | |a Electronic books | ||
| 655 | 7 | |0 (DE-588)4143389-0 |a Aufgabensammlung |2 gnd-content | |
| 689 | 0 | 0 | |a Excel 2013 |0 (DE-588)1031919325 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m Digitalisierung UB Bayreuth - ADAM Catalogue Enrichment |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027267616&sequence=000003&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 856 | 4 | 2 | |m Digitalisierung UB Bayreuth - ADAM Catalogue Enrichment |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027267616&sequence=000004&line_number=0002&func_code=DB_RECORDS&service_type=MEDIA |3 Klappentext |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-027267616 | ||
Datensatz im Suchindex
| _version_ | 1804152153869123584 |
|---|---|
| adam_text | Contents
Introduction
...............................................................
vii
Who this book is for
......................................................
vii
How this book is organized
................................................viii
Download the practice files
................................................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 Office Specialist exam
.....................................xiii
Microsoft Office Specialist certification
......................................xiii
Selecting a certification path
...............................................xiii
Test-taking tips
...........................................................xiv
Certification benefits
.....................................................xvi
For more information
....................................................xvi
Exams
77-427
and
77-428
Microsoft
ЕХСЄІ
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
hr
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 filtering
......................55
Creating custom conditional formats
..................................56
Using functions to format cells
........................................58
Creating advanced filters
.............................................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
Creating form fields
..................................................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: Proofing 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 financial 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
.........................................
Ill
Sidebar: Merging scenarios
..........................................112
Consolidating data
.................................................113
Practice tasks
......................................................117
Objective review
.......................... —...................... —117
Contents
4
Create
advanced charts and tables
119
4.1
Create advanced chart elements
.......................................119
Adding trendlines to charts
.........................................120
Sidebar: Working with other elements
.................................122
Creating dual-axis charts
............................................123
Creating custom chart templates
.....................................127
Practice tasks
......................................................129
4.2
Create and manage PivotTables
.......................................129
Creating PivotTables
................................................129
Modifying field selections and options
................................134
Creating slicers
.....................................................137
Using PowerPivot
...................................................139
Practice tasks
......................................................148
4.3
Create and manage PivotCharts
.......................................148
Creating PivotCharts
................................................149
Sidebar Viewing chart animations
....................................150
Manipulating options in existing PivotCharts
..........................150
Applying styles to PivotCharts
.......................................152
Practice tasks
......................................................153
Objective review
........................................................153
Index
....................................................................155
About the author
.........................................................167
Survey page
..............................................................168
Advance your expert-level skills with Excel
2013.
And earn the credential that proves it!
Demonstrate your expertise with Microsoft Excel! Designed to
help you practice and prepare for Microsoft Office Specialist
(MOS):
Excel
2013
Expert certification, this official Study Guide delivers:
•
In-depth preparation for each
MOS
objective
•
Detailed procedures to help build the skills measured by the exams
•
Hands-on tasks to practice what you ve learned
•
Ready-made practice files
Sharpen the skills measured by these
MOS
exam
objectives:
•
Manage and Share Workbooks
•
Apply Custom Formats and Layouts
•
Create Advanced Formulas
•
Create Advanced Charts and Tables
Μ ι
с
roso
Office Specialist
EXAMS
77-427 & 77-428
About
MOS
A Microsoft Office Specialist
(MOS)
certification validates your proficiency
with Microsoft Office programs,
demonstrating you can meet globally
recognized performance standards.
About Excel Expert
certification
Expert-level candidates for Microsoft
Excel
2013
certification should know
and demonstrate the use of advanced
and specialized features in Excel
2013,
including managing, formatting,
populating, and enhancing workbooks
for common business scenarios. Two
exams are required:
77-427
and
77-428.
See full details at:
microsoft.com/learning/certification
Practice Files
Available at:
http://aka.ms/mosExcelExp2013/ftles
|
| any_adam_object | 1 |
| author | Dodge, Mark |
| author_facet | Dodge, Mark |
| author_role | aut |
| author_sort | Dodge, Mark |
| author_variant | m d md |
| building | Verbundindex |
| bvnumber | BV041822555 |
| classification_rvk | ST 371 |
| ctrlnum | (OCoLC)892972572 (DE-599)BVBBV041822555 |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01977nam a2200421zc 4500</leader><controlfield tag="001">BV041822555</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20150528 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">140430s2013 ad|| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780735669215</subfield><subfield code="c">Print</subfield><subfield code="9">978-0-7356-6921-5</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)892972572</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV041822555</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-703</subfield><subfield code="a">DE-859</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 371</subfield><subfield code="0">(DE-625)143672:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Dodge, Mark</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">MOS 2013 study guide for Microsoft Excel Expert</subfield><subfield code="b">[Exams 77-427 & 77-428]</subfield><subfield code="c">Mark Dodge</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Microsoft Excel Expert</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Microsoft Office Specialist 2013 study guide for Microsoft Excel Expert</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Redmond, Wash.</subfield><subfield code="b">Microsoft Press</subfield><subfield code="c">2013</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVI, 165 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file) / Examinations / Study guides</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Wirtschaft</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft software / Examinations / Study guides</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business / Computer programs / Examinations / Study guides</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Excel 2013</subfield><subfield code="0">(DE-588)1031919325</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Electronic books</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="0">(DE-588)4143389-0</subfield><subfield code="a">Aufgabensammlung</subfield><subfield code="2">gnd-content</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Excel 2013</subfield><subfield code="0">(DE-588)1031919325</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bayreuth - ADAM Catalogue Enrichment</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027267616&sequence=000003&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bayreuth - ADAM Catalogue Enrichment</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027267616&sequence=000004&line_number=0002&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Klappentext</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-027267616</subfield></datafield></record></collection> |
| genre | (DE-588)4143389-0 Aufgabensammlung gnd-content |
| genre_facet | Aufgabensammlung |
| id | DE-604.BV041822555 |
| illustrated | Illustrated |
| indexdate | 2024-07-10T01:06:11Z |
| institution | BVB |
| isbn | 9780735669215 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-027267616 |
| oclc_num | 892972572 |
| open_access_boolean | |
| owner | DE-703 DE-859 |
| owner_facet | DE-703 DE-859 |
| physical | XVI, 165 S. Ill., graph. Darst. |
| publishDate | 2013 |
| publishDateSearch | 2013 |
| publishDateSort | 2013 |
| publisher | Microsoft Press |
| record_format | marc |
| spelling | Dodge, Mark Verfasser aut MOS 2013 study guide for Microsoft Excel Expert [Exams 77-427 & 77-428] Mark Dodge Microsoft Excel Expert Microsoft Office Specialist 2013 study guide for Microsoft Excel Expert Redmond, Wash. Microsoft Press 2013 XVI, 165 S. Ill., graph. Darst. txt rdacontent n rdamedia nc rdacarrier Microsoft Excel (Computer file) / Examinations / Study guides Wirtschaft Microsoft software / Examinations / Study guides Business / Computer programs / Examinations / Study guides Excel 2013 (DE-588)1031919325 gnd rswk-swf Electronic books (DE-588)4143389-0 Aufgabensammlung gnd-content Excel 2013 (DE-588)1031919325 s DE-604 Digitalisierung UB Bayreuth - ADAM Catalogue Enrichment application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027267616&sequence=000003&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis Digitalisierung UB Bayreuth - ADAM Catalogue Enrichment application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027267616&sequence=000004&line_number=0002&func_code=DB_RECORDS&service_type=MEDIA Klappentext |
| spellingShingle | Dodge, Mark MOS 2013 study guide for Microsoft Excel Expert [Exams 77-427 & 77-428] Microsoft Excel (Computer file) / Examinations / Study guides Wirtschaft Microsoft software / Examinations / Study guides Business / Computer programs / Examinations / Study guides Excel 2013 (DE-588)1031919325 gnd |
| subject_GND | (DE-588)1031919325 (DE-588)4143389-0 |
| title | MOS 2013 study guide for Microsoft Excel Expert [Exams 77-427 & 77-428] |
| title_alt | Microsoft Excel Expert Microsoft Office Specialist 2013 study guide for Microsoft Excel Expert |
| title_auth | MOS 2013 study guide for Microsoft Excel Expert [Exams 77-427 & 77-428] |
| title_exact_search | MOS 2013 study guide for Microsoft Excel Expert [Exams 77-427 & 77-428] |
| title_full | MOS 2013 study guide for Microsoft Excel Expert [Exams 77-427 & 77-428] Mark Dodge |
| title_fullStr | MOS 2013 study guide for Microsoft Excel Expert [Exams 77-427 & 77-428] Mark Dodge |
| title_full_unstemmed | MOS 2013 study guide for Microsoft Excel Expert [Exams 77-427 & 77-428] Mark Dodge |
| title_short | MOS 2013 study guide for Microsoft Excel Expert |
| title_sort | mos 2013 study guide for microsoft excel expert exams 77 427 77 428 |
| title_sub | [Exams 77-427 & 77-428] |
| topic | Microsoft Excel (Computer file) / Examinations / Study guides Wirtschaft Microsoft software / Examinations / Study guides Business / Computer programs / Examinations / Study guides Excel 2013 (DE-588)1031919325 gnd |
| topic_facet | Microsoft Excel (Computer file) / Examinations / Study guides Wirtschaft Microsoft software / Examinations / Study guides Business / Computer programs / Examinations / Study guides Excel 2013 Aufgabensammlung |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027267616&sequence=000003&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027267616&sequence=000004&line_number=0002&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT dodgemark mos2013studyguideformicrosoftexcelexpertexams7742777428 AT dodgemark microsoftexcelexpert AT dodgemark microsoftofficespecialist2013studyguideformicrosoftexcelexpert |