Muutke küpsiste eelistusi

Illustrated Microsoft Office 365 & Office 2016: Intermediate, Loose-Leaf Version [köitmata]

5.00/5 (1 hinnangut Goodreads-ist)
, , , ,
  • Formaat: Loose-leaf, 461 pages, kõrgus x laius x paksus: 274x213x18 mm, kaal: 840 g, Illustrations
  • Ilmumisaeg: 11-May-2016
  • Kirjastus: CENGAGE Learning Custom Publishing
  • ISBN-10: 1337250856
  • ISBN-13: 9781337250856
Teised raamatud teemal:
  • köitmata
  • Hind: 95,04 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Illustrated Microsoft Office 365 & Office 2016: Intermediate, Loose-Leaf VersionSuurem pilt
  • Formaat: Loose-leaf, 461 pages, kõrgus x laius x paksus: 274x213x18 mm, kaal: 840 g, Illustrations
  • Ilmumisaeg: 11-May-2016
  • Kirjastus: CENGAGE Learning Custom Publishing
  • ISBN-10: 1337250856
  • ISBN-13: 9781337250856
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781337250856.html
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
1(104)
Introduction to OneNote 2016
2(4)
Introduction to Sway
6(4)
Introduction to Office Mix
10(4)
Introduction to Microsoft Edge
14(91)
Word 2016
Module 5 Creating and Formatting Tables
105(24)
Insert a Table
106(2)
Converting text to a table and a table to text
Insert and Delete Rows and Columns
108(2)
Copying and moving rows and columns
Modify Rows and Columns
110(2)
Setting advanced table properties
Sort Table Data
112(2)
Sorting lists and paragraphs
Split and Merge Cells
114(2)
Changing cell margins
Using tables to lay out a page
Perform Calculations in Tables
116(2)
Working with formulas
Apply a Table Style
118(2)
Customize a Table Format
120(2)
Drawing a table
Practice
122(7)
Module 6 Illustrating Documents with Graphics
129(24)
Insert a Graphic
130(2)
Correcting pictures, changing colors, and applying artistic effects
Size and Scale a Graphic
132(2)
Cropping graphics
Position a Graphic
134(2)
Removing the background from a picture
Create a Text Box
136(2)
Linking text boxes
Create WordArt
138(2)
Enhancing graphic objects with styles and effects
Draw Shapes
140(2)
Creating an illustration in a drawing canvas
Create a Chart
142(2)
Creating SmartArt graphics
Finalize Page Layout
144(2)
Inserting online videos and online pictures in a document
Practice
146(7)
Module 7 Working with Themes and Building Blocks
153(24)
Apply Styles to Text
154(2)
Saving a document as a webpage
Apply a Theme
156(2)
Changing the style set
Changing the default theme
Customize a Theme
158(2)
Insert a Sidebar
160(2)
Insert Quick Parts
162(2)
Add a Cover Page
164(2)
Create Building Blocks
166(2)
Renaming a building block and editing other properties
Insert Building Blocks
168(2)
Practice
170(7)
Module 8 Merging Word Documents
177
Understand Mail Merge
178(2)
Create a Main Document
180(2)
Using a mail merge template
Design a Data Source
182(2)
Merging with an Outlook data source
Enter and Edit Records
184(2)
Add Merge Fields
186(2)
Matching fields
Merge Data
188(2)
Create Labels
190(2)
Printing individual envelopes and labels
Sort and Filter Records
192(2)
Inserting individual merge fields
Practice
194
Excel 2016
Module 5 Analyzing Data Using Formulas
105(24)
Format Data Using Text Functions
106(2)
Working with text in other ways
Sum a Data Range Based on Conditions
108(2)
Entering date and time functions
Consolidate Data Using a Formula
110(2)
Linking data between workbooks
Check Formulas for Errors
112(2)
Correcting circular references
Construct Formulas Using Named Ranges
114(2)
Consolidating data using named ranges
Managing workbook names
Build a Logical Formula with the IF Function
116(2)
Build a Logical Formula with the AND Function
118(2)
Using the OR and NOT logical functions
Calculate Payments with the PMT Function
120(2)
Calculating future value with the FV function
Practice
122(7)
Module 6 Managing Workbook Data
129(24)
View and Arrange Worksheets
130(2)
Splitting the worksheet into multiple panes
Protect Worksheets and Workbooks
132(2)
Freezing rows and columns
Save Custom Views of a Worksheet
134(2)
Using Page Break Preview
Add a Worksheet Background
136(2)
Working with screenshots in Excel
Prepare a Workbook for Distribution
138(2)
Sharing a workbook using OneDrive
Insert Hyperlinks
140(2)
Working with Headers and Footers
Using research tools
Save a Workbook for Distribution
142(2)
Saving a workbook in other formats
Group Worksheets
144(2)
Practice
146(7)
Module 7 Managing Data Using Tables
153(24)
Plan a Table
154(2)
Create and Format a Table
156(2)
Changing table style options
Add Table Data
158(2)
Selecting table elements
Find and Replace Table Data
160(2)
Using Find and Select features
Delete Table Data
162(2)
Sort Table Data
164(2)
Sorting conditionally formatted data
Specifying a custom sort order
Use Formulas in a Table
166(2)
Print a Table
168(2)
Setting a print area
Practice
170(7)
Module 8 Analyzing Table Data
177
Filter a Table
178(2)
Create a Custom Filter
180(2)
Using more than one rule when conditionally formatting data
Filter a Table with the Advanced Filter
182(2)
Saving time with conditional formatting
Extract Table Data
184(2)
Understanding the criteria range and the copy-to location
Look Up Values in a Table
186(2)
Using other LOOKUP functions
Summarize Table Data
188(2)
Validate Table Data
190(2)
Restricting cell values and data length
Adding input messages and error alerts
Create Subtotals
192(2)
Practice
194
Integration
Module 4 Integrating Word and Excel
49(56)
Use Paste Special to Modify Formatting
50(2)
Create a Hyperlink Between Word and Excel
52(2)
Editing and removing a hyperlink
Create an Excel Spreadsheet in Word
54(2)
Embed an Excel File in Word
56(2)
Formatting pasted, embedded, and linked objects
Change Link Sources
58(2)
Reestablishing links
Practice
60(45)
Access 2016
Module 5 Modifying the Database Structure
105(32)
Examine Relational Databases
106(2)
Using many-to-many relationships Enforcing referential integrity
Design Related Fables
108(2)
Specifying the foreign key field data type
Create One-to-Many Relationships
110(2)
More on enforcing referential integrity
Create Lookup Fields
112(2)
Creating multivalued fields
Modify Short Text Fields
114(2)
Working with the Input Mask property
Modify Number and Currency Fields
116(2)
Modifying fields in Datasheet View
Modify Date/Time Fields
118(2)
Using Smart Tags
Modify Validation Properties
120(2)
Create Attachment Fields
122(2)
Working with database file types
Practice
124(13)
Module 6 Improving Queries
137(26)
Create Multitable Queries
138(2)
Deleting a field from the query grid
Apply Sorts and View SQL
140(2)
Specifying a sort order different from the field order in the datasheet
Develop AND Criteria
142(2)
Develop OR Criteria
144(2)
Using wildcard characters in query criteria
Create Calculated Fields
146(2)
Build Summary Queries
148(2)
Build Crosstab Queries
150(2)
Using query wizards
Create a Report on a Query
152(2)
Practice
154(9)
Module 7 Enhancing Forms
163(26)
Use Form Design View
164(2)
Add Subforms
166(2)
Linking the form and subform
Align Control Edges
168(2)
Anchoring, margins, and padding
Add a Combo Box for Data Entry
170(2)
Choosing between a combo box and a list box
Add a Combo Box to Find Records
172(2)
Add Command Buttons
174(2)
Shape effects
Add Option Groups
176(2)
Protecting data
Add Tab Controls
178(2)
Practice
180(9)
Module 8 Analyzing Data with Reports
189
Use Report Design View
190(2)
Create Parameter Reports
192(2)
Parameter criteria Apply Conditional Formatting
194(2)
Conditional formatting using data bars
Add Lines
196(2)
Line troubles
Use the Format Painter and Themes
198(2)
Add Subreports
200(2)
Modify Section Properties
202(2)
Create Summary Reports
204(2)
Practice
206
Integration
Module 5 Integrating Word and Access
65(32)
Merge from Access to Word
66(2)
Export an Access Report to Word
68(2)
Practice
70(27)
Powerpoint 2016
Module 5 Working with Advanced Tools and Masters
97(24)
Draw and Format Connectors
98(2)
Changing page setup and slide orientation
Use Advanced Formatting Tools
100(2)
Creating columns in a text box
Customize Animation Effects
102(2)
Understanding animation timings
Create Custom Slide Layouts
104(2)
Restoring the slide master layout
Format Master Text
106(2)
Organizing slides into sections
Change Master Text Indents
108(2)
Adjust Text Objects
110(2)
Changing text direction
Use Templates and Add Comments
112(2)
Understanding PowerPoint templates and themes
Practice
114(7)
Module 6 Enhancing Charts
121(24)
Work with Charts in PowerPoint
122(2)
Using Paste Special
Change Chart Design and Style
124(2)
Using AutoFit Options to divide and fit body text
Customize a Chart
126(2)
Using the Insights task pane
Format Chart Elements
128(2)
Changing PowerPoint options
Animate a Chart
130(2)
Inserting a picture as a slide background
Embed an Excel Chart
132(2)
Embedding a worksheet
Link an Excel Worksheet
134(2)
Update a Linked Excel Worksheet
136(2)
Editing links
Practice
138(7)
Module 7 Inserting Graphics, Media, and Objects
145(24)
Create a Custom Table
146(2)
Design a SmartArt Graphic
148(2)
Creating mathematical equations
Enhance a SmartArt Graphic
150(2)
Saving a presentation in PDF, XPS, or other fixed file formats
Insert and Edit Digital Video
152(2)
Trimming a video
Insert and Trim Audio
154(2)
Recording a narration on a slide
Edit and Adjust a Picture
156(2)
Compressing pictures
Add Action Buttons
158(2)
Changing the transparency of a picture
Insert Hyperlinks
160(2)
Inserting a screenshot
Practice
162(7)
Module 8 Using Advanced Features
169
Customize Handout and Notes Masters
170(2)
Creating handouts in Microsoft Word
Send a Presentation for Review
172(2)
Packaging a presentation
Combine Reviewed Presentations
174(2)
Coauthoring a presentation
Set Up a Slide Show
176(2)
Installing and using Office Add-ins
Create a Custom Show
178(2)
Linking to a custom slide show
Prepare a Presentation for Distribution
180(2)
Recording a slide show
Create a Photo Album
182(2)
Publishing slides to a Slide Library
Deliver a Presentation Online
184(2)
Mastering PowerPoint features and online presentations
Practice
186
Module 6 Integrating Word, Excel, Access, and PowerPoint
73
Insert an Access Table into PowerPoint
74(2)
Insert Word Objects into PowerPoint
76(2)
Link an Excel File into PowerPoint
78(2)
Create PowerPoint Handouts in Word
80(2)
Embed a PowerPoint Slide in Word
82(2)
Practice
84
Glossary 1(31)
Index 32