
Microsoft Word and Excel 2013/365
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- Intro
- Title Page
- Dedication
- Contents
- Introduction
- Acknowledgments
- Chapter 1: Review of Basic Computing
- 1.1 Navigating the Desktop
- 1.2 Introduction to the Windows Operating System
- 1.2.1 Windows 7
- 1.2.2 Windows 8
- 1.2.3 The Windows Desktop
- 1.2.3.1 The Control Panel
- 1.2.3.2 Jump Lists
- 1.2.3.3 Task Manager
- 1.2.3.4 Libraries Feature
- 1.3 Introduction to Mac OS X
- 1.3.1 The Macintosh OS X Desktop
- 1.3.1.1 The Finder
- 1.3.1.2 The Dock
- 1.3.1.3 The Dashboard, Exposé, and Spaces
- 1.3.1.4 Force Quit
- 1.4 Organizing Files and Folders
- 1.4.1 Files and Folders in Windows
- 1.4.2 Files and Folders on a Mac
- 1.5 Working with Files on Your Computer
- 1.5.1 WordPad on Windows
- 1.5.2 TextEdit for Macintosh
- Chapter Summary
- Chapter Knowledge Check
- Practice Exercises
- Chapter 2: Microsoft OneDrive and Cloud Computing
- 2.1 Cloud Computing
- 2.2 Microsoft OneDrive
- 2.2.1 Creating a Microsoft Account
- 2.2.2 Uploading and Downloading Files
- 2.3 Integrating OneDrive with the Desktop
- 2.3.1 OneDrive on Windows 7
- 2.3.2 OneDrive on Windows 8
- 2.3.3 OneDrive on Mac OS X
- 2.4 Integrating OneDrive with Microsoft Office
- 2.5 Accessing OneDrive on a Remote Device
- 2.6 Alternate Cloud Computing Platforms
- 2.6.1 Google Drive
- 2.6.2 iCloud
- Chapter Summary
- Chapter Knowledge Check
- Practice Exercises
- Chapter 3: Introduction to Word and Word Processing
- 3.1 Introduction to Productivity Software
- 3.1.1 The File Menu
- 3.1.2 Document Management
- 3.1.3 Help Files
- 3.1.4 Productivity Shortcuts
- 3.1.5 The System Clipboard
- 3.2 Introduction to Word Processing Software
- 3.3 Anatomy of Microsoft Word
- 3.3.1 Microsoft Word 2013
- 3.3.2 Microsoft Word 2011
- 3.3.3 Microsoft Word Web App
- 3.4 Diving into Word Processing
- 3.4.1 Writing a Cover Letter
- 3.4.2 Formatting Text
- 3.4.2.1 The Font Panel
- 3.4.2.2 The Paragraph Panel
- 3.4.2.3 Format Painter
- 3.4.3 Bullets and Numbering
- 3.4.4 Document Review
- 3.4.4.1 Spelling and Grammar
- 3.4.4.2 Thesaurus
- 3.4.4.3 Find and Replace
- 3.4.5 Using Document Templates
- 3.4.6 Writing a Resume
- 3.4.7 Using Headers and Footers
- 3.4.8 Document Types
- Chapter Summary
- Chapter Knowledge Check
- Practice Exercises
- Chapter 4: Developing and Editing Documents
- 4.1 Typography
- 4.2 Writing a Research Article
- 4.2.1 Outlining the Document
- 4.2.2 Using and Managing Styles
- 4.2.3 Using the Navigation Pane and Document Map Pane
- 4.3 Managing Citations
- 4.3.1 Footnotes and Endnotes
- 4.3.2 Creating a Bibliography
- 4.4 Setting a Page Layout
- 4.4.1 Formatting Columns
- 4.4.2 Adding Graphic Elements and Captions
- 4.5 Additional Document Elements
- 4.5.1 Adding a Cover Page
- 4.5.2 Adding a Table of Contents
- Chapter Summary
- Chapter Knowledge Check
- Practice Exercises
- Chapter 5: Incorporating Media Elements
- 5.1 Visually Enhancing Documents
- 5.2 Media Elements in Word
- 5.2.1 Images
- 5.2.2 Adding Shapes
- 5.2.3 Clip Art
- 5.2.3.1 Clip Art in Office 2013
- 5.2.3.2 Clip Art in Office 2011
- 5.2.3.3 Getting Clip Art from Office.com
- 5.2.3.4 Handling Clip Art
- 5.2.4 SmartArt
- 5.2.5 Tables
- 5.2.6 Charts
- 5.2.7 Symbols
- 5.2.8 Equations
- 5.2.9 Additional Document Enhancements
- 5.3 Arranging and Grouping Elements
- Chapter Summary
- Chapter Knowledge Check
- Practice Exercises
- Chapter 6: Advanced Features of Word Processing
- 6.1 Mail Merge
- 6.1.1 Mail Merge in Microsoft Word 2013
- 6.1.2 Mail Merge in Microsoft Word 2011
- 6.2 Additional Document Elements
- 6.2.1 Adding Symbols
- 6.2.2 Editing Equations
- 6.2.3 Adding Tables
- 6.3 Editing Existing Documents
- 6.3.1 Document Comparison
- 6.3.2 Track Changes
- 6.3.3 Comments
- Chapter Summary
- Chapter Knowledge Check
- Practice Exercises
- Chapter 7: Introduction to Excel and Spreadsheet Software
- 7.1 Introduction to Spreadsheet Software
- 7.2 Anatomy of Excel
- 7.2.1 Microsoft Excel 2013
- 7.2.2 Microsoft Excel 2011
- 7.2.3 Microsoft Excel Web App
- 7.3 Diving into Spreadsheets
- 7.3.1 Adding and Formatting Text
- 7.3.2 Formatting Values
- 7.3.3 Using Sequences
- 7.3.4 Formatting Cells
- 7.3.5 Freezing Panes
- 7.3.6 Adding Basic Formulas
- 7.3.6.1 Mathematical Calculations
- 7.3.6.2 Freezing Cells in Formulas
- 7.3.6.3 The SUM Function
- 7.3.7 Using Directional Fill
- 7.3.8 Navigating the Spreadsheet
- 7.4 Adding Charts
- 7.4.1 Chart Data
- 7.4.2 Formatting Charts
- Chapter Summary
- Chapter Knowledge Check
- Practice Exercises
- Chapter 8: Developing Worksheets and Graphic Representations
- 8.1 Constructing a Worksheet
- 8.1.1 Merging and Splitting Cells
- 8.1.2 Adding and Deleting Rows and Columns
- 8.1.3 Hiding Rows and Columns
- 8.1.4 Advanced Cell Referencing
- 8.2 List Management
- 8.2.1 Using Sorting and Filters
- 8.2.2 Removing Duplicates
- 8.2.3 Text to Columns
- 8.2.4 Table Formatting
- 8.3 Additional Formatting Elements
- 8.3.1 Conditional Formatting
- 8.3.2 Tab Color
- 8.3.3 Comments
- 8.3.4 Text Boxes
- 8.4 Chart Types
- 8.4.1 Column
- 8.4.2 Line
- 8.4.3 Pie
- 8.4.4 Bar
- 8.4.5 Area
- 8.4.6 Scatter
- Chapter Summary
- Chapter Knowledge Check
- Practice Exercises
- Chapter 9: Advanced Features of Spreadsheet Software
- 9.1 Business Applications
- 9.2 Using Functions
- 9.2.1 Common Functions
- 9.2.2 Text Functions
- 9.2.3 Value Lookup
- 9.2.4 IF Statements and Logic
- 9.2.5 Function Wizard
- 9.2.6 Calculation Options
- 9.2.7 Tracing Variables
- 9.2.8 Data Validation
- 9.3 Subtotals
- 9.3.1 Grouping Cells
- 9.3.2 Constructing Subtotals
- 9.4 Pivot Tables
- 9.4.1 Constructing a Pivot Table
- 9.4.2 Using Pivot Table Values in Formulas
- 9.5 What If Analysis
- 9.6 External Data Management
- 9.6.1 External Data Sources
- 9.6.2 Exporting Data
- 9.7 Arranging the Workspace
- Chapter Summary
- Chapter Knowledge Check
- Practice Exercises
- Index
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.