Muutke küpsiste eelistusi

Illustrated Microsoft®Office 365 & Office 2019 Intermediate New edition [Pehme köide]

(NA), (Johnson County Community College), (NA), (Capilano College), (NA)
  • Formaat: Paperback / softback, 664 pages, kõrgus x laius x paksus: 20x213x274 mm, kaal: 1065 g
  • Ilmumisaeg: 17-May-2019
  • Kirjastus: Course Technology Inc
  • ISBN-10: 0357360087
  • ISBN-13: 9780357360088
Teised raamatud teemal:
  • Pehme köide
  • Hind: 72,43 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 90,54 €
  • Säästad 20%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Illustrated Microsoft®Office 365 & Office 2019 Intermediate New editionSuurem pilt
  • Formaat: Paperback / softback, 664 pages, kõrgus x laius x paksus: 20x213x274 mm, kaal: 1065 g
  • Ilmumisaeg: 17-May-2019
  • Kirjastus: Course Technology Inc
  • ISBN-10: 0357360087
  • ISBN-13: 9780357360088
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780357360088.html
Now students can master the nuances of Microsoft® Office quickly with ILLUSTRATED MICROSOFT® OFFICE 2019 & OFFICE 365 INTERMEDIATE, part of today's popular Illustrated Series. This focused, user-friendly approach uses a proven two-page layout that allows students to work through an entire task without turning the page. Clear Learning Outcomes outline the skills for each lesson, while large full-color screen images reflect exactly what students see on their own computers. Each module begins with a brief overview of the principles covered in the lesson and introduces a real-world case scenario to engage students and reinforce critical skills to make them successful in their educational and professional careers. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.
Getting to Know Microsoft Office Versions 1(1)
Using SAM Projects and Textbook Projects 1(1)
Word 2019
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(1)
Adding a custom header or footer to the gallery
Modify a Table
8(4)
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(2)
Create a Main Document
4(2)
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 2019
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 2019
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
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)
Add Subforms
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 2019
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 2019
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 Insights 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 2019
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 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.