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

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

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

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

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

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

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

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

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