Microsoft Office - Beginners

Recommend course:

Description

These skills are in high demand in the workplace. Covers Microsoft Word documents, Excel spread sheets and PowerPoint presentation

By the end of the course, you'll have developed your skills in the following areas and will be able to:
 
MS WORD
• Open, close and save a document 
• Perform basic formatting 
• Cut, copy and paste 
• Create and format a table 
• Understand the commands on the Print menu 
 
MS EXCEL
  • Create a spreadsheet using the sum function and simple formulas
  • Perform basic formatting
  • Copy, paste and use the Fill command
  • Link formulas across sheets in a workbook
  • Use relative and absolute references in a formula
  • Create pie and column charts
  • Copy tables and charts into a Word document

 

MS POWERPOINT
  • Create a presentation using bulleted lists, tables and charts
  • Add transition effects
  • Show the presentation, and print handouts or notes

 

*:) happy

 

Session 1: Create and save a document using basic formatting. Insert and delete text. Open an existing document and apply font and paragraph formatting including a bit on bullets and numbering. Try out the built in styles (just the ones on the ribbon).

 Session 2: Review formatting and editing. Cut, copy and paste using the clipboard, and drag and drop. Create and format a simple table, insert and delete rows. Apply table formats. Insert clip art (Online picture), move and size it.

Session 3: Excel – create a spreadsheet using the SUM function and simple formula. Format fonts, borders and column widths. Insert and delete rows. Use the Fill function to copy and to build series. Create pie and column charts. Copy data and charts from Excel to Word.

Session 4: Excel – review simple formula and functions. Create formula across sheets within a workbook. Use relative and absolute addresses to enable easy copying of formula. Use simple database functions in Excel such as sort and filter.

Session 5: Powerpoint – create a presentation with slides including bullet lists, tables, charts and organisation charts. Use transitions between slides and animations with a bullet list. Create notes. Run your slideshow and review your print options.

Session 6: Students’ choice: Review topics from previous sessions or cover an additional topic such as making an invitation in Powerpoint, working with long documents in Word (styles, headers and footers, table of contents etc), Mail Merge, advanced tables, a quick introduction to Publisher