book

My Office® 2016

by Paul McFedries

October 2015

Beginner

432 pages

11h 30m

English

Que

Read now

Unlock full access

Understanding Office 365 and Office 2016Learning How Office 365 WorksTaking Your First Steps with Office 2016Sign In to Your Microsoft AccountCreate a Microsoft AccountSign Out of Your Microsoft AccountSwitch Between Office 2016 ApplicationsCreating a New DocumentCreate a Blank Document at StartupCreate a Blank Document After an Office 2016 Application Is RunningCreating a Document from a Template or ThemePreserving Your WorkSave a New DocumentCreate a Duplicate of a DocumentConvert a Document to the Latest FormatWorking with DocumentsOpen a DocumentPin a Document to the Recent TabPrint a Document
Selecting TextSelect Text with a MouseChanging 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
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
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
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
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
Selecting a RangeSelect a Range with a MouseSelect a Range on a TouchscreenWorking 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
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
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
Defining Slide AnimationsAnimation GuidelinesSet Up a Slide TransitionAnimate Slide ObjectsAdd an AnimationPreparing a Slide ShowRehearse Slide TimingsRecording NarrationRecord Narration for a SlideRecord Narration for an Entire PresentationSetting Up Multiple Versions of a Slide ShowCreate a Custom Slide ShowRunning a Slide ShowStart the Slide ShowNavigate SlidesSet Up an Automatic Slide Show
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
Using the Calendar FolderSwitch to the Calendar FolderNavigate to a DateSwitch the Calendar’s ViewSetting Up AppointmentsCreate a New AppointmentTaking Advantage of AutoDateCreate a Recurring AppointmentAppointments Versus All-Day EventsSchedule an All-Day EventUnderstanding Meeting RequestsRequest a Meeting
Exploring the Contacts FolderSwitch to the Contacts FolderUnderstanding the Contacts Folder ViewsAdding a New ContactCreate a New Contact from ScratchUnderstanding Outlook’s Contact Data FieldsCreate a Contact from the Same CompanyCreate a Contact from an Email MessageImporting Contact DataImport Contact DataWorking 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 AddressPrint a Contact Address on an Envelope or Label
Working with SectionsInsert a New SectionRename a SectionColor-Code a SectionWorking with PagesInsert a New PageInsert a New Page from a TemplateEnter Text on a PageWork with Page ContainersBuilding a OneNote TableInsert a TableWorking with TagsTag an ItemBuild ListsCreate a To-Do List
Working with NotebooksCreate a New NotebookSwitch Between NotebooksSet Notebook PropertiesAdding Data to a PageInsert the Date and TimeAdd a Link to a WebsiteAdd a Link to a OneNote LocationInsert a Spreadsheet FileInsert a New SpreadsheetAttach a FileAdding InkHandwrite TextHighlight TextConvert Ink to TextErase Ink
Understanding Access DatabasesCreating a DatabaseCreate a DatabaseBuilding and Working with TablesDesigning a TableLearning About Access Data TypesCreate a TableEnter DataSort Table DataFilter Table DataQuerying Access DataDesign a Simple QueryUnderstanding Query CriteriaEnter Query CriteriaCreating FormsCreate a Basic FormNavigating Form Fields and RecordsRun the Form WizardCreating ReportsCreate a Basic ReportRun the Report Wizard
Working with Application OptionsWorking with the Options Dialog BoxChanging Your User Name and InitialsBypassing the Start Screen at LaunchCustomizing the InterfacePinning the RibbonHiding the RibbonCustomizing the RibbonChanging the Position of the Quick Access ToolbarCustomizing the Quick Access ToolbarSetting the Office Background
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
Financial FunctionsDate and Time FunctionsMath and Trigonometry FunctionsStatistical FunctionsLookup and Reference FunctionsDatabase FunctionsText FunctionsLogical FunctionsInformation FunctionsEngineering FunctionsCube FunctionsCompatibility FunctionsWeb Functions

Content preview from My Office® 2016

A. Excel Worksheet Function Reference

As you learned in Chapter 6, “Entering Excel Data,” to get to the real meat of a spreadsheet model, you need to expand your formula repertoire to include Excel’s worksheet functions. Several hundred of these functions exist, and they’re an essential part of making your worksheet work easier and more powerfully. Excel has various function categories, including the following:

• Financial

• Logical

• Text

• Date and time

• Lookup and reference

• Math and trigonometry

• Statistical

• Engineering

• Information

• Database

• Cube

• Compatibility

• Web

(Note that this list, as well as the sections that follow, are presented in the order that the function category buttons appear in Excel’s Insert Function dialog box.) ...