Microsoft Office 2013/365 and Beyond

Name: Microsoft Office 2013/365 and Beyond | Computer Concepts and Applications
Brand: Mercury Learning & Information
Price: 46.99 EUR
Availability: OnlineOnly

Computer Concepts and Applications

Theodor Richardson Charles Thies(Autor*in)

Mercury Learning & Information (Verlag)

1. Auflage

Erschienen am 10. März 2015

350 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-1-942270-12-6 (ISBN)

46,99 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Personen

Inhalt

Intro
Title Page
Copyright
Dedication
Contents
Introduction
Acknowledgements
Section I: Computing Basics
1. Introduction to Computer Concepts
1.1 What Is a Computer?
1.1.1 Computer Software
1.1.2 Computer Hardware
1.2 History and Background of Computing Technology
1.3 Purchasing a New Computer System
1.4 How the Computer Works
1.4.1 Input Hardware Devices
1.4.2 Output Hardware Devices
1.4.3 Processing Hardware Devices
1.4.4 Data Storage
1.4.5 What Computers Can and Cannot Do
1.5 Introduction to the Windows Operating System
1.5.1 Windows 7
1.5.2 Windows 8
1.6 Introduction to Mac OS X
1.7 Shutdown Procedures
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
2. Navigating and Using the Computer Environment
2.1 Navigating the Desktop
2.1.1 The Windows Desktop
2.1.1.1 The Control Panel
2.1.1.2 Jump Lists
2.1.1.3 Task Manager
2.1.1.4 Libraries Feature
2.1.2 The Macintosh OS X Desktop
2.1.2.1 The Finder
2.1.2.2 The Dock
2.1.2.3 The Dashboard, Exposé, and Spaces
2.1.2.4 Force Quit
2.2 Organizing Files and Folders
2.2.1 Files and Folders in Windows
2.2.2 Files and Folders on a Mac
2.3 Working with Files on Your Computer
2.3.1 WordPad on Windows
2.3.2 TextEdit for Macintosh
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
3. Using the Internet
3.1 Background and Historical Context of the Web
3.1.1 How the Web Works
3.1.2 Connecting to the Internet
3.2 Using a Web Browser
3.2.1 Addresses on the Web
3.2.2 Microsoft Internet Explorer
3.2.3 Mozilla Firefox
3.2.4 Apple Safari
3.3 Using Web Browser Plug-Ins
3.4 Using Search Engines to Find Information on the Web
3.5 Privacy and Security on the Web
3.5.1 Browsing and Search History
3.5.2 Secure Sites
3.5.3 Safe Sites
3.6 The Web and Fair Use
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
4. Using Email and Email Clients
4.1 Introduction to Electronic Mail
4.2 Email Structure
4.3 Email Addresses
4.4 Creating a Personal Email Account
4.4.1 Email Account Types
4.4.2 Microsoft Windows Live Hotmail
4.4.2.1 Creating an Account
4.4.2.2 Navigating and Opening Email
4.4.2.3 Composing an Email
4.4.2.4 Logging Out and Logging In
4.4.3 Gmail by Google
4.4.3.1 Creating an Account
4.4.3.2 Navigating and Opening Email
4.4.3.3 Composing an Email
4.4.3.4 Logging Out and Logging In
4.5 Email Clients
4.5.1 Microsoft Windows Live Mail
4.5.2 Macintosh Mail
4.5.3 Mozilla Thunderbird
4.5.4 Connecting to Your Email Remotely
4.6 Email Etiquette
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
5. Microsoft OneDrive and Cloud Computing
5.1 Cloud Computing
5.2 Microsoft OneDrive
5.2.1 Creating a Microsoft Account
5.2.2 Uploading and Downloading Files
5.3 Integrating OneDrive with the Desktop
5.3.1 OneDrive on Windows 7
5.3.2 OneDrive on Windows 8
5.3.3 OneDrive on Mac OS X
5.4 Integrating OneDrive with Microsoft Office
5.5 Accessing OneDrive on a Remote Device
5.6 Alternate Cloud Computing Platforms
5.6.1 Google Drive
5.6.2 iCloud
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
6. Microsoft Outlook® and Productivity Management
6.1 Microsoft Outlook
6.1.1 Anatomy of Microsoft Outlook 2013
6.1.2 Anatomy of Microsoft Outlook 2011
6.2 Managing Email in Outlook
6.2.1 Creating a New Email
6.2.2 Formatting Email Content
6.2.3 Managing Incoming Email
6.2.4 Responding to Email
6.3 Managing Calendars
6.4 Managing Contacts
6.5 Tasks and Notes
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
Section II: Word Processing
7. Introduction to Word and Word Processing
7.1 Introduction to Productivity Software
7.1.1 The File Menu
7.1.2 Document Management
7.1.3 Help Files
7.1.4 Productivity Shortcuts
7.1.5 The System Clipboard
7.2 Introduction to Word Processing Software
7.3 Anatomy of Microsoft Word
7.3.1 Microsoft Word 2013
7.3.2 Microsoft Word 2011
7.3.3 Microsoft Word Web App
7.4 Diving into Word Processing
7.4.1 Writing a Cover Letter
7.4.2 Formatting Text
7.4.2.1 The Font Panel
7.4.2.2 The Paragraph Panel
7.4.2.3 Format Painter
7.4.3 Bullets and Numbering
7.4.4 Document Review
7.4.4.1 Spelling and Grammar
7.4.4.2 Thesaurus
7.4.4.3 Find and Replace
7.4.5 Using Document Templates
7.4.6 Writing a Resume
7.4.7 Using Headers and Footers
7.4.8 Document Types
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
8. Developing and Editing Documents
8.1 Typography
8.2 Writing a Research Article
8.2.1 Outlining the Document
8.2.2 Using and Managing Styles
8.2.3 Using the Navigation Pane and Document Map Pane
8.3 Managing Citations
8.3.1 Footnotes and Endnotes
8.3.2 Creating a Bibliography
8.4 Setting a Page Layout
8.4.1 Formatting Columns
8.4.2 Adding Graphic Elements and Captions
8.5 Additional Document Elements
8.5.1 Adding a Cover Page
8.5.2 Adding a Table of Contents
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
9. Advanced Features of Word Processing
9.1 Mail Merge
9.1.1 Mail Merge in Microsoft Word 2013
9.1.2 Mail Merge in Microsoft Word 2011
9.2 Additional Document Elements
9.2.1 Adding Symbols
9.2.2 Editing Equations
9.2.3 Adding Tables
9.2.4 Adding Shapes
9.3 Arranging and Grouping Elements
9.4 Editing Existing Documents
9.4.1 Document Comparison
9.4.2 Track Changes
9.4.3 Comments
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
Section III: Presentation Software
10. Introduction to PowerPoint and Presentation Software
10.1 Introduction to Presentation Software
10.2 Anatomy of Microsoft PowerPoint
10.2.1 Microsoft PowerPoint 2013
10.2.2 Microsoft PowerPoint 2011
10.2.3 Microsoft PowerPoint Web App
10.3 Diving into Presentations
10.3.1 Text Formatting
10.3.2 Inserting and Formatting Shapes
10.3.3 Inserting, Manipulating, and Cropping Images
10.3.4 Arranging, Linking, and Grouping Elements
10.3.5 Adding Text and Hyperlinks
10.3.6 Clip Art and Screenshots
10.3.6.1 Clip Art in Office 2013
10.3.6.2 Clip Art in Office 2011
10.3.6.3 Getting Clip Art from Office.com
10.3.6.4 Handling Clip Art
10.3.7 Sorting Slides
10.3.8 Inserting Screenshots
10.3.9 Transitions
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
11 Creating Effective Presentations
11.1 Writing Your Value Proposition
11.2 Establishing a Visual Style
11.2.1 Modifying the Slide Master
11.2.2 Planning Your Design
11.2.3 Assigning a Theme
11.2.4 Colors, Fonts, and Effects
11.2.5 Bullets and Numbering in the Slide Master
11.2.6 Adding and Formatting Slide Footers
11.2.7 Formatting Text on the Slide Master
11.2.8 Branding Your Slides
11.3 Constructing an Effective Presentation
11.3.1 Outlining
11.3.1.1 Adding Slide Notes
11.3.1.2 Best Practices for Outlining
11.3.2 Grabbing Attention in Your First Slide
11.3.3 Build the Need for Your Presentation
11.3.4 Present Your Main Contribution
11.3.4.1 Effective Visualization
11.3.4.2 Modifying Layouts
11.3.4.3 Tips for Success
11.3.5 Summarize and Conclude
11.4 Presenting Your Masterpiece
11.4.1 Live Presentations
11.4.2 Recording Narration
11.4.3 Sharing Your Presentation
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
12. Advanced Features of Presentation Software
12.1 Creating Handouts
12.1.1 Modifying the Handout Master
12.1.2 Modifying the Notes Master
12.2 Adding Advanced Media
12.2.1 Sound and Video
12.2.2 Tables
12.2.3 Charts
12.2.4 SmartArt
12.2.5 Animations
12.3 Editing Presentations
12.3.1 Opening and Editing Existing Presentations
12.3.2 Slide Setup and Slide Orientation
12.3.3 Creating a Custom Layout
12.3.4 Hiding and Showing Slides
12.3.5 Optimizing and Exporting Images from Slides
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
Section IV: Spreadsheet Software
13. Introduction to Excel and Spreadsheet Software
13.1 Introduction to Spreadsheet Software
13.2 Anatomy of Excel
13.2.1 Microsoft Excel 2013
13.2.2 Microsoft Excel 2011
13.2.3 Microsoft Excel Web App
13.3 Diving into Spreadsheets
13.3.1 Adding and Formatting Text
13.3.2 Formatting Values
13.3.3 Using Sequences
13.3.4 Formatting Cells
13.3.5 Freezing Panes
13.3.6 Adding Basic Formulas
13.3.6.1 Mathematical Calculations
13.3.6.2 Freezing Cells in Formulas
13.3.6.3 The SUM Function
13.3.7 Using Directional Fill
13.3.8 Navigating the Spreadsheet
13.4 Adding Charts
13.4.1 Chart Data
13.4.2 Formatting Charts
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
14. Developing Worksheets and Graphic Representations
14.1 Constructing a Worksheet
14.1.1 Merging and Splitting Cells
14.1.2 Adding and Deleting Rows and Columns
14.1.3 Hiding Rows and Columns
14.1.4 Advanced Cell Referencing
14.2 List Management
14.2.1 Using Sorting and Filters
14.2.2 Removing Duplicates
14.2.3 Text to Columns
14.2.4 Table Formatting
14.3 Additional Formatting Elements
14.3.1 Conditional Formatting
14.3.2 Tab Color
14.3.3 Comments
14.3.4 Text Boxes
14.4 Chart Types
14.4.1 Column
14.4.2 Line
14.4.3 Pie
14.4.4 Bar
14.4.5 Area
14.4.6 Scatter
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
15. Advanced Features of Spreadsheet Software
15.1 Business Applications
15.2 Using Functions
15.2.1 Common Functions
15.2.2 Text Functions
15.2.3 Value Lookup
15.2.4 IF Statements and Logic
15.2.5 Function Wizard
15.2.6 Calculation Options
15.2.7 Tracing Variables
15.2.8 Data Validation
15.3 Subtotals
15.3.1 Grouping Cells
15.3.2 Constructing Subtotals
15.4 Pivot Tables
15.4.1 Constructing a Pivot Table
15.4.2 Using Pivot Table Values in Formulas
15.5 What If Analysis
15.6 External Data Management
15.6.1 External Data Sources
15.6.2 Exporting Data
15.7 Arranging the Workspace
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
Section V: Database Software
16. Introduction to Access and Database Software
16.1 Introduction to Access
16.2 Working with the Interface
16.2.1 Creating a Database
16.2.2 Creating a Database Table
16.2.3 Working with Design View
16.2.4 Primary Keys
16.2.5 More on Data Types
16.3 Data Integrity, Validation, and Good Design Practices
16.3.1 Database Backups
16.3.2 Compressing and Repairing the Database
16.4 Working with Relationships in Microsoft Access
16.4.1 Defining Relationships
16.5 Data Manipulation Using Queries
16.5.1 Basic Queries
16.5.2 Using Query Design to Develop Queries
16.5.3 Working with SQL View
16.5.4 Implementing Inner and Outer Joins
16.6 Learning to Develop Reports
16.7 Developing a Simple Form
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
Appendices
A. Additional Productivity Software
A.1 Adobe Reader
A.1.1 Portable Document Format (PDF)
A.1.2 Adobe Reader Tools
A.1.2.1 Adobe Reader X for Windows
A.1.2.2 Adobe Reader XI for Macintosh
A.2 Microsoft OneNote for Windows
A.2.1 Anatomy of Microsoft OneNote 2013
A.2.2 Adding and Organizing Media and Notes
A.2.3 Linked Notes
A.2.4 Printing to OneNote
A.2.5 Saving and Sharing Notebooks
A.3 Microsoft Word Notebook Layout View for Macintosh
A.3.1 Notebook Layout View
A.3.2 Adding and Organizing Media and Notes
B. Alternate Productivity Software
B.1 Apache OpenOffice Software
B.1.1 OpenOffice Writer
B.1.1.1 Anatomy of Writer
B.1.1.2 Completing the Cover Letter in Writer
B.1.1.3 Completing the Resume in Writer
B.1.1.4 Mail Merge in OpenOffice Writer
B.1.1.5 Advanced Features of Writer
B.1.2 OpenOffice Impress
B.1.2.1 Anatomy of OpenOffice Impress
B.1.2.2 Completing the Projects in Impress
B.1.2.3 Advanced Features of Impress
B.1.3 OpenOffice Calc
B.1.3.1 Anatomy of OpenOffice Calc
B.1.3.2 Creating a Budget in Calc
B.1.3.3 Adding Charts in Calc
B.1.3.4 Advanced Features of Calc
B.2 Google Drive
B.2.1 Document
B.2.2 Presentation
B.2.3 Spreadsheet
C. Odd Numbered Answers to Knowledge Check Exercises
D. On The Companion Disc
Index

Systemvoraussetzungen

Als PDF speichern Als Link merken