book

How to Do Everything: Microsoft Office Online

Name: How to Do Everything: Microsoft Office Online
ISBN: 9780071850087

by Carole Matthews, Marty Matthews

April 2015

Beginner

264 pages

6h 59m

English

McGraw-Hill

Read now

Unlock full access

Cover
Title Page
Copyright Page
Dedication
Contents at a Glance
Contents
Acknowledgments
Introduction
CHAPTER 1 Getting and Exploring OneDrive
Explore the CloudGet Started with OneDriveConnect to and Sign Up for OneDriveExplore OneDriveSet Up OneDrive on Your ComputerSet Up OneDrive on Multiple DevicesSet Up OneDrive on an iPhoneSet Up OneDrive on an iPadSet Up OneDrive on an Android PhoneSet Up OneDrive on an Android TabletSet Up OneDrive on a Windows Phone
CHAPTER 2 Handling Files in OneDrive
Work with Files and Folders in OneDriveAdd Files and Folders to OneDriveHandle Files and Folders in OneDriveUse OneDriveUse OneDrive from AppsOpen Apps from OneDrive FilesShare OneDrive Files and Folders

CHAPTER 3 Introducing Office Online
Open and Close an Office Online AppStart an Office Online App DirectlyStart an Office Online App in OneDriveClose an Office Online AppOpen, Close, and Save an Office Online DocumentOpen a Document in an Office Online AppSave a Document in Office OnlineExplore an Office Online AppExplore an Office Online App WindowUnderstand the RibbonDisplay the Mini ToolbarUse Tabs and MenusUse Various ViewsUse Common Office Online ToolsOpen HelpUse the Office Online ClipboardCheck SpellingChange Basic Character FormattingPrint a DocumentEnter Comments
CHAPTER 4 Working with Word Online
Explore Word OnlineStart WordCreate a New DocumentUse a Template to Create a DocumentLocate and Open an Existing DocumentWrite a DocumentEnter TextInsert Text or Type Over ItInsert Line or Page BreaksSelect TextCopy and Move TextDelete TextEnter Symbols and Special CharactersNavigate a DocumentMove Around in a DocumentFind and Replace TextUse Word Writing AidsCount WordsUse Highlighting
CHAPTER 5 Formatting a Document
Format TextReview the Text-Formatting ToolsApply Character FormattingFormat a ParagraphSurvey the Paragraph-Formatting ToolsSet Paragraph AlignmentIndent a ParagraphChange and Remove IndentsUnderstand Line and Paragraph SpacingSet Line SpacingFormat a PageSet MarginsDetermine Page OrientationSpecify Paper SizeUse StylesUnderstand StylesIdentify Text with a StyleClear a Style from Text or a DocumentWork with DocumentsUse TabsAdd Headers and FootersApply Header and Footer OptionsAdd Footnotes and EndnotesUse TablesCreate a TableModify TablesWork with Table ElementsFormat Table Elements
CHAPTER 6 Entering, Editing, and Formatting Data in Excel Online
Enter and Format Numbers, Text, Dates, and TimesExplore Excel Data TypesEnter TextComplete an EntryEnter Numeric DataEnter and Format DatesFormat NumbersWork with Dates and TimesUse TimesAdd Data QuicklySelect, Edit, Copy, Paste, and Delete DataEdit Cell DataRemove Cell ContentsSelect Cells and RangesCopy and Paste DataFind DataSelect, Size, Add, Hide, and Remove Rows and ColumnsAdjust Row HeightAdjust Column WidthHide and Unhide Rows and ColumnsAdd and Remove Rows, Columns, and CellsFormat Using Borders, Alignment, and ColorAdd ColorChange Cell BordersAlign Cell Contents
CHAPTER 7 Using Formulas, Functions, and Tables and Organizing Data
Reference and Name Cells and Ranges of CellsWork with Cell Referencing TypesGo to a Cell QuicklyBuild, Edit, Copy, Move, and Calculate FormulasCreate a FormulaEdit or Delete a FormulaMove FormulasCopy FormulasRecalculate FormulasUse Worksheet References in FormulasUse FunctionsUse Functions QuicklyEnter a FunctionEnter a Sum in Columns or Rows QuicklyWork with TablesInsert a TableChange Rows and Columns in a TableAdd a Total RowOrganize DataPerform an Ascending/Descending SortUse AutoFilterUse Worksheets to Organize Data
CHAPTER 8 Creating a Presentation with PowerPoint Online
Begin to Use PowerPointStart PowerPointBegin with a New Blank SlideBegin with TemplatesOpen an Existing PresentationCreate a PresentationUnderstand Themes, Layouts, and TemplatesFind a ThemeAdd New Slides and LayoutsAdd Content to a SlideSwitch Between PowerPoint Online and Desktop PowerPointExplore PowerPoint Online ViewsNavigate and Manipulate SlidesMove to the Next or Previous SlideNavigate from Slide to SlideMove, Duplicate, or Hide SlidesChange the Look and Feel of SlidesChange a ThemeAdd Animations and Transitions to SlidesInsert SmartArt for Lists
CHAPTER 9 Working with Slide Content
Work with Notes and CommentsCreate a NoteCreate CommentsWork with TextUse a Text LayoutInsert a New Text BoxWork with Placeholders and ObjectsUse Headers and FootersMove and Copy TextWork with HyperlinksWork with CollaboratorsShare the Presentation
CHAPTER 10 Using OneNote Notebooks
Start OneNoteStart OneNote Using Office.comStart OneNote Using OneDrive.comCreate a New NotebookCreate a New SectionCreate a New PageAdd Content to a PageAdd and Format TextAdd Images to a PageLabel or Resize ImagesAdd TablesManipulate TablesAdd Web LinksAdd a SymbolExplore OneNote ViewsUse Editing ViewUse Reading ViewShow Authors and Page VersionsPerform Other Functions with OneNoteShare the NotebookCheck SpellingEdit the Notebook in Desktop OneNotePrint with OneNote
CHAPTER 11 Using and Managing Outlook, Calendar, and People
Work with OutlookGet Started with Outlook.comCreate a New E-mailArrange E-mail into FoldersSort the Display of E-mailDisplay Selected E-mailManage Your CalendarOpen and Display the CalendarCreate a New AppointmentAdd an Event, Task, or BirthdayAdd Another CalendarFilter Calendar EntriesImport Calendar EntriesShare Your CalendarSet Calendar OptionsManage Your People ContactsImport or Add, Edit, and Delete ContactsManage Display of ContactsWork with Groups
Index

Overview

Master Microsoft Office Online and OneDrive

How to Do Everything: Microsoft Office Online shows you how to use this versatile, free platform to create and save documents, presentations, and spreadsheets online and easily collaborate with others. You’ll also get tips for storing and sharing photos, videos, and more on OneDrive and organizing your notes with OneNote Online. You'll see how to manage your email, contacts, and calendar using Outlook.com. Access and share your files anytime, anywhere from Windows, Mac OSX, Apple iOS, and Android devices. This practical guide covers it all!

Connect to and sign up for OneDrive
Add, manage, and share files and folders on OneDrive
Navigate and customize Office Online
Create, format, and edit documents in Word Online
Enter, edit, and format data in Excel Online
Use Excel Online formulas, functions, and tables
Create impressive presentations in PowerPoint Online
Collect and organize notes in OneNote Online
Work with Outlook.com and manage your email, calendar, and contacts

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780071850087

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills