Muutke küpsiste eelistusi

MOS 2016 Study Guide for Microsoft Excel Expert [Pehme köide]

4.22/5 (26 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 192 pages, kõrgus x laius x paksus: 226x188x10 mm, kaal: 300 g
  • Sari: MOS Study Guide
  • Ilmumisaeg: 13-Feb-2017
  • Kirjastus: Microsoft Press,U.S.
  • ISBN-10: 0735699429
  • ISBN-13: 9780735699427
Teised raamatud teemal:
MOS 2016 Study Guide for Microsoft Excel ExpertSuurem pilt
  • Formaat: Paperback / softback, 192 pages, kõrgus x laius x paksus: 226x188x10 mm, kaal: 300 g
  • Sari: MOS Study Guide
  • Ilmumisaeg: 13-Feb-2017
  • Kirjastus: Microsoft Press,U.S.
  • ISBN-10: 0735699429
  • ISBN-13: 9780735699427
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780735699427.html
Märksõnad:
Hone your advanced Excel 2016 skills. 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 Expert 2016 certification, this official 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 youve learned Ready-made practice files





Sharpen the skills measured by these objectives:









Create and Manage Workbooks Apply Custom Formatting and Layouts Create Advanced Formulas Perform Data Analysis Create Advanced Charts and PivotTables









 
Introduction vii
Taking a Microsoft Office Specialist exam xi
Exam 77-728 Excel 2016 Expert: Interpreting Data for Insights
1(1)
Prerequisites
2(1)
1 Manage workbook options and settings
3(28)
Objective 1.1 Manage workbooks
4(13)
Save a workbook as a template
4(1)
Hide or display ribbon tabs
5(1)
Enable macros in a workbook
6(2)
Copy macros between workbooks
8(2)
Reference data in another workbook
10(2)
Reference table data by using structured references
12(3)
Objective 1.1 Practice Tasks
15(2)
Objective 1.2 Manage workbook review
17(14)
Restrict editing
17(4)
Protect workbook structure
21(1)
Encrypt a workbook with a password
22(1)
Manage workbook versions
23(2)
Configure formula calculation options
25(4)
Objective 1.2 Practice tasks
29(2)
2 Apply custom data formats and layouts
31(40)
Objective 2.1 Apply custom data formats and validation
32(13)
Create custom data formats
32(4)
Populate cells by using advanced Fill Series options
36(2)
Configure data validation
38(5)
Objective 2.1 Practice Tasks
43(2)
Objective 2.2 Apply advanced conditional formatting and filtering
45(8)
Create custom conditional formatting rules
45(3)
Create conditional formatting rules that use formulas
48(1)
Manage conditional formatting rules
49(2)
Objective 2.2 Practice Tasks
51(2)
Objective 2.3 Create and modify custom workbook elements
53(15)
Create and modify cell styles
53(2)
Create custom themes and theme elements
55(6)
Create and modify simple macros
61(3)
Insert and configure form controls
64(3)
Objective 2.3 Practice Tasks
67(1)
Objective 2.4 Prepare a workbook for internationalization
68(3)
Objective 2.4 Practice Tasks
70(1)
3 Create advanced formulas
71(64)
Objective 3.1 Apply functions in formulas
72(10)
Insert functions into a formula
72(1)
Perform logical operations by using the IF, AND, OR, and NOT functions
72(4)
Perform logical operations by using nested functions
76(1)
Perform statistical operations by using the SUMIFS, AVERAGEIFS, and COUNTIFS functions
77(4)
Objective 3.1 Practice Tasks
81(1)
Objective 3.2 Look up data by using functions
82(7)
Objective 3.2 Practice Tasks
88(1)
Objective 3.3 Apply advanced date and time functions
89(8)
Reference the date and time by using the NOW and TODAY functions
89(2)
Serialize numbers by using date and time functions
91(5)
Objective 3.3 Practice Tasks
96(1)
Objective 3.4 Perform data analysis and business intelligence
97(24)
Import, transform, combine, display, and connect to data
97(6)
Consolidate data
103(4)
Perform what-if analysis by using Goal Seek and Scenario Manager
107(5)
Use cube functions to get data out of the Excel data model
112(4)
Calculate data by using financial functions
116(4)
Objective 3.4 Practice Tasks
120(1)
Objective 3.5 Troubleshoot formulas
121(8)
Trace precedence and dependence
121(1)
Monitor cells and formulas by using the Watch Window
122(2)
Validate formulas by using error-checking rules
124(3)
Evaluate formulas
127(1)
Objective 3.5 Practice Tasks
128(1)
Objective 3.6 Define named ranges and objects
129(6)
Name a cell or range
130(2)
Name a table
132(1)
Manage named ranges and objects
133(1)
Objective 3.6 Practice Tasks
134(1)
4 Create advanced charts and tables
135(34)
Objective 4.1 Create advanced charts
136(7)
Add trendlines to charts
136(3)
Create dual-axis charts
139(2)
Save a chart as a template
141(1)
Objective 4.1 Practice Tasks
142(1)
Objective 4.2 Create and manage PivotTables
143(20)
Create PivotTables
144(3)
Modify PivotTable field selections and options
147(3)
Create slicers
150(2)
Group PivotTable data
152(4)
Reference data in a PivotTable by using the GETPIVOTDATA function
156(2)
Add calculated fields
158(2)
Format data
160(2)
Objective 4.2 Practice Tasks
162(1)
Objective 4.3 Create and manage PivotCharts
163(6)
Create PivotCharts
163(2)
Modify PivotCharts
165(1)
Drill down into PivotChart details
166(2)
Objective 4.3 Practice Tasks
168(1)
Index 169(8)
About the author 177
Paul McFedries is a full-time technical author who has worked with computers in one form or another since 1975. He is the author of more than 90 computer books that have sold more than 4 million copies worldwide. His recent Office-related titles include My Office 2016, My Office 2016 for Mac, and Formulas and Functions for Microsoft Excel 2016. His other titles include Windows 10 In Depth, (with Brian Knittel), PCs for Grownups, and Fixing Your Computer Absolute Beginner's Guide.