Ribbons were introduced in Office 2007 applications to replace the former drop-down Menus. Office 2010 continues to use ribbons but there have been changes to the ribbons, so two separate courses have been combined for these applications.
Prerequisites: Either version of Office installed. Windows Stage 2 and File Management
Course Content: The Office User Interface - Learn screen component names - Open and close documents - Use Backspace and Delete keys - Move within a document - Select text - word, line, paragraph, all - Cut / Copy / Paste - Use right click - Use "Save" and "Save as" - Apply simple formatting - Correct spelling and replace text - Use Show and Hide - Use Print Preview - Use all commands on the Home tab
Prerequisites: Either version of Office installed. Word 2007/2010 Stage 1 OR familiarity with other word processors/versions.
Course Content: PAGE LAYOUT RIBBON - Use Page Setup Group options - Setup margins, paper sizes and columns - Paragraph Group - Set tabs - FILE TAB - Understand "Backstage" - New - Use Templates - Save / Save As - Print and printer options - Share options - All Word Options settings - Using Headers and Footers
Prerequisites: Either version of Office installed. Word 2007/2010 Stage 2.
Course Content: The Picture Tools Ribbon - Insert clip art - Text Wrapping - Insert Picture. Insert a table - Insert text boxes - Apply Picture Styles - Use Drop Capitals - Use WordArt. Use bullets and numbering - Use AutoCorrect - Add words to a custom Dictionary. Set up a Mail Merge
Prerequisites: Windows Stage 2 and File Management
Course Content: Learn screen component names - Understand worksheet structure - Use mouse and keyboard to move in the worksheet - Prepare a simple worksheet - Start a spreadsheet - Add data - Save the spreadsheet - Change the formatting - Calculate formulae. Prepare a graphical chart - Edit graph components - Use HELP menu
Prerequisites: Windows Stage 2, Excel Stage 1 and File Management
Course Content: Open and Save a file to a different folder - Sort and filter data for analysis - Investigate the various Ribbons - Format worksheet - Align cell contents - Resize columns and rows - Use borders and shading - Use Print Preview and its options - Centralise the spreadsheet on the page - Set Headers and footers - Hide and reveal columns and rows - Change type of graph - Review and set all Excel options - Calculate formulae - Freeze columns and row headings
Prerequisites: Windows Stage 2, Word 2007/2010 Stage 2 and File Management.
Course Content: Prepare a simple presentation - Use an Outline - Format the presentation. Use themes - Add gridlines - Insert a photograph - Insert graphics and Clip Art - Add animations - Add notes - Sort slides - Use the Handout Master ribbon - Printing options.
PowerPoint slideshows are frequently used in e-mails. This course is all about preparing attractive slideshows which you can use with your own photographs.
Prerequisites: Windows Stage 2, Word 2007/2010 Stage 2 and File Management.
Course Content: Understand the Options settings - Set PowerPoint options - Slideshow Presentation Techniques - Select photo for the Photo Album - Change background colour. Manipulate the photos - Use Animations - Use Transitions - Use Text Boxes - Animate text. Add Music - Save as Slideshow - Use Alternate photo displays.