57,10 €*
Versandkostenfrei per Post / DHL
Lieferzeit 1-2 Wochen
As Microsoft Office becomes ever more ubiquitous in modern offices across the world, competence and familiarity with its intricacies is more important than ever. Now you can set yourself apart from the pack and prove your skills with the Microsoft Office Specialist certification.
The MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide : Word Associate Exam MO-100, Excel Associate Exam MO-200, and PowerPoint Associate Exam MO-300 delivers a comprehensive roadmap to achieving the certification with easy-to-follow instruction for each of the three required proficiencies: Word, Excel, and PowerPoint. You'll enjoy access to chapter review questions and Exam Essentials, a feature that identifies critical subject areas.
Discover practical, hands-on exercises that prepare you for real-world roles and jobs, and gain valuable experience as you reinforce key Microsoft Office skills that you'll be expected to demonstrate in job interviews and your day-to-day professional life. Learn to manage and create text documents in Word, perform operations with formulas in Excel, and create engaging slideshows and presentations in PowerPoint.
This practical book also provides:
* Fully updated information for the latest Microsoft Office Specialist certification exams covering Microsoft Office 365
* Access to new career opportunities with a professional certification that's relevant to virtually any office environment
* Access to the Sybex online study tools, with chapter review questions, full-length practice exams, hundreds of electronic flashcards, and a glossary of key terms
The MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide offers crystal-clear organization, comprehensive coverage, and easy-to-understand instruction. It's perfect for anyone who hopes to prove their skills with the Microsoft Office Specialist certification or to improve their mastery of Microsoft Office 365.
As Microsoft Office becomes ever more ubiquitous in modern offices across the world, competence and familiarity with its intricacies is more important than ever. Now you can set yourself apart from the pack and prove your skills with the Microsoft Office Specialist certification.
The MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide : Word Associate Exam MO-100, Excel Associate Exam MO-200, and PowerPoint Associate Exam MO-300 delivers a comprehensive roadmap to achieving the certification with easy-to-follow instruction for each of the three required proficiencies: Word, Excel, and PowerPoint. You'll enjoy access to chapter review questions and Exam Essentials, a feature that identifies critical subject areas.
Discover practical, hands-on exercises that prepare you for real-world roles and jobs, and gain valuable experience as you reinforce key Microsoft Office skills that you'll be expected to demonstrate in job interviews and your day-to-day professional life. Learn to manage and create text documents in Word, perform operations with formulas in Excel, and create engaging slideshows and presentations in PowerPoint.
This practical book also provides:
* Fully updated information for the latest Microsoft Office Specialist certification exams covering Microsoft Office 365
* Access to new career opportunities with a professional certification that's relevant to virtually any office environment
* Access to the Sybex online study tools, with chapter review questions, full-length practice exams, hundreds of electronic flashcards, and a glossary of key terms
The MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide offers crystal-clear organization, comprehensive coverage, and easy-to-understand instruction. It's perfect for anyone who hopes to prove their skills with the Microsoft Office Specialist certification or to improve their mastery of Microsoft Office 365.
ABOUT THE AUTHOR
ERIC BUTOW is the author of 41 books on technology topics and has developed and taught networking, computing, and usability courses for Ed2Go, Virtual Training Company, California State University, Sacramento, and Udemy. He has been using Office since 1994. He's served as a technical writer for companies like Intel, Wells Fargo, Cisco Systems, and Hewlett-Packard. He is the founder and owner of Butow Communications Group in Jackson, California.
Introduction xxi
Assessment Test xxviii
Answers to Assessment Test xl
Part I Word Exam MO-100 1
Chapter 1 Working with Documents 3
Navigating Within Documents 4
Searching for Text 4
Linking to Locations Within Documents 8
Moving to Specific Locations and Objects in Documents 9
Showing and Hiding Formatting Symbols and Hidden Text 10
Formatting Documents 13
Setting Up Document Pages 14
Applying Style Settings 15
Inserting and Modifying Headers and Footers 17
Configuring Page Background Elements 18
Saving and Sharing Documents 20
Saving Documents in Alternative File Formatting 20
Changing Basic Document Properties 21
Modifying Print Settings 23
Sharing Documents Electronically 24
Inspecting Documents for Issues 26
Locating and Removing Hidden Properties and Personal Information 26
Finding and Fixing Accessibility Issues 28
Locating and Correcting Compatibility Issues 29
Summary 30
Key Terms 31
Exam Essentials 31
Review Questions 33
Chapter 2 Inserting and Formatting Text 35
Adding and Replacing Text 36
Finding and Replacing Text 36
Inserting Symbols and Special Characters 40
Formatting Text and Paragraphs 42
Adding Text Effects 42
Applying Formatting by Using Format Painter 43
Setting Line and Paragraph Spacing and Indentation 43
Applying Built-In Styles to Text 46
Clearing Formatting 47
Creating and Configuring Document Sections 50
Formatting Text in Multiple Columns 50
Inserting Page, Section, and Column Breaks 52
Changing Page Setting Options for a Section 53
Summary 56
Key Terms 57
Exam Essentials 57
Review Questions 58
Chapter 3 Managing Tables and Lists 61
Creating Tables 62
Converting Text to Tables 64
Switching Tables to Text 65
Creating Tables by Specifying Rows and Columns 66
Modifying Tables 68
Sorting Table Data 68
Configuring Cell Margins and Spacing 70
Merging and Splitting Cells 73
Resizing Tables, Rows, and Columns 75
Splitting Tables 80
Configuring a Repeating Row Header 82
Creating and Formatting Lists 85
Structuring Paragraphs as Numbered and Bulleted Lists 85
Changing Bullet Characters and Number Formatting 86
Defining Custom Bullet Characters and Number Formatting 88
Increasing and Decreasing List Levels 91
Restarting and Continuing List Numbering 92
Setting Starting Number Values 94
Summary 95
Key Terms 96
Exam Essentials 96
Review Questions 97
Chapter 4 Building References 99
Creating and Managing Referencing Elements 100
Inserting Footnotes and Endnotes 100
Modifying Footnote and Endnote Properties 103
Creating and Modifying Bibliography Citation Sources 104
Inserting Citations for Bibliographies 107
Working with Referencing Tables 109
Inserting Tables of Contents 109
Customizing Tables of Contents 110
Adding Bibliographies 112
Summary 113
Key Terms 113
Exam Essentials 114
Review Questions 115
Chapter 5 Adding and Formatting Graphic Elements 117
Inserting Illustrations and Text Boxes 118
Adding Shapes 118
Including Pictures 120
Inserting 3D Models 121
Adding SmartArt Graphics 122
Placing Screenshots and Screen Clippings 123
Inserting Text Boxes 125
Formatting Illustrations and Text Boxes 127
Applying Artistic Effects 127
Adding Picture Effects and Picture Styles 128
Removing Picture Backgrounds 131
Formatting Graphic Elements 132
Setting Up SmartArt Graphics 134
Working with 3D Models 136
Adding and Organizing Text 137
Formatting Text in Text Boxes 137
Adding Text in Shapes 139
Changing SmartArt Graphic Content 141
Modifying Graphic Elements 142
Positioning Objects 142
Wrapping Text Around Objects 143
Adding Alt Text to Objects 146
Summary 148
Key Terms 148
Exam Essentials 148
Review Questions 149
Chapter 6 Working with Other Users on Your Document 151
Adding Comments 152
Inserting Comments 152
Reviewing and Replying to Comments 153
Resolving Comments 154
Deleting Comments 155
Tracking Your Changes 157
Turning On Track Changes 157
Reviewing Tracked Changes 158
Accepting and Rejecting Tracked Changes 159
Locking and Unlocking Change Tracking 162
Summary 165
Key Terms 165
Exam Essentials 165
Review Questions 166
Part II Excel Exam MO-200 169
Chapter 7 Managing Worksheets and Workbooks 171
Importing Data into Workbooks 172
Bringing in Data from TXT Files 173
Importing Data from CSV Files 174
Navigating Within Workbooks 178
Searching for Data Within a Workbook 178
Navigating to Named Cells, Ranges, or Workbook Elements 180
Inserting and Removing Hyperlinks 182
Formatting Worksheets and Workbooks 190
Modifying Page Settings 190
Adjusting Row Height and Column Width 192
Customizing Headers and Footers 200
Customizing Options and Views 206
Customizing the Quick Access Toolbar 207
Displaying and Modifying Workbook Content in Different Views 211
Freezing Worksheet Rows and Columns 214
Changing Window Views 216
Modifying Basic Workbook Properties 218
Displaying Formulas 219
Configuring Content for Collaboration 222
Setting a Print Area 222
Saving Workbooks in Other File Formats 224
Configuring Print Settings 224
Inspecting Workbooks for Issues 225
Summary 229
Key Terms 229
Exam Essentials 229
Review Questions 231
Chapter 8 Using Data Cells and Ranges 233
Manipulating Data in Worksheets 234
Pasting Data by Using Special Paste Options 234
Filling Cells by Using Auto Filling 238
Inserting and Deleting Multiple Columns or Rows 240
Adding and Removing Cells 242
Formatting Cells and Ranges 245
Merging and Unmerging Cells 245
Modifying Cell Alignment, Orientation, and Indentation 246
Formatting Cells by Using Format Painter 249
Wrapping Text Within Cells 250
Using Number Formatting 252
Applying Cell Formatting from the Format Cells Dialog Box 253
Working with Cell Styles 254
Clearing Cell Formatting 256
Defining and Referencing Named Ranges 258
Defining a Named Range 258
Naming a Table 263
Summarizing Data Visually 265
Inserting Sparklines 265
Applying Built-In Conditional Formatting 269
Removing Conditional Formatting 271
Summary 275
Key Terms 275
Exam Essentials 275
Review Questions 277
Chapter 9 Working with Tables and Table Data 279
Creating and Formatting Tables 280
Creating Excel Tables from Cell Ranges 280
Applying Table Styles 282
Converting Tables to Cell Ranges 283
Modifying Tables 285
Adding or Remove Table Rows and Columns 285
Configuring Table Style Options 288
Inserting and Configuring Total Rows 289
Filtering and Sorting Table Data 292
Filtering Records 292
Sorting Data by Multiple Columns 296
Summary 298
Key Terms 299
Exam Essentials 299
Review Questions 300
Chapter 10 Performing Operations by Using Formulas and Functions 303
Inserting References 304
Inserting Relative, Absolute, and Mixed References 305
Referencing Named Ranges and Named Tables in Formulas 307
Calculating and Transforming Datas 310
Performing Calculations Using the AVERAGE(), MAX(), MIN(), and SUM() Functions 310
Perform Conditional Operations by Using the IF() Function 321
Formatting and Modifying Text 325
Formatting Text Using the RIGHT(), LEFT(), and MID() Functions 325
Formatting Text Using the UPPER(), LOWER(), and LEN() Functions 329
Formatting Text Using the CONCAT() and TEXTJOIN() Functions 333
Summary 336
Key Terms 337
Exam Essentials 337
Review Questions 338
Chapter 11 Managing Charts 341
Creating Charts 342
Building Charts 342
Working with Chart Sheets 344
Modifying Charts 348
Adding Data Series to Charts 348
Switching Between Rows and Columns in Source Data 351
Adding and Modifying Chart Elements 352
Formatting Charts 355
Using Chart Layouts 356
Applying Chart Styles 364
Adding Alternative Text to Charts for Accessibility 366
Summary 368
Key Terms 368
Exam Essentials 369
Review Questions 370
Part III PowerPoint Exam MO-300 373
Chapter 12 Creating Presentations 375
Modifying Slide Masters, Handout Masters, and Note Masters 377
Changing the Slide Master Theme or Background 378
Modifying Slide Master Content 383
Creating Slide Layouts 384
Modify Slide Layouts 389
Modifying the Handout Master 393
Modifying the Notes Master 400
Changing Presentation Options and Views 406
Changing the Slide Size 406
Displaying Presentations in Different Views 408
Setting Basic File Properties 410
Configuring Print Settings for Presentations 411
Printing All or Part of a...
| Erscheinungsjahr: | 2021 |
|---|---|
| Fachbereich: | Anwendungs-Software |
| Genre: | Importe, Informatik |
| Rubrik: | Naturwissenschaften & Technik |
| Medium: | Taschenbuch |
| Inhalt: | 704 S. |
| ISBN-13: | 9781119718499 |
| ISBN-10: | 111971849X |
| Sprache: | Englisch |
| Einband: | Kartoniert / Broschiert |
| Autor: | Butow, Eric |
| Hersteller: | Wiley |
| Maße: | 234 x 185 x 38 mm |
| Von/Mit: | Eric Butow |
| Erscheinungsdatum: | 29.06.2021 |
| Gewicht: | 1,179 kg |
ABOUT THE AUTHOR
ERIC BUTOW is the author of 41 books on technology topics and has developed and taught networking, computing, and usability courses for Ed2Go, Virtual Training Company, California State University, Sacramento, and Udemy. He has been using Office since 1994. He's served as a technical writer for companies like Intel, Wells Fargo, Cisco Systems, and Hewlett-Packard. He is the founder and owner of Butow Communications Group in Jackson, California.
Introduction xxi
Assessment Test xxviii
Answers to Assessment Test xl
Part I Word Exam MO-100 1
Chapter 1 Working with Documents 3
Navigating Within Documents 4
Searching for Text 4
Linking to Locations Within Documents 8
Moving to Specific Locations and Objects in Documents 9
Showing and Hiding Formatting Symbols and Hidden Text 10
Formatting Documents 13
Setting Up Document Pages 14
Applying Style Settings 15
Inserting and Modifying Headers and Footers 17
Configuring Page Background Elements 18
Saving and Sharing Documents 20
Saving Documents in Alternative File Formatting 20
Changing Basic Document Properties 21
Modifying Print Settings 23
Sharing Documents Electronically 24
Inspecting Documents for Issues 26
Locating and Removing Hidden Properties and Personal Information 26
Finding and Fixing Accessibility Issues 28
Locating and Correcting Compatibility Issues 29
Summary 30
Key Terms 31
Exam Essentials 31
Review Questions 33
Chapter 2 Inserting and Formatting Text 35
Adding and Replacing Text 36
Finding and Replacing Text 36
Inserting Symbols and Special Characters 40
Formatting Text and Paragraphs 42
Adding Text Effects 42
Applying Formatting by Using Format Painter 43
Setting Line and Paragraph Spacing and Indentation 43
Applying Built-In Styles to Text 46
Clearing Formatting 47
Creating and Configuring Document Sections 50
Formatting Text in Multiple Columns 50
Inserting Page, Section, and Column Breaks 52
Changing Page Setting Options for a Section 53
Summary 56
Key Terms 57
Exam Essentials 57
Review Questions 58
Chapter 3 Managing Tables and Lists 61
Creating Tables 62
Converting Text to Tables 64
Switching Tables to Text 65
Creating Tables by Specifying Rows and Columns 66
Modifying Tables 68
Sorting Table Data 68
Configuring Cell Margins and Spacing 70
Merging and Splitting Cells 73
Resizing Tables, Rows, and Columns 75
Splitting Tables 80
Configuring a Repeating Row Header 82
Creating and Formatting Lists 85
Structuring Paragraphs as Numbered and Bulleted Lists 85
Changing Bullet Characters and Number Formatting 86
Defining Custom Bullet Characters and Number Formatting 88
Increasing and Decreasing List Levels 91
Restarting and Continuing List Numbering 92
Setting Starting Number Values 94
Summary 95
Key Terms 96
Exam Essentials 96
Review Questions 97
Chapter 4 Building References 99
Creating and Managing Referencing Elements 100
Inserting Footnotes and Endnotes 100
Modifying Footnote and Endnote Properties 103
Creating and Modifying Bibliography Citation Sources 104
Inserting Citations for Bibliographies 107
Working with Referencing Tables 109
Inserting Tables of Contents 109
Customizing Tables of Contents 110
Adding Bibliographies 112
Summary 113
Key Terms 113
Exam Essentials 114
Review Questions 115
Chapter 5 Adding and Formatting Graphic Elements 117
Inserting Illustrations and Text Boxes 118
Adding Shapes 118
Including Pictures 120
Inserting 3D Models 121
Adding SmartArt Graphics 122
Placing Screenshots and Screen Clippings 123
Inserting Text Boxes 125
Formatting Illustrations and Text Boxes 127
Applying Artistic Effects 127
Adding Picture Effects and Picture Styles 128
Removing Picture Backgrounds 131
Formatting Graphic Elements 132
Setting Up SmartArt Graphics 134
Working with 3D Models 136
Adding and Organizing Text 137
Formatting Text in Text Boxes 137
Adding Text in Shapes 139
Changing SmartArt Graphic Content 141
Modifying Graphic Elements 142
Positioning Objects 142
Wrapping Text Around Objects 143
Adding Alt Text to Objects 146
Summary 148
Key Terms 148
Exam Essentials 148
Review Questions 149
Chapter 6 Working with Other Users on Your Document 151
Adding Comments 152
Inserting Comments 152
Reviewing and Replying to Comments 153
Resolving Comments 154
Deleting Comments 155
Tracking Your Changes 157
Turning On Track Changes 157
Reviewing Tracked Changes 158
Accepting and Rejecting Tracked Changes 159
Locking and Unlocking Change Tracking 162
Summary 165
Key Terms 165
Exam Essentials 165
Review Questions 166
Part II Excel Exam MO-200 169
Chapter 7 Managing Worksheets and Workbooks 171
Importing Data into Workbooks 172
Bringing in Data from TXT Files 173
Importing Data from CSV Files 174
Navigating Within Workbooks 178
Searching for Data Within a Workbook 178
Navigating to Named Cells, Ranges, or Workbook Elements 180
Inserting and Removing Hyperlinks 182
Formatting Worksheets and Workbooks 190
Modifying Page Settings 190
Adjusting Row Height and Column Width 192
Customizing Headers and Footers 200
Customizing Options and Views 206
Customizing the Quick Access Toolbar 207
Displaying and Modifying Workbook Content in Different Views 211
Freezing Worksheet Rows and Columns 214
Changing Window Views 216
Modifying Basic Workbook Properties 218
Displaying Formulas 219
Configuring Content for Collaboration 222
Setting a Print Area 222
Saving Workbooks in Other File Formats 224
Configuring Print Settings 224
Inspecting Workbooks for Issues 225
Summary 229
Key Terms 229
Exam Essentials 229
Review Questions 231
Chapter 8 Using Data Cells and Ranges 233
Manipulating Data in Worksheets 234
Pasting Data by Using Special Paste Options 234
Filling Cells by Using Auto Filling 238
Inserting and Deleting Multiple Columns or Rows 240
Adding and Removing Cells 242
Formatting Cells and Ranges 245
Merging and Unmerging Cells 245
Modifying Cell Alignment, Orientation, and Indentation 246
Formatting Cells by Using Format Painter 249
Wrapping Text Within Cells 250
Using Number Formatting 252
Applying Cell Formatting from the Format Cells Dialog Box 253
Working with Cell Styles 254
Clearing Cell Formatting 256
Defining and Referencing Named Ranges 258
Defining a Named Range 258
Naming a Table 263
Summarizing Data Visually 265
Inserting Sparklines 265
Applying Built-In Conditional Formatting 269
Removing Conditional Formatting 271
Summary 275
Key Terms 275
Exam Essentials 275
Review Questions 277
Chapter 9 Working with Tables and Table Data 279
Creating and Formatting Tables 280
Creating Excel Tables from Cell Ranges 280
Applying Table Styles 282
Converting Tables to Cell Ranges 283
Modifying Tables 285
Adding or Remove Table Rows and Columns 285
Configuring Table Style Options 288
Inserting and Configuring Total Rows 289
Filtering and Sorting Table Data 292
Filtering Records 292
Sorting Data by Multiple Columns 296
Summary 298
Key Terms 299
Exam Essentials 299
Review Questions 300
Chapter 10 Performing Operations by Using Formulas and Functions 303
Inserting References 304
Inserting Relative, Absolute, and Mixed References 305
Referencing Named Ranges and Named Tables in Formulas 307
Calculating and Transforming Datas 310
Performing Calculations Using the AVERAGE(), MAX(), MIN(), and SUM() Functions 310
Perform Conditional Operations by Using the IF() Function 321
Formatting and Modifying Text 325
Formatting Text Using the RIGHT(), LEFT(), and MID() Functions 325
Formatting Text Using the UPPER(), LOWER(), and LEN() Functions 329
Formatting Text Using the CONCAT() and TEXTJOIN() Functions 333
Summary 336
Key Terms 337
Exam Essentials 337
Review Questions 338
Chapter 11 Managing Charts 341
Creating Charts 342
Building Charts 342
Working with Chart Sheets 344
Modifying Charts 348
Adding Data Series to Charts 348
Switching Between Rows and Columns in Source Data 351
Adding and Modifying Chart Elements 352
Formatting Charts 355
Using Chart Layouts 356
Applying Chart Styles 364
Adding Alternative Text to Charts for Accessibility 366
Summary 368
Key Terms 368
Exam Essentials 369
Review Questions 370
Part III PowerPoint Exam MO-300 373
Chapter 12 Creating Presentations 375
Modifying Slide Masters, Handout Masters, and Note Masters 377
Changing the Slide Master Theme or Background 378
Modifying Slide Master Content 383
Creating Slide Layouts 384
Modify Slide Layouts 389
Modifying the Handout Master 393
Modifying the Notes Master 400
Changing Presentation Options and Views 406
Changing the Slide Size 406
Displaying Presentations in Different Views 408
Setting Basic File Properties 410
Configuring Print Settings for Presentations 411
Printing All or Part of a...
| Erscheinungsjahr: | 2021 |
|---|---|
| Fachbereich: | Anwendungs-Software |
| Genre: | Importe, Informatik |
| Rubrik: | Naturwissenschaften & Technik |
| Medium: | Taschenbuch |
| Inhalt: | 704 S. |
| ISBN-13: | 9781119718499 |
| ISBN-10: | 111971849X |
| Sprache: | Englisch |
| Einband: | Kartoniert / Broschiert |
| Autor: | Butow, Eric |
| Hersteller: | Wiley |
| Maße: | 234 x 185 x 38 mm |
| Von/Mit: | Eric Butow |
| Erscheinungsdatum: | 29.06.2021 |
| Gewicht: | 1,179 kg |
Ähnliche Produkte
Lieferzeit 1-2 Wochen
Lieferzeit 1-2 Wochen
Lieferzeit 1-2 Wochen
Lieferzeit 1-2 Werktage
Lieferzeit 1-2 Wochen
Lieferzeit 1-2 Werktage
