book

My Office® 2016 for Mac®

Name: My Office® 2016 for Mac®
Author: Paul McFedries
ISBN: 9780134075976

by Paul McFedries

October 2015

Intermediate to advanced

368 pages

9h 33m

English

Que

Read now

Unlock full access

About This eBook
Title Page
Copyright Page
Contents at a Glance
Table of Contents
About the Author
Dedication
Acknowledgments
We Want to Hear from You!
Reader Services

1. Getting Started with Office 2016 for Mac
Understanding Office 365 and Office 2016 for MacLearning How Office 365 WorksTaking Your First Steps with Office 2016 for MacSign In to Your Microsoft AccountCreate a Microsoft AccountSign Out of Your Microsoft AccountSwitch Between Office 2016 for Mac ApplicationsCreating a New DocumentCreate a Blank Document at StartupCreate a Blank Document After an Office 2016 for Mac Application Is RunningCreating a Document from a TemplatePreserving Your WorkSave a New DocumentCreate a Duplicate of a DocumentWorking with DocumentsOpen a DocumentPin a Document to the Recent TabPrint a Document
2. Formatting Documents
Selecting TextSelect Text with a Mouse or TrackpadChanging the FontUnderstanding TypefacesSet the TypefaceChange the Type SizeApply Type EffectsSet Text ColorsFormatting ParagraphsAlign ParagraphsSet the Line SpacingBuild a Bulleted ListCreate a Numbered ListSet the IndentationWorking with FormattingApply StylesApply Text EffectsClear Formatting
3. Working with Office 2016 for Mac Graphics
Working with ShapesInserting a LineInserting Any Other ShapeInserting ImagesInserting a PictureUnderstanding SmartArt GraphicsInserting a SmartArt GraphicInserting WordArtFormatting and Editing Graphic ObjectsSelecting Graphic ObjectsLassoing Graphic ObjectsSizing a Graphic ObjectMoving a Graphic ObjectRotating a Graphic ObjectFormatting a Graphic Object
4. Working with Text in Word
Learning Text BasicsEnter and Edit TextEnter Text with AutoCorrectInsert SymbolsInsert Symbols Using AutoCorrectSet TabsEnter HeadingsFinding and Replacing TextFind TextReplace TextProofing TextHandle Spelling and Grammar ErrorsAdding HyperlinksInsert a Hyperlink
5. Working with Page Layout and Design in Word
Building a TableInsert a TableSelect Table ElementsFormat a TableInsert New RowsInsert New ColumnsDelete Table ElementsWorking with Headers and FootersAdding a HeaderAdding a FooterChanging the Page SetupSetting the MarginsChanging the Page OrientationChanging the Paper SizeAdd a Page BreakUnderstanding SectionsAdd a Section BreakDisplay Text in ColumnsAdding Footnotes and EndnotesInsert a Footnote or Endnote
6. Entering Excel Data
Understanding Worksheet Cells and DataWorking with NumbersWorking with TextWorking with Dates and TimesEntering and Editing DataEnter Cell DataEdit Cell DataWorking with Formulas and FunctionsBuild a FormulaUnderstanding FunctionsAdd a Function Directly to a CellAdd a Function Using the Function WizardBuilding a TableConvert Cells to a TableSelect Table ElementsFormat a TableAdd New Rows and ColumnsDelete Rows and ColumnsSort a TableFilter a Table
7. Getting More Out of Excel Ranges
Selecting a RangeSelect a Range with a MouseSelect a Range with a KeyboardWorking with Excel RangesFill a Range with a Specific ValueFill a Range with a Series of ValuesMake a Copy of a RangeMove a RangeInsert a RangeDelete a RangeWorking with Range NamesName a RangeFormatting a RangeLearning About Data FormatsApply a Numeric or Date FormatControl the Number of Decimal PlacesResize ColumnsResize RowsAdd BordersWrap Text Within a Cell
8. Visualizing Excel Data with Charts
Creating a ChartCreate an Embedded ChartCreate a Chart in a Separate SheetWorking with ChartsUnderstanding Excel’s Chart TypesChange the Chart TypeMove a ChartResize a ChartChange the Chart Layout and StyleWorking with Chart ElementsSelect Chart ElementsFormat Chart ElementsAdd TitlesAdd a Chart LegendAdd Data Marker Labels
9. Building a PowerPoint Presentation
Adding a Slide to the PresentationUnderstanding Slide LayoutsInsert a New SlideDuplicate a SlideAdding Data to a SlideAdd TextCreate a Bulleted ListAdd a VideoAdd a ChartAdd a TableWorking with SlidesSelect SlidesRearrange SlidesChange the Layout of a SlideHide a SlideAdd Notes to a SlideUnderstanding the Slide MasterWork with the Slide Master
10. Working with PowerPoint Slide Shows
Defining Slide AnimationsAnimation GuidelinesSet Up a Slide TransitionAnimate Slide ObjectsAdd an AnimationPreparing a Slide ShowRehearse Slide TimingsRecording NarrationRecord Narration for a SlideSetting Up Multiple Versions of a Slide ShowCreate a Custom Slide ShowRunning a Slide ShowStart the Slide ShowNavigate SlidesSet Up an Automatic Slide Show
11. Sending and Receiving Outlook Email
Setting Up Your Email AccountAdd an Account AutomaticallyAdd an Account ManuallyComposing and Sending a New MessageCompose a MessageUse the Contacts List to Specify RecipientsAttach a File to a MessageReading and Working with Incoming MailRetrieve and Read MessagesReply to a MessageForward a MessageSave an AttachmentMove a MessageDelete a Message
12. Scheduling with the Outlook Calendar
Using the Calendar FolderSwitch to the Calendar FolderNavigate to a DateSwitch the Calendar’s ViewSetting Up AppointmentsCreate a New AppointmentCreate a Recurring AppointmentAppointments Versus All-Day EventsSchedule an All-Day EventUnderstanding Meeting RequestsRequest a Meeting
13. Keeping in Touch with Outlook People
Exploring the People FolderSwitch to the People FolderAdding a New ContactCreate a New Contact from ScratchUnderstanding Outlook’s Contact Data FieldsCreate a Contact from an Email MessageImporting Contact DataImport Contact Data from Outlook for WindowsImport Contact Data from Outlook 2011 for MacWorking with Your ContactsEdit Contact DataAdd a Picture for a ContactSend an Email to a ContactRequest a Meeting with a ContactView a Map of a Contact’s Address
14. Building a OneNote Notebook
Working with SectionsInsert a New SectionRename a SectionColor-Code a SectionWorking with PagesInsert a New PageEnter Text on a PageWork with Page ContainersBuilding a OneNote TableInsert a TableWorking with TagsTag an ItemBuild ListsCreate a To-Do List
15. Getting More Out of OneNote
Working with NotebooksCreate a New NotebookSwitch Between NotebooksSync a NotebookAdding Data to a PageInsert the DateAdd a Link to a WebsiteAdd a Link to a OneNote LocationAttach a File
16. Customizing the Office 2016 for Mac Applications
Working with Application PreferencesWorking with the Preferences DialogChanging Your User Name and InitialsBypassing the Start Screen at LaunchCustomizing the InterfaceCollapsing the RibbonExpanding the RibbonAdding Group Titles to the RibbonSetting the Office ThemeAdding the Developer Tab
17. Collaborating with Others
Collaborating in Word with Comments and ChangesInsert Comments in a Word DocumentEdit a CommentDelete a CommentTrack Changes in a Word DocumentControl the Display of Comments and ChangesControl the Markup DisplayNavigate Comments and ChangesAccept or Reject Comments and ChangesCollaborating in Excel with Comments and ChangesInsert Comments in CellsView Workbook CommentsTrack Worksheet ChangesAccept or Reject Workbook ChangesShare an Excel Workbook with Other UsersDisplay and Removing ReviewersHandle Sharing ConflictsSharing a Document OnlineSave a Document to OneDriveSend an Invitation to Share a OneDrive DocumentCopy a Link to Share a OneDrive Document
A. Excel Worksheet Function Reference
Financial FunctionsDate and Time FunctionsMath and Trig FunctionsStatistical FunctionsLookup and Reference FunctionsDatabase FunctionsText FunctionsLogical FunctionsInformation FunctionsEngineering FunctionsCube FunctionsCompatibility FunctionsWeb Functions
Index
Code Snippets

Content preview from My Office® 2016 for Mac®

11. Sending and Receiving Outlook Email

In this chapter, you learn about Outlook email, including setting up an account, sending and receiving mail, and working with incoming messages. Topics include the following:

Configuring Outlook with your email account

Creating and sending new messages

Retrieving and reading incoming messages

Replying to and ...

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

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

My Office® 2016 for Mac®

by Paul McFedries

11. Sending and Receiving Outlook Email

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.