Atjauninât sîkdatòu piekriðanu

Illustrated Series® Collection, Microsoft® 365® & Office® 2021 Intermediate 2nd Revised edition [Mîkstie vâki]

(Johnson County Community College), (NA), (NA), (NA), (Capilano College)
  • Formâts: Paperback / softback, 496 pages, height x width x depth: 30x210x271 mm, weight: 1133 g
  • Izdoðanas datums: 23-Sep-2022
  • Izdevniecîba: Course Technology Inc
  • ISBN-10: 0357674960
  • ISBN-13: 9780357674963
Citas grâmatas par ðo tçmu:
  • Mîkstie vâki
  • Cena: 69,77 €*
  • * ði ir gala cena, t.i., netiek piemçrotas nekâdas papildus atlaides
  • Standarta cena: 87,22 €
  • Ietaupiet 20%
  • Grâmatu piegâdes laiks ir 3-4 nedçïas, ja grâmata ir uz vietas izdevniecîbas noliktavâ. Ja izdevçjam nepiecieðams publicçt jaunu tirâþu, grâmatas piegâde var aizkavçties.
  • Daudzums:
  • Ielikt grozā
  • Piegâdes laiks - 4-6 nedçïas
  • Pievienot vçlmju sarakstam
Illustrated Series® Collection, Microsoft® 365® & Office® 2021 Intermediate 2nd Revised editionPalielinât
  • Formâts: Paperback / softback, 496 pages, height x width x depth: 30x210x271 mm, weight: 1133 g
  • Izdoðanas datums: 23-Sep-2022
  • Izdevniecîba: Course Technology Inc
  • ISBN-10: 0357674960
  • ISBN-13: 9780357674963
Citas grâmatas par ðo tçmu:
Permanent link: https://www.kriso.lv/db/9780357674963.html
Keywords:
Including the latest Microsoft 365 features and enhanced support for Mac users, Cengage's Illustrated Series® Collection, Microsoft® 365® & Office® 2021 Intermediate, 2nd edition, helps you quickly master the nuances of Microsoft® Office. Its concise, student-friendly approach uses a proven two-page layout that allows you to work through an entire task without turning the page. Each module begins with a brief overview of the principles covered while large, full-color screen images illustrate what you see on your computer. Module Learning Objectives are mapped to Microsoft Office Specialist (MOS) certification objectives, and module scenarios are based on Burning Glass market insights data -- helping you sharpen the critical skills you need for real-world success. In addition, MindTap and SAM (Skills Assessment Manager) online resources help maximize your study time -- and results.
Getting to Know Microsoft Office Versions 1(1)
Using SAM Projects and Textbook Projects 1(1)
Word 2021
Module 4 Formatting Tables and Documents
1(1)
Modify Character Spacing
2(2)
Researching job roles and job skills with the Resume Assistant Work with Indents
4(2)
Creating multilevel lists Insert a Section Break
6(2)
Using sections to vary the layout of a document Insert a Section Break (Continued)
8(2)
Adding a custom header or footer to the gallery Modify a Table
10(2)
Copying and moving rows and columns Modify Rows and Columns
12(2)
Setting advanced table properties Sort Table Data
14(2)
Sorting lists and paragraphs Split and Merge Cells
16(2)
Changing cell margins Using tables to lay out a page Perform Calculations in Tables
18(2)
Working with formulas Modify Table Style Options
20(2)
Customize a Table Format
22(2)
Drawing a table Insert a Cover Page
24(2)
Practice
26
Module 5 Working with Styles, Themes, and Building Blocks
1(1)
Add Hyperlinks
2(2)
Sharing documents from Word and checking compatibility Modify Page Margins
4(2)
Changing vertical alignment Create Paragraph Styles
6(2)
Saving a document as a webpage Format with Themes
8(2)
Changing the style set Changing the default theme Customize a Theme
10(2)
Insert Quick Parts
12(2)
Creating customized bullet characters Create Building Blocks
14(2)
Inserting icons in a document Create Building Blocks (continued)
16(2)
Renaming a building block and editing other properties Insert Building Blocks
18(2)
Use a Document Template
20(2)
Work with PDF Files in Word
22(2)
Opening non-native files directly in Word Practice
24
Module 6 Merging Word Documents
1(1)
Understand Mail Merge
2(4)
Create a Main Document WD
6(1)
Using a mail merge template Design a Data Source
6(2)
Merging with an Outlook data source Enter and Edit Records
8(2)
Add Merge Fields
10(2)
Matching fields Work with Merge Rules
12(2)
Merge Data
14(2)
Opening Merge Files Create Labels
16(2)
Printing individual envelopes and labels Sort and Filter Records
18(2)
Inserting individual merge fields Practice
20
Module 7 Illustrating Documents with Graphics
1(1)
Use the Office Clipboard
2(2)
Use the Office Clipboard (Continued)
4(2)
Create Sections and Columns
6(2)
Changing page layout settings for a section Create SmartArt Graphics
8(2)
Inserting a picture into a SmartArt shape Modify SmartArt Graphics
10(2)
Crop and Rotate a Picture
12(2)
Position a Graphic
14(2)
Position a Graphic (Continued)
16(2)
Inserting and Editing 3D Models Create WordArt
18(2)
Create a Text Box
20(2)
Linking text boxes Insert a Word File
22(2)
Configuring line numbers Inserting online videos and online pictures in a document Practice
24
Excel 2021
Module 5 Working with Tables
1(1)
Create and Format a Table
2(2)
Changing table style options Add and Delete Table Data
4(2)
Selecting table elements Sort Table Data
6(2)
Sorting conditional formatted data Specifying a custom sort order Use Formulas in a Table
8(2)
Filter a Table
10(2)
Using an advanced filter Look Up Values in a Table
12(2)
Using other LOOKUP functions Summarize Table Data
14(2)
Validate Table Data
16(2)
Restricting cell values and data length Adding input messages and error alerts Practice
18
Module 6 Managing Workbook Data
1(1)
View and Arrange Worksheets
2(2)
Splitting the worksheet into multiple panes Protect Worksheets and Workbooks
4(2)
Creating edit ranges Freezing rows and columns Save Custom Views of a Worksheet
6(2)
Using Page Break Preview Prepare a Workbook for Distribution
8(2)
Adding a worksheet background Insert Hyperlinks
10(2)
Save a Workbook for Distribution
12(2)
Exporting a workbook to other file types Work with Grouped Data
14(2)
Creating Subtotals Work with Grouped Worksheets
16(2)
Practice
18
Module 7 Working with Images and Integrating with Other Programs
1(1)
Plan a Data Exchange
2(2)
Import a Text File
4(2)
Importing text files using the Text Import Wizard Import Data from Another Workbook
6(2)
Converting text to columns Import a Database Table
8(2)
Link Worksheet Data to a Word Document
10(2)
Managing and breaking links Link an Excel Chart to a PowerPoint Slide
12(2)
Import Excel Data into Access
14(2)
Adding SmartArt graphics Insert a Graphic File in a Worksheet
16(2)
Working with SmartArt graphics Practice
18
Module 8 Analyzing Data with PivotTables
1(1)
Plan and Design a PivotTable Report
2(2)
Create a PivotTable Report
4(2)
Changing a PivotTable layout Change a PivotTable's Summary Function and Design
6(2)
Using the Show buttons Filter PivotTable Data
8(2)
Filtering PivotTables using multiple values Explore PivotTable Data Relationships
10(2)
Grouping PivotTable data Create a PivotChart Report
12(2)
Update a PivotTable Report
14(2)
Adding a calculated field to a PivotTable and a PivotChart Use the GETPIVOTDATA Function
16(2)
Practice
18
Integration
Module 4 Integrating Word and Excel
1(1)
Use Paste Special to Modify Formatting
2(2)
Create a Hyperlink Between Word and Excel
4(2)
Editing and removing a hyperlink Create an Excel Spreadsheet in Word
6(2)
Embed an Excel File in Word
8(2)
Formatting pasted, embedded, and linked objects Change Link Sources
10(2)
Reestablishing links Practice
12
Access 2021
Module 5 Improving Tables and Creating Advanced Queries
1(1)
Create Lookup Fields
2(2)
Multivalued fields Modify Lookup Fields
4(2)
Modify Validation and Index Properties
6(2)
Table validation properties Create Attachment and Hyperlink Fields
8(2)
Create Long Text Fields
10(2)
Allow Zero Length property Query for Top Values
12(2)
Create a Parameter Query
14(2)
Modify Properties in Queries
16(2)
Find Unmatched Records
18(2)
Reviewing referential integrity Build Summary Queries
20(2)
Build Crosstab Queries
22(2)
Practice
24
Module 6 Creating Forms
1(1)
Add Labels and Text Boxes
2(2)
Resize and Align Controls
4(2)
Create Calculations on Forms
6(2)
Bound versus unbound controls Add Check Boxes and Toggle Buttons
8(2)
Add Option Groups
10(2)
Add Combo Boxes to Enter Data
12(2)
Choosing between a combo box and a list box Add Combo Boxes to Find Records
14(2)
Add Lines and Rectangles
16(2)
Line troubles Add Hyperlink Controls
18(2)
Add Command Buttons
20(2)
Modify Tab Order
22(2)
Naming conventions Add Images
24(2)
Applying a background image Create a Split Form
26(2)
AddSubforms
28(2)
Linking the form and subform Add Tab Controls
30(2)
Create a group in the Navigation Pane Modify Form Properties
32(2)
Practice
34
Module 7 Creating Reports
1(1)
Create and Preview a Report
2(2)
Modify Report Layout
4(2)
Add Fields and Lines
6(2)
Group and Sort Records
8(2)
Combo boxes versus text boxes on a report Add Calculations and Subtotals
10(2)
Resize and Align Controls
12(2)
Modify Report Sections
14(2)
Hexadecimal color values Inserting page breaks Create Multicolumn Reports
16(2)
Add a Subreport
18(2)
Add Command Buttons
20(2)
Rich Text formatting Practice
22
Module 8 Importing and Exporting Data
1(1)
Import Access Objects
2(2)
Import or Export Text Files
4(2)
Imported data must be structured Export to Excel
6(2)
Export to PDF
8(2)
Emailing an Access report Export to HTML or XML
10(2)
Merge to Word
12(2)
Create Charts
14(2)
Modify Charts
16(2)
Use a Database Template
18(2)
Use Application Parts
20(2)
Creating custom Application Parts Practice
22
Integration
Module 5 Integrating Word and Access
1(1)
Merge from Access to Word
2(2)
Export an Access Report to Word
4(2)
Practice
6
Powerpoint 2021
Module 4 Formatting Slide Masters and Backgrounds
1(1)
Apply Design Themes
2(2)
Customizing themes Modify Masters
4(2)
Understanding PowerPoint templates and themes Create Custom Slide Layouts
6(2)
Restoring the slide master layout Customize the Background and Theme
8(2)
Use Slide Show Commands
10(2)
Use Proofing and Language Tools
12(2)
Rehearsing slide show timings Inspect a Presentation
14(2)
Practice
16
Module 5 Working with Advanced Tools
1(1)
Use Advanced Formatting Tools
2(2)
Creating columns in a text box Insert and Modify a Picture
4(2)
Using paste special Adjust and Format Text Objects
6(2)
Changing text direction and margin space Customize Animation Effects
8(2)
Understanding animation start timings Set Advanced Animation Effects
10(2)
Animating objects with a custom motion path Use Comments
12(2)
Replacing text and fonts Combine Reviewed Presentations
14(2)
Changing page setup Insert Zoom Links
16(2)
Dictating text on a slide Practice
18
Module 6 Enhancing Charts and Tables
1(1)
Insert Text from Microsoft Word
2(2)
Recording a slide show Change Chart Design and Style
4(2)
Using AutoFit Options to divide and fit body text Customize a Chart
6(2)
Using the Search pane Modify Chart Elements
8(2)
Changing PowerPoint options Embed an Excel Chart
10(2)
Embedding a worksheet Link an Excel Worksheet
12(2)
Editing links Create a Custom Table
14(2)
Resizing table rows and columns Modify Data in a Table
16(2)
Add Effects to Table Data
18(2)
Practice
20
Module 7 Inserting Graphics, Media, and Objects
1(1)
Design a SmartArt Graphic
2(2)
Creating mathematical equations Enhance a SmartArt Graphic
4(2)
Saving a presentation in PDF, XPS, or other fixed file formats Customize Digital Video
6(2)
Trimming a video Insert and Trim Audio
8(2)
Edit and Adjust a Picture
10(2)
Compressing pictures Add Action Buttons
12(2)
Changing the transparency of a picture Insert Hyperlinks
14(2)
Inserting a screenshot Insert and Animate 3-D Models
16(2)
Zooming in on a 3-D model Practice
18
Integration
Module 6 Integrating Word, Excel, Access, and PowerPoint
1(1)
Insert an Access Table into PowerPoint
2(2)
Insert Word Objects into PowerPoint
4(2)
Link an Excel File into PowerPoint
6(2)
Create PowerPoint Handouts in Word
8(2)
Embed a PowerPoint Slide in Word
10(2)
Practice
12
Index Index 1
David W. Beskeen has authored or co-authored over 65 successful computer books since 1992, including more than 40 educational titles for Course Technology and Cengage. He has guided readers in mastering PowerPoint®, Word, Excel, Internet Explorer, Outlook, Windows®, LiveMotion and other leading proprietary software packages. An expert in applied technology, Beskeen has extensive teaching and consulting experience in today's computer technology. Carol M. Cram is the author of more than 35 textbooks on computer applications, business communications and Internet-related subjects. Ms. Cram was also a long-time faculty member at Capilano College in North Vancouver, where she served as the Convenor of the Executive Support Program and the Program Consultant for Business and Computers in Continuing Education as well as instructor of business and computer-related courses. NA Lisa Friedrichsen is a professor at Johnson County Community College in Overland Park, Kansas, where she teaches database and web development classes. She also has written several prominent Access, Office and web-related textbooks. Friedrichsen spent a decade at IBM Corp. before becoming a consultant, author and college professor. Combining her extensive industry experience with her passion for teaching, she creates clear, practical presentations. She earned a B.S. in engineering from Iowa State University and an MBA from Drake University. Lynn Wermers is a professor in the computer science department at North Shore Community College in Massachusetts, where she teaches IT, data management, data analysis and web development courses. She also teaches part time in the math department for the College of Professional Studies at Northeastern University. Wermers has authored numerous leading books focusing on Excel for Cengage.