Microsoft Office - Beginners

13th May 2019

Schedule:
6 Weeks, Mon, 7:00 PM - 9:00 PM
Presenter(s):
Price:
$110.00 incl. gst

21st October 2019

Schedule:
6 weeks, Mon, 7:00 PM - 9:00 PM
Presenter(s):
Price:
$110.00 incl. gst

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


 


 


 


 


Please note: All courses need a minimum number to go ahead. If your course does not have enough enrolments, we regret that we will have to cancel and will let you know either by email or text. Courses are usually cancelled, when necessary, 2-3 working days prior to the scheduled start date.