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