In Module 8, we are going to look at how the functions and features of Microsoft Office i.e. MS Word, MS Excel, MS PowerPoint, and MS Outlook help us to be more productive in the workplace. Most users of MS Office learn by default or have attended a workshop when it came out many years ago and have not kept up to date with the changes that have been made across the versions.  The aim of this module is to get you up to date with some of the features that can save you time and increase your productivity.

At the end of this module, you will be able to:

  • Customise MS Office to work for you by using the Backstage (Options), Quick Access Toolbar and Customise Ribbon features
  • Use the basic formulas in Excel e.g. IF, DATE, and VLOOKUP and use the Function Library
  • Use text formulas to manipulate data in Excel e.g. UPPER, LOWER, CONCAT, MID, LEFT, RIGHT
  • Apply data validation in Excel to ensure the correct data is inputted e.g. drop down lists
  • Split a single column of text into multiple columns in Excel
  • Delete duplicate rows from a sheet in Excel
  • Work with large spreadsheets in Excel
  • Create a PivotTable to manipulate data in Excel
  • Apply styles in Word to easily edit documents, navigate around documents, add a table of contents
  • Use Mail Merge in Word to send out information on letters or emails
  • Create Word documents that are consistent in style and design
  • Use the Section Break to apply different formatting through a document e.g. landscape and portrait pages in one document, different headers and footers in a Word document
  • Use building blocks in Word i.e. QuickParts to quickly call up repetitive text and Cover Pages
  • Use the features of Tables in a Word
  • Add illustrations to documents in Word
  • Create slide masters in PowerPoint and apply a design
  • Align, group, edit, merge, and apply styles to shapes in PowerPoint
  • Use SmartArt graphics feature in PowerPoint
  • Create a custom slideshow in PowerPoint
  • Insert media i.e. videos and audio to make your presentation stand out
  • Record your own slide show in PowerPoint and convert to a video

Course Curriculum