Essential Office 2016 by Wilson, Kevin -- Read -- Imperial Library of Trantor

Index

About the Author Table of Contents Getting Started with Office

Office Packages Which Package is Right for Me? What is the Cloud? Purchasing Office Online Downloading Office 2016 Suite Create a Microsoft Account Exchange Email on your iPhone Set up Email on Windows Phone Setting up Outlook Desktop App Office Apps for iOS Setting up OneDrive on iOS Setting up OneDrive on PC

Using Office on the Web

Web Apps Microsoft Sway Mail Calendar People Docs Office Mix Office Lens Using OneDrive on the Web

Editing Files Uploading Files Organising Files

OneDrive on your Desktop

Uploading Files Searching for Files

Using your iPad

Accessing your Files Upload Files to OneDrive Editing Files on iPad

Microsoft Word 2016

Starting Word Create a Shortcut Getting Started

The Home Ribbon The Insert Ribbon The Design Ribbon The Page Layout Ribbon The References Ribbon The Mailings Ribbon The Format Ribbon File Backstage

Using Paragraph Styles Editing Paragraph Styles Bold, Italic & Underlined Superscript & Subscript Highlighting Text Text Colour Text Justification Paragraph Indents First Line Indent Hanging Indent Paragraph Spacing Line Spacing Tabs Bullet Lists Numbered Lists Cut, Copy & Paste Inserting Symbols Hidden Characters Equations SmartArt Cover Pages Contents Pages Indexes Adding Images Adding Clipart Adding Effects to Images Wrap Text around Images Remove Image Backgrounds Adding Tables Formatting Tables Add a Column Align Cell Text Insert a Row Resizing Rows & Columns Merge Cells Text Direction Adding a Chart Chart Styles Finding a Template Making Your Own Template Create a Document from Saved Template Printing on Envelopes Mail Merge your Envelopes Mail Merge a Letter Check your Spelling & Grammar Add to Dictionary Thesaurus Insights Search & Replace Real Time Co-Authoring Zoom Controls Tell Me Feature The Character Map Office Add-ons Saving Documents Saving as a Different Format Opening Saved Documents Sharing Documents Printing Documents Page Setup Multiple Documents Headers and Footers

Inserting Headers & Footers Editing Headers & Footers

Page Numbering Page Borders Page Breaks Creating Columns Watermarks

Microsoft Excel 2016

What’s a Spreadsheet? Starting Excel Create a Shortcut Main Screen The Ribbon

The Home Ribbon The Insert Ribbon The Page Layout Ribbon The Formulas Ribbon The Data Ribbon The Review Ribbon The View Ribbon File Backstage

Getting Started

Entering Data Simple Text Formatting Text Orientation Resizing Rows and Columns Inserting Rows & Columns Cut, Copy & Paste

Sorting Data Formatting your Spreadsheet

Cell Alignment Text Format Cell Borders

Importing Data Freeze Panes Conditional Formatting Using Formulas

BIDMAS Rule

Using Functions Count CountIf Auto Sum Average Max & Min IF Function VLookup Types of Data Cell Referencing Relative Absolute Adding Charts Formatting Charts

Chart Titles Chart Elements Axis Titles

Customising Charts Change Background to Solid Colour Change Background to Gradient Colour Change Chart Type Move and Resize Charts Data Analysis with Goal Seek Data Analysis with Scenario Manager Creating Scenarios Summary Reports Creating Pivot Tables Using Slicers Sorting Pivot Table Data Pivot Charts Data Validation Rules By Data Type Text Length Displaying Messages Input Message Error Messages Create a Drop Down List Locking Cells Opening a Saved Workbook Saving Workbooks Using Multiple Workbooks Printing your Spreadsheet Page Setup Page Options Margins Customising Margins Headers & Footers Page Print Order Print Options

Print Row and Column Headers Print Gridlines

Print Selection Print Titles Show & Print Formulas

PowerPoint 2016

Getting Started Create a Shortcut The Ribbon Menus

Home Ribbon Insert Ribbon Design Ribbon Transitions Ribbon Animations Ribbon Slide Show Ribbon

File Backstage Creating a New Presentation Designing a Slide Adding Images

From your PC Online Images Design Ideas Resizing Images Image Arrangement

Adding a New Slide Slide Masters Adding Notes Insert a Table Formatting Tables Table Themes Add a Chart Formatting Charts Chart Titles Data Labels Chart Legends Edit Chart Data Chart Styles Chart Colour Schemes Adding Objects Shapes Icons SmartArt Adding Special Effects

Adjusting Images

Removing Image Backgrounds Slide Transitions Animations Effects Motion Paths Custom Motion Paths Effects & Timings Animation Pane Adding Video Add Video on your PC to a New Slide Add video from your PC to an Existing Slide Trimming Videos Online Video Adding Sound Recording Audio Audio on your PC Screen Recording Recording Presentations Export your Presentation Photo Albums Setting Up Projectors Running your Presentation Wireless Presenting Present Online Using Office Mix Opening a Saved Presentation Saving your Presentation Save as a Different Format Print your Slides Online Collaboration Normal View Outline View Slide Sorter View Note Page View Reading View

Microsoft Access 2016

What is a Database Microsoft Access Databases Creating a Database The Ribbons

Home Create External Data Database Tools

Creating Tables Relationships Between Tables Creating Relationships Entering Data

Adding Records Deleting Records To Resize a Column

Creating Forms Forms Wizard Creating Queries Query Parameters Creating Reports

Microsoft Outlook 2016

Getting Started Create a Shortcut Main Ribbon Menus

Home Ribbon Send/Receive Ribbon Folder Ribbon View Ribbon Attachments Ribbon File BackStage

Email Message Ribbons

Message Ribbon Insert Ribbon Options Ribbon Review Ribbon

Sending Email Adding Attachments Saving Attachments Previewing Attachments Sending Email to Groups

Creating Contact Groups

Managing Email Messages

Creating Folders Organising Messages Creating Rules

Dealing with Junk Mail

Clutter

Contacts

Adding new Contacts

Calendar Add Appointment

Microsoft OneNote 2016

Getting Started

Home Ribbon Insert Ribbon Draw Ribbon Review Ribbon View Ribbon

Taking Notes Pictures Tables Type Notes Write Notes Screen Clippings Audio & Video Using Tags To-do List

← Prev
Back
Next →

← Prev
Back
Next →