Computer Training

 

Free Training is available to members of Ringwood Clocktower Probus Club only.

Training Medium:                   via ZOOM 

Separate Sessions:               There will be separate sessions for Windows and Apple users

Start date :                              Monday 10th August 2020

Pre Training Knowledge:       Know how to turn your computer on and how to use the
                                                 mouse / or track pad.

Four Main Areas will be covered:  (NOTE: Some will require more that 1 session)

1   Operating System and Screen Layout

2   File Management

3   Word – Basic Level

4   Excel – Basic Level

Details of each Area are below

Essential :                              All those doing Word or Excel MUST have completed 1 & 2. 
                                                i.e.: Operating System and Screen Layout AND File
                                                Management

Options:                                  Word and Excel are optional.

To Register, Please email Col Pask with the following informatiom:

  • Which Areas you are interested in
  • Windows or Apple Operating System
  • Version of Operating System (eg Windows 10, Apple Mojave or 10.14.1  )
  • Approximate age of computer.

DETAILS  OF THE TRAINING

1.  OPERATING SYSTEM & SCREEN LAYOUT

  • Screen Layout
  • Sizing the screen
  • Working with multiple Apps and screens
  • Settings – how to find them and change them
  • Internet Browsers
  • Search Engines
  • Task Manager / Force Quit
  • Size of text etc
  • Task Bar / Dock
  • Desktop
  • Power Off / Sleep / Hibernation / Restart
  • Accessing programs/apps

 

      2.  FILE MANAGEMENT

  • Changing Views of file information
  • Folders / Directories
  • Naming of Files
  • File Extensions
  • Searching for files
  • Changing order of files
  • Copying Files
  • Moving Files
  • External Drives / USB Flash Drives

     

3. WORD – BASIC LEVEL

GETTING STARTED – The Word Environment

  • The Word window
  • New documents
  • Word Help

WORD NAVIGATION – Navigation And Selection Techniques

  • Document navigation
  • Selection techniques

EDITING TEXT – Working with text

  • The Undo and Redo commands
  • Cutting, copying, and pasting text

FORMATTING – Formatting Text

  • Character formatting
  • Tab settings
  • Paragraph formatting
  • Paragraph spacing and indents
  • Automatic formatting

TABLES – Creating Tables

  • Working with table content
  • Changing table structure

PAGE LAYOUT – Setting up the page

  • Headers and footers
  • Margins
  • Page breaks

PREPARING A DOCUMENT FOR PRINT – Proofing And Printing Documents

  • Checking spelling and grammar
  • Using AutoCorrect
  • Finding and replacing text
  • Printing documents
  • Working with Print Options

GRAPHICS – Working with Graphics

  • Adding graphics and clip art
  • Working with graphics

 

4 EXCEL – BASIC LEVEL

GETTING STARTED
Spreadsheet terminology
The Excel environment

  • Start Microsoft Excel and identify the components of the Excel interface

Getting help
Navigating a worksheet

ENTERING AND EDITING DATA
Entering and editing text and values
Entering and editing formulas
Working with pictures

  • Insert Pictures
  • Apply Picture effects

Saving and updating workbooks

  • Save and update a workbook
  • Save a workbook as a PDF file

MODIFYING A WORKSHEET
Moving and copying data
Moving and copying formulas
Absolute and relative references
Inserting and deleting ranges, rows, and columns

FUNCTIONS
Entering functions
AutoSum
Other common functions

  • AVERAGE
  • MIN
  • MAX
  • COUNT
  • COUNTA

FORMATTING
Text formatting

  • Format cells, rows, and columns; merge cells; apply colour and borders; format numbers; create conditional formats; copy formatting; and apply table styles

Row and column formatting
Number formatting
Conditional formatting
Additional formatting options

PRINTING
Preparing to print
Page Setup options
Printing worksheets

CHARTS
Chart basics
Formatting charts

MANAGING LARGE WORKBOOKS
Viewing large worksheets

  • Freeze panes and split a worksheet
  • Hide and unhide data

Printing large worksheets

  • Set print titles and page breaks to optimize print output

Working with multiple worksheets