Contact
Demo
Contact
Demo
Cross-cutting

Office Automation: Computerised Management Applications

Digital Skills 100 h

Introduction

This Office Automation Course: Management Software Applications offers you specialised training in the management and automation of office tasks and administrative processes. These applications help to create, store, organise and process information efficiently in an office environment. These management software applications form an essential part of the office automation and are used in a variety of sectors and businesses to improve efficiency, productivity and the organisation of tasks in the office environment.

Objectives

  • Purchase the knowledge y skills necessary to cope in the Windows environment.

  • Use the programmes from Microsoft Office: word processing, spreadsheets, databases and creating presentations.

Table of Contents

TEACHING UNIT 1. BASIC CONCEPTS

  1. Hardware, software and peripherals
  2. Operating systems
  3. Windows
  4. Key desktop functions and tools
  5. Control panel
  6. Add or remove programmes
  7. Creating folders, moving, cutting and copying folders
  8. Installing a programme
  9. Use of multimedia material
  10. Paint

TEACHING UNIT 2. OFFICE SOFTWARE. BASIC KNOWLEDGE AND OPERATION AT USER LEVEL: WORD PROCESSOR.

  1. Introduction to Word
  2. Document design and editing
  3. Cutting, copying and pasting text
  4. Format
  5. Styles
  6. Borders and shading
  7. Numbering and bullet points
  8. Page layout
  9. Insert tables
  10. Inserting charts
  11. Review
  12. Mailing options
  13. View options
  14. Spelling
  15. Print options
  16. The aid
  17. Document recording and retrieval

TEACHING UNIT 3. SPREADSHEETS: EXCEL.

  1. Concept
  2. The Excel environment
  3. Creating and opening workbooks
  4. Leaves
  5. Designing and editing a spreadsheet
  6. Create tables
  7. Edit
  8. Selecting items from a table
  9. Formats
  10. Inserting and deleting rows and columns
  11. Print options
  12. Basic calculation functions
  13. Charts

TEACHING UNIT 4. DATABASES: ACCESS.

  1. Run the programme
  2. Create a database
  3. Database components
  4. Insert fields
  5. Relational databases
  6. Tables: creating tables and formatting tables
  7. Convert text to tables and vice versa
  8. Relationships between tables: Forms, queries and reports
  9. Form views
  10. AutoFormats
  11. The enquiry assistant
  12. Grouping of records
  13. Reports

TEACHING UNIT 5. GRAPHICAL PRESENTATIONS USING POWERPOINT:

  1. Run the programme
  2. Basic concepts
  3. Creating simple presentations
  4. Slide templates
  5. Blank slide
  6. Add and delete a slide
  7. Change the order
  8. Slide layout: Formatting; Inserting objects, lines and shapes; Inserting an audio file; Transitions and effects; Final presentation

TEACHING UNIT 6. BASIC CONCEPTS FOR BROWSING THE INTERNET.

  1. World Wide Web
  2. Commonly used web browsers
  3. Internet Explorer
  4. Open window
  5. Most common search engines
  6. Eyelashes
  7. New tab
  8. The navigation bar
  9. Toolbars
  10. Explorer bars
  11. Help
  12. Favourites
  13. Internet options
  14. Content control
  15. Dial-up networking: Configuration
  16. Email
  17. Webmail and POP email
  18. Outlook

More related courses

Cross-cutting
Cross-cutting 1 hour

Masterclass – Fundamentals of Business Intelligence

View course →
Cross-cutting
Cross-cutting 40 hours

Relational databases: SQL. Data warehouse

View course →
Scroll to Top