Muutke küpsiste eelistusi

E-raamat: MOS Study Guide for Microsoft Excel Expert Exam MO-201

4.20/5 (20 hinnangut Goodreads-ist)
  • Formaat: 192 pages
  • Sari: MOS Study Guide
  • Ilmumisaeg: 06-Mar-2020
  • Kirjastus: Addison Wesley
  • Keel: eng
  • ISBN-13: 9780136627586
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 18,71 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
MOS Study Guide for Microsoft Excel Expert Exam MO-201Suurem pilt
  • Formaat: 192 pages
  • Sari: MOS Study Guide
  • Ilmumisaeg: 06-Mar-2020
  • Kirjastus: Addison Wesley
  • Keel: eng
  • ISBN-13: 9780136627586
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Advance your expert-level proficiency with Excel.

And earn the credential that proves it!











Demonstrate your expert-level competency with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Microsoft Excel Expert (Excel and Excel 2019) 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:









Manage Workbook Options and Settings



Manage and Format Data



Create Advanced Formulas and Macros



Manage Advanced Charts and Tables





About the MOS: Expert Certification

A Microsoft Office Specialist (MOS): Expert certification validates your hands-on experience and competency with an Office product at an expert level. It demonstrates that you can apply the products principal features at an advanced level, can complete expert tasks independently, and are ready to enter the job market.

 

See full details at: microsoft.com/learn

 

Practice Files

Available at: MicrosoftPressStore.com/ MOSExcelExpert201/downloads
Introduction vi
Exam MO-201 Excel 2019 Expert x
Prerequisites xi
1 Manage workbook options and settings
1(36)
Objective 1.1 Manage workbooks
2(13)
Copy macros between workbooks
2(2)
Enable macros in a workbook
4(2)
Reference data in another workbook
6(3)
Manage workbook versions
9(6)
Objective 1.2 Prepare workbooks for collaboration
15(16)
Restrict editing
15(2)
Protect worksheets and cell ranges
17(2)
Protect workbook structure
19(1)
Configure formula calculation options
20(5)
Manage comments
25(6)
Objective 1.3 Use and configure language options
31(6)
Configure authoring and display languages
31(2)
Use language-specific features
33(4)
2 Manage and format data
37(34)
Objective 2.1 Fill cells based on existing data
38(7)
Fill cells by using Flash Fill
38(3)
Fill cells by using advanced Fill Series options
41(4)
Objective 2.2 Format and validate data
45(17)
Create custom number formats
45(5)
Configure data validation
50(3)
Group and ungroup data
53(3)
Calculate data by inserting subtotals and totals
56(2)
Remove duplicate records
58(4)
Objective 2.3 Apply advanced conditional formatting and filtering
62(9)
Create custom conditional formatting rules
62(4)
Create conditional formatting rules that use formulas
66(1)
Manage conditional formatting rules
67(4)
3 Create advanced formulas and macros
71(62)
Objective 3.1 Perform logical operations in formulas
72(19)
Insert functions into a formula
72(1)
Perform logical operations by using the IF, AND, OR, and NOT functions
72(5)
Perform logical operations by using nested functions
77(1)
Perform multiple logical tests with the IFS function
78(1)
Perform logical operations with criteria
79(3)
Perform logical operations with multiple ranges and criteria
82(5)
Apply multiple exact-match criteria to a value
87(4)
Objective 3.2 Look up data by using functions
91(7)
Objective 3.3 Apply advanced date and time functions
98(8)
Reference the date and time by using the NOW and TODAY functions
98(2)
Serialize numbers by using date and time functions
100(6)
Objective 3.4 Perform data analysis
106(14)
Consolidate data
106(3)
Perform what-if analysis by using Goal Seek and Scenario Manager
109(5)
Calculate data by using financial functions
114(2)
Calculate data by using the NPER function
116(1)
Calculate data by using the PMT function
117(3)
Objective 3.5 Troubleshoot formulas
120(8)
Trace precedence and dependence
120(1)
Monitor cells and formulas by using the Watch Window
121(2)
Validate formulas by using error-checking rules
123(3)
Evaluate formulas
126(2)
Objective 3.6 Create and modify simple macros
128(5)
4 Manage advanced charts and tables
133(38)
Objective 4.1 Create and modify advanced charts
134(10)
Create dual-axis charts
134(1)
Create advanced chart types
135(9)
Objective 4.2 Create and modify PivotTables
144(20)
Create PivotTables
145(3)
Modify PivotTable field selections and options
148(3)
Create slicers
151(2)
Group PivotTable data
153(4)
Add calculated fields
157(3)
Format data
160(4)
Objective 4.3 Create and modify PivotCharts
164(7)
Create PivotCharts
164(2)
Manipulate options in existing PivotCharts
166(1)
Apply styles to PivotCharts
167(1)
Drill down into PivotChart details
168(3)
Index 171
Paul McFedries, a Microsoft Office expert and owner of the technical writing company Logophilia Limited, has authored nearly 100 books, including Microsoft Excel 2019 Formulas and Functions. Combined, his books have sold more than 4 million copies worldwide.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97801366275862e.html
Märksõnad: