Muutke küpsiste eelistusi

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

  • Formaat: Loose-leaf, kõrgus x laius x paksus: 274x213x25 mm, kaal: 1338 g, Illustrations
  • Ilmumisaeg: 11-Feb-2016
  • Kirjastus: CENGAGE Learning Custom Publishing
  • ISBN-10: 1337250759
  • ISBN-13: 9781337250757
Teised raamatud teemal:
  • köitmata
  • Hind: 105,84 €*
  • * 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
  • Formaat: Loose-leaf, kõrgus x laius x paksus: 274x213x25 mm, kaal: 1338 g, Illustrations
  • Ilmumisaeg: 11-Feb-2016
  • Kirjastus: CENGAGE Learning Custom Publishing
  • ISBN-10: 1337250759
  • ISBN-13: 9781337250757
Teised raamatud teemal:
Whether you're a computer rookie or hot shot, you can master Microsoft Office 2016 applications quickly with ILLUSTRATED MICROSOFT OFFICE 2016 & OFFICE 365 INTRODUCTORY, part of the popular Illustrated Series. Using a focused, user-friendly format, a two-page layout allows you to work through an entire task without turning the page. The book's easy to follow presentation highlights Learning Outcomes that outline the skills in each lesson. Larger full-color screen images reflect exactly what you should see on your own computer. Each module begins with a brief overview of the principles of the lesson and introduces a case study for further application. New Productivity Apps visually introduce Microsoft OneNote, Sway, Office Mix and Edge using fun, hands-on activities. Companion Sways provide videos and step-by-step instructions to help you master each app. In addition, MindTap and SAM help you further focus your study for results now and success later on the job.
Productivity Apps
Productivity Apps for School and Work
1(1)
Introduction to OneNote 2016
2(4)
Introduction to Sway
6(4)
Introduction to Office Mix
10(4)
Introduction to Microsoft Edge
14
Concepts
Module 1 Understanding Essential Computer Concepts
1(1)
Recognize You Live and Work in the Digital World
2(2)
How to be a good online citizen Distinguish Types of Computers Touchscreens
4(2)
Identify Computer System Components
6(2)
About microprocessor speeds
Compare Types of Memory
8(2)
Upgrading RAM
Summarize Types of Storage Media
10(2)
Storage in the Cloud
Differentiate Between Input Devices
12(2)
Understanding assistive devices
Explain Output Devices
14(2)
About 3D printers
Describe Data Communications
16(2)
Understanding USB types and connectors
How computers represent and interpret data
Define Types of Networks
18(2)
Understanding telecommunications
Assess Security Threats
20(2)
Understanding two-factor authentication
Understand System Software
22(2)
Protecting information with passwords
Examining Windows 10 hardware requirements
Describe Types of Application Software
24(2)
Practice
26
Windows 10
Module 1 Getting Started with Windows 10
1(24)
Start Windows 10
2(2)
Using a touch screen with Windows
Navigate the Desktop and Start Menu
4(2)
Point, Click, and Drag
6(2)
Selecting and moving items using touch-screen devices
Start an App
8(2)
Using the Windows Store
Work with a Window
10(2)
Using the Quick Access toolbar
Manage Multiple Windows
12(2)
Use Buttons, Menus, and Dialog Boxes
14(2)
Get Help
16(2)
Using Cortana
Exit Windows 10
18(2)
Installing updates when you exit Windows
Practice
20(5)
Module 2 Understanding File Management
25
Understand Files and Folders
26(2)
Plan your file organization
Create and Save a File
28(2)
Explore the Files and Folders on Your Computer
30(2)
Using and disabling Quick Access view
Change File and Folder Views
32(2)
Using the Windows Action Center
Customizing Details view
Open, Edit, and Save Files
34(2)
Comparing Save and Save As Using Microsoft OneDrive
Copy Files
36(2)
Copying files using Send to Move and Rename Files
38(2)
Using Task View to create multiple desktops Search for Files and Folders
40(2)
Using the Search Tools tab in File Explorer Using Microsoft Edge
Delete and Restore Files
42(2)
More techniques for selecting and moving files
Practice
44
Office 2016
Module 1 Getting Started with Microsoft Office 2016
1(1)
Understand the Office 2016 Suite
2(2)
What is Office 365?
Start an Office App
4(2)
Enabling touch mode
Using shortcut keys to move between Office programs
Using the Office Clipboard
Identify Office 2016 Screen Elements
6(2)
Using Backstage view
Create and Save a File
8(2)
Saving files to OneDrive
Open a File and Save It with a New Name
10(2)
Exploring File Open options
Working in Compatibility Mode
View and Print Your Work
12(2)
Customizing the Quick Access toolbar
Creating a screen capture
Get Help, Close a File, and Exit an App
14(2)
Using Sharing features and Co-authoring capabilities
Recovering a document
Practice
16
Word 2016
Module 1 Creating Documents with Word 2016
1(24)
Understand Word Processing Software
2(2)
Planning a document
Explore the Word Window
4(2)
Start a Document
6(2)
Save a Document
8(2)
Select Text
10(2)
Format Text Using the Mini Toolbar and the Ribbon
12(2)
Use a Document Template
14(2)
Using the Undo, Redo, and Repeat commands
Navigate a Document
16(2)
Using Word document views
Practice
18(7)
Module 2 Editing Documents
25(24)
Cut and Paste Text
26(2)
Using keyboard shortcuts
Copy and Paste Text
28(2)
Splitting the document window to copy and move items in a long document
Use the Office Clipboard
30(2)
Copying and moving items between documents
Find and Replace Text
32(2)
Navigating a document using the Navigation pane and the Go To command
Check Spelling and Grammar
34(2)
Using Smart Lookup
Inserting text with AutoCorrect
Research Information
36(2)
Publishing a blog directly from Word
Using a dictionary and other add-ins for Word
Add Hyperlinks
38(2)
Sharing documents directly from Word, including e-mailing
Work with Document Properties
40(2)
Viewing and modifying advanced document properties
Practice
42(7)
Module 3 Formatting Text and Paragraphs
49(28)
Format with Fonts
50(2)
Adding a drop cap
Use the Format Painter
52(2)
Underlining text
Change Line and Paragraph Spacing
54(2)
Formatting with Quick Styles
Align Paragraphs
56(2)
Formatting a document using themes
Work with Tabs
58(2)
Work with Indents
60(2)
Applying text effects and clearing formatting
Add Bullets and Numbering
62(2)
Creating multilevel lists
Add Borders and Shading
64(2)
Highlighting text in a document
Insert Online Pictures
66(2)
Practice
68(9)
Module 4 Formatting Documents
77
Set Document Margins
78(2)
Changing orientation, margin settings, and paper size
Create Sections and Columns
80(2)
Changing page layout settings for a section
Insert Page Breaks
82(2)
Controlling automatic pagination
Insert Page Numbers
84(2)
Moving around in a long document
Inserting Quick Parts
Add Headers and Footers
86(2)
Adding a custom header or footer to the gallery
Insert a Table
88(2)
Add Footnotes and Endnotes
90(2)
Customizing the layout and formatting of footnotes and endnotes
Insert Citations
92(2)
Manage Sources and Create a Bibliography
94(2)
Working with Web sources
Practice
96
Excel 2016
Module 1 Getting Started with Excel 2016
1(24)
Understand Spreadsheet Software
2(2)
Identify Excel 2016 Window Components
4(2)
Using OneDrive and Office Online
Understand Formulas
6(2)
Enter Labels and Values and Use the AutoSum Button
8(2)
Navigating a worksheet
Edit Cell Entries
10(2)
Recovering unsaved changes to a workbook file
Enter and Edit a Simple Formula
12(2)
Understanding named ranges
Switch Worksheet Views
14(2)
Choose Print Options
16(2)
Printing worksheet formulas
Scaling to fit
Practice
18(7)
Module 2 Working with Formulas and Functions
25(26)
Create a Complex Formula
26(2)
Using Add-ins to improve worksheet functionality
Reviewing the order of precedence
Insert a Function
28(2)
Type a Function
30(2)
Using the COUNT and COUNTA functions
Copy and Move Cell Entries
32(2)
Inserting and deleting selected cells
Understand Relative and Absolute Cell
References
34(2)
Using a mixed reference
Copy Formulas with Relative Cell
References
36(2)
Using Paste Preview
Copy Formulas with Absolute Cell
References
38(2)
Using the fill handle for sequential text or values
Round a Value with a Function
40(2)
Using Auto Fill options
Creating a new workbook using a template
Practice
42(9)
Module 3 Formatting a Worksheet
51(28)
Format Values
52(2)
Formatting as a table
Change Font and Font Size
54(2)
Inserting and adjusting online pictures and other images
Change Font Styles and Alignment
56(2)
Rotating and indenting cell entries
Adjust Column Width
58(2)
Changing row height
Insert and Delete Rows and Columns
60(2)
Hiding and unhiding columns and rows
Adding and editing comments
Apply Colors, Patterns, and Borders
62(2)
Working with themes and cell styles
Apply Conditional Formatting
64(2)
Managing conditional formatting rules
Rename and Move a Worksheet
66(2)
Copying, adding, and deleting worksheets
Check Spelling
68(2)
Emailing a workbook
Practice
70(9)
Module 4 Working with Charts
79
Plan a Chart
80(2)
Create a Chart
82(2)
Creating sparklines
Move and Resize a Chart
84(2)
Moving an embedded chart to a sheet
Change the Chart Design
86(2)
Creating a combo chart
Working with a 3-D chart
Change the Chart Format
88(2)
Adding data labels to a chart
Format a Chart
90(2)
Previewing a chart
Changing alignment and angle in axis labels and titles
Annotate and Draw on a Chart
92(2)
Adding SmartArt graphics
Create a Pie Chart
94(2)
Using the Insert Chart dialog box to discover new chart types
Practice
96
Integration
Module 1 Integrating Word and Excel
1(1)
Integrate Data Between Word and Excel
2(2)
Understanding object linking and embedding (OLE)
Copy Data from Excel to Word
4(2)
Copy a Chart from Excel to Word
6(2)
Create Linked Objects
8(2)
Opening linked files and reestablishing links to charts
Embed a Word File in Excel
10(2)
Practice
12
Access 2016
Module 1 Getting Started with Access 2016
1(26)
Understand Relational Databases
2(2)
Explore a Database
4(2)
Create a Database
6(2)
Create a Table
8(2)
Creating a table in Datasheet View
Create Primary Keys
10(2)
Object views
Learning about field properties
Relate Two Tables
12(2)
Enter Data
14(2)
Changing from Navigation mode to Edit mode
Cloud computing
Edit Data
16(2)
Resizing and moving datasheet columns
Practice
18(9)
Module 2 Building and Using Queries
27(26)
Use the Query Wizard
28(2)
Simple Query Wizard
Work with Data in a Query
30(2)
Hiding and unhiding fields in a datasheet
Freezing and unfreezing fields in a datasheet
Use Query Design View
32(2)
Adding or deleting a table in a query
Sort and Find Data
34(2)
Filter Data
36(2)
Using wildcard characters
Apply AND Criteria
38(2)
Searching for blank fields
Apply OR Criteria
40(2)
Format a Datasheet
42(2)
Practice
44(9)
Module 3 Using Forms
53(26)
Use the Form Wizard
54(2)
Create a Split Form
56(2)
Use Form Layout View
58(2)
Table layouts
Add Fields to a Form
60(2)
Bound versus unbound controls
Modify Form Controls
62(2)
Create Calculations
64(2)
Modify Tab Order
66(2)
Form layouts
Insert an Image
68(2)
Applying a background image
Practice
70(9)
Module 4 Using Reports
79
Use the Report Wizard
80(2)
Changing page orientation
Use Report Layout View
82(2)
Review Report Sections
84(2)
Apply Group and Sort Orders
86(2)
Record Source Property
Add Subtotals and Counts
88(2)
Resize and Align Controls
90(2)
Precisely moving and resizing controls
Format a Report
92(2)
Create Mailing Labels
94(2)
Practice
96
Integration
Module 2 Integrating Word, Excel, and Access
17
Integrate Data Among Word, Excel, and Access
18(2)
Import an Excel Worksheet into Access
20(2)
Copy a Word Table to Access
22(2)
Link an Access Table to Excel and Word
24(2)
Link an Access Table to Word
26(2)
Opening linked files and enabling content
Practice
28
Powerpoint 2016
Module 1 Creating a Presentation in PowerPoint 2016
1(24)
Define Presentation Software
2(2)
Using PowerPoint on a touch screen
Plan an Effective Presentation
4(2)
Understanding copyright
Examine the PowerPoint Window
6(2)
Viewing your presentation in gray scale or black and white
Enter Slide Text
8(2)
Inking a slide
Add a New Slide
10(2)
Entering and printing notes
Apply a Design Theme
12(2)
Customizing themes
Compare Presentation Views
14(2)
Print a PowerPoint Presentation
16(2)
Microsoft Office Online Apps
Practice
18(7)
Module 2 Modifying a Presentation
25(24)
Enter Text in Outline View
26(2)
Using proofing tools for other languages
Format Text
28(2)
Replacing text and fonts
Convert Text to SmartArt
30(2)
Choosing SmartArt graphics
Insert and Modify Shapes
32(2)
Using the Eyedropper to match colors
Rearrange and Merge Shapes
34(2)
Changing the size and position of shapes
Edit and Duplicate Shapes
36(2)
Editing points of a shape
Align and Group Objects
38(2)
Distributing objects
Add Slide Footers
40(2)
Creating superscript and subscript text
Practice
42(7)
Module 3 Inserting Objects into a Presentation
49(24)
Insert Text from Microsoft
50(2)
Sending a presentation using email
Insert and Style a Picture
52(2)
Inserting a screen recording
Insert a Text Box
54(2)
Changing text box defaults
Insert a Chart
56(2)
Enter and Edit Chart Data
58(2)
Adding a hyperlink to a chart
Insert Slides from Other Presentations
60(2)
Working with multiple windows
Insert a Table
62(2)
Setting permissions
Insert and Format WordArt
64(2)
Saving a presentation as a video
Practice
66(7)
Module 4 Finishing a Presentation
73
Modify Masters
74(2)
Create custom slide layouts
Customize the Background and Theme
76(2)
Use Slide Show Commands
78(2)
Set Slide Transitions and Timings
80(2)
Rehearsing slide show timings
Animate Objects
82(2)
Attaching a sound to an animation
Use Proofing and Language Tools
84(2)
Checking spelling as you type
Inspect a Presentation
86(2)
Digitally sign a presentation
Create an Office Mix
88(2)
Inserting an interactive quiz
Practice
90
Integration
Module 3 Integrating Word, Excel, Access, and PowerPoint
33
Integrate Data Among Word, Excel, Access, and PowerPoint
34(2)
Import a Word Outline into PowerPoint
36(2)
Embed an Excel Worksheet in PowerPoint
38(2)
Link Access and Excel Objects to PowerPoint
40(2)
Manage Links
42(2)
Practice
44
Outlook 2016
Module 1 Getting Started with Email
1(24)
Communicate with Email
2(2)
Use Email Addresses
4(2)
Create and Send Emails
6(2)
Understanding message headers in emails you receive
Understand Email Folders
8(2)
Managing your email
Receive and Reply to Emails
10(2)
Setting up vacation responses
Forward Emails
12(2)
Controlling your message
Flagging or labeling messages
Send Email Attachments
14(2)
Reviewing options when sending messages
Employ Good Email Practices
16(2)
Creating distribution lists
Practice
18(7)
Module 2 Managing Information Using Outlook
25
Describe Outlook
26(2)
Weather in Calendar view
Organize Email
28(2)
Manage Your Contacts
30(2)
Manage Your Calendar
32(2)
Sending electronic business cards
Manage Tasks
34(2)
Create Notes
36(2)
Connect Mail to Contacts
38(2)
Apply Categories
40(2)
Coordinating calendars
Practice
42
Glossary 1(16)
Index 17