book

Pro Office for iPad: How to Be Productive with Office for iPad

Name: Pro Office for iPad: How to Be Productive with Office for iPad
Author: Guy Hart-Davis
ISBN: 9781430245889

by Guy Hart-Davis

November 2014

Beginner

332 pages

7h 26m

English

Apress

Read now

Unlock full access

Cover
Title
Copyright
Dedication
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction

Chapter 1: Up and Running with Office for iPad
Understanding What Office for iPad Is and What You Can Do with ItGetting Office for iPadDownloading and Installing the Office AppsBuying an Office 365SubscriptionActivating the Office Apps on Your iPadOpening and Closing the AppsOpening an App from the Home ScreenLaunching an App by Opening a DocumentSwitching Among AppsMaking the Office Apps’ Icons Easy to AccessClosing an AppChoosing Settings and Resetting the AppsChoosing SettingsResettingan Office AppUsing Gestures to Navigate Your iPadTurning on Gestures forMultitaskingUsing Gestures for MultitaskingLocking theScreen OrientationSummary
Chapter 2: Using Common Tools in the Office Apps
Launching Word and Creating a New DocumentUsing the RibbonNaming and Saving a DocumentWorking with TextPlacing and Moving the Insertion PointEntering Text Quickly with the Onscreen Keyboard’s Hidden FeaturesEntering Text via DictationEntering Text Quickly by Using ShortcutsEntering Text via Optical Character RecognitionSelecting TextUsing Cut, Copy, and PasteDeleting TextConnecting a Hardware KeyboardPositioning Graphics, Shapes, and Other ObjectsUnderstanding How You Position Graphical ObjectsArranging Graphical Objects to Control Which Is VisibleWorking with GraphicsResizing and Formatting a PictureWorking with ShapesWorking with Text BoxesPrinting from Your iPadSummary
Chapter 3: Managing Your Office Documents
Setting Up Your ServicesAdding a ServiceRemoving a ServiceSigning Out from Your AccountSigning In to an AccountNavigating the File Management ScreensDisplaying the File Management ScreensCreating New Documents from the New ScreenWorking on the Recent ScreenManaging the Active Document from the File MenuSharing DocumentsUnderstanding the Ways of Sharing a DocumentSharing a DocumentTroubleshooting Problems with DocumentsDealing with Multiple Instances of DocumentsDealing with ErrorsSummary
Chapter 4: Getting Up to Speed with Word for iPad
Understanding Word for iPad’s Features and LimitationsWhich Features Does Word for iPad Have and Lack?What Happens to Content That Word for iPad Does Not Support?Creating a New Document on Your iPadNavigating the Word InterfaceEntering and Editing Text in a DocumentEntering Text with the Onscreen KeyboardInserting Tabs and Line BreaksSetting TabsEntering Text with a Hardware KeyboardCopying and Pasting TextEditing TextSummary
Chapter 5: Formatting and Laying Out Your Documents
Setting the Page Size, Orientation, and MarginsUnderstanding the Different Types of FormattingUnderstanding Direct Formatting and When to Use ItUnderstanding Styles and When to Use ThemFormattingSee also Formatting Your Documents the Best WayApplying StylesApplying Direct FormattingApplying Font FormattingApplying Paragraph FormattingPasting FormattingUsing Word’s Extra Table FeaturesConverting Existing Text to a TableUsing AutoFitRepeating Table Headers on Each PageUsing Sections to Create Complex DocumentsCreating Columns of TextWrapping Text Around ObjectsSummary
Chapter 6: Revising and Completing Your Documents
Adding Headers, Footers, and Page NumbersAdding Headers and Footers to a DocumentRemoving a Header or FooterAdding Page Numbers to a DocumentWorking with Footnotes and EndnotesDeciding Between Footnotes and EndnotesInserting a FootnoteEditing and Deleting Footnotes and EndnotesWorking with CommentsAdding a CommentViewing and Deleting CommentsTracking Changes in Your DocumentsTurning on Track Changes and Working with ItIntegrating Tracked Changes into a DocumentEditing Your Documents Simultaneously with ColleaguesEditing a Document SimultaneouslyWorking with BlockingResolving ConflictsSummary
Chapter 7: Getting Started with Excel for iPad
Understanding Excel for iPad’s Features and LimitationsWhich Features Does Excel for iPad Have and Lack?What Happens to Content That Excel for iPad Does Not Support?Creating a New Workbook on Your iPadNavigating the Excel InterfaceNavigating Workbooks and WorksheetsMoving the Active CellSelecting Cells and RangesEntering Data in a WorksheetOpening a Cell for EditingMeeting Excel’s Numbers KeyboardTyping Data in a CellEditing a Cell’s ContentsEntering Data Quickly Using the Fill FeaturePasting Data into a WorksheetMoving Data with Cut and Paste and Drag and DropCreating TablesSetting Up Your Preferred ViewChoosing Which Onscreen Items to DisplayFreezing PanesSummary
Chapter 8: Building and Formatting Worksheets
Creating the Structure of Your WorkbookInserting, Deleting, and Duplicating WorksheetsRenaming, Reordering, and Hiding Your WorksheetsInserting and Deleting Rows, Columns, and CellsSetting Column Width and Row HeightHiding Rows and ColumnsFormatting Cells and RangesUnderstanding How Formatting Works in ExcelControlling How Data Appears by Applying Number FormattingApplying Direct FormattingFormatting with Cell StylesApplying Table FormattingUsing Find and ReplaceSorting and Filtering Your DataSorting DataFiltering DataWorking with CommentsPrinting a WorkbookSummary
Chapter 9: Using Formulas and Functions in Your Worksheets
Understanding the Difference Between Formulas and FunctionsReferring to Cells and Ranges in Formulas and FunctionsReferring to a CellReferring to a RangeMaking One Row or Column Refer to Another Row or ColumnCreating Formulas to Perform Custom CalculationsUnderstanding Excel’s Calculation OperatorsUsing the Calculation OperatorsOverriding the Order in Which Excel Evaluates OperatorsNesting Parts of a Formula to Control Operator PrecedenceInserting Functions to Perform Standard CalculationsUnderstanding Function SyntaxInserting a FunctionNesting One Function Inside Another FunctionMeeting Excel’s Most Useful FunctionsSUMAVERAGE, MEDIAN, and MODEMAX and MINDAY, MONTH, and YEARIFISBLANK, NA, and ISNALEFT, RIGHT, and MIDTRIMPIROUND, ROUNDDOWN, and ROUNDUPSummary
Chapter 10: Creating Effective Charts
Learning the Essentials of Charts in ExcelUnderstanding Embedded Charts and Chart SheetsUnderstanding the Components of a ChartChoosing the Best Chart Type for Your DataCreating, Laying Out, and Formatting a ChartCreating a ChartChanging the Chart TypeSwitching the Rows and Columns in a ChartChanging the Source Data for a ChartChoosing the Layout and Adding Any Titles NeededApplying a Style and Changing the ColorsCopying and Pasting a ChartSummary
Chapter 11: Becoming Expert with PowerPoint for iPad
Understanding PowerPoint for iPad’s Features and LimitationsWhich Features Does PowerPoint for iPad Have and Lack?What Happens to Content That PowerPoint for iPad Does Not Support?Creating a New Presentation on Your iPadOpening a PresentationNavigating the PowerPoint InterfaceAdding, Deleting, and Rearranging SlidesAdding a SlideDeleting a SlideRearranging SlidesDuplicating a SlideCutting and Copying SlidesHiding a SlideAdding Content to a SlideAdding TextAdding Text Boxes to SlidesAdding Pictures to SlidesAdding Videos to SlidesAdding Tables, Shapes, and Text Boxes to SlidesAdding a Chart from Excel to a SlideAdding Notes to SlidesAdding Transition Effects Between SlidesReviewing CommentsGiving a Presentation from Your iPadWays of Giving a Presentation from Your iPadSetting Up the PresentationDelivering the PresentationSummary
Chapter 12: Taking Notes in OneNote
Understanding How OneNote for iPad Works and What It Can and Cannot DoSetting Up Your NotebooksLaunching OneNote and Opening a NotebookExploring the OneNote InterfaceWorking with Notebooks, Sections, and PagesLooking Around in the Personal NotebookAdding a Section to a NotebookDeleting a SectionRenaming and Reorganizing SectionsWorking with Section GroupsAdding PagesEntering Notes on a PageUnderstanding Which Types of Information You Can Save in OneNoteAdding Text to a PageAdding Graphics to a PageCreating TablesApplying TagsUsing the Find FeatureSharing Your Notes with OthersSummary
Index

Overview

Microsoft Office for iPad is here! So learn the tips, tricks, and get around the gotchas in Microsoft Office for iPad with Pro Office for iPad. This book shows you how you can become productive quickly by avoiding those annoyances and confusions and slow-me-downs that can happen when you start using Office with your fingers!

How is Office for iPad different from Office on your Mac or PC? Which features do the Office for iPad apps have, which do they lack, and how can you work around their limitations? How can you share your files among the different versions of Office? How quickly can you work without the physical keyboard and keyboard shortcuts you're used to -- and which keyboard shortcuts can you use if you connect a hardware keyboard to your iPad?

Whether you plan to write a few letters or your dissertation, run your home office away from home, or use your iPad for daily business, Pro Office for iPad will show you how to get the most out of Word, Excel, and other Office apps on your iPad. Enjoy your new freedom and still be as productive as ever with the skills and techniques you'll learn in Pro Office for iPad.

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: 9781430245889Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills