Office 2016

Note: These training materials are licensed to the University of Aberdeen. Consequently, access is restricted to University of Aberdeen users only (University login required).

What topics are covered in each workbook?
Word | Excel | PowerPoint | Creating posters using PowerPoint
Outlook | OneNote | Publisher | Creating posters using Publisher

Word

• Download workbooks and associated exercise files

Topics include:

Getting Started and finding your way around Creating and working with Documents Editing text - Cutting, Copying and Pasting Formatting Text Formatting Paragraphs Bulleted and Numbered Lists Working with Tables Formatting Pages - page and section breaks, columns, watermarks Headers and Footers Spellchecking and Proofing features Printing Paragraph Styles Table of Contents and other Referencing Tools

Mail Merge Working with Images Working with Shapes Working with Text Boxes Working with Smart Art AutoCorrect, AutoText, and Building Blocks Templates and Themes Comparing and Protecting documents Using Fields Electronic Forms Master Documents Recording and running Macros Working with Tabs

Excel

• Download workbooks and associated exercise files

Topics include:

Finding your Way Around Creating and Using Workbooks Selecting, Finding and Replacing Data Inserting, Deleting & Viewing Worksheets Copying, Moving and Pasting Data Using Autofill and Flash Fill Introduction to Formulas, Functions and Linking Formatting Cells, Columns and Rows Getting Ready to Print Data Creating and Using Charts Using the Quick Analysis Toolbar Using Logical Functions Using Lookup Functions Using Statistical Functions Using Date and time Functions

Using Text Functions Using Other Useful Functions Creating and Using Named Ranges Sorting and Filtering Data Using Grouping, Subtotalling and Outlining Analysing Data with Pivot Tables and Pivot Charts Setting Data Validation Options Creating and Using Excel Tables Using Conditional Formatting Rules Using Data from Other Sources Using the Formula Auditing Tools Applying Protection Options Recording Macros Using the What-if Analysis Tools Using the Excel Application Options

PowerPoint

• Download workbooks and associated exercise files

Topics include:

Finding your Way Around Creating and Using Presentations Font Formatting Using Slide Layouts Inserting and Enhancing Images Creating and Using Tables Creating and Using Charts Inserting and Enhancing SmartArt Inserting and Enhancing Shapes Using Slide Masters

Creating a Template and Working with Themes  Using the Slide Show Tab Enhancing your Slide Show Previewing and Printing a Presentation Embedding and Linking Objects Using Media Clips and Action Buttons Saving and Sharing Working Collaboratively Planning Hints and Tips

Creating posters using PowerPoint

•  Download course materials [ZIP]
  • Poster content © Dr Jenny Gregory, Department of Orthopaedic Surgery, IMS, University of Aberdeen. Image, chart and text may not be reproduced, copied or distributed without permission.

Topics include:

Launching PowerPoint and creating a new presentation Specifying poster size Using the Zoom tool Applying backgrounds Working with guides and the grid Adding a poster title Creating Text Boxes Importing text from Word

Formatting text Formatting Text Boxes Positioning Text Boxes Insert and resize images Copy a chart from Excel Insert a table Add captions Printing out an A4 copy

Outlook

• Download workbooks and associated exercise files

Topics include:

Finding your Way Around Sending and Receiving Email Organising Messages Junk Mail and Rules Flags, Categories and Views

Tasks and Task Requests Methods of Searching People and Groups Working with Calendars Appointments and Meetings

OneNote

• Download workbooks and associated exercise files

Topics include:

Finding your Way Around Creating and Using Notebooks Adding Content to Notebooks Using Various Types of Notes

Using Tables and Drawing Tools Tagging and Searching Using Templates, Printing and Exporting Permissions and Sharing

Publisher

• Download workbooks and associated exercise files

Topics include:

Finding your Way Around Creating and Using Publications Text Techniques

Shapes, Pictures, Tables and Building Blocks Design, Layout and Master Pages Mail Merge and Catalogue Merge

Creating posters using Publisher

• Download course material [ZIP] 
  • Poster content © Dr Jenny Gregory, Department of Orthopaedic Surgery, IMS, University of Aberdeen. Image, chart and text may not be reproduced, copied or distributed without permission.

Topics include:

Launching Publisher and creating a new presentation Specifying poster size Using the Zoom tool Applying backgrounds Working with guides and the grid Adding a poster title Creating Text Boxes Importing text from Word

Formatting text Formatting Text Boxes Positioning Text Boxes Insert and resize images Copy a chart from Excel Insert a table Add captions Printing out an A4 copy