Muutke küpsiste eelistusi

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

(Johnson County Community College), (NA), (Capilano College), (NA), (NA)
  • Formaat: Paperback / softback, 461 pages, kõrgus x laius x paksus: 276x217x18 mm, kaal: 1069 g
  • Ilmumisaeg: 11-May-2016
  • Kirjastus: Course Technology Inc
  • ISBN-10: 1305876040
  • ISBN-13: 9781305876040
Teised raamatud teemal:
  • Pehme köide
  • Hind: 67,03 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 83,79 €
  • 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 2016: Intermediate New editionSuurem pilt
  • Formaat: Paperback / softback, 461 pages, kõrgus x laius x paksus: 276x217x18 mm, kaal: 1069 g
  • Ilmumisaeg: 11-May-2016
  • Kirjastus: Course Technology Inc
  • ISBN-10: 1305876040
  • ISBN-13: 9781305876040
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781305876040.html
Märksõnad:
Whether you are a computer rookie or hot shot, you can master basic and more advanced Microsoft Office 2016 skills quickly and efficiently with ILLUSTRATED MICROSOFT OFFICE 365 & OFFICE 2016: INTERMEDIATE. Using a concise, focused approach and user-friendly format, the Illustrated Series incorporates a hallmark two-page layout that allows you to see an entire task in one view. Each presentation is easy to follow with Learning Outcomes that outline the skills covered in each lesson and larger full-color screens that reflect exactly what you should see on your own computer. Each module begins with a brief overview of the lesson's principles and introduces a case study for further application. In addition, new Productivity Apps visually introduce Microsoft OneNote, Sway, Office Mix and Edge using hands-on activities.
Productivity App
Productivity Apps for School and Work
PA-1
Introduction to OneNote 2016
PA-2
Introduction to Sway
PA-6
Introduction to Office Mix
PA-10
Introduction to Microsoft Edge
PA-14
Word 2016*
Module 5: Creating and Formatting Tables
Word-105
Insert a Table
Word-106
Converting text to a table and a table to text
Insert and Delete Rows and Columns
Word-108
Copying and moving rows and columns
Modify Rows and Columns
Word-110
Setting advanced table properties
Sort Table Data
Word-112
Sorting lists and paragraphs
Split and Merge Cells
Word-114
Changing cell margins
Using tables to lay out a page
Perform Calculations in Tables
Word-116
Working with formulas
Apply a Table Style
Word-118
Customize a Table Format
Word-120
Drawing a table
Practice
Word-122
Module 6: Illustrating Documents with Graphics
Word-129
Insert a Graphic
Word-130
Correcting pictures, changing colors, and applying artistic effects
Size and Scale a Graphic
Word-132
Cropping graphics
Position a Graphic
Word-134
Removing the background from a picture
Create a Text Box
Word-136
Linking text boxes
Create WordArt
Word-138
Enhancing graphic objects with styles and effects
Draw Shapes
Word-140
Creating an illustration in a drawing canvas
Create a Chart
Word-142
Creating SmartArt graphics
Finalize Page Layout
Word-144
Inserting online videos and online pictures in a document
Practice
Word-146
Module 7: Working with Themes and Building Blocks
Word-153
Apply Styles to Text
Word-154
Saving a document as a webpage
Apply a Theme
Word-156
Changing the style set
Changing the default theme
Customize a Theme
Word-158
Insert a Sidebar
Word-160
Insert Quick Parts
Word-162
Add a Cover Page
Word-164
Create Building Blocks
Word-166
Renaming a building block and editing other properties
Insert Building Blocks
Word-168
Practice
Word-170
Module 8: Merging Word-Documents
Word-177
Understand Mail Merge
Word-178
Create a Main Document
Word-180
Using a mail merge template
Design a Data Source
Word-182
Merging with an Outlook data source
Enter and Edit Records
Word-184
Add Merge Fields
Word-186
Matching fields
Merge Data
Word-188
Create Labels
Word-190
Printing individual envelopes and labels
Sort and Filter Records
Word-192
Inserting individual merge fields
Practice
Word-194
Excel 2016*
Module 5: Analyzing Data Using Formulas
Excel-105
Format Data Using Text Functions
Excel-106
Working with text in other ways
Sum a Data Range Based on Conditions
Excel-108
Entering date and time functions
Consolidate Data Using a Formula
Excel-110
Linking data between workbooks
Check Formulas for Errors
Excel-112
Correcting circular references
Construct Formulas Using Named Ranges
Excel-114
Consolidating data using named ranges
Managing workbook names
Build a Logical Formula with the IF Function
Excel-116
Build a Logical Formula with the AND Function
Excel-118
Using the OR and NOT logical functions
Calculate Payments with the PMT Function
Excel-120
Calculating future value with the FV function
Practice
Excel-122
Module 6: Managing Workbook Data
Excel-129
View and Arrange Worksheets
Excel-130
Splitting the worksheet into multiple panes
Protect Worksheets and Workbooks
Excel-132
Freezing rows and columns
Save Custom Views of a Worksheet
Excel-134
Using Page Break Preview
Add a Worksheet Background
Excel-136
Working with screenshots in Excel
Prepare a Workbook for Distribution
Excel-138
Sharing a workbook using OneDrive
Insert Hyperlinks
Excel-140
Working with Headers and Footers
Using research tools
Save a Workbook for Distribution
Excel-142
Saving a workbook in other formats
Group Worksheets
Excel-144
Practice
Excel-146
Module 7: Managing Data Using Tables
Excel-153
Plan a Table
Excel-154
Create and Format a Table
Excel-156
Changing table style options
Add Table Data
Excel-158
Selecting table elements
Find and Replace Table Data
Excel-160
Using Find and Select features
Delete Table Data
Excel-162
Sort Table Data
Excel-164
Sorting conditionally formatted data
Specifying a custom sort order
Use Formulas in a Table
Excel-166
Print a Table
Excel-168
Setting a print area
Practice
Excel-170
Module 8: Analyzing Table Data
Excel-177
Filter a Table
Excel-178
Create a Custom Filter
Excel-180
Using more than one rule when conditionally formatting data
Filter a Table with the Advanced Filter
Excel-182
Saving time with conditional formatting
Extract Table Data
Excel-184
Understanding the criteria range and the copy-to location
Look Up Values in a Table
Excel-186
Using other LOOKUP functions
Summarize Table Data
Excel-188
Validate Table Data
Excel-190
Restricting cell values and data length
Adding input messages and error alerts
Create Subtotals
Excel-192
Practice
Excel-194
Integration
Module 4: Integrating Word and Excel
Integration-49
Use Paste Special to Modify Formatting
Integration-50
Create a Hyperlink Between Word and Excel
Integration-52
Editing and removing a hyperlink
Create an Excel Spreadsheet in Word
Integration-54
Embed an Excel File in Word
Integration-56
Formatting pasted, embedded, and linked objects
Change Link Sources
Integration-58
Reestablishing links
Practice
Integration-60
Access 2016*
Module 5: Modifying the Database Structure
Access-105
Examine Relational Databases
Access-106
Using many-to-many relationships
Enforcing referential integrity
Design Related Tables
Access-108
Specifying the foreign key field data type
Create One-to-Many Relationships
Access-110
More on enforcing referential integrity
Create Lookup Fields
Access-112
Creating multivalued fields
Modify Short Text Fields
Access-114
Working with the Input Mask property
Modify Number and Currency Fields
Access-116
Modifying fields in Datasheet View
Modify Date/Time Fields
Access-118
Using Smart Tags
Modify Validation Properties
Access-120
Create Attachment Fields
Access-122
Working with database file types
Practice
Access-124
Module 6: Improving Queries
Access-137
Create Multitable Queries
Access-138
Deleting a field from the query grid
Apply Sorts and View SQL
Access-140
Specifying a sort order different from the field order in the datasheet
Develop AND Criteria
Access-142
Develop OR Criteria
Access-144
Using wildcard characters in query criteria
Create Calculated Fields
Access-146
Build Summary Queries
Access-148
Build Crosstab Queries
Access-150
Using query wizards
Create a Report on a Query
Access-152
Practice
Access-154
Module 7: Enhancing Forms
Access-163
Use Form Design View
Access-164
Add Subforms
Access-166
Linking the form and subform
Align Control Edges
Access-168
Anchoring, margins, and padding
Add a Combo Box for Data Entry
Access-170
Choosing between a combo box and a list box
Add a Combo Box to Find Records
Access-172
Add Command Buttons
Access-174
Shape effects
Add Option Groups
Access-176
Protecting data
Add Tab Controls
Access-178
Practice
Access-180
Module 8: Analyzing Data with Reports
Access-189
Use Report Design View
Access-190
Create Parameter Reports
Access-192
Parameter criteria
Apply Conditional Formatting
Access-194
Conditional formatting using data bars
Add Lines
Access-196
Line troubles
Use the Format Painter and Themes
Access-198
Add Subreports
Access-200
Modify Section Properties
Access-202
Create Summary Reports
Access-204
Practice
Access-206
Integration
Module 5: Integrating Word and Access
Integration-65
Merge from Access-to Word
Integration-66
Export an Access-Report to Word
Integration-68
Practic Integration-70
Powerpoint 2016*
Module 5: Working with Advanced Tools and Masters
PowerPoint-97
Draw and Format Connectors
PowerPoint-98
Changing page setup and slide orientation
Use Advanced Formatting Tools
PowerPoint-100
Creating columns in a text box
Customize Animation Effects
PowerPoint-102
Understanding animation timings
Create Custom Slide Layouts
PowerPoint-104
Restoring the slide master layout
Format Master Text
PowerPoint-106
Organizing slides into sections
Change Master Text Indents
PowerPoint-108
Adjust Text Objects
PowerPoint-110
Changing text direction
Use Templates and Add Comments
PowerPoint-112
Understanding PowerPoint templates and themes
Practice
PowerPoint-114
Module 6: Enhancing Charts...
PowerPoint-121
Work with Charts in PowerPoint
PowerPoint-122
Using Paste Special
Change Chart Design and Style
PowerPoint-124
Using AutoFit Options to divide and fit body text
Customize a Chart
PowerPoint-126
Using the Insights task pane
Format Chart Elements
PowerPoint-128
Changing PowerPoint options
Animate a Chart
PowerPoint-130
Inserting a picture as a slide background
Embed an Excel-Chart
PowerPoint-132
Embedding a worksheet
Link an Excel-Worksheet
PowerPoint-134
Update a Linked Excel-Worksheet
PowerPoint-136
Editing links
Practice
PowerPoint-138
Module 7: Inserting Graphics, Media, and Objects
PowerPoint-145
Create a Custom Table
PowerPoint-146
Design a SmartArt Graphic
PowerPoint-148
Creating mathematical equations
Enhance a SmartArt Graphic
PowerPoint-150
Saving a presentation in PDF, XPS, or other fixed file formats
Insert and Edit Digital Video
PowerPoint-152
Trimming a video
Insert and Trim Audio
PowerPoint-154
Recording a narration on a slide
Edit and Adjust a Picture
PowerPoint-156
Compressing pictures
Add Action Buttons
PowerPoint-158
Changing the transparency of a picture
Insert Hyperlinks
PowerPoint-160
Inserting a screenshot
Practice
PowerPoint-162
Module 8: Using Advanced Features
PowerPoint-169
Customize Handout and Notes Masters
PowerPoint-170
Creating handouts in Microsoft Word
Send a Presentation for Review
PowerPoint-172
Packaging a presentation
Combine Reviewed Presentations
PowerPoint-174
Coauthoring a presentation
Set Up a Slide Show
PowerPoint-176
Installing and using Office Add-ins
Create a Custom Show
PowerPoint-178
Linking to a custom slide show
Prepare a Presentation for Distribution
PowerPoint-180
Recording a slide show
Create a Photo Album
PowerPoint-182
Publishing slides to a Slide Library
Deliver a Presentation Online
PowerPoint-184
Mastering PowerPoint features and online presentations
Practice
PowerPoint-186
Integration
Module 6: Integrating Word, Excel, Access, and PowerPoint
Integration-73
Insert an Access Table into PowerPoint
Integration-74
Insert Word Objects into PowerPoint
Integration-76
Link an Excel File into PowerPoint
Integration-78
Create PowerPoint Handouts in Word
Integration-80
Embed a PowerPoint Slide in Word
Integration-82
Practice
Integration-84
Glossary Glossary-1
Index Index-32
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. 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. 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. NA 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.