Office 365 All-in-One For Dummies (eBook)

eBook Download: EPUB
2021 | 2. Auflage
960 Seiten
Wiley (Verlag)
978-1-119-83073-3 (ISBN)

Lese- und Medienproben

Office 365 All-in-One For Dummies -  Matt Wade,  Peter Weverka
Systemvoraussetzungen
25,99 inkl. MwSt
  • Download sofort lieferbar
  • Zahlungsarten anzeigen
Multiply your productivity with the world's most straightforward guide to the world's most popular office software

Microsoft Office 365 contains straightforward tools for virtually every office task you could possibly think of. And learning how to use this powerful software is much easier than you might expect! With the latest edition of Office 365 All-in-One For Dummies, you'll get a grip on some of the most popular and effective office software on the planet, including Word, Excel, PowerPoint, Outlook, Access, Publisher, and Teams.

This expanded handbook walks you through the ins and outs of reviewing and composing documents with Word, hosting and joining meetings with Teams, crunching numbers with Excel, and answering emails with Outlook. And it's ideal for anyone who's brand new to Office and those who just need a quick refresher on the latest useful updates from Microsoft.

In this one-stop reference, you'll find:

  • Step-by-step instructions on the installation, maintenance, and navigation of all the critical components of Office 365
  • Guidance for using Office 365's built-in online and cloud functionality
  • Complete explanations of what every part of Office 365 is used for and how to apply them to your life

Office 365 All-in-One For Dummies is the last handbook you'll ever need to apply Microsoft's world-famous software suite to countless everyday tasks.


Multiply your productivity with the world's most straightforward guide to the world's most popular office software Microsoft Office 365 contains straightforward tools for virtually every office task you could possibly think of. And learning how to use this powerful software is much easier than you might expect! With the latest edition of Office 365 All-in-One For Dummies, you'll get a grip on some of the most popular and effective office software on the planet, including Word, Excel, PowerPoint, Outlook, Access, Publisher, and Teams. This expanded handbook walks you through the ins and outs of reviewing and composing documents with Word, hosting and joining meetings with Teams, crunching numbers with Excel, and answering emails with Outlook. And it's ideal for anyone who's brand new to Office and those who just need a quick refresher on the latest useful updates from Microsoft. In this one-stop reference, you'll find: Step-by-step instructions on the installation, maintenance, and navigation of all the critical components of Office 365 Guidance for using Office 365's built-in online and cloud functionality Complete explanations of what every part of Office 365 is used for and how to apply them to your life Office 365 All-in-One For Dummies is the last handbook you'll ever need to apply Microsoft's world-famous software suite to countless everyday tasks.

Peter Weverka is a veteran tech writer who has written dozens of Dummies titles, including the first edition of Office 365 All-in-One For Dummies. He has also authored books on PowerPoint, OneNote, Word, and Quicken.

Introduction 1

Book 1: Common Office Tasks 5

Chapter 1: Office Nuts and Bolts 7

Chapter 2: Wrestling with the Text 29

Chapter 3: Speed Techniques Worth Knowing About 49

Book 2: Word 365 57

Chapter 1: Speed Techniques for Using Word 59

Chapter 2: Laying Out Text and Pages 79

Chapter 3: Word Styles 105

Chapter 4: Constructing the Perfect Table 123

Chapter 5: Taking Advantage of the Proofing Tools 147

Chapter 6: Desktop Publishing with Word 167

Chapter 7: Getting Word's Help with Office Chores 185

Chapter 8: Tools for Reports and Scholarly Papers 205

Book 3: Excel 365 229

Chapter 1: Up and Running with Excel 231

Chapter 2: Refining Your Worksheet 249

Chapter 3: Formulas and Functions for Crunching Numbers 265

Chapter 4: Making a Worksheet Easier to Read and Understand 299

Chapter 5: Advanced Techniques for Analyzing Data 317

Book 4: PowerPoint 365 337

Chapter 1: Getting Started in PowerPoint 339

Chapter 2: Fashioning a Look for Your Presentation 361

Chapter 3: Entering the Text 377

Chapter 4: Making Your Presentations Livelier 393

Chapter 5: Delivering a Presentation 409

Book 5: Outlook 365 431

Chapter 1: Outlook Basics. 433

Chapter 2: Maintaining the People App 445

Chapter 3: Handling Your Email 457

Chapter 4: Managing Your Time and Schedule 479

Book 6: Access 365 491

Chapter 1: Introducing Access 493

Chapter 2: Building Your Database Tables 509

Chapter 3: Entering the Data 537

Chapter 4: Sorting, Querying, and Filtering for Data 547

Chapter 5: Presenting Data in a Report 567

Book 7: Publisher 365 573

Chapter 1: Introducing Publisher 575

Chapter 2: Refining a Publication 587

Chapter 3: Putting on the Finishing Touches 599

Book 8: Working with Charts and Graphics 609

Chapter 1: Creating a Chart 611

Chapter 2: Making a SmartArt Diagram 631

Chapter 3: Handling Graphics and Photos 651

Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 667

Book 9: Office 365: One Step Beyond 701

Chapter 1: Customizing an Office Program 703

Chapter 2: Ways of Distributing Your Work 717

Book 10: Microsoft Teams 725

Chapter 1: Getting around in Teams 727

Chapter 2: Getting Up to Speed with Teams and Channels 753

Chapter 3: Communicating through Channels and Private Chat 769

Chapter 4: Organizing Your Files in Teams 793

Chapter 5: Getting Together for Online Meetings 809

Book 11: File Sharing and Collaborating 835

Chapter 1: File Sharing and Collaborating 837

Chapter 2: Making the Most of OneDrive 851

Chapter 3: Collaborating in SharePoint 865

Index 895

Chapter 1

Office Nuts and Bolts


IN THIS CHAPTER

Introducing the Office applications

Exploring the Office interface

Opening, saving, and closing an Office file

Clamping a password on a file

Chapter 1 is where you get your feet wet with Office 365. Walk right to the shore and sink your toes in the water. Don’t worry; I won’t push you from behind.

In this chapter, you meet the Office applications and discover speed techniques for opening files. I show you around the Ribbon, Quick Access toolbar, and other Office landmarks. I also show you how to open files, save files, and clamp a password on a file.

Introducing Office 365


Office 365 is a subscription service from Microsoft. Subscribers can install and run Office applications on their computers; they can also take advantage of the Office cloud-based services. In computer jargon, the cloud is the name for servers on the Internet where individuals can store files and run online software. Microsoft offers many different versions of Office 365, some aimed at home users and some at business users. Visit this web page to compare and contrast the different versions of Office:

https://products.office.com

Office 365 applications


Table 1-1 describes the Office 365 applications. Not all versions of Office 365 include Outlook, Access, and Publisher.

TABLE 1-1 Office 365 Applications

Application

Description

Word

A word processor for writing letters, reports, and so on. A Word file is called a document (see Book 2).

Excel

A number cruncher for performing numerical analyses. An Excel file is called a workbook (see Book 3).

PowerPoint

A means of creating slide presentations to give in front of audiences. A PowerPoint file is called a presentation, or sometimes a slide show (see Book 4).

Outlook

A personal information manager, scheduler, and emailer (see Book 5).

Access

A database management application (see Book 6).

Publisher

A means of creating desktop-publishing files — pamphlets, notices, newsletters, and the like (see Book 7).

Windows 10 must be installed on your computer to run Office 365 applications. The applications don’t run on computers running earlier versions of the Windows operating system.

If you’re new to Office, don’t be daunted by the prospect of having to study so many different applications. The applications have much in common, with the same commands showing up throughout. For example, the method of choosing fonts is the same in Word, Outlook, PowerPoint, Excel, Access, and Publisher. Master one Office program and you’re well on your way to mastering the next.

Office 365 cloud services


Besides the applications described in Table 1-1, an Office 365 subscription entitles you to these goodies from the cloud:

  • The opportunity to install Word, Excel, and PowerPoint on iPads and Windows tablets.
  • Automatic updates to the Office software on your computer. As long as your subscription is paid up, Microsoft updates the Office software automatically.
  • Storing and sharing files with OneDrive, Microsoft’s cloud service. As well as keep files on your computer, you can keep them on the Internet so that you can open them wherever your travels take you. At minimum, subscribers to Office 365 get 5 gigabytes of free storage space for their files on OneDrive (some plans offer more free storage than others). You can invite others to work on files you store on OneDrive. (Book 11 explains how to store and share files with OneDrive.)
  • The opportunity to use the web (online) versions of Word, Excel, and PowerPoint. To use a Web application, you open it in a browser and give commands through the browser window.
  • Microsoft Teams for sharing files, chatting, and participating in voice and video calls with coworkers. (Book 10 and Book 11 explain Microsoft Teams, a service available only to Office 365 Business subscribers.)

Finding out what software and Office version you have


Follow these steps to find out which version of Office 365 you have and which Office applications are installed on your computer:

  1. Open any Office 365 application.
  2. Click the File tab.

    This tab is located in the upper-left corner of the screen. The Backstage window opens after you click the File tab.

    Here’s a fast way to open the Backstage window: Click your name in the upper-right corner of any Office application window and choose the Office User Info link on the drop-down menu.

  3. Select the Account category.

    As shown in Figure 1-1, the Account window opens. Under “This Product Contains” is an icon for each Office application that is installed on your computer.

  4. Click the Manage Account button.

    Your web browser opens to a Microsoft web page that tells you, among other things, what type of Office 365 account you have and how much free OneDrive storage space you are entitled to use. (If you aren’t signed in to your Microsoft account, sign in to view the web page.)

  5. Return to the Office 365 application and click the Back button in the Account window.

    The Back button, a left-pointing arrow, is located in the upper-left corner of the Account window.

FIGURE 1-1: The Account window tells you which Office applications are installed.

UPDATING OFFICE 365


From time to time, Microsoft updates Office 365 software. The updates are performed automatically. Follow these steps to find out when your version of Office 365 was last updated and update your software, if necessary:

  1. In any Office application, click the File tab.
  2. In the Backstage window, click Account to open the Account window (refer to Figure 1-1).
  3. Click the Update Options button and choose an option on the drop-down menu.

    The options are the following:

    • Update Now: Checks whether an update is needed and updates the software, if need be.
    • View Updates: Opens a web page where you see when the software was last updated.

Managing your Microsoft account


All subscribers to Office 365 must have a Microsoft account. To find out whether your account is paid up, change the password to your account, pay your subscription fee, and do all else pertaining to your account, follow these steps:

  1. Open any Office 365 application.
  2. In the upper-right corner of the screen, click your name.

    A drop-down menu appears.

    If you don’t see your name in the upper-right corner of the screen, you aren’t signed in to your Microsoft account. Click the Sign In button and enter your sign-in credentials.

  3. Select the My Microsoft Account link on the drop-down menu.

    Your web browser opens to a page at Microsoft.com where you can investigate everything you need to know about your account.

Beside your name in the upper-right corner of the screen is a diamond-shaped button called Your Subscription Benefits Center. You may click this button to open a screen that tells you how wonderful it is to have a subscription to Office 365. Most people click the button only once.

Finding Your Way Around the Office Interface


Interface, also called the user interface, is a computer term that describes how a software program presents itself to the people who use it (and you probably thought interface meant two people kissing). Figure 1-2 shows the Word interface. You will be glad to know that the interface of all the Office programs is pretty much the same.

These pages give you a quick tour of the Office interface and explain what the various parts of the interface are. Click along with me as I describe the interface and you’ll know what’s what by the time you finish reading these pages.

FIGURE 1-2: The File tab, Quick Access toolbar, and Ribbon.

The File tab and Backstage


In the upper-left corner of the window is the File tab (see Figure 1-2). Clicking the File tab opens the Backstage (Microsoft’s word, not mine). As shown in Figure 1-3, the Backstage offers commands for creating, saving, printing, and sharing files, as well as performing other file-management tasks. Notice the Options command on the Backstage. You can choose Options to open the Options dialog box and tell the application you are working in how you want it to work.

To leave the Backstage and return to the application window, click the Back button. This button, an arrow, is located in the upper-left corner of the Backstage.

The Quick Access...


Erscheint lt. Verlag 30.11.2021
Sprache englisch
Themenwelt Informatik Office Programme Office
Informatik Office Programme Outlook
Schlagworte Computer-Ratgeber • End-User Computing • Office 365 • Office Productivity-Microsoft (General & Office suite) • Office-Software Microsoft
ISBN-10 1-119-83073-7 / 1119830737
ISBN-13 978-1-119-83073-3 / 9781119830733
Haben Sie eine Frage zum Produkt?
EPUBEPUB (Adobe DRM)

Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM

Dateiformat: EPUB (Electronic Publication)
EPUB ist ein offener Standard für eBooks und eignet sich besonders zur Darstellung von Belle­tristik und Sach­büchern. Der Fließ­text wird dynamisch an die Display- und Schrift­größe ange­passt. Auch für mobile Lese­geräte ist EPUB daher gut geeignet.

Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine Adobe-ID und die Software Adobe Digital Editions (kostenlos). Von der Benutzung der OverDrive Media Console raten wir Ihnen ab. Erfahrungsgemäß treten hier gehäuft Probleme mit dem Adobe DRM auf.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine Adobe-ID sowie eine kostenlose App.
Geräteliste und zusätzliche Hinweise

Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.

Mehr entdecken
aus dem Bereich